Ramani Ranjan
January 28th, 2000, 04:58 AM
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.
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.