Jim
Wed Jul 14 15:09:48 CDT 2004
First off, don't do
<!--#include file="../../global.asa"-->
That's totally wrong.
Instead, most developers add a line like this to the
Application_OnStart subroutine in global.asa
Application("orapmm3") = "Provider=MSDAORA.1;" & _
"Password=afval18;" & _
"User ID=d1107911i;" & _
"Data Source=pmm3;" & _
"Persist Security Info=True"
and then, in any number of pages, open the connection as
Connect.Open Application("orapmm3")
Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
>-----Original Message-----
>I would like to access an Oracle database specified in my
>global.asa file as "pmm3"
>set-up and verified in Front Page 2002 (IIS 5, Win 2000
>Server)
>without using the Databse Results Wizard.
>
>The code on my ASP works except I have to use this
>connection string (same as one in global.asa):
>
>Connect.Open "Provider=MSDAORA.1;Password=afval18;User
>ID=d1107911i;Data Source=pmm3;Persist Security Info=True"
>
>instead of something like this:
>
>Connect.Open "pmm3"
>
>I included the global.asa file, but to no avail
>
><!--#include file="../../global.asa"-->
>
>Am I missing something? How do i get it to access the
>Database Connection already setup in the global.asa file?
>.
>