Enable Updates to External Data

I am working on an Actinic site that pulls its product data from an external source, a SQL Server database. This works fine but I notice there is a greyed out checkbox that says 'Enable updates to external data'. This would be extremely handy if someone could advise me on how to activate this feature or at least tell me why it is greyed out.

Thanks in advance.

[Jan]

Check the permissions on the SQL server tables for the user that you specified in your SQL server ODBC connection. If that box is greyed out it means that Actinic thinks that it is using a readonly connection.

Regards,

[CreativeNRG]

The user is the dbowner and therefore has Read, Write, Update & Delete permissions on the table??

[wjcampbe]

is the data coming from a view or an sql join - many times that will produce a read only rowset. If yes, see if they can produce an import export table which you can access with a clean sql query. They would then be able to use your data as an updateset for the original tables.

For a really specific answer, would need to know the type of database (Interbase/Firebird/MySQL etc) and the flavour of SQL in use.

[Jan]

In your ODBC settings have you specified NT authentication or SQL server authentication.

Are you linking to a table or a view (I wouldn't expect Actinic to offer views for linking, but you never know do you).

Regards,

[CreativeNRG]

Thanks for your assistance on this.

The database is a local MSDE database on my machine. I am linking directly to a table and not a view.

I have tried both a trusted connection and SQL Server authentication with the same results.

[wjcampbe]

In my ODBC Data Source Administrator there is a tickbox for read-only, can you confirm that box is NOT ticked?

[CreativeNRG]

It is a machine datasource and does not have that option.

[wjcampbe]

This document

http://support.microsoft.com/default...;EN-US;Q325020

states that the recordset using DAO or ODBC direct will default to read only. Hopefully it includes details on how to change this. I have not yet read the full doc.

[Jan]

Did you get anywhere with this Simon?

Regards,

[CreativeNRG]

Enable Updates to External Data

Unfortunately I have still not resolved the problem.

Simon

[Jan]

The only thing that I can suggest now is to submit a support request to Actinic, you can call in if you have cover or use the email form on the support section of their website to submit the report otherwise.

Regards,

[Guy]

I am having the same problem, the option for linking to external data is greyed out on new products I want to link. I even tried changing the ref number on a linked product, saving it, then putting it back as it was, just to see if it was just me. The Link option just disapeared now I can't get it back?

Has this thread got a fix for it yet?
Guy.

[cdicken]

Did this thread help you at all?

[Guy]

Hi, No not at all. I've tried that already.
I was wondering, does Actinic pu them in a folder call "unallocated external product" ? by default?