Re: Connecting to Oracle
- From: "Björn Holmgren" <bjohol@xxxxxxxxxxx>
- Date: Mon, 22 Aug 2005 14:37:34 +0200
"Venkman" <Venkman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3D00EF68-FC0E-4925-833F-E097E5EA66A3@xxxxxxxxxxxxxxxx
> Hi There !
>
> I'm having a little bit of a problem. I'm trying to connect from a XP
> Workstation ( later a win2003 Server ) to an oracle database. So i
installed
> the oracle client 8.1i including the ODBC driver. The settings in tnsnames
> are correct. I can connect via SQLPlus. The ODBC connecting software also
> works fine. I also installed the MDAC 2.8 .
> So i tried to connect to ORACLE via VB Script like all the Examples do:
> Set conn = Server.createobject("ADODB.Connection")
>
> ..and get a runtime error that the object "server" is unknown.
>
> So, does "Server" need an IIS, or is this connection only possible in an
> IIS/ASP environment ? Do i have missed something in installation?
> The first part of my script ( filling an oracle Table ) should run within
a
> scheduled task, the oher part should connect the database from an ASP
script.
>
> Can anyone point me into the correct direction - please ?
>
> Thanks
> Venkman
The Server object is only available in ASP, but you can make the connection
from a standalone VB script as well. Just remove the "server." part.
--
Björn Holmgren
.
- References:
- Connecting to Oracle
- From: Venkman
- Connecting to Oracle
- Prev by Date: Re: autocomplete script
- Next by Date: Re: Starting external Programm with VBScript
- Previous by thread: Connecting to Oracle
- Next by thread: update from client-side code
- Index(es):
Relevant Pages
|
