excel vba - VBA odbc connection accessing a single library only -

excel vba - VBA odbc connection accessing a single library only -

i have connected as400 server. whenever execute sql statement

select * nosd0

it doesn't work, because nosd0 in lib1/fil1(nosd0)

it gives error saying nosd0 not in lib2.

when execute query on strsql on as400 works fine.

i tried creating alias , it's malfunctioning. please need help on one

alias working, accessing wrong file.

ok figured out problem, help wants connect as400 iseries using vba. ;)

my problem above when seek query on box, accesses lib1/nosd0, , in vba, trying lib2/fil1(nosd0) description of table nosdo itself. simple solution query

select * lib1.nosd0

more on when connecting as400 iseries using odbc, there parameter called dbq connection string parameters

my final connection string be.

connectstring = "driver={iseries access odbc driver};system=" & dcserver(i) & ";uid=--;pwd=--;nam=0;dbq=lib1,*all;"

excel-vba odbc ibm-midrange