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
Access a broad range of knowledge to help get the most out of your products and services.
Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.
Upgrading to a 2015 product? Make sure to check these out 1st!