connection of sql server via vba

Help !!

I have a sql server database that is as follows

SERVER: AFG
Database Name : APF
Authentication: Windows authentication

how do I create the connectionstring via vba to access this database?sydney (mr.vinay.gupta@.gmail.com) writes:

Quote:

Originally Posted by

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

"Provider=SQLOLEDB;Server=AFG;Inital Catalog=APF;Trusted_connection=yes"

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||sydney wrote:

Quote:

Originally Posted by

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

www.connectionstrings.com