Be.Smart ERP Picker
(EN) ERP Picker
(EN) ERP Picker
  • ℹī¸What is Be.Smart ERP Picker?
  • ⚙ī¸System Requirements
  • 🔑Installation & Activation Guide
  • 🆕What's New
    • Version 2.2.1.0
    • Version 2.1.3.0
  • Common information
    • Application configuration
      • Configuration file structure
      • Configuration file location
      • Configuration file parameters
        • Section [Settings]
        • Section [Mappings]
        • Section [MappingsC]
      • Examples of connections to data sources
        • Text file (txt | csv)
        • MS Excel
        • MS Access
        • MS SQL
        • Autodesk Vault
    • Overview of error messages
  • ERP Picker (Inventor add-on)
    • Basic description of functionality
    • Overview of commands
      • Be.Smart ERP Picker
        • Pick & Exit
        • Pick & Exit (Custom)
        • Export to file
        • Cancel
        • About
        • Help
        • Filtering and searching
        • Panel of additional information
      • Config
        • Edit config
        • Open folder
        • Exit
        • About
        • Help
      • About
  • ERP Picker (standalone app)
    • Basic description of functionality
    • Overview of commands
      • Export to file
      • Open folder
      • Cancel
      • About
      • Help
      • Filtering and Searching
      • Panel of additional information
Powered by GitBook
On this page
  1. Common information
  2. Application configuration
  3. Examples of connections to data sources

MS SQL

PreviousMS AccessNextAutodesk Vault

Last updated 1 year ago

An example of the settings for the MS SQL database is shown below.

Settings ConnectionString

ConnectionString=Server=(LocalDb)\LocalDBTesting; Database=MyTestDatabase; User ID=***; Password=***

Settings ConnectionSelectCommand

ConnectionSelectCommand=SELECT ID_, Group_, Number, Name01, Description_, Standard_, Material, Thickness FROM TestDataTable

Database preview