ODBC Link To All Libraries

[Skittle]

I have created a standard Client Access Express System DSN on my PC. It points to our AS400 and I have used it to access data from the AS400 via Excel and Crystal Reports.

I have a library list problem with the DSN.
I have files that appear in more than one library ( eg. a test and live library ). When I select the file from
either the live or test library, the library is ignored and the data returned is based on the library list
on the 'Server' tab of the DSN. Is there a way of setting up the DSN do I can specify the library/file rather than the file that appears first in the library list?



Dazed and confused
(N+, MCAD .NET)

 

[jmanj]

Create separate DSN for each libraries you are accessing.

 

[Mercury2]

You could try this out:

Dim MySystem As New ADODB.Connection

MySystem.Open "Provider=IBMDA400;Data Source=MyDNS;", "", ""
MySystem.Execute "{{CHGLIBL LIBL(LIB1 LIB2 etc)}}", Rcds, adCmdText


hth