connection problem MSSQL SERVER & PWS same machine

Im getting an error when i try to connect to my MS SQL database

0x80040e21 ... multiple-step ole db operation generated errors ...check each ole db status value

this code works connecting to database via web hosting, only things i changed was to replace the server with "(local)" [also tried ip no joy there either] and add integrated security to the connection string

ms sql server and IIS, personal web server all on same laptop, i can access the same database with same details no problem to login it gives up on the subsequent login

code (generally)

Set objconn=Server.CreateObject("ADODB.Connection")
objconn.ConnectionString="SERVER=(local);Database=blah;uid=blah1;pwd=blah2;Integrated Security=true;"

objconn.open

can anybody help

ta, bIf you are using Driver={SQL Server} then instead use the native OLEDB connection style of

Provider=SQLOLEDB.1;UID=user;Password=password;Initial Catalog=DBName;Data Source=Servername

Then try your code again.

Check the following URL:

http://www.adopenstatic.com/faq/80040e21.asp|||thanks om but im afraid i still havent got it working :( had seen that link already but thank u

i have tried all concievable options at this stage ?? eg

http://www.tnsites.com/support/s_databaseconn.asp#SQL

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.open "Driver={SQL Server};Provider=SQLOLEDB.1;SERVER=136.xxx.xxx.xxx;DSN=localhostname;UID=uuu;PWD=ppp;Initial Catalog=bmdb; Integrated Security=true"

Error Type:
Provider (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/DotNetNuke/jobid/sel_services.asp, line 12

Any further suggestions?

I have no problem hooking up to same database in the web.config file --

<add key="connectionString" value="Server=136.xxx.xxx.xxx;Database=bmdb;uid=uuu;pwd=ppp;Integrated Security=true;" /
--

AND it worked previously on the web4life internet hosting server --

Set objConn=Server.CreateObject("ADODB.Connection")
objConn.ConnectionString="DRIVER={SQL Server};SERVER=xxx.xxxxx.com;Database=bmdb;uid=uuu;pwd=ppp"
objConn.open

--

hosted on the local machine browsing locally
STILL ERROR (0x80040E21)

B|||...

asp or asp.net? and pws? <add key=.. shows it's asp.net, but you're using normal ado. i'm confused.|||ive just started asp.net, so the best I can say is that its an asp.net vb project running on a (pws) personal web server

its no wonder your confused seeing as im confused|||... pws? I'm still borked out on this. I didn't know ASP.NET can run on PWS.

First of all, if you're using an ado connection object like that, then you're better off using an ADO based connection string. Secondly, if you use .net, you should research ado.net under the System.Data namespace.