September 16, 2003 at 11:22 pm
We are not able to connect to the sql server database via asp,using Vb it does connect.
The only difference I see is that the sql server has been installed in an instance.
Any one Can help?
Pay Respect to People on your way up. For you will meet the same People on your way down.
He who knows others is learned but the wise one is one who knows himself.
September 17, 2003 at 12:01 am
I need to know how do I mention the instance name in the connection string.
This is what I am doing
oCon.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=aaa;Data Source=servername\instance"
Pay Respect to People on your way up. For you will meet the same People on your way down.
He who knows others is learned but the wise one is one who knows himself.
September 17, 2003 at 12:45 am
Hi brokenrulz,
quote:
I need to know how do I mention the instance name in the connection string.This is what I am doing
oCon.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=aaa;Data Source=servername\instance"
maybe this could help you http://qa.sqlservercentral.com/columnists/awarren/worstpracticebadconnectionstringsandbadinfoinsyspr.asp ?
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
September 17, 2003 at 1:32 am
What I have noticed is that if I use Named Pipes in client network configuration I can connect to the sql server (The server is on the lan). But if i change it to tcp/ip it does not connect through vb also.
Is it because
1.The fire wall is blocking requests send from 1433 port of my machine. ( I may be wrong)
2. 1433 port is blocked on the server where sql server is installed.
Pay Respect to People on your way up. For you will meet the same People on your way down.
He who knows others is learned but the wise one is one who knows himself.
September 17, 2003 at 10:15 am
Or the server isn't listening for sockets (check the server network utility).
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
September 17, 2003 at 11:28 pm
I am able to connect via both ASP and VB if I use TCP/IP.However named pipes don't work.
Any reasons that prevents ASP pages from connecting when Named pipes is used.
He who knows others is learned but the wise one is one who knows himself.
He who knows others is learned but the wise one is one who knows himself.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply