database interfaces

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

FP2002 with MS Access DB 2002

Am I limited to using only ONE database interface in a website? It seems as
if when I create one - it works - but when I add a 2nd DBI, connected to a
separate, 2nd Access DB, that neither one works - I get an error when trying
to edit a record that states can't be updated - contact administrator.

Any clues or direction?
 
Yes, you can use 2 databases in one web site. Your global.asa should end up
with both connections defined, like this:

<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Application_OnStart
'==FrontPage Generated - startspan==
Dim FrontPage_UrlVars(2)
'--Project Data Connection
Application("dbcbiz_ConnectionString") = "DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=URL=fpdb/ehbusiness.mdb"
FrontPage_UrlVars(0) = "dbcbiz_ConnectionString"
Application("dbcbiz_ConnectionTimeout") = 15
Application("dbcbiz_CommandTimeout") = 30
Application("dbcbiz_CursorLocation") = 3
Application("dbcbiz_RuntimeUserName") = ""
Application("dbcbiz_RuntimePassword") = ""
'--Project Data Connection
Application("store_ConnectionString") = "DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=URL=fpdb/creds.mdb"
FrontPage_UrlVars(1) = "store_ConnectionString"
Application("store_ConnectionTimeout") = 15
Application("store_CommandTimeout") = 30
Application("store_CursorLocation") = 3
Application("store_RuntimeUserName") = ""
Application("store_RuntimePassword") = ""
'--
Application("FrontPage_UrlVars") = FrontPage_UrlVars
'==FrontPage Generated - endspan==
End Sub

It's possible there's something wrong with the second database - have you
tried using it in its own web site to see if it works?


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others
 
I have several websites with at least half a dozen access dbs each. I don't
believe there's a limit (at least, nothing set by Frontpage).

The issue with the database interface wizard (edit/update mode) is a known
problem (frequently reported on this group - I haven't yet seen an easy,
workable solution) but I didn't think it was related to the fact you have
more than one DB on the site.
 
Back
Top