I would like get input from users on setting up and using MS SQL Server 2008 on a Windows 7 64-bit system and connecting to AutoCAD 2011.
Be more specific. What are you using SQL server to do? SQL is a database system, not an operating system, so there is little direct connection between SQL and Autocad. BTW we have SQL here and Autocad, but they have nothing to do with each other.
I am new to databases but do somewhat understand the differences among the items covered in this discussion.
The specifics of this discussion include, via ODBC using MS SQL,:
1.) If it is possible establish a link between AutoCAD data via block attribute values and/or AutoCAD XDATA to MS Office 2010 (probably Excel).
2.) Has someone accomplished something similar?
3.)Could someone confirm this is possible using a 64-bit operating system? I understand that this is not possible using MS Access in a 64-bit based O.S. Correct?
I don't know about item 1 since our use of autocad, except for 1 lisp routine, could be satisfied with LT due to the nature of our work.
BUT we use MS Access 2003 in a 64 bit environment to create reports from SQL 2008. However the report design process, if using scripting, requires Microsoft® SQL Server® 2008 Management Studio Express which is free.