Hi,

I'm rather new in Visual Basic 4.0/RDO programming. In my application I
make a
connection with SQL server using the following code:

  strConn = "DSN=PGS"
  Set envUser = rdoEngine.rdoEnvironments(0)
  Set conUser =
envUser.OpenConnection(dsname:="PGS",Prompt:=rdDriverPrompt,
ReadOnly:=False, Connect:=strConn)

When I start the application for the first time, all goes well. When I
start the application for the second time on another Windows-NT client,
while the first one still runs on the other client, I get:

error message 400002

S1T00:[Microsoft][ODBC SQL Server Driver]Time Out expired.

It seems like the database is locked and can only be accessed by one
user at the time. I assume this is not meant to be like that.

Does anyone have a solution for this problem?

Best whishes,
Toine Schijvenaars
Twinfo BV