Client applications

package main

import (
        "database/sql"
        _ "github.com/alexbrainman/odbc2"
        "log"
)

func main() {
        // Replace the DSN value with the name of your ODBC data source.
        db, err := sql.Open("odbc",
                "DSN=FreeAgent")
        if err != nil {
                log.Fatal(err)
        }

        var (
                name string
        )

        rows, err := db.Query("SELECT Contact FROM Bills")
        if err != nil {
                log.Fatal(err)
        }
        defer rows.Close()
        for rows.Next() {
                err := rows.Scan(&name)
                if err != nil {
                        log.Fatal(err)
                }
                log.Println(name)
        }
        err = rows.Err()
        if err != nil {
                log.Fatal(err)
        }

        defer db.Close()
}

const odbc = require('odbc');
// Replace FreeAgent with the name of your Easysoft ODBC-FreeAgent Driver
// data source.
const connection = odbc.connect('DSN=FreeAgent', (error, connection) => {
    connection.query('SELECT Contact FROM Bills', (error, result) => {
        if (error) { console.error(error) }
        console.log(result);
    });
});

const odbc = require('odbc');
const connection = odbc.connect('DSN=FreeAgent', (error, connection) => {
    connection.tables(null, null, null, null, (error, result) => {
        if (error) { return; }
        const util = require('util');
        console.log(util.inspect(result, {maxArrayLength: null, depth:null}))
    });
});

const odbc = require('odbc');
const connection = odbc.connect('DSN=FreeAgent', (error, connection) => {
    connection.columns(null, null, null, null, (error, result) => {
        if (error) { return; }
        const util = require('util');
        console.log(util.inspect(result, {maxArrayLength: null, depth:null}))
    });
});

const odbc = require("odbc");
const connection = odbc.connect("DSN=FreeAgent", (error, connection) => {
    connection.query("INSERT INTO
    Bills (
        Contact,
        Reference,
        Dated_On,
        Due_On,
        Bill_Items
    )
VALUES
    (
        'https://api.freeagent.com/v2/contacts/18727314',
        'YEB021',
        '2025-01-16',
        '2025-01-16',
        '[{"category":"https://api.freeagent.com/v2/categories/291","description":"YEB-line-2-standing-charge","sales_tax_rate":"20","total_value_ex_tax":6.99}]'
    )", (error, result) => {
        if (error) { console.error(error) }
        console.log(result);
    });
});

const odbc = require("odbc");
const connection = odbc.connect("DSN=FreeAgent", (error, connection) => {
    connection.query("UPDATE Bills SET Contact = 'Standing charges for second line.' WHERE Id = '31962267'", (error, result) => {
        if (error) { console.error(error) }
        console.log(result);
    });
});

const odbc = require("odbc");
const connection = odbc.connect("DSN=FreeAgent", (error, connection) => {
    connection.query("DELETE FROM Bills WHERE Id = '31962267'", (error, result) => {
        if (error) { console.error(error) }
        console.log(result);
    });
});

use strict;
use DBI;
# Replace FreeAgent with the name of your Easysoft ODBC-FreeAgent Driver data source.
my $dbh = DBI-> connect('dbi:ODBC:FreeAgent');

my $sql = "SELECT Contact FROM Bills";

my $sth = $dbh->prepare($sql)
    or die "Can't prepare statement: $DBI::errstr";

$sth->execute();

my($Col);

# Fetch and display the result set values.
while(($Col) = $sth->fetchrow()){
   print("$Col\n");
}

$dbh->disconnect if ($dbh);

use strict;
use DBI;
my $dbh = DBI-> connect('dbi:ODBC:FreeAgent');

my $sth = $dbh->table_info()
    or die "Can't prepare statement: $DBI::errstr";

my @row;

while (@row = $sth->fetchrow_array) {
    print join(", ", @row), "\n";
}

$dbh->disconnect if ($dbh);

use strict;
use DBI;
my $dbh = DBI-> connect('dbi:ODBC:FreeAgent');

my $sth = $dbh->column_info('','','','')
    or die "Can't prepare statement: $DBI::errstr";

my @row;
while (@row = $sth->fetchrow_array) {
    print join(", ", @row), "\n";
}

$dbh->disconnect if ($dbh);

use strict;
use DBI;
my $dbh = DBI-> connect('dbi:ODBC:FreeAgent');

my $sth = $dbh->prepare(q/INSERT INTO Bills (Contact, Reference, Dated_On, Due_On, Bill_Items) VALUES (?, ?, ?, ?, ?)/)
    or die "Can't prepare statement: $DBI::errstr";

$sth->execute('https://api.freeagent.com/v2/contacts/18727314', 'YEB021', '2025-01-16', '2025-01-16', '[{"category":"https://api.freeagent.com/v2/categories/291","description":"YEB-line-2-standing-charge","sales_tax_rate":"20","total_value_ex_tax":6.99}]');

$dbh->disconnect if ($dbh);

use strict;
use DBI;
my $dbh = DBI-> connect('dbi:ODBC:FreeAgent');

my $sth = $dbh->prepare('UPDATE Bills SET Contact = \'Standing charges for second line.\' WHERE Id = ?')
    or die "Can't prepare statement: $DBI::errstr";

$sth->execute('31962267');

$dbh->disconnect if ($dbh);

use strict;
use DBI;
my $dbh = DBI-> connect('dbi:ODBC:FreeAgent');

my $sth = $dbh->prepare('DELETE FROM Bills WHERE Id = ?')
    or die "Can't prepare statement: $DBI::errstr";

$sth->execute('31962267');

$dbh->disconnect if ($dbh);

