
Setting the ActiveConnection property of a Command Object (ADO 2.7)
Don't know if this helps, but there are now different
types of ADO objects... for SQL and for OLEDB. Could that
have anything to do with it? I use an open SQLConnection
and dim a new SQLCommand, passing the CommandText and the
SQLConnection object into the constructor, and this works
fine.
Quote:
>-----Original Message-----
>I used to use the syntax of MyCommand.ActiveConnection =
cnnConnection where
>cnnConnection is an open connection object to a
database. This no longer
Quote:
>seems to work in VB.NET. I keep getting the
error "Specified cast is not
Quote:
>valid." What am I doing wrong?
>.