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
