Stack Overflow
Stack Overflow

Questions tagged [faircom-db-sql]

7 questions
2
votes
1 answer

FairCom c-tree ODBC Connection - PHP

I have a User DSN configured in Windows ODBC: Name Driver testdb FairCom c-tree ODBC Driver $user = ""; $pass = ""; $dsn = "testdb"; $cx = odbc_connect($dsn,$user,$pass); if($cx === false) { echo "
failure

"; echo…
Xin Chen
  • 283
  • 5
  • 14
1
vote
2 answers

Need Ctree Faircom connection string for Tosca Automation tool

We are trying to establish connection between Tosca and ctree faircom database but it fails to establish the connection. Getting the following error message: 'Could not establish a connection using "connection string: DRIVER=CTREE ODBC Driver; …
Arul S
  • 13
  • 4
1
vote
0 answers

Error when exporting the data from FairCom c-tree database (ODBC) into MS Excel

I'm trying to transfer the data from an old .dat file into MS Excel using the ODBC driver for FairCom c-tree database. The data is transfered to Excel, but before import I've received two warning messages and it seems like the part of the data is…
NikolaH
  • 11
  • 1
0
votes
1 answer

Selecting parent records when child mathes criteria

I am trying to limit returned results of users to results that are "recent" but where users have a parent, I also need to return the parent. CREATE TABLE `users` ( `id` int(0) NOT NULL, `parent_id` int(0) NULL, `name` varchar(255) NULL, …
Alan
  • 2,046
  • 2
  • 20
  • 43
0
votes
1 answer

While loop for selecting field names?

I have a nasty, nasty data layout that I am forced to work with. I finally got a working query using C# and a for loop executing the same query over and over but adjusting which fields are called, but now I am wondering if it is possible to do it…
Alan
  • 2,046
  • 2
  • 20
  • 43
0
votes
0 answers

Get DataTable Value from Adjacent Cell without ForEach loop?

I am working my way around this problem: Create multiple results from single row joining either 2 or 3 tables based off conditional of table1 results? and while I wish I could take Strawberry's advice, I can't, so I am trying now to do more in C#…
Alan
  • 2,046
  • 2
  • 20
  • 43
0
votes
1 answer

Create multiple results from single row joining either 2 or 3 tables based off conditional of table1 results?

First let me say that yes, this is a horrible way to have stored data, second, it isn't my fault :) I am trying to integrate with a 3rd party database to extract info which is stored in 3 tables, which really should have been in two AND stored where…
Alan
  • 2,046
  • 2
  • 20
  • 43