I have a query which combines data from two Tables (MS Access database) together.
The query works fine in Access, but Autocad refuses to open the query in DBConnect.
When I'm lucky, I get the message "table is inaccessible, Code 14215 SQLSTATE 37135", otherwise Autocad crashes.
So what's wrong with my query.
Any help would be appreciated.
Thanks
Sorry but there's no where enough information here 😞
How do you access the SQL database? Is it preconfigured somewhere or do you supply a path to the SQL database? You might want to use the PROCMON.EXE to monitor the paths that are being processed by the SQL engine to see where the differences lay...
i am getting the below error while accessing the database using queries. plz help me out
hellomaster879,
The query statement appears correct to me.
In Autocad, when you added the table into the tree structure, did you set the data source to specify MS SQL Server or MS access?
Using windows authentication?
Does the Connection test button work when specifying the correct database?
Is the windows SQL server Management Studio running locally on your computer?
Sorry guys, I just noticed this was an old pots. My bad. 😞