RE: ASP Connection to Mysql fails

2004-08-17 Thread Armando
rrow with a few people at work and see what I can come up with and will let you know. This is starting to bug me too... Armando -Original Message- From: Paul Stearns [mailto:[EMAIL PROTECTED] Sent: August 15, 2004 11:51 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: ASP Connection

Re: ASP Connection to Mysql fails

2004-08-15 Thread Michael Stassen
s 3307. Paul -Original Message- From: Michael Stassen [EMAIL PROTECTED];] Sent: 8/15/2004 8:05:23 PM To: [EMAIL PROTECTED] Subject: Re: ASP Connection to Mysql fails If I understand you correctly, you can connect to both mysql servers from localhost, but not to one from the other. To mysql, a

RE: ASP Connection to Mysql fails

2004-08-15 Thread Paul Stearns
othesis is that the odbc driver is confusing (or ignoring)either the ip address or port # for the local mysql DB with what I want for the remote. Paul -Original Message- From: Armando [EMAIL PROTECTED];] Sent: 8/15/2004 11:35:44 PM To: [EMAIL PROTECTED] Subject: RE: ASP Connection to My

RE: Re: ASP Connection to Mysql fails

2004-08-15 Thread Paul Stearns
7; OPTION=35;" work? Yes the port number really is 3307. Paul -Original Message- From: Michael Stassen [EMAIL PROTECTED];] Sent: 8/15/2004 8:05:23 PM To: [EMAIL PROTECTED] Subject: Re: ASP Connection to Mysql fails If I understand you correctly, you can connect to both mysql serv

Re: ASP Connection to Mysql fails

2004-08-15 Thread Michael Stassen
If I understand you correctly, you can connect to both mysql servers from localhost, but not to one from the other. To mysql, a user is a combination of user and connecting host, so I think your problem translates as you can connect as [EMAIL PROTECTED], but you cannot connect as [EMAIL PROTECT

RE: ASP Connection to Mysql fails

2004-08-15 Thread Paul Stearns
Ignore the sentence that starts Remember... When I telnet to port 3307 on the DB server from the web server I get the version, a few characters of garbage and it disconnects. Paul -Original Message- From: Paul Stearns [EMAIL PROTECTED];] Sent: 8/15/2004 6:01:59 PM To: [EMAIL PROTECTED]