
RDO and ODBC, time out error
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