Use Sybase

You need to install the AsaClient provider on your computer; the tests with AVEVA Edge were performed using the architecture explained in the topic Manually install Studio Database Gateway.

If you are using the browse button to automatically generate the connection string, the string returned will have the following format:

Provider=ASAProv.90; Data Source=Test

This format requires that you create an ODBC DSN with the same name as the Data Source (in this case, Test) in order to communicate with the database. If the DSN is not created, the following error will display in the LogWin when connecting to the database:

Database: Error: Parse error: DSN 'Test' does not exist

To void an ODBC DSN, you can enter with the connection string manually as shown in the example below:

Provider=ASAProv.90; DBF=C:\Test.db

Note: These procedures were tested using Sybase Server Anywhere 9.0.1.1751.