Oracle connection string with IP address

[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...

 

[Tom Ploskon]

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