Changing DSN to DSN-Less

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
david220
Forum Newbie
Posts: 1
Joined: Tue Aug 22, 2006 2:53 pm

Changing DSN to DSN-Less

Post by david220 »

feyd | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]


hi

I bought a web site of ebay for about £4500 (http://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

[syntax="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


feyd | Please use[/syntax]

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
User avatar
Ollie Saunders
DevNet Master
Posts: 3179
Joined: Tue May 24, 2005 6:01 pm
Location: UK

Post by Ollie Saunders »

Dude, this is a PHP forum. A lot of people here would scoff at you using ASP and MSSQL.
My advice is to get out of here, quick, before somebody else sees you!
Post Reply