I received similar messages to the first two in your e-mail, and setting
the host field appropriately in the mysql.user table resolved it.
I didn't receive any error messages like the last two in your message.
What version of myODBC, MySQL, and Access are you running?
Dan Crawford
Integrated Network Strategies
> 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
---------------------------------------------------------------------
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
