I am useing an ODBC driver to connect to an Oracle database through a ADODB connection in Access vba.
However, I'm running into some settings-problems with the connection. I have access to, and can set about 13 connection properties prior to executing the conn.open statement (including the General timeout).
However after running the statement and establishing the connection, there are more like 90 properties of the connection. But they are read-only.
Something is causing my connection to 'time-out?' which Oracle is interpreting as a Ctrl-C and giving me an Oracle error saying that the operation has been canceled.
Does anyone know the proper way to set these conn.properties while doing the conn.open statement. I've tried including them in the open statement (conn.open "ORDER BY Columns in Select List = True"
but the setting are ignored?
Any help or pointers would be appreciated. Tek-tips has been a great resource, I'm sure someone out there will know which way to sniff to get closer to the answer.
However, I'm running into some settings-problems with the connection. I have access to, and can set about 13 connection properties prior to executing the conn.open statement (including the General timeout).
However after running the statement and establishing the connection, there are more like 90 properties of the connection. But they are read-only.
Something is causing my connection to 'time-out?' which Oracle is interpreting as a Ctrl-C and giving me an Oracle error saying that the operation has been canceled.
Does anyone know the proper way to set these conn.properties while doing the conn.open statement. I've tried including them in the open statement (conn.open "ORDER BY Columns in Select List = True"
but the setting are ignored? Any help or pointers would be appreciated. Tek-tips has been a great resource, I'm sure someone out there will know which way to sniff to get closer to the answer.