Web Wiz Forums - Using SQL Server DSN connection

Print Page | Close Window

Using SQL Server DSN 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=7360
Printed Date: 04 April 2026 at 8:09am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Using SQL Server DSN connection

Posted By: csussman
Subject: Using SQL Server DSN connection
Date Posted: 18 November 2003 at 7:35am

My SQL database is on another server and not on my web server. I have created an ODCB connection in order to use the DSN for this forum. However, I am having difficulty getting the msSQL_server_setup.asp page to run. Do you have a configuration example I can use to setup a DSN connection to the database on a remote server? Thank you.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 18 November 2003 at 8:21am

The MS SQL server version will only work with the faster DSN-less connection to the SQL server, using the OLE driver.

The MS SQL Server database is usally on another server, which is why you need to put in the address of the SQL server into the SQL_connection.asp page in the admin directory.

Also it's Microsft SQL server 2000 that is supported, not mySQL.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting