[AccessD] Problem with DNS-Less connection string

[Heenan, Lambert]

I'm in the process of switching over from using a System DSN to connect to an Oracle Database to using a DSN-less connection.

All is fine with tables. I have a routine that happily replaces the original connection string with the new DSN-less one. The tables are read/write.

My problem comes when I try to update the connection string for pass-through queries.  When I try to assign the new connection string (the exact same one as used by the tables) to a queried object via VBA then I get error 3125:

'ODBC;DRIVER={Oracle in Client11g_x32_home1};SERVER=TheServer;UID=TheID;PWD=ThePassword;DBQ=TheDB;DBA=W;APA=T;EXC=F;XSM=Default;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BNF=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=Me;CSR=F;FWC=F;FBS=60000;TLO=O;MLD=0;ODA=F;' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.

Actual server name, ID and password substituted.  The exact same connection string (which is 276 characters long) works with tables, but queries reject it.

If I try to paste the string into the query property sheen then I get a Msgbox saying "The text is too long to be edited."


Lambert