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@xxxxxxxxxxxxxxxxxxx] 
Sent: Monday, 26 September 2005 10:50 PM
To: myodbc@xxxxxxxxxxxxxxx
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=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@xxxxxxxxxxx