Post reply

VB6 App using RDO to link to sequel 2005

  • July 17, 2007 at 12:52 am

    #76742

    Hello all

    The latest project I'm on is attempting to upgrade a database from Sequel 6.5 to Sequel 2005.

    I've been asked to ensure that the vb6 app that points to this database functions correctly under 2005.

    The app uses RDO (which I've never used before).

     

    A couple of questions:

    1. Can you link to a Sequel 2005 db using RDO ?

    2. Can someone point me in a direction of a good user guide for using RDO with VB6 ?

    Thanks in advance

     

  • July 17, 2007 at 1:02 am

    #719894

    Instead of using RDO's use ADO's.

  • July 17, 2007 at 1:16 am

    #719897

    thanks for the reply.

    It would take an age to change all the RDO links to ADO (unless you know of a quick way of doing it) as its a large app.

    I was hoping to ammend the RDO so that it works with 2005 as this might be quicker.

  • July 17, 2007 at 1:57 am

    #719909

    RDO uses ODBC underneath so it should be possible to connect to sql 2005 with out changing much. create a system dsn that points to your sql 2005 server and use that in your connection string.

    Everything you can imagine is real.

  • July 17, 2007 at 1:59 am

    #719911

    RDO!  I forgot to add that your system is due for an upgrade.

    Everything you can imagine is real.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply