MySQL ODBC Connector - I need your help

Author

I need your help

Phil Taylor

2005-09-26, 9:23 am

Hi

I am trying to use this example in a vb.net project to connect to mysql database
that is located on a different machine but its on the same local network. I
already have a mysql odbc connection setup from the start-->control Panel-->
admin-->odbc as test with the login pos annd the password pos100 on my windows
xp machine. Mysql is running under linux and when I click on test connection
button from the control panel that works fine.

Dim fdCon As New OleDb.OleDbConnection(" Provider=MySQLProv;D
ata Source=test;User
Id=pos;Password=pos1
00;")
Dim fdCom As New OleDb.OleDbCommand("", fdCon)

fdCom.Connection.Open()

Dim fdRead As OleDb.OleDbDataReader =
fdCom. ExecuteReader(Comman
dBehavior.CloseConnection)

fdCom.CommandText = "INSERT INTO TABLENAME (FIELDNAME1, FIELDNAME2) VALUES
(""lookatme"", ""newline!"")"
fdCom.ExecuteNonQuery()

fdCon.Close()

The error I am getting when I run this is that it can not find the provider on
the
local machine. I already loaded the odbc drivers from mysql web site and when I
try and
register the myodbc3.dll I get a error message telling me that is was unable to
register
the program because it can not find the entry point.

I need some help please with this?

Thanks
PHillip Taylor

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc? unsu...sie.nctu.edu.tw

2005-09-26, 8:24 pm

Do you need to use ODBC? I have had success using the .NET Connector for
MySQL.

John B.

-----Original Message-----
From: Phil Taylor & #91;mailto:phil@tayl
orassociate.com]=20
Sent: Monday, 26 September 2005 10:50 PM
To: myodbc@lists.mysql.com
Subject: I need your help

Hi

I am trying to use this example in a vb.net project to connect to mysql
database
that is located on a different machine but its on the same local
network. I
already have a mysql odbc connection setup from the start-->control
Panel-->
admin-->odbc as test with the login pos annd the password pos100 on my
windows
xp machine. Mysql is running under linux and when I click on test
connection
button from the control panel that works fine.

Dim fdCon As New OleDb.OleDbConnection(" Provider=3DMySQLProv
;Data
Source=3Dtest;User
Id=3Dpos;Password=3D
pos100;")
Dim fdCom As New OleDb.OleDbCommand("", fdCon)

fdCom.Connection.Open()

Dim fdRead As OleDb.OleDbDataReader =3D
fdCom. ExecuteReader(Comman
dBehavior.CloseConnection)

fdCom.CommandText =3D "INSERT INTO TABLENAME (FIELDNAME1, FIELDNAME2)
VALUES
(""lookatme"", ""newline!"")"
fdCom.ExecuteNonQuery()

fdCon.Close()

The error I am getting when I run this is that it can not find the
provider on
the
local machine. I already loaded the odbc drivers from mysql web site
and when I
try and
register the myodbc3.dll I get a error message telling me that is was
unable to
register
the program because it can not find the entry point.

I need some help please with this?

Thanks
PHillip Taylor

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc? unsu...sie.nctu.edu.tw

Sponsored Links