invalid connection string

[2cxc]

i just setup the sql2k db and i was wondering if there is something i need to do, in order for the asp connection string on the web server (seperate server) in IIS6 to work?

I strongly believe my connection string is flawless in the asp script, but i keep getting this error:

Microsoft OLE DB Provider for SQL Server error '80004005'
Invalid connection string attribute

this is the connection string:

sqlMenu="EXECUTE uspSideMenu2"

set connobjMenu = Server.CreateObject("ADODB.Connection")
connobjMenu.CommandTimeout=20000
connobjMenu.open "DSN=" & Application("DSN") &_
";UID=" & Application("ipo_adm") &_
";PWD=" & Application("ipo_adm_password")
set rsMenu = connobjMenu.Execute(sqlMenu)

where ipo stuff is translated into the real info in the global.asa file and this is the store procedure call above, which is correct in syntax:
CREATE PROCEDURE uspSideMenu AS
Select * from sideMenu sm, parentMenu pm
where sm.parentMenuID= pm.menuID and sm.parentMenuID<2
order by sm.parentMenuID
GO


i'm figuring maybe there are some kinda setting in the sql2k db, that i'm unaware of, since i'm kinda new to sql DBs.

thanks

 

[nigelrivett]

should be ok - is the default database correct?
Do you have the latest mdac on the web server?

I assume the error is from opening the connection not the SP call.

Dim strConnect
Dim objDB
strConnect = "DSN=dbdsn;" &_
"UID=username;" & _
"PWD=password;" & _
"Database=dbname"

Set objDB = Server.CreateObject("ADODB.Connection")
objDB.Open strConnect
Set connectDB = objDB

see

http://www.nigelrivett.net/DBAccess.inc.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.