Hi Friends,
I'm having a stateful component designed with Vb 6.0. I'm connecting to the database(SQL Server) using the SQLOLEDB provider. When i check for the state of connection object it returns true but when i use it for ActiveConnection proprty of a recordset object i get connection failure error.
But this works fine with the Oracle-8 database.
I'll be greateful if anybody can give suggession on this matter.
Thanks.