I have searched high and low for information regarding the ODBCDataSource element. The only thing I can find is a posting on this list. From that post, I created the following Code in a component:
<ODBCDataSource Id="SMSHistoryDSN" DriverName="SQL Server" Name="SMS-3000 History SQL" Registration="machine">
<Property Id="DatabaseFile" Value="[MergeRedirecFolder]SMS_History_data.mdf" />
</ODBCDataSource>
I get an error on install that tells me that the file "SMS-3000 History SQL" could not be found. I want that to be the DSN name after creation, and I want to point to a SQL Server DB on the current machine. I assume that I should be using some property other than DatabaseFile (since it is SQL Server and not an access MDB), but I don't know what. I am also confused about the DBFile name error that I'm getting. here is the entry in the log file I get:
MSI (s) (7C:7C) [11:58:52:147]: Executing op: ActionStart(Name=InstallODBC,Description=Installing ODBC components,)
Action 11:58:52: InstallODBC. Installing ODBC components
MSI (s) (7C:7C) [11:58:52:157]: Executing op: ODBCDataSource(DriverKey=SQL Server,,Registration=4,Attribute_=DSN,Value_=SMS-3000 History SQL)
1: SQL Server 2: 3: 4 4: DSN 5: SMS-3000 History SQL 6: DatabaseFile 7: SMS_History_data.mdf
MSI (s) (7C:7C) [11:58:52:347]: LocalSQLConfigDataSource returned 0 in remote context.
MSI (s) (7C:7C) [11:58:52:398]: LocalSQLConfigDataSource returned 0 in remote context.
MSI (s) (7C:7C) [11:58:52:398]: LocalSQLInstallerError returned 0 in remote context.
MSI (s) (7C:7C) [11:58:52:398]: Note: 1: 2205 2: 3: Error
MSI (s) (7C:7C) [11:58:52:398]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1919
Error 1919. Error configuring ODBC data source: SMS-3000 History SQL, ODBC error 8: Invalid keyword-value pairs. Verify that the file SMS-3000 History SQL exists and that you can access it.
MSI (s) (7C:7C) [12:00:04:551]: Note: 1: 2205 2: 3: Error
MSI (s) (7C:7C) [12:00:04:551]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1709
MSI (s) (7C:7C) [12:00:04:611]: Product: Fiji Prototype -- Error 1919. Error configuring ODBC data source: SMS-3000 History SQL, ODBC error 8: Invalid keyword-value pairs. Verify that the file SMS-3000 History SQL exists and that you can access it.
Any help would be appreciated. Can I get this information from the WiX source code or something. I'm willing to dig, I just don't know where to start with the shovel...
Thanks,
Joseph
------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
