oledb-runner README

Features

This VSCode extension is used to execute OLEDB queries to CSV files.

To use the extension you need run this commands.
Open the command palette press the key combination Ctrl+Shift+P

• Configure Path - OLEDB configure files path.
• Configure Provider - OLEDB configure provider.
• Configure Delimiter - OLEDB configure delimiter.
• Execute - OLEDB execute OLEDB query.

Settings

You can change default values in extension settings or can add this property in settings.json.

Example to default provider

"OLEDB-Runner.Default-Provider": "Microsoft.ACE.OLEDB.12.0" 

Example to default delimiter

"OLEDB-Runner.Default-Delimiter": "," 

You can change the engine in extension settings or can add this property with x86 or x64 value.

"OLEDB-Runner.Engine": "x86" 

You can change image to wait for the query to be performed. If you do not want to show any image, leave this option empty.

"OLEDB-Runner.Consulting-IMG": "https://media.giphy.com/media/JIX9t2j0ZTN9S/giphy.gif"

You can change image on error. If you do not want to show any image, leave this option empty.

"OLEDB-Runner.Error-IMG": "https://i.kym-cdn.com/photos/images/newsfeed/001/384/531/8ed.jpg",

Installation

Important

You need .NET of your system engine (x86 or x64).
If you don't have .NET 6.0 or later, you can download in this page.

1. Download .vsix
2. Open view extensions (Ctrl+Shift+X), More actions and click in 'Install from VSIX'
   
3. Enjoy 😀

Release Notes

Version 1.1.0

• Add a loading screen and error screen.
• Changed table CSS to be dynamic.
• Add 3 new setting.

Version 1.0.0

• Changed the way the query table is created .
• Add control to update or create webViewPanel.

Version 0.0.4

• Changed the path for the OLEDB executable file.
• Add icon to extensions view.

Version 0.0.3

• Add new command to configure the provider and delimiter.
• Add extension settings for default values.

Version 0.0.2

• Changed the path for the OLEDB executable file.

Version 0.0.1

• Initial version.