Hi Everyone - I have an access database that has linked tables in an Oracle Database. When the user logs into the access app it does a connection to oracle using their username to determine fine grain access privileges. When I had this database using an old Oracle 9i ODBC client it worked fine, now with Oracle Instant Client 11.2.0.3 ODBC i get the following message:
"The connection string is too long. The connection string cannot exceed 255 characters. (3210) encountered."
The connection string is like this:
This is WAY less then 255 characters so i'm confused.
This is the code it's using to connect (The varConnect is the connection string from above):
The Internet has been less the helpful. Any assistance is appreciated.
"The connection string is too long. The connection string cannot exceed 255 characters. (3210) encountered."
The connection string is like this:
PHP:
ODBC;DRIVER={Oracle in OraHome92};DBQ=XXXXXXXX;UID=XXXXXXXX;PWD=XXXXXXXXX
This is WAY less then 255 characters so i'm confused.
This is the code it's using to connect (The varConnect is the connection string from above):
PHP:
Set db = DBEngine.Workspaces(0).OpenDatabase("", False, False, varConnect)
The Internet has been less the helpful. Any assistance is appreciated.
Last edited: