• Home
  • Investors
  • Contact Parker
  • Sign In / Register
Parker Community
  • Site
  • User
  • Site
  • Search
  • User
  • Products
  • Support
  • Divisions
  • Where to Buy
  • Careers
  • About Parker
Home Parker Community Technologies Electromechanical Group Electromechanical Knowledge Base InteractX Training - SQL Database - Basics to use Logging Tools and how to use VBA SQL Script to read data back.
  • Electromechanical Knowledge Base & Frequently Asked Questions
  • +Motion and Machine Controllers
  • +General Technology Information
  • +Virtual Engineer
  • -Visualization and Human Machine Interface (HMI)
    • +General Communications Driver
    • +Interact (Legacy)
    • -InteractX
      • InteractX Misc - Cannot find product code for Win9X/NT
      • InteractX Misc - Comm Server Connection to Allen Bradley Logix Processors
      • InteractX Misc - How do I get my InteractX project off of my old unit and onto my new IPX Powerstation?
      • InteractX Misc - How to order InteractX Upgrades
      • InteractX Misc - How to re-register older versions of Interact X (versions 1.x through 3.4)
      • InteractX Misc - How to Start InteractX Runtime Project Automatically?
      • InteractX Misc - Is InteractX Version 1.x, 2.x or 3.x Compatible with Windows 7 or Later?
      • InteractX Misc - InteractX Software Archive
      • InteractX Misc - Language Multi-Byte Character Support for ASCII Input - Cyrillic, Asian etc...
      • InteractX Misc - Migrating InteractX from legacy HMI and PC systems to Current Hardware and Windows OS Versions
      • InteractX Misc - Uploading and downloading InteractX projects over Ethernet
      • InteractX Misc - Uploading and downloading InteractX projects with a USB drive
      • InteractX Misc - User Configurable Driver User Guide (UCON)
      • InteractX Misc - Version 4.0/4.1 Security Device Questions
      • InteractX Misc - Where does my Powerstation store my InteractX license activation?
      • InteractX Misc - Which HMI runs InteractX?
      • InteractX Software - Complete Modbus/RTU Addressing Example for P Series Indexer Drive
      • InteractX Software - Express Browser Demo
      • InteractX Software - How do I control the Lens States for an Indicator tool in Int X?
      • InteractX Software - How to Shutdown InteractX and Windows
      • InteractX Software - How to Use Existing Recipes as Items within a New or Modified Recipe
      • InteractX Training - Creating and Configuring Event Logs in InteractX
      • InteractX Training - Creating Databases and Tables in InteractX
      • InteractX Training - Database Basics
      • InteractX Training - Getting Started with Quicklogging
      • InteractX Training - Print a Report from InteractX using a VBA form to create your Report layout and VBA logic to populate it.
      • InteractX Training - Recipe Training Module
      • InteractX Training - SQL Database - Basics to use Logging Tools and how to use VBA SQL Script to read data back.
      • InteractX Training - Tag Rules (Tag Sharing) Examples
      • InteractX Training - VBA Login Example
      • InteractX Troubleshooting - Version 4.1 will not automatically start on my Windows 10 Runtime PC due to requiring elevated privileges
      • InteractX Troubleshooting - Alarm History Viewer not working as expected (InteractX version 4.1)
      • InteractX Troubleshooting - Allen Bradley ControlLogix Driver Compatibility Issues.
      • InteractX Troubleshooting - Can not get License Activation to work on HMI/PC running InteractX version 1.x to 3.4
      • InteractX Troubleshooting - Com Server Error Log
      • InteractX Troubleshooting - COMM Server still using old configuration after download of application with changes to communication settings.
      • InteractX Troubleshooting - ControlLogix Driver unable to upload tags from Device (PLC) unable to read known good tags from processor.
      • InteractX Troubleshooting - CTC Runtime Data Error Symbols (! ? broken pencil etc)
      • InteractX Troubleshooting - Error Initializing VBA when going into run mode or opening the VBA Editor in Development
      • InteractX Troubleshooting - Hardware License Not Found - One Hour Runtime - Remote Desktop
      • InteractX Troubleshooting - InteractX 4.0 HASP key driver Aladdin vs Sentinel (NOTE: IntX4.1 for Windows 10 uses Sentinel Drivers)
      • InteractX Troubleshooting - Invalid Page Fault in the NTOSKERNEL.EXE (old PC/PX models)
      • InteractX Troubleshooting - Loss of Characters on the Pop-up Keyboard, Keypad, etc.
      • InteractX Troubleshooting - Problems with large number accuracy
      • InteractX Troubleshooting - Downloaded InteractX application with Ethernet driver fails to connect even though ping is successful and works otherwise
      • InteractX Troubleshooting - VBA is not working on my new Windows 7/8.1/10 PC (Versions 4.0 / 4.1)
      • InteractX Troubleshooting - Unable to get Data Connection to Xpress tags to work.
      • InteractX Troubleshooting - Why can't I log data with Microsoft Jet (MDB file) in InteractX?
      • z CIP Communications stop on all devices when one CIP device goes offline
      • InteractX Browser Tool used to display Xpress or PFD screens impacted by Adobe Flash EOL.
    • +Interact Xpress
    • +IX / PCA
    • +IPX / IPC (Discontinued)
    • +PHM / PM1 (Industrial Monitor)
    • +PA / PS / P1-P9 (DOS-based Interact HMI)
    • +PX / HPX InteractX HMIs (Discontinued)
    • CE Declaration of Conformity for HMI
    • CTC/HMI: Connector Part Numbers
    • My HMI will not boot. Says no boot device found even after I ran the Flashback utility for my model HMI
    • Parker Factory Display Troubleshooting - Step 3 Error when clicking Design in your PFD Project
    • Latest versions of HMI software packages
    • Failed install / Can't install because of pending/suspended action. Can't uninstall and Installshield quits or throws an error and can not continue.
    • PowerStation Accessories - Mounting kits, Connectors, Protective Overlays
    • What HMI software runs on which models of HMI? (Consolidated History of HMI and Software Versions)
    • What software is on my Parker/CTC HMIs?
  • +Servo Drives and Servo Drive/Controllers
  • +Stepper Drives and Stepper Drive/Controller
  • +Gearheads
  • +AC and DC Drives and Inverters
  • +Servo Motors
  • +Step Motors
  • +Linear and Rotary Positioners
  • +Electric Cylinders
  • +T-Slot Aluminum Framing
  • +OEM Products
  • +C3 + Xpress + ETH
  • How can I stay updated on Parker electromechanical and drives product news?
  • +Legacy (Discontinued)
  • +Other

