Thanks for the help with MyODBC

2002-01-08 Thread Norman McLeod
Through the responses, links, and a little concern (and a really smart and helpful web Host, he did most of the hard stuff), I got MyODBC working like a charm. Made up a file DSN and can use it in Visual C++, Visual Basic, and Access. Also thanks to whomever put MyODBC out there...

RE: ms acess to mysql

2002-01-04 Thread Norman McLeod
My question too... Matter of fact, I found a ODBC driver for M$-MySQL access, i.e., Visual C++/Visual Basic/Access, but can't get it to work. Anybody have any experience with this? I know about the Port 3306, I know about the wildcard permissions to access MySQL from any domain, but still can't

RE: ms acess to mysql-More information

2002-01-04 Thread Norman McLeod
Thanks for the help so far. The specific error messages I get are: SQLDriverConnect returned: SQL_ERROR=-1 dbc:szSqlState = S1000, *pfNativeError = 1130, *pcbErrorMsg = 108, *ColumnNumber = -1, *RowNumber = -1