February 7, 2006 at 12:53 am
I have a Connection string which is used to connect to a SQL SERVER Database Server from ASP page.
Connection string 1:
Provider=SQLOLEDB.1;Network Liberary=dbmssocn;Persist Security Info=False;User ID=sa; Initial Catalog=Center;Data Source=20.145.112.112
I want to user a simple query string with named pipe and not with the Network Liberary=dbmssocn option as below:
Connection string 2:
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa; Initial Catalog=Center;Data Source=20.145.112.112
If i use the "Connection string 2" it says "SQL Server not found"
Can some one suggest on how can i connect the SQL server using the "Connection string 2" connection string.
Web server is Windows 2000 ,SP 5
mdac Level is 2.80.1022.3
Pavas
Dream The Dream
Explore the World
Experince The Exhilaration
February 8, 2006 at 3:29 am
Have you tried checking here:
http://www.connectionstrings.com/
February 8, 2006 at 4:36 am
Let me check this ...
Pavas
Dream The Dream
Explore the World
Experince The Exhilaration
February 8, 2006 at 6:34 am
Hey guys i have a solution for the above problem
There is a utility called as Client Network Utility
Go to Run->cliconfg.exe
In the cliconfg.exe there is an Alias Tab where
In one Web server it is defined to some path like as below [Server where we have to use the Network liberary]
//server name/pipe/sql/query
But in the other Web server it was not defined any thing in Alias Tab.[This was working without original query string]
I have removed the Alias from the server where Normal query string was not working and it works.
Thanks for all of your time and support.
Can some one give a hint why is this Alias is used for so that i can dig more.
Pavas
Dream The Dream
Explore the World
Experince The Exhilaration
February 8, 2006 at 6:39 am
Hey guys i have a solution for the above problem
There is a utility called as Client Network Utility
Go to Run->cliconfg.exe
In the cliconfg.exe there is an Alias Tab where
In one Web server it is defined to some path like as below [Server where we have to use the Network liberary]
//server name/pipe/sql/query
But in the other Web server it was not defined any thing in Alias Tab.[This was working without original query string]
I have removed the Alias from the server where Normal query string was not working and it works.
Thanks for all of your time and support.
Can some one give a hint why is this Alias is used for so that i can dig more.
Pavas
Dream The Dream
Explore the World
Experince The Exhilaration
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply