I am trying to connect LC to a Progress/OpenEdge database (which is a commercial product) via ODBC connection. When I try to connect, I get a "The specified DSN contains an architecture mismatch between the Driver and Application" error which appears to be a 32bit/64bit issue. The installed ODBC driver that comes with the DB is 32bit (I cannot obtain a 64bit driver) and I can successfully connect to the DB via the Windows ODBC Data Source Administrator so I know the connection works. I am using LC 9.6 on a Windows 10 Pro 64bit PC.
Here's my LC code (actual connection parameters have been removed for confidentiality):
Code: Select all
on mouseUp
put "<ip address>:<port>" into tDBurl
put "<database name>" into tDBname
put "<user name>" into tDBuser
put "<password>" into tDBpword
put revOpenDatabase("ODBC", "Progress", tDBurl, tDBname, tDBuser, tDBpword) into gConID
if gConID is not a number then
put "Error: " & gConID into field "Result"
exit mouseUp
else
put "Connection Established!" into field "Result"
put gConID into field "IDconex"
end if
#close the DB connection
revCloseDatabase gConID
put "Connection Closed." into field "IDconex"
end mouseUp
Thank you so much!
Jon