tee
Member
Hi,
How to connect JDE database by using ODBC in Visual Basic.
I tried the following connection.
Set db = OpenDatabase("Business Data - TEST", _
' dbDriverNoPrompt, True, _
"ODBC;DATABASE=TESTDTA;UID=JDESMS;PWD=JDESMS;DSN=Business Data - TEST")
but i hit error "ODBC-Call Failed"
In iSeries Access for Windows ODBC Setup, Data source name :Business Data - TEST, System:S65F996B, SQL default Library : TESTDTA, Package Library :TESTDTA, Driver: iSeries Access ODBC Driver
Please give some guidance.
Thanks
tee
How to connect JDE database by using ODBC in Visual Basic.
I tried the following connection.
Set db = OpenDatabase("Business Data - TEST", _
' dbDriverNoPrompt, True, _
"ODBC;DATABASE=TESTDTA;UID=JDESMS;PWD=JDESMS;DSN=Business Data - TEST")
but i hit error "ODBC-Call Failed"
In iSeries Access for Windows ODBC Setup, Data source name :Business Data - TEST, System:S65F996B, SQL default Library : TESTDTA, Package Library :TESTDTA, Driver: iSeries Access ODBC Driver
Please give some guidance.
Thanks
tee