Are you using the myodbc drivers for mysql?
--- Norman McLeod <[EMAIL PROTECTED]> wrote: > 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 > >MessageText = "[TCX][MyODBC]Host > 'jackson-24-159-79-100.midtn.chartertn.net' is not > allowed to connect to > this MySQL server" > > dbc: szSqlState = "S1000", *pfNativeError = 1130, > *pcbErrorMsg = 108, > *ColumnNumber = -1, *RowNumber = -1 > >MessageText = "[TCX][MyODBC]Host > 'jackson-24-159-79-100.midtn.chartertn.net' is not > allowed to connect to > this MySQL server" > > dbc: szSqlState = "01000", *pfNativeError = 0, > *pcbErrorMsg = 140, > *ColumnNumber = -1, *RowNumber = -1 > >MessageText = "[Microsoft][ODBC Driver > Manager] The driver doesn't > support the version of ODBC behavior that the > application requested (see > SQLSetEnvAttr)." > > dbc: szSqlState = "01000", *pfNativeError = 0, > *pcbErrorMsg = 140, > *ColumnNumber = -1, *RowNumber = -1 > >MessageText = "[Microsoft][ODBC Driver > Manager] The driver doesn't > support the version of ODBC behavior that the > application requested (see > SQLSetEnvAttr)." > > > It seems to me that the first 2 have to do with the > permissions in setup, > but that's only a guess. > The bottom 2 I expect I could work on the settings > strings on my end? > > Any logic to my guesses??? > > > -----Original Message----- > From: Dan Crawford [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 04, 2002 1:24 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; > [EMAIL PROTECTED]; > [EMAIL PROTECTED] > Subject: RE: ms acess to mysql > > > I successfully upsized a small Access 2000 database > to MySQL this weekend. > It was a little tricky, and I had to do some manual > altering of the table > structures after I upsized, but I eventually got it > to work. > > Are you getting any kind of error message that might > shed some light on the > issue? > > Dan Crawford > Integrated Network Strategies > > > 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 get > it to work... > > > > > > Thanks in Advance > > > > Norm McLeod > > Digital Signature & Public PKI key attached > <http://www.thawte.com/> > > > > > > > > -----Original Message----- > > From: Duncan Hill [mailto:[EMAIL PROTECTED]] > > Sent: Friday, January 04, 2002 12:45 PM > > To: Investor > > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > > Subject: Re: ms acess to mysql > > > > > > On Fri, 4 Jan 2002, Investor wrote: > > > >> Has anyone converted data in MS Access to Mysql? > >> > >> I would think this is possible!! > > > > "ODBC". > > > > (sql,mysql,database) > > > > -- > > > > Sapere aude > > My mind not only wanders, it sometimes leaves > completely. > > Never attribute to malice that which can be > adequately explained by > > stupidity. > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list > archive) > > > > To request this thread, e-mail > <[EMAIL PROTECTED]> To > > unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list > archive) > > > > To request this thread, e-mail > <[EMAIL PROTECTED]> To > > unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > Trouble > > unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > ===== Regards, Investorclb __________________________________________________ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php