MS SQL .. Probably a silly question

[sowen]

I am in the process of moving our site and the new package comes with MS SQL (only ever used access so far).

Now I have converted the access db and uploaded it no problem - I think, but I can only get the content to display using the SQL Server login and password supplied by the host hard coded into the connection string (DSN assigned by host). I know that the information never reaches the client but it still seems to be unsecure. I know this is probably a dead simple answer but I'm totally new to heavy duty databases

[Jeremy W.]

If you're connecting via your copy of Enterprise Manager to one on the host, you will be using the database username/password.

When making the connection (via port 1433 or something, if you ever get quizzed on it) the connection is made secure for you

[sowen]

Thanks J, but I really am being thick today!

I'm with the enterprise manager bit, my details, can add delete yada yada..

But if I don' do this on my pages..
[VBS]myConn.Open "DSN=myDB;" &_
"Uid=myUserID;" &_
"Pwd=myPassword;"
[/VBS]

I get a error and the page wont display

is that right?

[Jeremy W.]

SQL Server Connection string

<%
	Set Con = Server.CreateObject( "ADODB.Connection" )
	Con.Open "DRIVER={SQL Server}; Server=server; Database=databasename; UID=user; PWD=pass"
%>

[sowen]

Oh. it is right then, thanks mate, they should make you an Advisor or something

[Jeremy W.]

Maybe one day, but til then I'm stuck being a lowly Servant

[sowen]

Wow this is great I can use the same DB on my local sever as I can on my host, a system DSN over the net! Makes scence now I think about it (derr) I love MSSQL

Kid with a new toy