Hi,

1. How can I pass NULL through a VB function. It could be done if argument's data type is variant but I don't want that because in future I may need to port this in .NET. .NET doesn't support variant data type.

2. Is there any function to check whether connection is open or not?

Regards,Pankaj

Hi,

About the Null i probably cannot help you. But I know that there is a vbNullString.

About the connection on the other hand: you can check the connection.state object.
If this is 1 it is open and if it is 0 it is closed.

Hope this helps a bit.

Greetz

Tom.