Jump to content
Software FX Community

Connecting to SQLite db in PowerGadgets


Recommended Posts

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...