AutoCAD and MySQL

AutoCAD and MySQL

strawberry12
Advocate Advocate
1,144 Views
1 Reply
Message 1 of 2

AutoCAD and MySQL

strawberry12
Advocate
Advocate

Because I know a bit of AutoCAD, and I know a bit of MySQL, I thought it would be amusing to put them to work together - specifically with a view to letting MySQL control some dynamic block stretch parameters - but that's for another day.

 

Today I'm just trying to connect to MySQL from within AutoCAD (vanilla 2012).

 

In the dbConnect Manager window, I can see the list of tables under my chosen connection, but whenever I try double-clicking on a table, I just get an error:

 

"

An error occurred in executing the SQL statement.

 

<SQL Error Information>

 

cursor operation conflict

Code 2304 SQLSTATE 09000

"

 

Anyone know how I might go about either resolving or circumventing this? Or am I on a hiding to nothing.

 

0 Likes
1,145 Views
1 Reply
Reply (1)
Message 2 of 2

strawberry12
Advocate
Advocate

OK - so the solution was simple: In Data Sources (ODBC) (aka ODBC Data Source Administrator) ...

 

- click Configure for your chosen connection

- Details >>

- under the Misc tab, check/tick the box that says "Ignore space after function names"

0 Likes