Business v7 - External link to MySQL

[dave.webb]

Hi all.

I've been trying to link to a MySQL database using Business version 7 but keep getting the error "User cancelled" when creating the external link. I've created the DSN in control panel and tested it and it works. However, when using Actinic to create the external link I get the above error.

I pay for support with Actinic but the four people I have spoken to have never done anything with SQL and have no documentaion on this error.

Can anyone offer any advice or a solution?

Thanks in advance,
Dave

[axpoint]

Connecting to MyQL

Hi,

Ive been working very closely with MySQL integration... I found connecting to MySQL very simple...

Do you have some snap shots of the config and errors that you are getting?

Dean
Axpoint Business Solutions

[Manic]

I've managed to do it by inserting php code into the product template to create my own links.

For example if you look at http://www.chinalifeweb.com/acatalog...op_Teas_5.html

you'll see that I've made a link to an extra info page by setting a variable with a netqoutevar

$product = 'NETQUOTEVAR:PRODUCTREFERENCE';

<?php
if ( $fullurl == "http://www.chinalifeweb.com/acatalog/Chinalife_Shop_Teas_5.html" )
{
    echo ("<a href=\"http://www.chinalifeweb.com/prodinfo/teainfo.php?prod=$product\"><IMG SRC=\"NETQUOTEVAR:IMAGEFILE\" ALT=\"NETQUOTEVAR:ALTERNATETEXT\" BORDER=0 NETQUOTEVAR:IMAGEHEIGHT NETQUOTEVAR:IMAGEWIDTH NETQUOTEVAR:OTHERIMAGEMARKUP></a>");
    echo ("<br><a href=\"http://www.chinalifeweb.com/prodinfo/teainfo.php?prod=$product\"><SPAN CLASS=\"actxsmall\"><B>View More Info</B></span></a>");
}
else
{
    echo ("<IMG SRC=\"NETQUOTEVAR:IMAGEFILE\" ALT=\"NETQUOTEVAR:ALTERNATETEXT\" BORDER=0 NETQUOTEVAR:IMAGEHEIGHT NETQUOTEVAR:IMAGEWIDTH NETQUOTEVAR:OTHERIMAGEMARKUP>");
}
?>

You can put php code to connect to your database where ever you like in your product templates. Just make sure your server is set to parse php in html files and as Norman suggested - turn off highlight search results in View--->Search Settings --> Search Options! If you dont your code will be exposed displaying search results.

[Jan]

You problems are likely to be either down to database permissions, make sure that the database table you are trying to link to has full access for the user that your are connecting with.

Regards,

[dave.webb]

Hi all.

Thanks to those that replied.

I'm using MyODBC 3.51.12 and do have full access to the database (using root). When creating the DSN the test is successful.

The error I get is simply "User cancelled" and it pops up when I click OK to creating the external link inside Actinic.

Dave

[Bruce]

Dave,

You have an ongoing ticket with support on this issue. Just in case you did not receive the last update, Development have tested on MySQL ODBC 2.50.37.00 and ODBC 3.525.1117.0 which works fine. They think that this could be a driver issue.

Take a look at the following threads ..
http://forums.mysql.com/read.php?37,...0770#msg-50770
and
http://forums.mysql.com/read.php?37,...3792#msg-53792

If this doesn't help, please send Dhivya a screen shot of the ODBC User DSN
settings and if possible the snapshot and MySQL DB.

Kind regards,

[dave.webb]

Hi Bruce.

I've sent the screen shots to Dhivya and am waiting for a response.

I tried switching to an older version of the MyODBC driver but this didn't work.

Thanks,
Dave