- can connect with jdbc admin tool - port scan shows 3306 is open, so no firewall issues - mysql permissions allow connection from the user coming from host=% - nothing on the server has changed, just moved to new IP address - odbc connection has new IP address in it
puzzled.....
did a recent OS X security patch break ODBC? On Mar 9, 2006, at 7:13 AM, Jason Pamental wrote: Roland,
Can you connect with the MySQL admin program from your machine to the colo dev server? If so, then it's probably a config thing on your machine - otherwise it might be blocked on the other end. See if the colo facility blocks traffic on certain ports, or if maybe it's blocked on the dev server itself for non-local traffic (OS firewall settings maybe?)
Just a few more ideas... can't think of anything else at the moment.
Jason
-----
Jason Pamental Director of Web Services North Sails
Office: 401.643.1415 Fax: 401.643.1420 Mobile: 401.743.4406
On Mar 9, 2006, at 9:45 AM, Roland Dumas wrote: I checked to make sure port 3306 is open, changed the server IP from old to new IP address. save. reboot., and still can't connect to database. Very perplexingOn Mar 8, 2006, at 10:44 PM, Customer Support wrote: Roland, It will look something like this in your odbc.ini file. Make sure you specify the ones in capitals.
[testdb_MySQL_remote] DRIVER = /usr/lib/libmyodbc3.dylib Description = Test DB SERVER = 10.1.1.1 PORT = 3306 User = Password = Database = testdb OPTION = 0 Socket =
Regards
Witango Support
On 09/03/2006, at 5:20 PM, Roland Dumas wrote: sorry. didn't give all the details:MacOS X / mysql 4 /ODBC
port 1433? 1433
Date: March 8, 2006 9:30:00 PM PST Subject: Witango-Talk: what port for odbc?
I moved my dev server from next room to a colo. I mucked with DNS so that domain records that used to point to closet now point to the colo properly.
In the Dev Studio, I can't connect to my dev server any more. It says "unable to connect to the data source ... verify that the data source is properly configured and that the database server is online
could it be that I need to open a port in the router? What else should I look at?
Roland A. Dumas 310 W. Bellevue Ave. San Mateo, CA 94402 650-347-1373 415-412-9300 (cell) AIM: radumas
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Roland A. Dumas 310 W. Bellevue Ave. San Mateo, CA 94402 650-347-1373 415-412-9300 (cell) AIM: radumas
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
|