471,605 Members | 1,620 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,605 software developers and data experts.

Connecting to Mysql via ODBC 5.0

Good Day to everyone.. please help me how to connect to MYSQL 5.0. I am using
the connection string.
I installed the ODBC MySQL Connector/ODBC v5.

my connecstring

------------------
dbcon.ConnectionString = "DRIVER={MySQL ODBC 5.0 Driver};" _
& "SERVER=" & servername & _
";DATABASE=" & dbname & _
";UID=rlp;PWD=rlp; OPTION=3"
----------------
where
servername is myservername and dbname is my databasename i created in
MySQL.. it says that my data source not found and no default driver
specified.

but when i connect using ODBC 3.51 theres no problem.. is there any way i
can connect to ODBC using v5 connector... i am using visual c# nad running
under windows XP Pro.
--
Thanks
Regards.
Josema
Feb 21 '06 #1
2 1541
Hello Josema,

Have u tried to look there http://dev.mysql.com/doc/refman/5.0/...connector.html
?

J> Good Day to everyone.. please help me how to connect to MYSQL 5.0. I
J> am using the connection string. I installed the ODBC MySQL
J> Connector/ODBC v5.
J>
J> my connecstring
J>
J> ------------------ dbcon.ConnectionString = "DRIVER={MySQL ODBC 5.0
J> Driver};" _ & "SERVER=" & servername & _ ";DATABASE=" & dbname & _
J> ";UID=rlp;PWD=rlp; OPTION=3" ---------------- where servername is
J> myservername and dbname is my databasename i created in MySQL.. it
J> says that my data source not found and no default driver specified.
J>
J> but when i connect using ODBC 3.51 theres no problem.. is there any
J> way i can connect to ODBC using v5 connector... i am using visual c#
J> nad running under windows XP Pro.
J>
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche
Feb 21 '06 #2
Hello Josema,

Or look there http://dev.mysql.com/tech-resources/articles/dotnet/

J> Good Day to everyone.. please help me how to connect to MYSQL 5.0. I
J> am using the connection string. I installed the ODBC MySQL
J> Connector/ODBC v5.
J>
J> my connecstring
J>
J> ------------------ dbcon.ConnectionString = "DRIVER={MySQL ODBC 5.0
J> Driver};" _ & "SERVER=" & servername & _ ";DATABASE=" & dbname & _
J> ";UID=rlp;PWD=rlp; OPTION=3" ---------------- where servername is
J> myservername and dbname is my databasename i created in MySQL.. it
J> says that my data source not found and no default driver specified.
J>
J> but when i connect using ODBC 3.51 theres no problem.. is there any
J> way i can connect to ODBC using v5 connector... i am using visual c#
J> nad running under windows XP Pro.
J>
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche
Feb 21 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by kamilla | last post: by
2 posts views Thread by s5034454 | last post: by
3 posts views Thread by Jeremy Dillinger | last post: by
3 posts views Thread by Mike | last post: by
3 posts views Thread by Paradox Synthesist | last post: by
1 post views Thread by XIAOLAOHU | last post: by
reply views Thread by CCCYYYY | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.