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="Connection_odbc_conn_dsn.htm" ' Type="ADO" ' DesigntimeType="ADO" ' HTTP="false" ' Catalog="" ' Schema="" Dim MM_TATTOO_STRING MM_TATTOO_STRING = "dsn=TATTOO;uid=dt-data;pwd=XXXXXXXX;" %> 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@uktattoostudios.co.uk inof@uktattoostudios.co.uk