sql connection problem with ip address

ASP Free Forums Sponsor:

May 2nd, 2005, 10:51 AM

larbo

Registered User

Join Date: May 2005

Posts: 3

Time spent in forums: 42 m 50 sec
Reputation Power: 0

sql connection problem with ip address

This works:
connStr = "Driver={SQL Server};" &_
"Server=MachineName\InstanceName;Database=MyDatabas e;" &_
"Uid=MyId;Pwd=MyPwd;"

This doesn't:
connStr = "Driver={SQL Server};" & _
"Server=192.168.0.102\InstanceName,1433;" & _
"Database=MyDatabase;" & _
"Uid=MyId;" & _
"Pwd=MyPwd"

Why?

May 2nd, 2005, 06:34 PM

Scorpions4ever

Mad Rater

Join Date: Sep 2003

Posts: 126

Time spent in forums: 11 h 31 m 44 sec
Reputation Power: 8

Perhaps because your server isn't using TCP/IP connections and using Named Pipes alone. Also make sure it is listening on port 1433. You can check these with the Server Config utility.

__________________
Up the Irons
What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.

May 3rd, 2005, 05:19 AM

larbo

Registered User

Join Date: May 2005

Posts: 3

Time spent in forums: 42 m 50 sec
Reputation Power: 0

The server uses both TCP/IP (port 1433) and Named Pipes. I also oppened up the firewall for port 1433 but it didn't help

Viewing: ASP Free Forums > Database > Microsoft SQL Server > sql connection problem with ip address

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump