Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Keywords:
Working to avoid the dreaded "ODBC Call - Failed" error. I would set up my ADODB.Connection Object, set both the ConnectionTimeOut and the CommandTimeOut to 0 ( which means they should not time out ), then issue a
DB.Execute( MySQLStatement ).
which I have always assumed acts as a Command. However, and the ADO docs say this, but it is easy to gloss over, the Command Object does not inherit from the Connection Object. Add to that there is a bug in the CommandTimeOut property of the Connection Object which Microsoft swears they fixed, but others swear is still a bug, which will fail if set to 0.
So the following,( assuming cConn is your Connection Statement ) is a workaround.
cmd = ObjectOpen("ADODB.Command") cmd.ActiveConnection = cConn cmd.CommandText = MySQLStatement cmd.CommandTimeOut =0 cmd.Execute()
Article ID: W15222
File Created: 2002:09:05:13:50:44
Last Updated: 2002:09:05:13:50:44