Actinic Version 7 linking to SQL db

[emranpatel]

I'm trying to link to an external MS SQL Server database from an empty site using ODBC. When linking the external product reference to the internal one, the following error message appears:
Actinic Ecommerce was unable to determine if there are duplicate product references in the external table. Please correct the error or disable external product linking. The error message reported was:
ODBC--connection to 'mysqldb' failed.

The external table has the product reference as its primary key and a unique index and a unique constraint on the field. It does work however when the data is imported to an MS Access table.

I'm using Actinic Developer 7.0.2 and the Product ID's are 20 character varchar.

Does anyone know what I need to do to use SQL Server ?

Any help would be appreciated

Thanks,
Emran

[Nadeem]

Hi there Emran,

From the error

ODBC--connection to 'mysqldb' failed.

This suggest that actinic cannot make the connection to the mysql database via OBDC. Have you set up the ODBC Data source through Actinic, or through Windows Control Panel? Also does the database require a username and password to enter?

Kind Regards

[webyourbusiness]

I'm trying to link to an external MS SQL Server database from an empty site using ODBC. When linking the external product reference to the internal one, the following error message appears:
Actinic Ecommerce was unable to determine if there are duplicate product references in the external table. Please correct the error or disable external product linking. The error message reported was:
ODBC--connection to 'mysqldb' failed.

When you created the odbc connection, did you create a connection to a MS SQL database or a MySQL database?

[emranpatel]

Actinic Version 7 linking to SQL db

The ODBC connection is fine - we use SQL for our SAP systems, integrate in Access and Excel via ODBC, and have sufficient knowledge to do the simple things. But we cannot figure out why there is an error message about unique values - the table has a PRIMARY key, and they are unique. Also, we have ensured it is a nvarchar field type, as mentioned in the help file.

[Pneumatus]

I think the point that WYB were trying to make is that the error message is reporting a mySQL error, however you said in your first post that your were using a MS SQL database