Oracle connection string with IP address


R

Ron Fluegge

With SQL Server, I can create a connection string to a remote server using
an IP address such as:

"Data Source=190.190.200.100,1433;..." where 1433 is the port (1433 is the
default)

This works just fine.

Is it possible to use the "Microsoft Managed Provider for Oracle" and
connect via an IP address using something like the string below to connect
to a remote Oracle 8i or 9i database server:

"Data Source=190.190.200.100,1521;..." -- it is my understanding that 1521
or 1526 are the ports that are similar to 1433

If that is not the correct syntax, could you please identify how to do this.
I have searched the web and discussion groups and can find nothing on
connecting to a remote Oracle database server.

Any help or advice would be much appreciated.

Thanks.

Ron
_____________________________________
Ron Fluegge
ronflueggeATswbellDOTnet
Power corrupts, and absolute power is actually pretty neat...
 
Ad

Advertisements

T

Tom Ploskon

Ron Fluegge said:
With SQL Server, I can create a connection string to a remote server using
an IP address such as:

"Data Source=190.190.200.100,1433;..." where 1433 is the port (1433 is the
default)

This works just fine.

Is it possible to use the "Microsoft Managed Provider for Oracle" and
connect via an IP address using something like the string below to connect
to a remote Oracle 8i or 9i database server:

"Data Source=190.190.200.100,1521;..." -- it is my understanding that 1521
or 1526 are the ports that are similar to 1433

If that is not the correct syntax, could you please identify how to do this.
I have searched the web and discussion groups and can find nothing on
connecting to a remote Oracle database server.
The proper way is to use the Oracle Client's tnsnames.ora alias (default
Oracle naming method), or however else you configured your Oracle Client.
That's where your ports and IP addresses are defined.

-Thomas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top