MySQL Connectivity

[nailbombjoe]

I'm trying to connect to a MySQL server in AutoCAD 2002 using dbconnect. I installed the ODBC driver from the MySQL website. I configured it through the ODBC settings in the Control Panel. I tested the connection from there and it worked. When I set up a connection using ODBC in dbconnect and I try to test it I get an "unexpected error" message. Is there some special setting I have to tweak in dbconnect?

Using:
Autocad 2002
Windows 98
MySQL server v4.1.7

Any help will be appreciated and yes I did check the other posts before creating this one.

Thanks :)

[Adesu]

Hi nailbombjoe,may be you can try this

Ade <***@telkom.net> wrote in message news:***@WebX.maYIadrTaRb...
Same with me problem for last time,and now i success to connect db,before
with db connect suggest for all user
# install MDAC_TYP.EXE
# Creat data base by MICROSOFT ACCESSS,put your data on your folder.
# Setting ODBC
- click start>setting>control panel>click 2x ODBC data source
- ODBC DATA SOURCE ADMINISTRATION dialog box,click USER DSN and click xxx
file ,click ADD
- CREAT NEW DATA SOURCE dialog box ,click MICROSOFT ACCESS DRIVER,click
finish
- On ODBC MICROSFT ACCESS SETUP,type your data base ,click select find
your data ,on system database select database,type your data base,click OK.
# application on Auto CAD
- click tools menu>db connect
- on db manager click data source
- click db connect menu>data source>configure
- at CONFIGURE A DATA SOURCE,type your database,click OK
- at DATA LINK PROPERTIES click MICROSOFT JET 4.0 OLE DB PROVIDER clicl
next
-Connection tab click [...] find your database
-click PROVIDER,click MICROSOFT OLE DB PROVIDER FOR ODBC DRIVERS click
next.
-Connection tab,type your database on USE DATA SOURCE NAME
click TEST CONNECTION
-click OK,click OK
-On DB MANAGER must be displayed your data base

Post by nailbombjoe
I'm trying to connect to a MySQL server in AutoCAD 2002 using dbconnect.

I installed the ODBC driver from the MySQL website. I configured it
through the ODBC settings in the Control Panel. I tested the connection
from there and it worked. When I set up a connection using ODBC in
dbconnect and I try to test it I get an "unexpected error" message. Is
there some special setting I have to tweak in dbconnect?

Post by nailbombjoe
Autocad 2002
Windows 98
MySQL server v4.1.7
Any help will be appreciated and yes I did check the other posts before creating this one.
Thanks :)

[Jon Fleming]

Ther may be nothing to do.

In December 2003 Robert Broussard reported a similar problem, and tracked down the
reason. I bet you're seeing the same thing. I asked ADN about it and the reply was
that yes, the problem exists, but MySQL is not a supported DBMS so they might or might
not do something about it someday.

See <http://discussion.autodesk.com/thread.jspa?messageID=1942926>, the fourth message
in the thread.

I don't know who's doing it wrong, Autodesk or MySQL.

Maybe, if MySQL has an OLEDB data provider, you can use that instead of ODBC.
--
jrf
Autodesk Discussion Group Facilitator
Please do not email questions unless you wish to hire my services

Post by nailbombjoe
I'm trying to connect to a MySQL server in AutoCAD 2002 using dbconnect. I
installed the ODBC driver from the MySQL website. I configured it through the ODBC
settings in the Control Panel. I tested the connection from there and it worked.
When I set up a connection using ODBC in dbconnect and I try to test it I get an
"unexpected error" message. Is there some special setting I have to tweak in
dbconnect?
Autocad 2002
Windows 98
MySQL server v4.1.7
Any help will be appreciated and yes I did check the other posts before creating this one.
Thanks :)

[Stephan Koster]

Post by Jon Fleming
Ther may be nothing to do.
In December 2003 Robert Broussard reported a similar problem, and tracked down the
reason. I bet you're seeing the same thing. I asked ADN about it and the reply was
that yes, the problem exists, but MySQL is not a supported DBMS so they might or might
not do something about it someday.
See <http://discussion.autodesk.com/thread.jspa?messageID=1942926>, the fourth message
in the thread.
I don't know who's doing it wrong, Autodesk or MySQL.
Maybe, if MySQL has an OLEDB data provider, you can use that instead of ODBC.

I looked at the mentioned thread and there Robert Broussard wrote that
the problem is the extra space in the query:
SELECT COUNT (*) FROM tablename
he means the space after 'COUNT'

In the MySQL OBDC-driver there is an option to ignore this space:
Go to the ODBC settings in the Control Panel, select your MySQL-DSN,
click 'Configure...' and then 'Options >>' and then enable
'Ignore Space After Function Names'.
With this setting enabled, dbconnect works for me.

Stephan

[Jon Fleming]

Great! Thanks for posting that solution. That's a keeper!
--
jrf
Autodesk Discussion Group Facilitator
Please do not email questions unless you wish to hire my services

Post by nailbombjoe

Post by Jon Fleming
Ther may be nothing to do.
In December 2003 Robert Broussard reported a similar problem, and tracked down the
reason. I bet you're seeing the same thing. I asked ADN about it and the reply

was

Post by Jon Fleming
that yes, the problem exists, but MySQL is not a supported DBMS so they might or

might

Post by Jon Fleming
not do something about it someday.
See <http://discussion.autodesk.com/thread.jspa?messageID=1942926>, the fourth

message

Post by Jon Fleming
in the thread.
I don't know who's doing it wrong, Autodesk or MySQL.
Maybe, if MySQL has an OLEDB data provider, you can use that instead of ODBC.

I looked at the mentioned thread and there Robert Broussard wrote that
SELECT COUNT (*) FROM tablename
he means the space after 'COUNT'
Go to the ODBC settings in the Control Panel, select your MySQL-DSN,
click 'Configure...' and then 'Options >>' and then enable
'Ignore Space After Function Names'.
With this setting enabled, dbconnect works for me.
Stephan

[RobertBroussard]

For some reason I decided to Google my name today (out of sheer boredom) and I came across this thread. I could not believe the odds of finding the solution to a problem I posted over a year ago...but here I am! This is cool. Thanks Stephan!

And Jon your the man! That ADOLISP Library is the greatest thing since sliced bread.

Take care guys,

Robert Broussard