ODBC Connection Dialog box (VBA) - deactivate

[linedata]

I would like to prevent the ODBC Connection Dialog box from appearing when I run an Excel VBA macro that queries an ODBC database.

I am using the following code in VBA to open the connection..the query works fine and produces the output but the query box still appears whatever I try (SQL_Driver_NoPrompt etc)...but maybe I have been using it incorrectly. Any help would be much appreciated.

Sub UsingSQLOpen()

Dim Chan As Variant
Dim queryString As String

queryString = "SELECT * from Customers where CustID = 100"

Chan = sqlopen("DSN=TestDSN;UID=TestUser;PWD=Test;SERVER=TestServer;&quot

SQLExecQuery Chan, queryString
SQLRetrieveToFile Chan, "c:\OUTPUT.TXT", True

SQLClose (Chan)
End Sub

 

[Bensta]

I think you need to add one more parameter to you connection string. I think it should use trusted connection.
I hope this wil help.