mySQL database

[mrperfect]

Hi

I have setup a mySQL database on my server and trying to connect to it. My host has told me the ODBC connector does not work on this server. How can I set the connector using NOF11 ?

[chuckj]

Most hosts do not allow remote connections. And on a local connection (once you've published your site), a ODBC connector is not required. You just use a (custom) connection string.

[mrperfect]

Thanks chuckj. I am a newbie to mySQL so its taking me a while to suss it out. I have set the connector as you said, how dod I set the iterator recordset etc ?

[chuckj]

Personally, I don't use the DB tools in Fusion, since I write my own code and insert it using the code insertion points in design view.

Lots of people do use them though.

Before you can use the other tools, you have to place a connector in your layout and have a database schema to connect to.

In other words, first you design your database, then you use the DB tools in Fusion to access it and display records.

[mrperfect]

I am having great pains trying to set any external data source !

[mrperfect]

I would link to a script but I dont write my own and others cost lots of money to purchace

[chuckj]

This will help you learn to do your own.

http://www.beyondfusion.com/html/phptutorials.php