Professional Web Applications Themes

MySql ODBC and Frontpage2003 - ASP Database

I'm a bit confused, or a lot. I'm developing a web app in Frontpage that needs to access a MySql database. MySql database is on the server located at my hosting company. My hosting company uses DSN on the server side. What do I use for a connection string in Frontpage (ASP) that doesn't have client side dependancies? ie. no need to configure client side DSN's or load programs. Any examples? Thanks, Mike....

  1. #1

    Default MySql ODBC and Frontpage2003

    I'm a bit confused, or a lot.
    I'm developing a web app in Frontpage that needs to access a MySql database.
    MySql database is on the server located at my hosting company.
    My hosting company uses DSN on the server side.
    What do I use for a connection string in Frontpage (ASP) that doesn't have
    client side dependancies? ie. no need to configure client side DSN's or load
    programs.
    Any examples?
    Thanks, Mike.

    Mike Guest

  2. #2

    Default Re: MySql ODBC and Frontpage2003

    On Mon, 9 Aug 2004 05:03:02 -0700, "Mike"
    <Mikediscussions.microsoft.com> wrote:
    >I'm a bit confused, or a lot.
    >I'm developing a web app in Frontpage that needs to access a MySql database.
    >MySql database is on the server located at my hosting company.
    >My hosting company uses DSN on the server side.
    >What do I use for a connection string in Frontpage (ASP) that doesn't have
    >client side dependancies? ie. no need to configure client side DSN's or load
    >programs.
    Nothing you do in ASP has a client-side dependency since it's server
    side code. :)
    >Any examples?
    Try:

    [url]http://www.able-consulting.com/ADO_Conn.htm[/url]

    Or ask your ISP.

    Jeff
    Jeff Cochran Guest

  3. #3

    Default Re: MySql ODBC and Frontpage2003

    AHHHHHHHHHHHHHHHH not ODBC again (that's your DSN FYI). I wish people
    would realize that they need to stop using it.

    Here are two links with information about what is being Deprecated from
    the MDAC (in the first link) & information about what you should
    actually code (in the second link).

    [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/ado_deprecated_components.asp[/url]

    [url]http://www.aspfaq.com/show.asp?id=2126[/url]

    Mike wrote:
    > I'm a bit confused, or a lot.
    > I'm developing a web app in Frontpage that needs to access a MySql database.
    > MySql database is on the server located at my hosting company.
    > My hosting company uses DSN on the server side.
    > What do I use for a connection string in Frontpage (ASP) that doesn't have
    > client side dependancies? ie. no need to configure client side DSN's or load
    > programs.
    > Any examples?
    > Thanks, Mike.
    >
    joker Guest

Similar Threads

  1. ODBC driver for MySql V5
    By Kris Jennings in forum MySQL
    Replies: 0
    Last Post: July 28th, 01:19 AM
  2. MySQL ODBC utf8
    By Artur Bać in forum MySQL
    Replies: 1
    Last Post: December 17th, 06:52 PM
  3. MySQL ODBC error
    By jbogren in forum Coldfusion Database Access
    Replies: 9
    Last Post: December 1st, 06:17 PM
  4. MySQL ODBC/OLE DB Drivers
    By CJM in forum ASP Database
    Replies: 4
    Last Post: February 23rd, 09:53 PM
  5. get Data into MySQL via ODBC
    By Ivo Angelo Carobbio in forum IBM DB2
    Replies: 0
    Last Post: September 8th, 09:09 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139