Re: oledbConnection to SQL Server

[Mark Rae [MVP]]

"Roger Withnell" <Ro***********@discussions.microsoft.comwrote in message
news:95**********************************@microsof t.com...

What is the connection string in asp.net?
OleDbConnection("?")

For ASP.NET you should use a native .NET data provider whenever possible:
http://www.connectionstrings.com/?carrier=sqlserver2005
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[=?Utf-8?B?Um9nZXIgV2l0aG5lbGw=?=]

I can now connect to the database on my operational server, which uses SQL
Server authentication, with:

'dbconn=New OleDbConnection("Provider=sqloledb; Data Source=ip address;
Initial Catalog=dbName; User Id=xxxx; Password=yyyy;")

But I cannot connect to my in house SQL Server on localhost, which uses
Windows Authentication. The string:

dbconn=New OleDbConnection("Provider=sqloledb; Data
Source=UBE-IAS\SQLEXPRESS; Initial Catalog=upperbridge2; User Id=;
Password=;")

gives the error Invalid authorization specification.

What is the correct connection string for this?

Thanking you in anticipation.

Roger

"Mark Rae [MVP]" wrote:

"Roger Withnell" <Ro***********@discussions.microsoft.comwrote in message
news:95**********************************@microsof t.com...

What is the connection string in asp.net?
OleDbConnection("?")

For ASP.NET you should use a native .NET data provider whenever possible:
http://www.connectionstrings.com/?carrier=sqlserver2005
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Mark Rae [MVP]]

"Roger Withnell" <Ro***********@discussions.microsoft.comwrote in message
news:BB**********************************@microsof t.com...

[top-posting corrected]

What is the connection string in asp.net?
OleDbConnection("?")

For ASP.NET you should use a native .NET data provider whenever possible:
http://www.connectionstrings.com/?carrier=sqlserver2005

I can now connect to the database on my operational server, which uses SQL
Server authentication, with:

'dbconn=New OleDbConnection("Provider=sqloledb; Data Source=ip address;
Initial Catalog=dbName; User Id=xxxx; Password=yyyy;")

Again, why are you even trying to use OleDb to connect to SQL Server through
ASP.NET...?

What is the correct connection string for this?

I've already given you the link, but here it is again:
http://www.connectionstrings.com/?carrier=sqlserver2005

Please scroll down *past* the OleDb section until you come to the section
entitled SqlConnection (.NET)
--
Mark Rae
ASP.NET MVP
http://www.markrae.net