Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Cheltenham, Gloucestershire, England
    Thanked 0 Times in 0 Posts

    Database connection using ADO (2000)

    I have a document from Microsoft regarding connecting databases using ASP and ODBC connections.

    It also contains a section relating to manage dataabse connections using ADO, which purports not to need to manage connections through the ODBC control panel, it all being done through Front Page.

    I have followed the instructions. Put my database in the _private folder, Tools Menu, web settings, database tab, add, in the new database connection dialog box typed [name for database], select file or folder in current web, select Browse.

    Then next step tells me to navigate to the files folder of my web and select the database.

    This is where I run into a problem - there is nothing there (though I know it is in the folder). I am working in Frontpage with my server based web. And the web has worked happily on ODBC registered databases.

    I tried to create a new web and imported a database. I then followed the above instructions and had exactly the same problem?

    What am I doing wrong? Can anybody help please. Not having to go cap in hand to get the database recognised by ODBC on the server would be so marvellous!!



  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Silicon Valley, USA
    Thanked 94 Times in 90 Posts

    Re: Database connection using ADO (2000)

    I'm not sure about using a _private folder; this could be the problem.

    You will find more (possibly useful) threads searching ASP and ADO on the HTML board, too.

Posting Permissions

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