[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    RE: I need your help
From:       <jbonnett () sola ! com ! au>
Date:       2005-09-26 22:56:44
Message-ID: CDD2448EDE5CAE4499CA5828A4CAF788B9C911 () pine ! ap ! sola ! com
[Download RAW message or body]

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] 
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=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=mysql-odbc@progressive-comp.com


[prev in list] [next in list] [prev in thread] [next in thread]