connection string

[kandy]

hello,


I want to know my whole oledb connection string parameter for sql servre 2000 like
Provider
Data Source
Initial Catalog
user ID
Password

so will u please tell me how do i know my data source and uid and password

[iam_clint]

well do you have sql server installed?

[sashi]

hello,


I want to know my whole oledb connection string parameter for sql servre 2000 like
Provider
Data Source
Initial Catalog
user ID
Password

so will u please tell me how do i know my data source and uid and password

Hi there,

Kindly refer to below, hope it helps. Good luck & Take care.

  Provider = "SQLOLEDB"
  Data Source = "(local)"
  Initial Catalog = "the_name_of_sql_database_you_wish_to_connect_to"
  User ID = "valid_user_name"
  Password = "valid_user_password"

[JohanK]

Another option would be to create a UDL.
To create a UDL open notepad and save the blank document as "DB.udl" then when you double click on the created UDL it will allow you to enter your information such as DB name, Location(IP/URL), Username and Password.
Once this is done you can test the connection by clicking the "Test Connection" button.

Now to get the Connection String all you have to do is click "OK" and "Close", then you right click the UDL and open it with notepad and there you have your connection string.

Hope this helps.