Yes its always good to remember that ODBC connection strings are data source dependent. So what you can do is use {...} macro substitution in the connection string if you want to switch between...
Type: Posts; User: barrymavin
Yes its always good to remember that ODBC connection strings are data source dependent. So what you can do is use {...} macro substitution in the connection string if you want to switch between...
Alternatively the ODBC manager should have somewhere to specify it. But as I say every driver is different.
You need to look at the connection string options available for that ODBC driver. Each one is different. Typically you can add uid=ca;pwd=ca; as part of your connection string or something to that...