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

LISP, AutoCAD 2011 and the Oracle initial Connection code

672 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


Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Are You Going To Be @ AU 2014? Feel free to drop by our AU topic post and share your plans, plug a class that you're teaching, or simply check out who else from the community might be in attendance. Ohh and don't forgot to stop by the Autodesk Help | Learn | Collaborate booths in the Exhibit Hall and meet our community team if you get a chance!