Be.Smart ERP Picker
(EN) ERP Picker
(EN) ERP Picker(CZ) ERP Picker(FR) ERP Picker(PL) ERP Picker(PT) ERP Picker(ES) ERP Picker
(EN) ERP Picker
(EN) ERP Picker(CZ) ERP Picker(FR) ERP Picker(PL) ERP Picker(PT) ERP Picker(ES) ERP Picker
  • ℹī¸What is Be.Smart ERP Picker?
  • ⚙ī¸System Requirements
  • 🔑Installation & Activation Guide
  • 🆕What's New
    • 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

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