ODBC does not support the requested properties???

[theel]

I am using VB coded programs to connect to the AS400 via a client access ODBC connection. I receive an error message saying "ODBC does not support the requested properties" once the computer sits idle for a few minutes.

The only way to get the connection is to stop the VB code and start it again. Then the connection can be made, but I then receive an error saying "the as400 ended the connection" afterwared.

Is there any line of code that I can added in my VB code to keep the connection open at all times??
Also, is there a command that I can use to lengthen the time of connections before they are timed out??

Please advise....


Theel

 

[ddiamond]

Are you including the user name and password in your connection string? I've encountered that bug before when I let the odbc driver automatically prompt the user for username and password. When I hardcoded the user name and password into the connection string, the problem went away. In any case, IBM's AS400 odbc driver is a bit buggy. Microsoft's ODBC driver for the AS400 works much better. I recommend you switch to Microsoft's driver.