ODBC MSSQL Database

[Kingsy101]

I have recently been using my actinic store with a spreadsheet system, and recently I have upgraded to a normalized MSSQL approach.

I have successfully created an ODBC connection to it, however when I enter the external links menu and select the ODBC connection it asks me to connect to a specific table.

Is it possible to connect to the DB only (no specific table) and to get the information to the actinic fields by using sql statements? (meaning I could use select, where & inner joins etc?)

Any advice would be appriciated.

Thanks

Chris

[Kingsy101]

More Importantly

I probably should have been more specific, by saying all I need to do is be able to access data from more than 1 table in the database in order to map the information to the actinic field, and preferably execute some small sql commands.

Is this possible?

[dave_finlayson]

I'm sure it's certainly possible but it may be worth considering getting a copy of Gabe's ActSQL. This will populate an sql table for you so may save you a lot of hassle.

[edit] heres the link http://www.interact-studio.co.uk/aca...Connector.html [/edit]

[dave_finlayson]

Excuse me, you are looking for it to work the other way round, never read your post properly! Pretend I never spoke! Let the slagging commence!

[fergusw]

Chris,
You'll need to create an SQL View which in effect returns the dataset that you wish to link to.
The Actinic ODBC connection utilises pretty direct SQL transactions and therefore won't allow you to use SQL statements in the query. It pretty much maps field to field between data sources.
If you can populate a single view/query with the required data fields that you wish to map then this would be the way forward for you.

[Kingsy101]

Cheers

Thanks fergusw

Thats a good idea, I will just sort out everything in the MS Sql Server application and create a single table with everything I need in it.
Which means the data will still be coming from a normalized DB and it can be accessed by actinic.

Good Idea
Thanks for the Help!

[Jan]

You can't link to views unfortunately. You could use a view to create a table that Actinic links to but then you wouldn't be able to update the source data.

Regards,