#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2004
    Posts
    1
    Rep Power
    0

    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
    Attached Images
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2004
    Posts
    5
    Rep Power
    0
    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.

IMN logo majestic logo threadwatch logo seochat tools logo