Results 1 to 2 of 2

Thread: Getting Started Questions

  1. Nov 21st, 2000, 02:47 PM #1
    spd
    spd is offline

    Thread Starter
    New Member
    Join Date
    Nov 2000
    Posts
    2

    Question

    I have a VB6.0 project which is a front end to an Access 97 database. I use DAO 3.51 and need to port the application to a MS SQL database. I have the following questions.

    1. What software is required to get started? Do I need to purchase MS SQL or do I order Visual Studio. Currently all I have is VB 6.0 Pro.

    2. Can I use DAO to access the database?

    3. The project uses many seeks to find a particular record in a recordset instead of a query. Do the SQL databases support a Seek statement instead of an SQL query to find a particular record?

    Any suggestions or recommended getting started books on SQL would be appreciated.
    Reply With Quote Reply With Quote
  2. Nov 22nd, 2000, 08:32 PM #2
    makai
    makai is offline
    Lively Member
    Join Date
    Aug 2000
    Posts
    125
    look in
    Start->Settings->Control Panel->ODBC->Drivers

    you probably want to open with an ODBC connection

    http://www.vbexplorer.com/vb_feature...er_ADO_DAO.asp
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width