Web Wiz Support and Community Forums : MSSQL with ODBC connection https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 05:13:25 +0000 Wed, 01 Jun 2005 06:16:33 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=15252 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[MSSQL with ODBC connection : Thanks for the info, finally the...]]> https://forums.webwiz.net/mssql-with-odbc-connection_topic15252_post84412.html#84412 Author: ahsher
Subject: 15252
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?
]]> Wed, 01 Jun 2005 06:16:33 +0000 https://forums.webwiz.net/mssql-with-odbc-connection_topic15252_post84412.html#84412 <![CDATA[MSSQL with ODBC connection : Whether you use a DSN or not,...]]> https://forums.webwiz.net/mssql-with-odbc-connection_topic15252_post84034.html#84034 Author: michael
Subject: 15252
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.]]> Fri, 27 May 2005 09:26:29 +0000 https://forums.webwiz.net/mssql-with-odbc-connection_topic15252_post84034.html#84034 <![CDATA[MSSQL with ODBC connection : Hi, Will need information on...]]> https://forums.webwiz.net/mssql-with-odbc-connection_topic15252_post84023.html#84023 Author: ahsher
Subject: 15252
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. Cry
 
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.
 
 
]]> Fri, 27 May 2005 06:57:49 +0000 https://forums.webwiz.net/mssql-with-odbc-connection_topic15252_post84023.html#84023