invalid connection string

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

invalid connection string - SQL

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> invalid connection string - SQL

Page: [1]

lu lu

Posts: 418
From: wpg, mb
Status: offline

invalid connection string - SQL - 11/12/2004 19:14:14

Please help me with this, i just can't seem to get it going.

this is the error:

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

this is the global.asa file:

<SCRIPT LANGUAGE="VBScript" RUNAT="Server">

	Sub application_onstart

Application("DSN") = """""; PROVIDER=SQLOLEDB;DATA SOURCE=Athos;database=real_otsite"
		
Application("ipo_adm") = "xxxx"
Application("ipo_adm_password") = "xxxx"		


		

        end sub
        
	
	sub Session_OnStart
	   session.Timeout=90
        end sub 
</SCRIPT>

this is the connection string:

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)

prior to the connection string i have a stored procedure called like so (don't know if this is important to solving the connection string issue, but here it is anyway):

sqlMenu="EXECUTE uspSideMenu2"

THANKS


Spooky Posts: 26599 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: invalid connection string - SQL - 11/12/2004 20:01:18 Its not actually a DSN, so : Application("DSN") = "PROVIDER=SQLOLEDB;DATA SOURCE=Athos;database=real_otsite" connobjMenu.open Application("DSN") &_ ";UID=" & Application("ipo_adm") &_ ";PWD=" & Application("ipo_adm_password") _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to lu lu)


lu lu Posts: 418 From: wpg, mb Status: offline	RE: invalid connection string - SQL - 11/15/2004 11:15:05 i don't know why i'm having such issues, maybe cause its Monday... Spooky, with the above i get this error: Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. any ideas as to why... Thanks (in reply to Spooky)


Spooky Posts: 26599 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: invalid connection string - SQL - 11/15/2004 13:58:52 Try going back to the good old : connobjMenu.open "DRIVER={SQL Server};SERVER=localhost;DATABASE=login;UID=sa;PWD=" _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to lu lu)

Page: [1]

All Forums >> Web Development >> ASP and Database >> invalid connection string - SQL

Page: [1]

Jump to: 1

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts