ASP - Connecting to Oracle DB

[FateFirst]

Im trying to connect to an Oracle DB but considering I've never been anywhere near Oracle before Im becoming quite lost. Client is running Oracle9i on another server located on the network.

Im using the below to try and establish a connection:

oConn.Open "Driver={Microsoft ODBC for Oracle};" & _
           "Server=SNTEST.world;" & _
           "Uid=SYSADM;" & _
           "Pwd=SYSADM"

On running the page I get:
[tt]
Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: ''
/index.asp, line 7
[/tt]

Line 7 is the oConn.Open line.

Can anyone supply any links or maybe some past experience with oracle?

Not sure if I need to install other items or maybe im going about connecting to the database in the wrong manner.

- FateFirst

 

[HimanB]

Hi,
There are samples on how to use ASP with Oracle odbc drivers on metalink.
You can see them by going to
Top Tech Docs -> Programmatic Interface -> Oracel ODBC Driver -> Scripts.

Also do not forget to install Oracle client software on the m/c from where you are trying to connect to Datbase server(As your Db is on different server).

HTH
Regards
Himanshu