MySql ODBC and Frontpage2003

[Mike]

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.

[Jeff Cochran]

On Mon, 9 Aug 2004 05:03:02 -0700, "Mike"
<Mike@discussions.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

[joker]

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.
>