Connecting to Mysql via ODBC 5.0

[Guest]

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.

 

[Michael Nemtsev]

Hello Josema,

Have u tried to look there http://dev.mysql.com/doc/refman/5.0/en/odbc-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

 

[Michael Nemtsev]

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 Nietzsch