Hi - just upgraded from v8.5 --> 9.2

Has anyone else had an issue in that they've had to reconfigure their protocols that use the SQL Open Connection component when connecting to a MS Access database.

It use to be that I could open a connection at the beginning of a protocol and name it.

I'd have to use something like

DRIVER=Microsoft Access Driver (*.mdb, *.accdb); DBQ=\\myserver\myACCESSDB.accdb

as the value for the Data Source parameter

I'd have some name specificed

'myDBname'

n the Connection Name parameter.

Then in later SQL components I could reference that connection by using

'Name=myDBname'

as the value forhte Data Source parameter.

This no longer works in v9.2 - error message:

Unknown data source 'Name=PeppDB' 

I've a workaround which is explicitly stating the source (along with the driver info etc) in each one of the SQL components but it's not pretty and I don't know how well that will work if emplying the SQL End Transaction component which I use sometimes as a nice way to roll-back if things go awry.

Note: I'm using the language above to avoid setting up ODBC sources at the server level whilst I do test projects. When the project is mature I move to the more formal way of referencing the database. It'd be a pity to lose the quick hack.

So is this a known issue, orexpected behaviour.

Thanks for any input,

Tristan