DataBase

[jan_ek]

Hello,I have a code written in python.

Is it possible to create such a connection using visualisp ?

 

import pyodbc
conn = pyodbc.connect('Driver={SQL Server};'
                      'Server=TEST;'
                      'Database=DTEST;'
                      'Trusted_Connection=yes;')

cursor = conn.cursor()

 

Edited January 13, 2020 by jan_ek

[ammobake]

I don't know much about python, myself.

 

I do know that the way Civil3D can link excel data to the drawing does seem more efficient and more straightforward (especially for point cloud data) but it just depends on what you're trying to do.  In your case you appear to be trying to link database content to the CAD file.

 

I do recall alot of of LISP discussions on this particular topic. (for Autocad).

 

I did run across the following - which may or may not help.

 

https://forums.autodesk.com/t5/visual-lisp-autolisp-and-general/implementing-python-to-autocad/td-p/6858701

 

https://through-the-interface.typepad.com/through_the_interface/2009/03/using-ironpython-with-autocad.html

 

ChriS

[BIGAL]

If you google Autocad has the ability to use SQL, so you can say open a ESRI database, same with Access. It has been around for years.

 

Edited January 14, 2020 by BIGAL