ODBC Problem - Not returning records

[droberson]

I'm having an odd problem with the ODBC object. I cannot get it to return rows.

I am running on Microsoft Vista Utimate. I have created an ODBC data source and tested it using OpenOffice Base. I can connect and issue the command "Select * from inventory" just fine. So I know the ODBC data source is working.

In MMF2 I add the ODBC object and tell it to connect to the ODBC datasource.

Then in my code I have
Start of frame
New Statement
Send SQL Command "Select * from Inventory"
Get Row

Can get data
Set text of text field to RowCount
Set texr of text field to ColName

End result I get the ColName but my RowCount comes back -1
meaning it did not return any data rows.

So I know I am access the table because the Colname is correct
but why no rows are returned. I also check the SQL Access
syntax and tested the SQL in OpenOffice BASE SQL query screen to
the same Access database and it works and is correct.

Is there a problem with the MMF2 ODBC object not working with the
Vista ODBC sources.????

Am I just doing something wrong????

[Joshtek]

I don't think all ODBC sources support RowCount. Check this thread out for ideas on how to use the ODBC object.

[droberson]

Thank Joshtek, are you using Vista?

See my real problem is that after sending the SQL command
I can only get Column heading names but I cannot get an data using the getColumntext also. I mean I can get the ColName
but not the Coltext or the rowcount. Its like it it is accessing the table but not returning any datarows.

[Joshtek]

I'm not using Vista. Try out the example and my tutorial. Forget about RowCount, its content is not to be trusted.

[droberson]

Well, you are correct that row count may not be supported. For some reason it now works. I have no idea why. I just readded a new text field telling it to get the Column text. This is strange. I guess it must just be me. Thanks for reply.

[Tomahawk]

Is it possible to access MySQL databases on websites? (i.e. like a forum)

How do you go about the steps of entering an address, login, password and choose a database?

[droberson]

You have the use PHP and MMF2. MMF2 as the frontend and PHP to pass the information back and forth. Do some searchs on this forum and you can find some examples of the PHP code.

Try this link.
http://www.clickteam.com/eng/resources/online_score/onlinescoreboards.html

This question keeps coming up on the forum and it would be nice to have a solution developed without having to result to PHP but for the time being PHP is the best answer so far.

I believe Clickteam is working on Vitialize for MMF2 that will allow you to place MMF2 application on the web. But even with that you would still need PHP.

If you going to do this your website would also have to support PHP and MySQL.

[DavidN]

Jam recently released the Live Receiver extension, which makes things quite a lot easier than using Moosock to send an HTTP request - though the idea is still the same.

The trouble with most MySQL servers is that they only allow connections from within the same site, so you have to go through PHP to work around it.

[James]

If the MySQL server accepts connections from other IP addresses than the site it is hosted at, you could always learn the MySQL protocol and use it with MooSock.