[AccessD] Accessing a SQL DB

OT:

Hi All:

This is a little off topic but has anyone had experience connecting to a
full MS SQL DB from a beta version of Visual Studio 2003?

I am currently working with an ASP project and just can not get the program
to recognize the MS SQL server. It is local but I just can not get the
correct connection string sequence.

This is a connection string used to connect to an MS SQL Express DB:
connectionString="Data Source=.\SQLExpress;Integrated 
			Security=True;
			UserInstance=True;
			MyDBFilename=|DataDirectory|mydbfilename.mdf"
providerName="System.Data.SqlClient"

The above connects fine. I can even view the 'Express' server in the 'Server
Explorer' but the scan ignores the MS SQL 2000. It is definitely there as
other applications have no difficulty see and connecting to it.

Below is one of the many connection string combinations that I have tried.

connectionString="Provider=sqloledb;
			Data Source=xpserver;
			Initial Catalog=pubs;
			Integrated Security=SSPI;"

Or

The above was modeled from proven strings and from samples at
http://www.connectionstrings.com/


Any comments of assistance would be greatly appreciated.
Jim