I am looking for an example of the windows authenticated connection to an MSSQL DB and a select count statement in a textbox in my form.
I have this connection string:
Can I simply just paste this into my form_onload? Also how to I reference this connection when I then go to add my SQL query to textboxes etc?
Dim SQLCon As ADODB.Connection
Set SQLCon = New ADODB.Connection
Provider=SQLOLEDB.1;Integrated Security=True;Initial Catalog=nautilus_MDB;Data Source=UKLONWPS3D01;Persyst Security Info=False;Command Properties='Command Time Out=45'"
Does anyone have any example code they would be willing to share or take the time to explain this to me.
Any replice will be much appreciated.