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
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register
Start with some of our most frequented solutions to get help installing your software.