ASP > ASPX problem, DW8

Report · Dec 12, 2006

Hello,

I have been struggling with connecting to my MS SQL 2000 database using .NET
/ ASPX for a couple of days now.

I'm currently using ASP with a MS SQL 2000 database on a Windows 2003
Server. For my classic ASP sites, the server string format is:
"Driver={SQL
Server};Server=MY-SERVER\TWO;Database=theTable;UID=theuser;PWD=thepassword;"
This works great with ASP.

However, I can't get it to work at all with .NET & ASPX with the web.config
file configuration.

With the web.config file, what is the "Datasource=" equivalent to the above
connection string that works in ASP?

Thanks,
Bob

Report · Dec 12, 2006

The connection you're using for classic ASP is ODBC. The data source
property is part of an OLE DB connection (which is a better connection
anyway). You can use an OLE DB connection with classic ASP as well.

For directions: www.connectionstrings.com

"Bob Sorrells" <rsorrellsYOUKNOW@WHAT2DOmindspring.com> wrote in message
news:eln34m$in9$1@forums.macromedia.com...
> Hello,
>
> I have been struggling with connecting to my MS SQL 2000 database using
> .NET / ASPX for a couple of days now.
>
> I'm currently using ASP with a MS SQL 2000 database on a Windows 2003
> Server. For my classic ASP sites, the server string format is:
> "Driver={SQL
> Server};Server=MY-SERVER\TWO;Database=theTable;UID=theuser;PWD=thepassword;"
> This works great with ASP.
>
> However, I can't get it to work at all with .NET & ASPX with the
> web.config file configuration.
>
> With the web.config file, what is the "Datasource=" equivalent to the
> above connection string that works in ASP?
>
> Thanks,
> Bob
>
>
>