DSN vs DSN-less connection

[Kactus]

Hello people,

I have been using Macromedia Ultradev to build quick and dirty VBScript and ASP pages and testing them on my PWS which worked fine because I had a DSN connection set up. The time came to release my children to the world and I chose Brinkster to host to do it (because it's free and I'm cheap;-)) but Brinkster it seems, doesn't support DSN connections.

Can someone explain, please, what all this DSN stuff is? How can I change from a DSN page to a DSN-less page?

I appreciate that this is a gaping whole in my basic knowledge and I'd love someone to fill it for me.

Thanks in advance,
Dave

 

[shaddow]

DSN connection requires acess to registry cuz there is stored the DSN and in DSN file is just the parameters for connection.
If the DSN wasn't created on the server your DSN connection won't work.
All u have to do is to use parts of your DSN file to connect at database.
in SQL i use

Connection.Open "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;Initial Catalog=databasebname;Data Source=servername"

________
George, M

 

[Kactus]

Okay, Thanks Shaddow, I'll give it a go.