Data Link - Can't connect to database

  • Thread starter Thread starter Alex Hardin
  • Start date Start date
A

Alex Hardin

Hey,
I'm trying to use the connect to database wizard to connect to a MySQL
database on my web server, 66.235.193.45 (I'm actually not sure if that
points specifically to my part of the server, if not, the domain that
goes right to is is www.freddyswebgraphics.com, which I have tried as
well), and everytime I try to test the connection I get this error
message.

Test connection failed because of an error in initializing provider.
[DBNETLIB][ConnectionOpen (ParseConnectParams().]Invalid connection.

I know that I've entered all the information correctly, so I have a
feeling that is is something like the wizard doesn't support MySQL
databases, in that case I'd have to just put in the code manually,
which I've looked into, but everything I've found, is for Visual Basic
or C#. OR, is it that I am in fact not entering some information
correctly? Namely something after the IP to make it only go to the
database rather then the HTTP server, or a differnt SQL/OleDB provider?

All help will be greatly appreciated, and sorry if this is the wrong
group, but I have a feeling that if I posted in a MySQL group they'd
tell me to come to a C++ or .Net group. Merry Christmas!
 
you have to use the ODBC data components. the SQL components are only for
microsoft SQL server. the oledb components for access, excell, ...

you have to configure an ODBC link to your db using control panel ->
computer management -> odbc administrator.
after doing that you can check if the link is ok.

then you just have to use the ODBC data components to access your database.

kind regards,
Bruno.
 
Back
Top