This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
GordonWeil
Level 3
‎Feb 23, 2011 02:09 PM

ODBC Data Source failure

Any help on this one would be greatly appreciated.

My installation fails to create the ODBC Data Source. After the installation, I can create the data source using the ODBC Administrator and can then connect to the database. I have tested the installation on Windows XP and Windows 7 with the same result.

I am installing SQL Anywhere 12.01 with a merge module created by the SQLA Deploy to Windows wizard. I built my installation using Installshield 2011 version 17. When the installation tries to create the ODBC Data Source I get this:

Error 1919. Error configuring ODBC data source R_2011, ODBC error 11: Driver's ConfigDSN, ConfigDriver, or ConfigTranslatro failed. Verify that the file R_2011 exists and that you can access it.

When I turn Msi logging on, the following appears in the log file:

ActionStart(Name=InstallODBC,Description=Installing ODBC components,)
MSI (s) (BC:90) [13:46:56:922]: Executing op: ODBCInstallDriver(DriverKey=SQL Anywhere 12,Component={57016628-60BB-4601-A7B8-4F8DC48856B0},Folder=C:\WINDOWS\system32\,Attribute_=Driver,Value_=dbodbc12.dll)
MSI (s) (BC:90) [13:46:57:000]: LocalSQLInstallDriverEx returned 1 in local context.
MSI (s) (BC:90) [13:46:57:281]: LocalSQLConfigDriver returned 1 in local context.
MSI (s) (BC:90) [13:46:57:281]: Executing op: ODBCDataSource(DriverKey=SQL Anywhere 12,,Registration=4,Attribute_=DSN,Value_=R_2011)
MSI (s) (BC:90) [13:46:58:047]: LocalSQLConfigDataSource returned 0 in local context.
MSI (s) (BC:90) [13:46:58:141]: LocalSQLConfigDataSource returned 0 in local context.
MSI (s) (BC:90) [13:46:58:141]: LocalSQLInstallerError returned 0 in local context.
Labels (1)
Labels
0 Kudos
(3) Replies
GordonWeil
Level 3
‎Feb 24, 2011 12:56 PM

Found the problem. I specified an invalid option. The option I specified for the Integrated property was "NONE". The correction option was "NO".
0 Kudos
amirbrb
Level 2
‎Mar 13, 2011 10:08 AM

Didnt quite get it.
where did you specify the property?
0 Kudos
GordonWeil
Level 3
‎Mar 16, 2011 04:04 PM

The settings are on the Installation Designer tab, 'ODBC Resources' under the System Configuration folder on the left hand list. The middle pane allows selecting and creating DSNs, and when a DSN is selected its properties and respective values are displayed on the right side pane titled 'ODBC Attributes & Properties'.

Apparently if an invalid value (and probably an invalid property) is specified under 'ODBC Attributes & Properties' then the attempt to create the ODBC DSN fails during the installation.
0 Kudos