Connection String for classic ASP to SQL Server 2005

How can i connect to SQL server 2005 from classic ASP without trusted
connection ? I have an application in classic ASP which is currently
connecting to SQL server 2000. with connection string as
Driver={SQL Server};Server=Servername;Database=DBNm;user id="DD"; password
="ff"; it is working fine.
I am getting error while connecting to SQL Server 2005. i have given
connection string as Provider=SQLOLEDB;Data
Source=servername\SQL2005,8701;Initial Catalog=Alps;Network=DBMSSOCN;user
id="DFDF"; password ="FF". Can anyone send me the connection string used to
connect to SQL Server 2005 from classic ASP application without trusted
connecting.
Thanks in advance
Padmalochan Sahu
Here are few examples:
http://www.connectionstrings.com/?carrier=sqlserver2005
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Padmalochan Sahu" wrote:

> How can i connect to SQL server 2005 from classic ASP without trusted
> connection ? I have an application in classic ASP which is currently
> connecting to SQL server 2000. with connection string as
> Driver={SQL Server};Server=Servername;Database=DBNm;user id="DD"; password
> ="ff"; it is working fine.
> I am getting error while connecting to SQL Server 2005. i have given
> connection string as Provider=SQLOLEDB;Data
> Source=servername\SQL2005,8701;Initial Catalog=Alps;Network=DBMSSOCN;user
> id="DFDF"; password ="FF". Can anyone send me the connection string used to
> connect to SQL Server 2005 from classic ASP application without trusted
> connecting.
> Thanks in advance
> Padmalochan Sahu
|||Well, there are a number of reasons. First, you should be using the SQL
Native Provider instead of SQLOLEDB when connecting to SS 2005. Use SQLNCLI
instead.
Next, you need to make sure that the SQL Server is configured to accept
"mixed-mode" security. This is off by default during setup.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Padmalochan Sahu" <PadmalochanSahu@.discussions.microsoft.com> wrote in
message news:D60C4786-94AB-430E-A72F-3256E6AE7AA9@.microsoft.com...
> How can i connect to SQL server 2005 from classic ASP without trusted
> connection ? I have an application in classic ASP which is currently
> connecting to SQL server 2000. with connection string as
> Driver={SQL Server};Server=Servername;Database=DBNm;user id="DD"; password
> ="ff"; it is working fine.
> I am getting error while connecting to SQL Server 2005. i have given
> connection string as Provider=SQLOLEDB;Data
> Source=servername\SQL2005,8701;Initial Catalog=Alps;Network=DBMSSOCN;user
> id="DFDF"; password ="FF". Can anyone send me the connection string used
> to
> connect to SQL Server 2005 from classic ASP application without trusted
> connecting.
> Thanks in advance
> Padmalochan Sahu