MySQL Forums
Forum List  »  Connector/ODBC

[MySQL][ODBC 3.51 Driver] Could not find driver {MySQL ODBC 3.51 Driver} in system information.
Posted by: John Holton
Date: March 28, 2005 10:53AM

I have an Excel spreadsheet that makes a call to a MySQL database.
It works fine on my computer and a couple others we've tested it on in my office.
In another company office, my coworker is getting this error after installing the MyODBC driver (MyODBC-3.51.11-1-win.msi).

[MySQL][ODBC 3.51 Driver] Could not find driver {MySQL ODBC 3.51 Driver} in system information.

He's tried it on two computers and gotten the same thing both times.

We are on the same network.

My database call is in an Excel macro (have only changed server name, table name, etc):

Sub Macro1()
'
'
With ActiveSheet.QueryTables.Add(Connection:= _
"ODBC;DATABASE=DatabaseName;DRIVER={MySQL ODBC 3.51 Driver};OPTION=0;PORT=3306;SERVER=10.5.5.5;UID=root" _
, Destination:=Range("A1"))
.CommandText = Array( _
"SELECT field1, field2, field3 " & Chr(13) & "" & Chr(10) & "FROM tableName" _
)
.Name = "Query from 10"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.PreserveColumnInfo = True
.Refresh BackgroundQuery:=False
End With
End Sub


Any ideas?

Thanks.

Options: ReplyQuote


Subject
Written By
Posted
[MySQL][ODBC 3.51 Driver] Could not find driver {MySQL ODBC 3.51 Driver} in system information.
March 28, 2005 10:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.