a real NOOB question..

Hi.

How do I find the database on the server using the connectionstring from sql server which is:

(or just how do i read this string, what does it mean?)

Const sqlFTDB = "Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=FTDB;Server=plato.center.olle.se;Locale Identifier=1055;Connect Timeout=15;Use Procedure for Prepare=0;Auto Translate=True;Packet Size=4096;Workstation ID=IIS;User Id=yyyyy;PASSWORD=xxxx;DATABASE=FTDB;"

I really need to get to that database. Have some things to change. Another question. As I have heard, the sql database on the server I´m trying to find the database on, is not connected "out" from the server. (if that makes any sense.=) How do I run the database then? Directly from the server or what?

If so, thats one of the reason i need to know how to know what the things in the string means...

thnx guys (and girls)

Hi

Provider=SQLOLEDB.1;
Persist Security Info=False;
Initial Catalog=FTDB;
Server=plato.center.olle.se;
Locale Identifier=1055;
Connect Timeout=15;
Use Procedure for Prepare=0;
Auto Translate=True;
Packet Size=4096;
Workstation ID=IIS;
User Id=yyyyy;
PASSWORD=xxxx;
DATABASE=FTDB;

In ASP you could get away with:

Driver={SQL Server};
Server=plato.center.olle.se;
Address=[ip address here];
Network=DBMSSOCN;
Database=FTDB;
Uid=yyyyyy;
Pwd=xxxx;

For more info on connection strings: http://www.connectionstrings.com

MK

Start with the SQL Server Books Online