[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: DSN - less ODBC connection to DB via MS Access DAO

Status
Not open for further replies.
T

Tinco

Guest
Hi, The connection string used in the VBA code could be incorrect (using 'SERVER' instead of 'HOST'), it should most probably be either something like: sConnStr = "DRIVER={Progress OpenEdge 10.2B Driver};HOST=localhost;PORT=12345;DB=sports2000;UID=sysprogress;PWD=sysprogress;DIL=0" (for an ODBC connection without DSN defined as shown in the example VBA code provided) or sConnStr = "DSN=sports2000;Uid=sysprogress;Pwd=sysprogress;" (for an ODBC connection with a DSN defined in %windir%\system32\odbcad32.exe or %windir%\syswow64\odbcad32.exe) If you test the ODBC connection string from outside of the VBA code of your MS Access application using the instruction from the following article I wrote on: knowledgebase.progress.com/.../how-to-test-an-odbc-connection-dsn-on-windows-using-powershell are you then able to connect to the OpenEdge 10.2B database? Also MS Access exist in both a 32 and 64 bit version and will need to use the matching 32 or 64 bit OpenEdge ODBC driver to be able to connect to the OpenEdge database. (more info on knowledgebase.progress.com/.../P170775) Kind regards, Tinco

Continue reading...
 
Status
Not open for further replies.
Top