DB Connection String

[Guest]

I am trying to use ODBC to connect ot my ERP application. The ERP uses a
Progress database & I am trying to schedule a table update in my Access
application overnight. I can get the schedule to run like I want it to, but
every time I try to connect to the Progress DB I get a dialog box that
prompts me for the password.

I created a module for the connection string, but I'm not certain how to
implement or even if this is the correct process. My connection code is shown
below:


Function DBConnect(strConnect As String) As ADODB.Connection

Dim strProgConn As ADODB.Connection
Dim strProgConnStr As String

Set strProgConn = New Connection
strProgConnStr = "DSN=TEST;Uid=XXX;Pwd=ABC;"

strProgConn.ConnectionString = strProgConnStr
strProgConn.Open

Set DBConnect = strProgConn

End Function

Any help would be appreciated.

Thanks,

 

[Joan Wild]

I don't have direct experience, but the following may help
http://www.connectionstrings.com/?carrier=progress

 

[Guest]

Joan,

thanks for the link, but it didn't solve my issue. I had already referenced
the Progress ODBC guide and based my connection string on that document. I am
using the same settings in my connection string that I use when connecting
via a dialog box.