Connection string

S

SPRASAD

Member
Joined
Mar 11, 2003
Messages
5
I am trying to learn SQL server with .Net. I am writing a simple app for a
client. Its good learning tool for me.
Right now I am using SQL 2000 and and using localhost as the server. The default in Code Samples. It seems to be working in my office but I know its not going to work at my clients. The data will be sitting on the server and my system will be running on a couple of stations.
I know this must be simple but I like to know how I get the Server, User and Password to the Server.

How do you guys handle this? Any help will be greatly appreciated.

Thanks
Sunil Prasad
sunilprasad@dccnet.com
 
Hi Sunil
I am not getting ur problem actually...u said u are using the server name as Localhost...and when u are going to instal ur application in ur client system which have another server name(instance of sql server) u should have to give the server name of the sql server in that client machine and u should have to give the username abd password according to the sql s erver authendication in client machine...i think this will help u ..if not i am sorry..........

Satya
gummadi009@yahoo.com
 
Maybe you could prompt the user for UserName,Pass and server name the first time he/she uses the program and then store it in registry. And then when you need it just read it from there.
 
Back
Top