Database Discussion - ODBC Port ?

Print Page | Close Window

ODBC Port ?

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=478
Printed Date: 28 March 2026 at 11:41pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: ODBC Port ?

Posted By: DoDgEtHiS
Subject: ODBC Port ?
Date Posted: 24 February 2003 at 12:41pm

I am trying to access ODBC from across the internet, in order to view the DSN on my server (at home).

The server is running Windows XP Pro, IIS5.1 and MSDE SQL. It is sat behind a router running NAT so I need to know which port the ODBC queries are run so that I may set up the router to pass them to the server.

Anyone know? Tried searching the net but only could find references to MySQL

Replies:

Posted By: michael
Date Posted: 25 February 2003 at 11:06am

How would you connect to the remote ODBC?? I don't think you can do it like that, unless you setup a VPN of some kind. If you are running MSDE, just open port 1433 on your router, and connect via IP, much easier and faster.

Posted By: DoDgEtHiS
Date Posted: 25 February 2003 at 12:25pm

Ooops - thats what I meant.

I use DSN connections - just for simplicities sake, just need to know the port to query the DSN

Cheers

Posted By: michael
Date Posted: 25 February 2003 at 3:27pm

it would still be 1433 because your dsn is always local, at the requesting pc. so you only need to open the sql port which is 1433 by default....