MySql Query in AMS, is it possible?

[Imagine Programming]

Hey folkes, I want to execute a MySql query from AMS, but not through a PHP script... I used PHP to do it before, but it's just to dang slow to parse it through php and wait for a response first...

Does anyone have a great idea?

[bule]

ODBC Plugin.

[Imagine Programming]

ODBC Plugin.

With MySql i mean the online database:P does this work online?

[Dermot]

With MySql i mean the online database:P does this work online?

Yes it does as long as you have the MySQL ODBC driver installed.

[Imagine Programming]

hmm, well i tried luasql and mysql dll wich i found on the forums, but i can't get it to work. It gives me an error that i am not allowed to connect to mysql from that current location. I checked mysql on my server, but i do not now howto allow this... Does somebody know howto allow external connections?

in php scripts i use mysql_connect("localhost", "username", "password")... so only local is possible, but i want to create an application that needs the external connection

thanks

[Dermot]

We are talking about the ODBC plugin. http://www.indigorose.com/forums/sho...ht=ODBC+plugin

[Imagine Programming]

We are talking about the ODBC plugin. http://www.indigorose.com/forums/sho...ht=ODBC+plugin

Yes i know, but the money must be there to buy it... and i don't have it i know that luasql works, but i just need to know howto allow external connections in mysql

[Imagine Programming]

I figured it out, i didn't know that the account i use was only for the host localhost, so it works now thanks

[ShadowUK]

hmm, well i tried luasql and mysql dll wich i found on the forums, but i can't get it to work. It gives me an error that i am not allowed to connect to mysql from that current location. I checked mysql on my server, but i do not now howto allow this... Does somebody know howto allow external connections?

in php scripts i use mysql_connect("localhost", "username", "password")... so only local is possible, but i want to create an application that needs the external connection

thanks

[Imagine Programming]

Hey shadow, thanks for the reply, but i got it fixed by adding a new user. And changing it now won't do:P a friend of me does the webpart of this project, and already has a huge script with this data in it.

Thanks

[Dermot]

Keep in mind that luasql does not work on Vista.

[Imagine Programming]

But odbc is not in my range, so that means i've got a problem... until something new pops up, the application will be for XP only, vista users will have to use the webapp for it then. Thanks for the help m8