Changing DSN to DSN-Less

[david220]

hi

I bought a web site of ebay for about £4500 (www.uktattoostudios.co.uk). I decided to get the web site hosted on a new hosting company called namesco.co.uk. the only problem is they dont support DSN and have DSN-Less

How would I change the site to work with DSN-Less?

the site is a tattoo studio directory.It uses MS SQL database with about 1000 studios listed. The studios can log in and change there details etc.

The only file I find on the site with dsn in is this code call tattoo.asp

<%
' FileName="Conne ction_odbc_conn _dsn.htm"
' Type="ADO"
' DesigntimeType= "ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_TATTOO_STRIN G
MM_TATTOO_STRIN G = "dsn=TATTOO;uid =dt-data;pwd=XXXXXX XX;"
%>

I can connect to the ms sql server , Would I need to change the MS SQL 2005 database codes? If yes how would I do this. and what do i change in the above code

Finally would changing it to dsn-less cause any problems?

thanks
dave
info@uktattoost udios.co.uk

[Seun Ojo]

Use this t replace what u av:
*************** *************** *************** *************** *************** *********
<%
' FileName="Conne ction_ado_conn_ string.htm"
' Type="ADO"
' DesigntimeType= "ADO"
' HTTP="true"
' Catalog=""
' Schema=""
Dim MM_connme_STRIN G
MM_connme_STRIN G = "Provider=SQLOL EDB.1;Persist Security Info=False;User ID=dt-data;Initial Catalog=Databas ename;Data Source=localhos t;pwd=XXXXXXXX; "
%>
*************** *************** *************** *************** *************** *******
/*
Note:
Initial Catalog : - is/should be d name of ur database
datasource : - is d name of d computer on which d database(on MS-SQL 2000) resides(ds can be computer name or IP Address)
*/