navigation
a webmaster learning community
     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
 

Advanced search
Recent Posts

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

Microsoft MVP

 

The Database Connection Named ' ' is unidentified ERROR

 
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 >> The Database Connection Named ' ' is unidentified ERROR
Page: [1]
 
ASP who?

 

Posts: 4
Joined: 12/16/2004
Status: offline

 
The Database Connection Named ' ' is unidentified ERROR - 12/16/2004 14:11:21   
Hi all. ASP Newb here. Hence the reason I'm at the mercy of the FP 2003 DRW. I've searched the various forums and checked the 2003 DRW FAQ, but no one seems to have resolved this particular issue in a manner that I understand. :)

The error is the same one, I'm sure, that people have seen a million times:
:)

As you can see in the code, the fp_sDataConn="Database3" is set and correct. It has been verified in the site settings, and, as such, it has not been removed from my web. The root folder does have write and scripting permissions enabled. I am unsure of the meaning of the last possibility "the web is not marked as an Application Root".

I do have other DB connections and other ASP pages functioning on other databases in this website. I've seen people recommending that you clean up otherwise verify the global.asa, and, though it looks fairly straightforward, I am unsure of how to do that without causing further damage. I will continue to peck away here, but I was hoping someone might have a suggestion or two.

Thanks in adv.
Garrett

< Message edited by ASP who? -- 12/20/2004 12:05:09 >
Spooky

 

Posts: 26603
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
RE: The Database Connection Named ' ' is unidentified E... - 12/16/2004 14:15:37   
On a blank asp page, add this in code view :

<%="Connection="&Application("Database3_Connectionstring")%>

Now open the asp page in your browser - what gets written to the screen?

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)


(in reply to ASP who?)
ASP who?

 

Posts: 4
Joined: 12/16/2004
Status: offline

 
RE: The Database Connection Named ' ' is unidentified E... - 12/16/2004 14:32:18   
I get:

Connection=

I tried running the page from several different directories, including those that have functioning ASP pages already, and I get the same thing.

Is this supposed to tell me that FP is not seeing my DB connection, though it states that it has been verified? see pics:

:)

:)

Thanks Spooky

(in reply to Spooky)
Spooky

 

Posts: 26603
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
RE: The Database Connection Named ' ' is unidentified E... - 12/16/2004 14:38:05   
Just to confirm the connection name, open your global.asa file, and locate the code I used.

You should see :
Application("Database3_Connectionstring") = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=....."

If it is the same - Application("Database3_Connectionstring") then it suggests your web is not marked as an application.
Youll need to ask your host to do this.

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)


(in reply to ASP who?)
ASP who?

 

Posts: 4
Joined: 12/16/2004
Status: offline

 
RE: The Database Connection Named ' ' is unidentified E... - 12/16/2004 14:52:56   
Global ASA for database3 conn:

'--Project Data Connection
Application("Database3_ConnectionString") = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/interface.mdb"
FrontPage_UrlVars(5) = "Database3_ConnectionString"
Application("Database3_ConnectionTimeout") = 15
Application("Database3_CommandTimeout") = 30
Application("Database3_CursorLocation") = 3
Application("Database3_RuntimeUserName") = ""
Application("Database3_RuntimePassword") = ""
'--

It would seem that all is well here, especially considering that the functioning DB conns are setup in a similar fashion. I would think if my web wasn't marked as an application space, then none of my DB conns in my web would work, correct?

For instance, I tried your single line of code for one of my other DB Conns (that was setup the same way, mind you) and I get this:

Connection=DRIVER={Microsoft Access Driver (*.mdb)};DBQ=F:\Inetpub\websites\eass\fpdb\Interface Statistics.mdb

Perhaps if I try to import the db again and tailor it to a previously existing db conn and see if I can even reach the db through the ASP page? Thanks for the feedback spooky. I'm off to see how badly I can rig this thing to work... :)

(in reply to Spooky)
ASP who?

 

Posts: 4
Joined: 12/16/2004
Status: offline

 
RE: The Database Connection Named ' ' is unidentified E... - 12/16/2004 15:17:13   
That did it. wtf?!? I took DB Conn 'database2' and tested it with your single line of code (which is right handy, thanks) and got the resulting Driver ID listed above. So I deleted the source DB (it was a test DB anyway) and imported my other DB with the same file name and destination directory as the one I deleted. I regenerated the existing DB results and it works fine. Go figure.

Is there some default setting in the global.asa that limits the amount of active DB conns you can have in one web, or something goofy like that? I've got 6, well, 5 now, but the thing is, they were all put together the same way. It seems odd that the DRW would balk on the very last one like this. I mean, what would I have done if I didn't have "extra" db conns laying around?

Either way, thanks for your help, Spooky. All my googling on this error for like the past two days has brought me to this board, so I figured this was a good place to ask. :)

(in reply to ASP who?)
dpf

 

Posts: 7123
Joined: 11/12/2003
From: India-napolis
Status: offline

 
RE: The Database Connection Named ' ' is unidentified E... - 12/16/2004 17:42:54   
quote:

has brought me to this board
and there is no better place to learn!

_____________________________

Dan

(in reply to ASP who?)
Spooky

 

Posts: 26603
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
RE: The Database Connection Named ' ' is unidentified E... - 12/16/2004 20:46:53   
Quite often the act of importing a database will reset the required permissions and settings - glad you got it sorted!

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)


(in reply to dpf)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> The Database Connection Named ' ' is unidentified ERROR
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