Home > Uncategorized > Connection string for Sage ODBC via OLEDB

Connection string for Sage ODBC via OLEDB

Provider=MSDASQL.1;Persist Security Info=False;User ID=Manager;Data Source=SageLine50v9;Extended Properties="DSN=SageLine50v9;UID="
 
When Sage Line 50 is installed, it creates a system ODBC DSN called SageLine50v9 (I assume other versions of sage have corresponding names). The "database "contains the following tables:
 
TABLES
COMPANY
PERIOD
SALES_LEDGER
PURCHASE_LEDGER
NOMINAL_LEDGER
AUDIT_HEADER
AUDIT_SPLIT
AUDIT_JOURNAL
AUDIT_VAT
AUDIT_USAGE
DEPARTMENT
BANK
STOCK
STOCK_TRAN
STOCK_CAT
STOCK_COMP
INVOICE
SALES_ORDER
PURCHASE_ORDER
RECURRING
FIXED_ASSET
FIXED_ASSET_CAT
PREPAYMENT
ACCRUAL
INVOICE_ITEM
SOP_ITEM
POP_ITEM
SALES_CONTACT
PURCHASE_CONTACT
SALES_DEL_ADDR
PURCHASE_DEL_ADDR
COMPANY_DEL_ADDR
PRICE
PRICE_LIST
GRN_ITEM
CHART_LIST
CAT_TITLE
CATEGORY
TAX_CODE
UPDATE_LEDGER
CURRENCY
VAT_SUMMARY
VAT_RETURN
REMITTANCE
Advertisements
Categories: Uncategorized
  1. January 24, 2011 at 5:01 pm

    Hi, this is interesting but how did you get the connection string for Sage, cause I’m dealing with Intégrale and it’s not the same connection string. If you can help, thanks for posting.

  2. Edwin
    March 2, 2011 at 12:13 pm

    Hi Waly DIOUF, Make sure you install the ODBC Driver for the version of SAGE you have.

  3. March 24, 2011 at 5:45 am

    I am Integrate Sage to our windows application. But I am facing problem for select company in 2011 version.
    szDataPath = oSDO.SelectCompany(“C:\\Documents and Settings\\All Users\\Application Data\\Sage\\Accounts\\2011\\IREPractice\\AcctDATA\\ACCOUNT.DTA”);

    it shows a window but no any company. How to solve this problem.

  4. Adnan
    August 1, 2015 at 1:21 pm

    I am trying to connection SAGE line 50 version 21 to c# and it is giving me error Provider=MSDASQL.1;Persist Security Info=False;User ID=Manager;Data Source=SageLine50v9;Extended Properties=”DSN=SageLine50v9;UID=”

  5. Adnan
    August 1, 2015 at 1:31 pm

    I am trying to connection SAGE line 50 version 21 to c# and it is giving me error ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: