Suppress logon box when connecting Progress 8.3 with VB

[flatbob]

Hi,

I've established an ODBC connection with Progress 8.3 using VB 5 and a Merant 3.5 ODBC driver. The only problem is, every time I connect and every time I run a query, the logon on box appears. I've tried using a connection string with a user id and password. When the box appears, the fields are populated but I still have to click OK to clear the box. Obviously I don't want endusers to have to do this! Does anyone know how to prevent the box from ever appearing? Thank you.

 

[ChrisBurch]

Are you using a DSN connection?

Using a dsn connection, I use :-

<snip>....

Set cnn = New ADODB.Connection
Set rst = New ADODB.Recordset
cnn.Open "ABMPilot"

rst.Open strSQL, cnn

<snip>....

Where "ABMPilot" is my dsn for the particular db. The logon box is not invoked using this method.

Chris

IT would be the perfect job......if it didn't have users!!!

 

[flatbob]

Yes, Chris, I am. I'll try your suggestion. Thank you.

Mike