List:General Discussion« Previous MessageNext Message »
From:Werner Stuerenburg Date:July 14 2001 3:30pm
Subject:Re[2]: Remote Access to SQL Server via Internet
View as plain text  
Shouldn't you say localhost instead???? This is what I do. If you
want to connect to a server not on your machine, you must have
extra right. Most ISPs won't do that for security reasons.

Sie schrieben am Samstag, 14. Juli 2001, 16:10:52:

> 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:brucev@stripped]
> Sent: Friday, July 13, 2001 7:20 PM
> To: mysql@stripped
> 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
> brucev@stripped


> ---------------------------------------------------------------------
> 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 <mysql-thread79544@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-ws=art-quarter.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-- 
Herzlich
Werner Stuerenburg            

_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de


Thread
Remote Access to SQL Server via InternetBruce Vander Werf14 Jul
  • Re: Remote Access to SQL Server via InternetGary Huntress14 Jul
  • Re: Remote Access to SQL Server via InternetJoshua J. Kugler14 Jul
    • Re[2]: Remote Access to SQL Server via InternetWerner Stuerenburg14 Jul
  • Re: Remote Access to SQL Server via InternetJoe Taraba14 Jul
    • Re: Remote Access to SQL Server via InternetDuncan Hill14 Jul
Re: Remote Access to SQL Server via InternetBruce Vander Werf14 Jul
  • Re[2]: Remote Access to SQL Server via InternetWerner Stuerenburg14 Jul