How can I use a DSN File in a VBA Connection Script?

Question

I have VBA code that uses a connection string to talk to an SQL Server. I would like to use an external DSN file for this connection, purely for the adaptability.

The current code:

Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
strConn = "DRIVER=SQLServer;SERVER=x;APP=Microsoft Excel;DATABASE=x;Trusted_Connection=Yes"
cn.Open strConn

The code works, but for our users a dsn file would be more appropriate.

The .DSN File:

[ODBC]
DRIVER=SQL Server
Database=x
APP=Microsoft Office 2013
Trusted Connection=Yes
SERVER=x
Description=x

Bond · Accepted Answer · 2015-08-26 13:20:20Z

2

You can use the File Name qualifier to specify a UDL or DSN file. For example:

cn.Open "File Name=c:\path\to\my.dsn;"

answered Aug 26, 2015 at 13:20

Bond

16.3k6 gold badges34 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I use a DSN File in a VBA Connection Script?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related