Forum Discussion

NS189's avatar
NS189
Occasional Contributor
10 years ago
Solved

working with MS SQL using TC11.11

I do not have much experince working with MS SQL using TC and tried to use the ADO class to connect and access the tables, was not able to get very far because I am not able to open the DB, I read co...
  • djadhav's avatar
    djadhav
    10 years ago

    You cannot 'bypass' security in SQL server. If you login to the SQL server using your Windows credential, the you can use this format of connection string:

     

    Provider=SQLOLEDB;Data Source=Your_Server_Name; Initial Catalog=Your_Database_Name; Integrated Security=true;

     

    If you have different username and password for the SQL server then you can use this format:

     

    "Provider=SQLOLEDB;Data Source=Your_Server_Name; Initial Catalog= Your_Database_Name; UserId=Your_Username; Password=Your_Password;"

djadhav's avatar
djadhav
Regular Contributor
10 years ago

You cannot 'bypass' security in SQL server. If you login to the SQL server using your Windows credential, the you can use this format of connection string:

 

Provider=SQLOLEDB;Data Source=Your_Server_Name; Initial Catalog=Your_Database_Name; Integrated Security=true;

 

If you have different username and password for the SQL server then you can use this format:

 

"Provider=SQLOLEDB;Data Source=Your_Server_Name; Initial Catalog= Your_Database_Name; UserId=Your_Username; Password=Your_Password;"