[sebiuta]

A friend of mine recomend me Firebird as a stable databes server with all the features. Ok ...I take the driver and i connected to the server but a have a serious problem. After conection i try to open 2 recordset for retrieving data from 2 separate tables.The first recordset is open but when i try to open the second recordset i get an error " ODBC Drive Manager Data source name not found and not default driver specified " . I use the same conection to open the recordsets..My question is : for every recordset to open is necesary a new conection ??

Excuse my bad english. Thank's

[saju]

For every recordset you need not open a new connection.
Pls try to use IBProiver Native OLEDB provider. (http://www.ibprovider.com/eng/index.html) It has a good example for how to use an ado connection on vb.