Using ASP to connect to a MySQL Database

[Guest]

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.

[Newsgroup_User]

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

[Guest]

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

[Newsgroup_User]

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.

[Guest]

Perhaps I am guilty of being ambiguous.

I have set up a connection item in ASP to a MySQL connection on a Linux serve

= website on a windows server and MYSQL on a Linux server.

Thanks for pointing this out.