Pulling data from c-tree (Faircom) into SQL Server using ODBC

• Todd Townley

  Ten Centuries

  Points: 1320

  More actions

  February 25, 2022 at 7:27 pm

  #3989132

  I could use some assistance attempting to pull data from a c-tree database into SQL Server.

  On a SQL Server 2019 server, we have installed the 32-bit and 64-bit ODBC drivers from the software vendor to their c-tree database.  We have set up an appropriate DSN called VendDSN.  This DSN works with Crystal Reports and with Excel.  I'd like to use this DSN to import the c-tree data directly into SQL Server.

  1. Import Wizard - Using the Import Wizard and the .Net Framework Data Provide for ODBC I can create a connection to the c-tree database.  I can get a list of all the tables (1400+) using Copy from Tables or Views.  However, for some tables, if I try to move forward or look at mappings I get an "Index was outside the bounds of the array" error and cannot move forward.  However, I can "Browse" the data in those tables.  If I use a direct query on the same table (Query rather than Copy Tables) (SELECT * FROM "abc"."table1") I'm able to import that table.  I'd prefer not to have to do this for 1400 individual tables.
  2. Linked Server - I was unable to set up a Linked Server using the DSN and I'm not sure what the parameters are for an appropriate connection string to c-tree.
  3. Using OPENQUERY or OPENROWSET - Again, I'm at a loss as to the proper values for the connection parameters.

  Does anyone have experience with importing from c-tree / Faircom using ODBC and could provide some guidance?

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  February 26, 2022 at 8:10 pm

  #3989639

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.