SQLCLIENT CONNECTION
-
When i use oledb.oledbconnection,i connect to SQL Server with this connection string :
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=MDLABS;Data Source=SQLBut when i use sqlclient sql connection , i cannot connect to sql server. my sqlclient connection string isPersist Security Info=False;User ID=sa;Initial Catalog=MDLABS;Data Source=SQLWhat is missing? -
When i use oledb.oledbconnection,i connect to SQL Server with this connection string :
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=MDLABS;Data Source=SQLBut when i use sqlclient sql connection , i cannot connect to sql server. my sqlclient connection string isPersist Security Info=False;User ID=sa;Initial Catalog=MDLABS;Data Source=SQLWhat is missing?Try adding in the Instance name e.g. Source=SQL\SQLSERVEREXPRESS or the password even if its blank Look where you want to go not where you don't want to crash. Bikers Bible