× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Assuming the DSN (System or User?) *libl has been set up ok, is it possible
that your authority to the libraries has been amended?

Might be worth running the ODBC trace.

Cheers

Keith

-----Original Message-----
From: Steve Dodkins [mailto:Steve.Dodkins@xxxxxxxxxxxxxxx]
Sent: 15 January 2008 13:58
To: Midrange Systems Technical Discussion
Subject: RE: ODBC connection

Hi

It's the default library list in the server tab of the ODBC connection
that has been set up, but when I use the ODBC connection I do not get
those libraries to select from.

Steve Dodkins
I.T Manager

ebm-papst UK Ltd
Chelmsford Business Park,
CM2 5EZ Chelmsford,
UK
Tel: +44 (0) 1245 468555
Dir: +44 (0) 1245 456510
steve.dodkins@xxxxxxxxxxxxxxx
www.ebmpapst.co.uk/index2.htm

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Guy Terry
Sent: 15 January 2008 13:26
To: 'Midrange Systems Technical Discussion'
Subject: RE: ODBC connection

Hi Steve,

In ODBC Administration, open the iSeries Data Source.

You might need to look at 'Library List' on the 'Server' Tab. I have *
in
there - if I leave it blank I only get offered QGPL.

(This is on v5r4)

Guy

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Steve Dodkins
Sent: 15 January 2008 13:04
To: Midrange Systems Technical Discussion
Subject: ODBC connection

Hi

I have an ODBC connection set up on my PC (iSeries V5R2M0, PC XP Pro
and Office 2007 patched up to date) which has worked fine, I am using
Excel 2007 and am attempting to download data in excel from other
sources and then select the Microsoft Query - Select Data source - which
is the ODBC connection I've created some time ago, but now instead of
showing the library list from the ODBC connection I get a default
library list which does not contain any of my libraries set up in the
ODBC connection.

Client Access data transfer is also at V5R2 and I've reinstalled it just
in case and the iSeries user has not changed either.

Can anyone point in the right direction to be able to use the default
library list from the ODBC connection?

Steve Dodkins
I.T Manager




As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.