You are currently reviewing an older revision of this page.

  • History View current version

SQL Database - Basics to use Logging Tools and how to use VBA SQL Script to read data back.

The linked InteractX 4.1 Project will also open and run in InteractX 4.0.

In this single screen demo, it is configured to talk to the default SQLExpress runtime database server name using Windows Authentication. It will automatically create the necessary database and tables.

Instead of using the Quicklog feature to automatically define my Table and Event links, I used the manual Database table tool to create two tables to write to simultaneously with two event definitions to simulate storing a subset of data that had technical details stripped out.

PDF step by step walk through of the application:

Simple Database DemoWithVBAReadIX 4.pdf

Project Backup in InteractX 4.1 and can be opened in 4.0 and run as well:

Database_BasicWithReadVBA.zip

Application Screen:

dm 20180412

  • Other Groups
    • Parker Indego
      • Parker Indego Instructors
      • Parker Indego Therapists
      • Parker Indego Distributors
  • Technologies
    • Aerospace
    • Climate Control
    • Electromechanical Group
      • Parker IPS Design Center Community
    • Filtration
    • Fluid and Gas Handling
    • Hydraulics
    • IoT
      • Mobile IoT
    • Pneumatics
    • Process Control
    • Sealing and Shielding
  • Home
  • All Blogs
  • Home
  • Electromechanical Blog
  • Electromechanical Group Forums
  • Electromechanical Knowledge Base
  • Electromechanical Group Members
  • Mentions
  • Electromechanical Group Sub-Groups
  • Tags
Follow Us
  • Follow Parker Hannifin on social media

Follow Parker Hannifin on social media:

Parker Hannifin Parker Hannifin

  • Products
  • About Parker
  • Investors
  • Community
  • Careers

Global Operations Global Operations

  • Divisions
  • Sales Companies
  • Worldwide Locations
  • Distribution Network
  • ParkerStoreā„¢ Network

Company Information Company Information

  • Newsroom
  • Event Calendar
  • Working with Parker
  • Product Brands
  • History

Global Support Center Global Support Center

  • Support
  • CAD
  • Where to Buy
  • Contact Parker
  • Manage Online Orders
Parker - Engineering Your Success
  • Site Map
  • Safety
  • Privacy Policies
  • Terms and Conditions
Ā© Parker Hannifin Corp 2021