connection strings
- Started
- Last post
- 3 Responses
- RocaBaby
CONNECTING TO SQL SERVER VIA AN IP ADDRESS:
http://www.connectionstrings.com…
-OLE DB
-Connect via an IP address:THis doesn't seem to work I neeed help. Basically, I have a website running on someonelses server, But I want to connect to the SQL Database on My Server. I have no problems usning a connection string on one of my websites. But when I try and use an IP I get nothing?
- RocaBaby0
I know there are some SQL Server dudes here, please help me. I know my Server is listening on 1433, and I created UID & PASS, MY IP is right. what am I doing wrong?
- jpea0
whenever i have a problem with tech stuff the ars technica forum usually gives me some help...
check it out
http://arstechnica.infopop.net
- Cowboy_D0
The problem is most likely the fact that most SQL servers only let you connect to them from the same machine they are running on unless you manually create a user account that you specify can connect from elsewhere. I dont know about SQL Server, but this is the case in both Oracle and MySQL so this is most likely your problem here.
For example in MySQL, when creating a user account you specify a username, password and host - which either leave (to mean localhost), specify an IP to connect from or specify "%" to mean any IP.