Results 1 to 7 of 7

Thread: mySQL database

  1. #1

    Default mySQL database

    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 ?

  2. #2
    Senior Member chuckj's Avatar
    Join Date
    Jan 2010
    Location
    www.beyondfusion.com - Florida
    Posts
    1,302

    Default

    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.
    Chuck Joslin
    www.BeyondFusion.com
    PHP & MySQL development with Fusion
    Fusion support for AllWebMenus (Likno) Contact me for custom AWM menus for your sites.
    Tutorials and Forums

  3. #3

    Default

    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 ?

  4. #4
    Senior Member chuckj's Avatar
    Join Date
    Jan 2010
    Location
    www.beyondfusion.com - Florida
    Posts
    1,302

    Default

    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.
    Chuck Joslin
    www.BeyondFusion.com
    PHP & MySQL development with Fusion
    Fusion support for AllWebMenus (Likno) Contact me for custom AWM menus for your sites.
    Tutorials and Forums

  5. #5

    Default

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

  6. #6

    Default

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

  7. #7
    Senior Member chuckj's Avatar
    Join Date
    Jan 2010
    Location
    www.beyondfusion.com - Florida
    Posts
    1,302

    Default

    This will help you learn to do your own.

    http://www.beyondfusion.com/html/phptutorials.php
    Chuck Joslin
    www.BeyondFusion.com
    PHP & MySQL development with Fusion
    Fusion support for AllWebMenus (Likno) Contact me for custom AWM menus for your sites.
    Tutorials and Forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •