connection of sql server via vba

[sydney]

Help !!

I have a sql server database that is as follows

SERVER: AFG
Database Name : APF
Authentication: Windows authentication

how do I create the connectionstrin g via vba to access this database?

[Erland Sommarskog]

Re: connection of sql server via vba

sydney (mr.vinay.gupta @gmail.com) writes:

I have a sql server database that is as follows
>
SERVER: AFG
Database Name : APF
Authentication: Windows authentication
>
how do I create the connectionstrin g via vba to access this database?

"Provider=SQLOL EDB;Server=AFG; Inital Catalog=APF;Tru sted_connection =yes"


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[lucm]

Re: connection of sql server via vba


sydney wrote:

Help !!
>
I have a sql server database that is as follows
>
SERVER: AFG
Database Name : APF
Authentication: Windows authentication
>
how do I create the connectionstrin g via vba to access this database?

https://www.connectionstrings.com