Access to SQL Server DB Connections

[freshtea]

Hi

I am new to SQL server, I have been using Access and Dreamweaver to build most of my websites.

I have to upgrade to SQL SERVER on a website I have built.

I have the new connection string but I'm not sure what do to now. do I have to recode all my query pages.

below is the code for the Connection String page. with samples of the new SQL SERVER connection string (commented out)

================

<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_Access_STRING
MM_Access_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\acom\sites\dummy\dummy.mdb;"

'const DBCONNECTIONSTRING = "Provider=sqloledb;DataSource=sql-2,2976;Database=ie_admin;UserId=admin;Password=Password"

'MM_Access_STRING = "Provider=sqloledb;DataSource=sql-2,2976;Database=ie_murphys_admin;UserId=username;Password=password"


%>

[silverbullet24]

no you don't have to recode all your pages. most should work right if you get the connection string correct. there are some simple things like when comparing dates you have to use different delimeters, stuff like that. nothing major though

[Bullschmidt]

Yes, apparently the # instead of ' around dates is for Access and not SQL Server.

And here's a great connections strings site:

Connection String Home Page
http://www.carlprothman.net/Default.aspx?tabid=81

And here's an interesting link:

http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/c52f5daaa1287d83/4631155d56c44047?lnk=st&q=SQL+set+datetime+column+to+British+dates&rnum=1&hl=en#4631155d56c44047