Are you sure have both windows host values setup the same? Do you
maybe have default domain setup on one, and not the other? MySQL host
issues, can be a pain at times, I use either localhost, and/or %. The
firewall takes care of which hosts can see mysql, makes it much easier.
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
On Apr 1, 2008, at 7:02 AM, Fogelson, Steve wrote:
Ics5 – sqlserver
Ics9 - Witango server – Windows 2003 Web Edition - MySQL ODBC
Connector
Ics14 - Witango server – Windows 2003 Web Edition – MySQL ODBC
Connector
I thought both ics9 and ics14 were set up identical. I setup a user
in MySQL on ics5 as follows as this was the only way ODBC access
from ics9 would work. The host had to be “ics9.askics.net”. When I
duplicated the user except for changing the host to
“ics14.askics.net”, the ODBC connector on ics14 couldn’t connect.
After a while I finally noticed that the user’s host had to be
“ics14” instead “ics14.askics.net”.
Can someone tell me how the ODBC connector on a server determines
the host? “ics14.askics.net” vrs “ics14”.
Thanks
Steve Fogelson
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
