Visual LISP connect to SQL Server 2012 database

[JBerns]

Community,

I would like to read information from a database managed by SQL Server 2012. Read-only required at this time.

I have searched many forums for days and most results are many years old. I have attempted to use ADOlisp and SQL_Lite, but without success. No clear solutions found after all this searching.

I have an existing LSP file (500+ lines of code) that I would prefer not to convert to VBA or VB.NET. By the way, I have been able to connect to the server and database using VBA to prove that I can connect and read data from the database from within AutoCAD 2019. I have also been able to connect to the database and read a table using DBCONNECT. I just want to automate this read using Visual LISP.

Eventually, the goal is to read the CompanyName from the dbo.Customers table. Place this list into a dialog for the user to select a single customer. From there, the data populates a block for use by CNC software.

Is it possible to connect to a SQL Server database using AutoCAD 2019 and Visual LISP? What additional software is required? If I have overlooked an AutoCAD2019+VisualLISP+SQL_Server resource, please point me in that direction.

Thanks for your time. I look forward to your replies.

Regards,
Jerry

[bob_basques]

The Postgres ODBC Driver was the bear to get working, next to no info about this, although, I probably was looking with the wrong keywords now that I think about it.

bobb