I am using AutoCAd 2011 and Oracle 9.3. I am using the 'Oracle Provider for OLE DB' I am very familiar with AutoCAd and with Oracle and connection between the client and the server Oracle portions.
Inside of AutoCAD I can connect fine using the dbconnect menu. I am able to query etc with AutoCAD. No issues there.
I am UNABLE to get LISP to connect no matter what I try. This seems like a very commoon issue for many developers (based on what I can see from a google query).
I am having trouble the getting the initial connection to work in LISP.
As you can see I am trying to use the ADOLISP library.
I would appreciate any input.
Thanks in advance.
(setq ConnectString "Driver=OraOLEDB.Oracle;DBQ=TEST_SID;UID=TestAdmin
(prompt (strcat "\n\nConnecting to the database using \n\""
(if (not (setq ConnectionObject
(ADOLISP_ConnectToDB ConnectString "TESTAdmin" "test")
(prompt "\nConnection failed!")
(prompt "\nResult: succeeded!")
Connecting to the database using
Visual LISP message Automation Error. [Microsoft][ODBC Driver
Manager] Data source name not found and no default driver specified
Description [Microsoft][ODBC Driver Manager] Data source name not found
and no default driver specified
Source Microsoft OLE DB Provider for ODBC Drivers