ASP and MySQL

[matthew stuart]

I have been developing asp sites with MySQL databases for a number of years now, and I have just come across a service provider who will not allow me to have an asp site with MySQL!! I either change to php to use MySQL, or I keep asp and then have to use Microsoft SQL!!!!!!

This has prompted me to look for another service provider, and I am seeing a bit of a trend here, few seem to offer asp with MySQL.

Why?

If anybody uses a provider that will allow me to use asp and MySQL, will you please recommend them here?

Thanks.

Mat

[Newsgroup_User]

The reason is probably because ASP requires a windows server so it's a
natural with SQL Server. Most servers with MySql would probably be Unix
servers which requires an addon like ChiliSoft to process ASP code and that
isn't often done.

That said, my host allows MySql on ASP sites and their URL is
http://www.crystaltech.com


--
Nancy Gill
Adobe Community Expert
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner''s
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"matthew stuart" <webforumsuser@macromedia.com> wrote in message
news:f002f6$1k2$1@forums.macromedia.com...
>I have been developing asp sites with MySQL databases for a number of years
> now, and I have just come across a service provider who will not allow me
> to
> have an asp site with MySQL!! I either change to php to use MySQL, or I
> keep
> asp and then have to use Microsoft SQL!!!!!!
>
> This has prompted me to look for another service provider, and I am seeing
> a
> bit of a trend here, few seem to offer asp with MySQL.
>
> Why?
>
> If anybody uses a provider that will allow me to use asp and MySQL, will
> you
> please recommend them here?
>
> Thanks.
>
> Mat
>

[matthew stuart]

Thanks for your reply Nancy. The problem with the host not supporting ASP and MySQL together is that their windows servers don't have the myodbc driver installed.

However, after a lot of to-ing and fro-ing it transpires that their linux server will support ASP due to Sun ONE ASP - I have no experience of this, and I am trying to test a page on the site to see if it will work, but it keeps erroring because of the connections file and stating that the driver doesn't exist!!

I assume it is simply down to this part of my connection string - DRIVER=MYSQL ODBC 3.51 DRIVER; - but because the site is on a linux server emulating ASP, it needs to change to suit, but I have no idea what to change it to. Could you please take a look at my connection string and see if you can advise me:

Dim MM_conn_STRING
MM_conn_STRING = "Provider=MSDASQL;DRIVER=MYSQL ODBC 3.51 DRIVER;SERVER=data.domain.com;DATABASE=myDataBase;UID=myUserName;PWD=myPassword"

Thanks once again.

Mat