Jump to content
Software FX Community

Connecting to SQLite db in PowerGadgets

Recommended Posts

marco.shaw    0

A couple of approaches is to determine whether there's an "ODBC" interface to your DB.  Another approach is to determine what kind of .NET functionality might be provided to access your DB (I just found this: http://sqlite.phxsoftware.com/).

Are you willing to install any kind of 3rd party app if required?

http://en.wikipedia.org/wiki/SQLlite says:

"SQLite also has bindings for a large number of programming languages, including BASIC, C, C++, Common Lisp, Java, C#, Delphi, Curl, Lua, Tcl, R, PHP, Perl, Ruby, Objective-C (on Mac OS X), Python, newLisp and Smalltalk. There is also a COM (ActiveX) wrapper making SQLite accessible on Windows to scripted languages such as Javascript and VBScript. This adds database capabilities to HTML Applications (HTA).[3]"

So, C# and COM support are probably good news for accessing these via PowerShell.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now