New Member
Posts: 1
Registered: ‎08-27-2011
Message 1 of 1 (614 Views)

LISP, AutoCAD 2011 and the Oracle initial Connection code

614 Views, 0 Replies
08-27-2011 12:50 PM


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.


Code example:

  (setq ConnectString "Driver=OraOLEDB.Oracle;DBQ=TEST_SID;UID=TestAdmin;Pwd=test")
  (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
Connection failed!
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
HelpContext        0
NativeError        0
Number              -2147467259
SQLState      IM002
Source              Microsoft OLE DB Provider for ODBC Drivers


You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community