SQL Server

All versions of Windows, come with two SQL Server data access libraries pre-installed:
Microsoft OLE DB Provider for SQL Server (SQLOLEDB)
Microsoft SQL Server ODBC Driver (SQLODBC)


Connection String - SQL Server

sConnectionStr  = "Driver = {SQL Server}" & ";" 
                 "Provider = " & "SQLOLEDB" & ";"
                 "Server = " & ServerName & ";"
                 "Database = " & DatabaseName & ";"
                 "User ID = " & UserId & ";"
                 "Password = " & Password & ";"
                 "Trusted Connection = " & & ";"
                 "Integrated Security = SSPI"

Driver -
Provider -
Server -
Database - DSN alternative
User ID -
Password -
Trusted Connection -
Integrated Security - You can use SSPI as an alternative to providing a user id and password.



© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext