Access to SQL DB through a Firewall
26 April 2002, 10:02 AM
#1
Moderator
Thread Starter
Join Date: Dec 1998
Location: Staffs
Posts: 23,573
Likes: 0
Received 0 Likes
on
0 Posts
Any ideas of what TCP / UDP ports need to be open for this to work?
Sonic Wall Pro 100. PC inside the private LAN needs has an Access DB which connects to a SQL DB on a remote server. AFAIK, the Access DB has linked tables to the SQL server - I presume that's ODBC or does it use DAO?
Gotta be the Sonic as if you move a PC outside the firewall, it works 1st time.
Yes, probably not the best way to do things in terms of security etc but that bit is nothing to do with us.
TIA,
Chris.
Sonic Wall Pro 100. PC inside the private LAN needs has an Access DB which connects to a SQL DB on a remote server. AFAIK, the Access DB has linked tables to the SQL server - I presume that's ODBC or does it use DAO?
Gotta be the Sonic as if you move a PC outside the firewall, it works 1st time.
Yes, probably not the best way to do things in terms of security etc but that bit is nothing to do with us.
TIA,
Chris.
26 April 2002, 10:45 AM
#2
Scooby Regular
Join Date: May 2001
Location: Scotland
Posts: 4,580
Likes: 0
Received 0 Likes
on
0 Posts
26 April 2002, 11:07 AM
#3
Scooby Regular
Join Date: Nov 2001
Location: Leeds - It was 562.4bhp@28psi on Optimax, How much closer to 600 with race fuel and a bigger turbo?
Posts: 15,239
Likes: 0
Received 1 Like
on
1 Post
sql server 7 port 1433 as default but you can change it to any... to test telnet to box on port 1433 and use isql to test..
isql -Uusername -Ppassword -Sserver
David
edited to add it depends how you link the tables if you do new linked table, go to the bottom of the list and pick odbc.. so yeah odbc for linked tables... check your dsn is using tcpip not named pipes or other protocols, as that will require too much effort to go through firewall, compared to opening up a port...
[Edited by David_Wallis - 4/26/2002 11:12:37 AM]
isql -Uusername -Ppassword -Sserver
David
edited to add it depends how you link the tables if you do new linked table, go to the bottom of the list and pick odbc.. so yeah odbc for linked tables... check your dsn is using tcpip not named pipes or other protocols, as that will require too much effort to go through firewall, compared to opening up a port...
[Edited by David_Wallis - 4/26/2002 11:12:37 AM]
Thread
Thread Starter
Forum
Replies
Last Post