Database Results

[Leroy]

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?

 

[Jim Buyens]

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)
|/---------------------------------------------------
*----------------------------------------------------