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=MySQLProv;Data Source=test;User
Id=pos;Password=pos100;")
Dim fdCom As New OleDb.OleDbCommand("", fdCon)

fdCom.Connection.Open()

Dim fdRead As OleDb.OleDbDataReader =
fdCom.ExecuteReader(CommandBehavior.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?unsub=gcdmo-myodbc@m.gmane.org

RE: I need your help

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

John B.

-----Original Message-----
From: Phil Taylor [mailto:phil@taylorassociate.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=3Dpos100;")
Dim fdCom As New OleDb.OleDbCommand("", fdCon)

fdCom.Connection.Open()

Dim fdRead As OleDb.OleDbDataReader =3D
fdCom.ExecuteReader(CommandBehavior.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?unsub=3Dgcdmo-myodbc@m.gmane.o rg