Connecting to Oracle

Tech-Archive recommends: Speed Up your PC by fixing your registry

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
.

Relevant Pages

  • script running under shell, has troubles with crond
    ... got a bash script that connects to a remote web server, ... this script, besides setting variables such as PATH and CLASSPATH ... runs a java application which works without any problem if run in shell. ... it tries to make a select on oracle it just hangs up with no error reported, ...
    (comp.os.linux.announce)
  • script running under shell has trouble with crond
    ... got a bash script that connects to a remote web server, ... this script, besides setting variables such as PATH and CLASSPATH ... runs a java application which works without any problem if run in shell. ... it tries to make a select on oracle it just hangs up with no error reported, ...
    (alt.os.linux)
  • Re: Script Triggered Following a Specific System Event
    ... We are running Oracle and SAP on a Win 2000 server. ... the Windows server logs a system event of type 'error' and ... to trigger a job which will execute a command script to ...
    (microsoft.public.win2000.general)
  • RE: Cant call method "prepare" on an undefined value
    ... The error happen on the line to connect to that database: ... This script is working fine I located the script in same server as the ... I have one oracle database located at server A and setup the Oracle ...
    (perl.dbi.users)
  • Spawning Multiple Process
    ... I have a script for automatic startup of Oracle databases on two Red Hat ... from the server where it was running fine. ...
    (RedHat)