MSSQL with ODBC connection
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=15252
Printed Date: 13 April 2026 at 8:26am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: MSSQL with ODBC connection
Posted By: ahsher
Subject: MSSQL with ODBC connection
Date Posted: 27 May 2005 at 6:57am
|
Hi,
Will need information on how to set up the database connection. We are using MSSQL and and the current arrangement is using a machine ODBC connection on the web server and database is behind the firewall. Think I'll need to connect using a DSN rite?
Had been browsing thru the forums... the only help i can see are DSN connection with Access database.
 Can this forum be configured with DSN and MSSQL? This is because of security issues... need to have firewall for the database.
Will someone please enlight me? thanks.
|
Replies:
Posted By: michael
Date Posted: 27 May 2005 at 9:26am
|
Whether you use a DSN or not, the Firewall needs to be open on port 1433 if you connect via IP. You can setup this forum to use a DSN, simply change the connection string but from what I hear it's slower. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: ahsher
Date Posted: 01 June 2005 at 6:16am
| Thanks for the info, finally the client is willing to allow us to connect directly. However, I'll need to encrypt the connection details.. Anybody has help done this before? Insert an encrypt and decrypt function in the SQL_server_connection.asp page? |