ODBC Connectivity

[Jeff K.]

Anybody know what port or ports ODBC generally communicates via. I've
got a customer that wants me to pull down information via ODBC, and
right now I use a dial up connection to the internet. What I'm hoping
to do, if it can even be done, is to map the port(s) to my newly
installed proxy server so that I won't have to dial the internet to
access this information.

[Rick Brown]

Jeff K. (je...@execpc.com) wrote:
: Anybody know what port or ports ODBC generally communicates via. I've

:
ODBC itself doesn't use TCP/IP ... you're always calling a set of
DLLs on your local machine. However, people often use ODBC to connect
to remote databases using the DBMSs proprietary networking layer.
Examples of this would be SQL*Net or Net8 for Oracle, and Net-Library
for Microsoft SQL Server.

The ports used are dependent solely on this networking layer and how
it is configured. For example:

MS SQL Server (conventionally) uses port 1433
Oracle (conventionally) uses 1521 or 1526 (and many more, if
plug-and-play listeners are used.)

The database administrator can setup the database to listen on
different ports, although in practice I believe this is rare unless
multiple databases and listeners are being used on the same machine.

You can use the NT "netstat" command when an ODBC connection is live
to view the ports being used for the connection. This should give you
the information you need to get started, at least.

Rick Brown
ri...@onramp.net