February 23rd, 2004, 03:59 AM
Firebird & Visual Basic & ADO problems
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
February 25th, 2004, 01:54 AM
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.