[sqlite] How to register System.Data.SQLite as a data source?
> Drago, William wrote: > > > > I always reference System.Data.SQLite directly and have no idea how to > > register it as a data source and what the implications of doing so are > > (will it break applications that reference the .NET assy directly)? > > Can anyone advise? > > > > A data source for what? The .NET Framework itself? Visual Studio? > The tool used by the official setup packages for this purpose is > here: > > http://urn.to/r/r > > -- > Joe Mistachkin Sorry for the poorly worded question. My follow-up might be just as bad; apologies in advance. I did look at Installer.cs, but I'm not knowledgeable enough to understand what it's doing. I noticed "what-if" mode and maybe now I'm not so averse to running the setups. Back to my question... Some Windows applications claim to work with any database as long as you choose the appropriate "provider" from the drop down list. On my computer the providers listed are: Odbc Data Provider OleDb Data Provider OracleClient Data Provider SqlClient Data Provider Microsoft SQL Server Compact Data Provider 4.0 Microsoft SQL Server Compact Data Provider How do I get SQLite/System.Data.SQLite to appear in that list? Thank you, -Bill Drago CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any attachments are solely for the use of the addressee and may contain information that is privileged or confidential. Any disclosure, use or distribution of the information contained herein is prohibited. In the event this e-mail contains technical data within the definition of the International Traffic in Arms Regulations or Export Administration Regulations, it is subject to the export control laws of the U.S.Government. The recipient should check this e-mail and any attachments for the presence of viruses as L-3 does not accept any liability associated with the transmission of this e-mail. If you have received this communication in error, please notify the sender by reply e-mail and immediately delete this message and any attachments.
[sqlite] How to register System.Data.SQLite as a data source?
Those look like the ODBC provider list... http://www.ch-werner.de/sqliteodbc/ On Wed, Apr 27, 2016 at 3:55 PM, Joe Mistachkin wrote: > > Drago, William wrote: >> >> I did look at Installer.cs, but I'm not knowledgeable enough to >> understand what it's doing. >> > > It modifies the registry and several .NET configuration files in > order to "install" the ADO.NET provider for System.Data.SQLite. > >> >> I noticed "what-if" mode and maybe now I'm not so averse to >> running the setups. >> > > That feature is dual purpose: 1) For being able to test the tool > without making any system changes and 2) Permitting end-users to > see what system changes would be made by the tool without actually > making any system changes. > >> >> Back to my question... Some Windows applications claim to work >> with any database as long as you choose the appropriate >> "provider" from the drop down list. On my computer the providers >> listed are: >> > > I suspect this is the list of ADO.NET providers managed by the .NET > Framework itself, via one of the aforementioned configuration files. > > In that case, the installer tool is what you are looking for. It > is possible to run the tool in such a way that it will only modify > those configuration files and nothing else. Although, now that I > think about it, I think putting the System.Data.SQLite assembly in > the GAC may also be required for this. > > Offhand, I'm not sure exactly what command line arguments you'll > need; however, they are all handled by the FromArgs() method. > They all set various fields of that class in order to alter the > behavior of the actual installation phase. Here are some > (untested) command line arguments to try (all on one line): > > -install true -wow64 true -installFlags > "CoreGlobalAssemblyCache DbProviderFactory" > -tracePriority Lowest -verbose true -noCompact true > -noNetFx20 true -noNetFx35 true -noNetFx45 true > -noNetFx451 true -noNetFx452 true -noNetFx46 true > -noNetFx461 true -noVs2005 true -noVs2008 true > -noVs2012 true -noVs2013 true -noVs2015 true > -confirm true > > I've purposely omitted the -whatIf option from the above example > command line. However, it would be required, with a value of > "false", if you actually wanted to make changes to the system. > > -- > Joe Mistachkin > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] How to register System.Data.SQLite as a data source?
All, I always reference System.Data.SQLite directly and have no idea how to register it as a data source and what the implications of doing so are (will it break applications that reference the .NET assy directly)? Can anyone advise? Thanks, -- Bill Drago Staff Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any attachments are solely for the use of the addressee and may contain information that is privileged or confidential. Any disclosure, use or distribution of the information contained herein is prohibited. In the event this e-mail contains technical data within the definition of the International Traffic in Arms Regulations or Export Administration Regulations, it is subject to the export control laws of the U.S.Government. The recipient should check this e-mail and any attachments for the presence of viruses as L-3 does not accept any liability associated with the transmission of this e-mail. If you have received this communication in error, please notify the sender by reply e-mail and immediately delete this message and any attachments.
[sqlite] How to register System.Data.SQLite as a data source?
Drago, William wrote: > > I did look at Installer.cs, but I'm not knowledgeable enough to > understand what it's doing. > It modifies the registry and several .NET configuration files in order to "install" the ADO.NET provider for System.Data.SQLite. > > I noticed "what-if" mode and maybe now I'm not so averse to > running the setups. > That feature is dual purpose: 1) For being able to test the tool without making any system changes and 2) Permitting end-users to see what system changes would be made by the tool without actually making any system changes. > > Back to my question... Some Windows applications claim to work > with any database as long as you choose the appropriate > "provider" from the drop down list. On my computer the providers > listed are: > I suspect this is the list of ADO.NET providers managed by the .NET Framework itself, via one of the aforementioned configuration files. In that case, the installer tool is what you are looking for. It is possible to run the tool in such a way that it will only modify those configuration files and nothing else. Although, now that I think about it, I think putting the System.Data.SQLite assembly in the GAC may also be required for this. Offhand, I'm not sure exactly what command line arguments you'll need; however, they are all handled by the FromArgs() method. They all set various fields of that class in order to alter the behavior of the actual installation phase. Here are some (untested) command line arguments to try (all on one line): -install true -wow64 true -installFlags "CoreGlobalAssemblyCache DbProviderFactory" -tracePriority Lowest -verbose true -noCompact true -noNetFx20 true -noNetFx35 true -noNetFx45 true -noNetFx451 true -noNetFx452 true -noNetFx46 true -noNetFx461 true -noVs2005 true -noVs2008 true -noVs2012 true -noVs2013 true -noVs2015 true -confirm true I've purposely omitted the -whatIf option from the above example command line. However, it would be required, with a value of "false", if you actually wanted to make changes to the system. -- Joe Mistachkin
[sqlite] How to register System.Data.SQLite as a data source?
Drago, William wrote: > > I always reference System.Data.SQLite directly and have no idea how > to register it as a data source and what the implications of doing > so are (will it break applications that reference the .NET assy > directly)? Can anyone advise? > A data source for what? The .NET Framework itself? Visual Studio? The tool used by the official setup packages for this purpose is here: http://urn.to/r/r -- Joe Mistachkin
