Community
Solved! Go to Solution.
Solved by zalant. Go to Solution.
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
"iam_doss" wrote in messageHi,
href="news:6349341@discussion.autodesk.com">news:6349341@discussion.autodesk.com...
I'm not a database expert but I'm trying tu use SQL Server with AutoCAD Map.
I'm running Map 2010-64 bits over Windows 7 Ultimate-64 bits. It seems there
is a lot of connectivity problems using Jet and ODBC on 64 bits platforms
because there is not drivers from Microsoft for 64 bits programs. Well here is
that I can do and that I can't do at this moment:
1. Installed SQL
Server Express 2008 (I'm an absolutely newbie using and understanding SQL
Server, but it seems it works fine)
2. I can create databases in SQL and
Import from Access and Excel, using SQL Server Management Studio (many terms
of SQL are new for me, but I can edit imported Tables, make Querys, and so
on)
3. I can use SQL data links in Map, define link paths, attach records
to objects, and so on, like using Jet or ODBC with Access or Excel files
(except SQL Server complexity, no problems here)
4. Most problems begins
using FDO
4.1 Do I need use SQL or SQL Server Spatial connection? I can
connect SQL only using "sa" as user but no using Windows Authentication. I can
connect SQL Spatial using also Windows Aut., but in both cases, I can't see my
databases, only Create a new database
4.2 As a sample: I've an Access table
with Hydrants data. Two columns of the table includes LAT and LONG of
Hydrants. Is there some simple method to connect to imported table in SQL like
thorugh ODBC FDO using ODBC?
Any help here using SQL Server with Map
will be appreciated
Thank you in advance
Thank you very much.
I spent nearly 10 hours to search on the help and on the net how to import the Excel database 32 bits in a AutoCAD Map 2011 64 bits (Win 7 64 bits) with ODBC, or anything else (but keeping the link between). I tried a lot of things.
Now it works. Thanks a lot, you all guys. I hope that you know than you are very usefull for some "autodidactes" users like us.