Using ASP to connect to a MySQL Database

I could have sworn you said Linux server .....


"southcot" <webforumsuser@macromedia.com> wrote in message
news:e6odo9$nm2$1@forums.macromedia.com...
> Thanks for responding so quickly. Yes the site is hosted on a windows 2003
> box and ASP works fine.

Thanks for responding so quickly. Yes the site is hosted on a windows 2003 box and ASP works fine.

Are you sure ASP is supported on the server? Unless you have a solution
like ChiliSoft, you usually run ASP on a Windows server.


--
Nancy Gill
Adobe Community Expert
BLOG: http://www.dmxwishes.com/blog.asp
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


"southcot" <webforumsuser@macromedia.com> wrote in message
news:e6nepc$juv$1@forums.macromedia.com...
>I have set up a connection item in asp to a MySQL connection on a Linux
>server:-
>
> "DRIVER={MySQL ODBC 3.51
> Driver};SERVER=somehost.co.uk;DATABASE=DBName;PORT=3306;UID=Username;PAS
> SWORD=password;OPTION=3;"
>
> When I click test on the Custom Connection String window I get the
> message:-
>
> "Connection was made successfully." and the tables and their properties
> show
> in the databases window. However when I click
>
> However when I select View Data by right clicking on one of the tables I
> get
> the message:-
>
> "[MySQL][mysqld-4.0.24_Debian-10ubuntu2.1-log]You have an error in your
> SQL
> syntax. Check the manual that corresponds to your MySQL server version for
> the
> right syntax to use near 'DBName.Groups limit 100' at line 1."
>
> A similar error prevents me from setting any dynamic list boxes etc.
>
> I am sure that this is not a problem with the database as I am able to
> connect
> to it using PHP. I have tried using a driver on my local XPPro PC to
> connect
> too but that fails in exactly the same way.
>
>