<?php
  // Replace FreeAgent with the name of your Easysoft ODBC-FreeAgent Driver data source.
  $con = odbc_connect("FreeAgent", "", "");

  $stmt = odbc_exec($con, "SELECT * FROM Bills");

  while ($row = odbc_fetch_array($stmt)) {
      echo "Contact = ", $row["Contact"], "\n";
  }
  odbc_close($con);
?>

<?php
$con = odbc_connect("FreeAgent", '', '');
$tables = odbc_tables($con);
while (($row = odbc_fetch_array($tables))) {
    print_r($row);
}
  odbc_close($con);
?>

<?php
$con = odbc_connect('FreeAgent', '', '');
$columns = odbc_columns($con);
while (($row = odbc_fetch_array($columns))) {
    print_r($row);
}
  odbc_close($con);
?>

<?php
  $cnx = odbc_connect("FreeAgent", "", "");

  $stmt = odbc_prepare($cnx, "INSERT INTO Bills (Contact, Reference, Dated_On, Due_On, Bill_Items) VALUES (?, ?, ?, ?, ?)");

  $success = odbc_execute($stmt, array('https://api.freeagent.com/v2/contacts/18727314', 'YEB021', '2025-01-16', '2025-01-16', '[{"category":"https://api.freeagent.com/v2/categories/291","description":"YEB-line-2-standing-charge","sales_tax_rate":"20","total_value_ex_tax":6.99}]'));

  odbc_close($cnx);
?>

<?php
  $cnx = odbc_connect("FreeAgent", "", "");

  $stmt = odbc_prepare($cnx, "UPDATE Bills SET Contact = 'Standing charges for second line.' WHERE Id = ?");

  $success = odbc_execute($stmt, array('31962267'));

  odbc_close($cnx);
?>

<?php
  $cnx = odbc_connect("FreeAgent", "", "");

  $stmt = odbc_prepare($cnx, "DELETE FROM Bills WHERE Id = ?");

  $success = odbc_execute($stmt, array('31962267'));

  odbc_close($cnx);
?>

import pyodbc

# Replace FreeAgent with the name of your Easysoft ODBC-FreeAgent Driver data source.
cnxn = pyodbc.connect("DSN=FreeAgent")
cursor = cnxn.cursor()
sql = "SELECT Contact FROM Bills"
cursor.execute(sql)
rows = cursor.fetchall()
for row in rows:
     print(row.Contact)
exit()

import pyodbc

# Replace FreeAgent with the name of your Easysoft ODBC-FreeAgent Driver data source.
cnxn = pyodbc.connect("DSN=FreeAgent")
cursor = cnxn.cursor()
cursor.tables()
rows = cursor.fetchall()
for row in rows:
     print(row.table_name)
exit()

import pyodbc

# Replace FreeAgent with the name of your Easysoft ODBC-FreeAgent Driver data source.
cnxn = pyodbc.connect("DSN=FreeAgent")
cursor = cnxn.cursor()
cursor.columns()
rows = cursor.fetchall()
for row in rows:
     print(row.table_name, row.column_name)
exit()

import pyodbc

cnxn = pyodbc.connect("DSN=FreeAgent")
cursor = cnxn.cursor()
sql = "INSERT INTO Bills (Contact, Reference, Dated_On, Due_On, Bill_Items) VALUES (?, ?, ?, ?, ?)"
cursor.execute(sql, 'https://api.freeagent.com/v2/contacts/18727314', 'YEB021', '2025-01-16', '2025-01-16', '[{"category":"https://api.freeagent.com/v2/categories/291","description":"YEB-line-2-standing-charge","sales_tax_rate":"20","total_value_ex_tax":6.99}]')
cursor.commit()
exit()

import pyodbc

cnxn = pyodbc.connect("DSN=FreeAgent")
cursor = cnxn.cursor()
sql = "UPDATE Bills SET Contact = Standing charges for second line.' WHERE Id = ?"
cursor.execute(sql, '31962267')
cursor.commit()
exit()

import pyodbc

cnxn = pyodbc.connect("DSN=FreeAgent")
cursor = cnxn.cursor()
sql = "DELETE FROM Bills WHERE Id = ?"
cursor.execute(sql, '31962267')
cursor.commit()
exit()

library("RODBC")
# Replace FreeAgent with the name of your Easysoft ODBC-FreeAgent Driver data source.
ch <- odbcConnect("FreeAgent")
sqlQuery(ch, paste("SELECT Contact FROM Bills"))
odbcClose(ch)
quit()

library("RODBC")
# Replace FreeAgent with the name of your Easysoft ODBC-FreeAgent Driver data source.
ch <- odbcConnect("FreeAgent")
sqlTables(ch)
odbcClose(ch)
quit()

library("RODBC")
# Replace FreeAgent with the name of your Easysoft ODBC-FreeAgent Driver data source.
ch <- odbcConnect("FreeAgent")
sqlColumns(ch, sqtable="Bills")
odbcClose(ch)
quit()

library("RODBC")
ch <- odbcConnect("FreeAgent")
sqlQuery(ch, paste("INSERT INTO Bills (Contact, Reference, Dated_On, Due_On, Bill_Items) VALUES ('https://api.freeagent.com/v2/contacts/18727314', 'YEB021', '2025-01-16', '2025-01-16', '[{"category":"https://api.freeagent.com/v2/categories/291","description":"YEB-line-2-standing-charge","sales_tax_rate":"20","total_value_ex_tax":6.99}]')"))
odbcClose(ch)
quit()

library("RODBC")
ch <- odbcConnect("FreeAgent")
sqlQuery(ch, paste("UPDATE Bills SET Contact = 'Standing charges for second line.' WHERE Id = '31962267'"))
odbcClose(ch)
quit()

library("RODBC")
ch <- odbcConnect("FreeAgent")
sqlQuery(ch, paste("DELETE FROM Bills WHERE Id = '31962267'"))
odbcClose(ch)
quit()