Thanks for all who responded. Here is the error message I get when I try to
connect to my current WSP:
MySQL Error Code: (1130)
"Host '63:160.226.3' is not allowed to connect to this MySQL server"
It looks like I need to find a new WSP. My current WSP is WebSiteSource
(www.websitesource.com), and I've been pretty happy with them until now. I
looked at Aletia Hosting (aletiahosting.com). They are very fast and it
looks like I can get a package comparable to what I have with WebSiteSource.
However, I jut got an e-mail from them that says they don't allow remote
access to SQL databases either. Sigh....
--Bruce
-----Original Message-----
From: Bruce Vander Werf [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 13, 2001 7:20 PM
To: [EMAIL PROTECTED]
Subject: Remote Access to SQL Server via Internet
Hi,
I would like to be able to create some tables in a database on an SQL server
at my web provider, then access those tables via a client application
running on my PC over the Internet (dial-up connection). My understanding is
that the client application accesses the SQL server via TCP/IP and not ODBC.
My web provider says no way. They can enable an ODBC connection for one
static IP address, which is not an acceptable solution, because a) I don't
want to use ODBC, and b) my dial-up connection may use one of a range of IP
addresses. They will not let me have direct TCP/IP access to the database.
My question is why my ISP would say this. Of course the database is password
protected, so I don't see why direct access is any more a security risk than
using their web-based client. Is this common practice among ISPs, or do I
need to shop for a new one? Any suggestions?
--
Bruce Vander Werf
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
