Using SQL Server DSN connection

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
csussman Members Profile Find Members Posts Newbie Joined: 18 November 2003 Status: Offline Points: 1	Post Options Post Reply Quote csussman Report Post Thanks(0) Quote Reply Topic: Using SQL Server DSN connection 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.

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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. Edited by -boRg-
	Web Wiz Forums Hosting ASP.NET Web Hosting

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.