Post reply

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

  • 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?

  • 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.

  • February 28, 2022 at 7:01 am

    This was removed by the editor as SPAM

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply