Web Wiz Support and Community Forums : Using SQL Server DSN connection https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 04 Apr 2026 06:42:59 +0000 Tue, 18 Nov 2003 08:21:14 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=7360 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Using SQL Server DSN connection : The MS SQL server version...]]> https://forums.webwiz.net/using-sql-server-dsn-connection_topic7360_post36751.html#36751 Author: WebWiz-Bruce
Subject: 7360
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 whyyou need to put in the address of the SQL server into theSQL_connection.asp page in the admin directory.

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


Edited by -boRg-]]> Tue, 18 Nov 2003 08:21:14 +0000 https://forums.webwiz.net/using-sql-server-dsn-connection_topic7360_post36751.html#36751 <![CDATA[Using SQL Server DSN connection : My SQL database is on another...]]> https://forums.webwiz.net/using-sql-server-dsn-connection_topic7360_post36748.html#36748 Author: csussman
Subject: 7360
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.

 

]]> Tue, 18 Nov 2003 07:35:50 +0000 https://forums.webwiz.net/using-sql-server-dsn-connection_topic7360_post36748.html#36748