Hello,

I am trying to connect to a database and I am using the following piece of code:

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "dsn=mydatabase;uid=user;pwd=password;"

But, as the database is on another computer, I would like to connect to it using the IP address of the computer instead of a dsn connection. Can anyone help me with that?

Thanks,
tcb.

What sort of database is it? (SQL Server, Access?)

Hi,

It is an oracle database.

objConn.Open "Provider=OraOLEDB.Oracle;Data Source=OracleDBase;User Id=user;Password=password;"

Hi Chris,

I would like to connect to a remote database. So I would like to use a connection that uses the IP address of the computer containing the database. Is that possible?

tcb.

I'm not sure if that's possible in the connection string... I would of thought you would have to set that up in the DSN itself, or somewhere in the Oracle client setup (we used to use TNSNAMES.ORA but I think it depends on your Oracle version and the way you connect)

Aha! Just noticed a crucial bit missing

objConn.Open "Provider=OraOLEDB.Oracle;Data Source=OracleDBase;User Id=user;Password=password;Database=dbname;"

datasource would be the server name or IP and Database is the name of the database on the server.

Hello Chris,

I tried what you told me, but I got the following message:

"The Provider could not be found."

Can you tell me what does it mean?

Thanks,
tcb.

The Oracle OLE drivers are not installed on the server.
Try the ODBC ones at
http://www.carlprothman.net/Default....eFromMicrosoft

Hello Chris,

So I am gonna ask the administrator of the server the to install the OLE drivers, since I need to connect to the database using anything but the ODBC drivers. Thank you very much for your help.

tcb.

Hello again Chris,

About the code that you told me:

objConn.Open "Provider=OraOLEDB.Oracle;Data Source=OracleDBase;User Id=user;Password=password;Database=dbname;"

Is it for ASP.NET or it's also for ASP files?

tcb

the connection string should work for either