I am aiming to create a very basic web based DBMS for Microsoft SQL Server. However, in order to connect to a SQL Server database you seem to require a ODBC connection on the server. Is there any possible way to overcome this?
A:
You haven't stated which version of SQLServer but you can use OLEDB connection in ASP.
An example of this is located here
Barry
2010-05-26 10:23:06
Thanks for the speedy answer we are using 2005 / 2008. So this connection method means an ODBC connection does not need to be created on the server?Many Thanks, Joel
J Harley
2010-05-26 10:29:07
Yes it should be fine. This site also a good source of information http://databases.aspfaq.com/database/what-should-my-connection-string-look-like.html And this one is always good when you just can't remember the connection string you need. www.connectionstrings.comHope this helpsBarry
Barry
2010-05-26 10:39:34