Accessing microsoft access from C program Post: 302094326

7 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

microsoft access database on Unix

Hello, I am a newborn baby to Unix and I was told that it was possible to have Microsoft Access databases on a Unix web server. I am using Perl to interface and query the Access database, which puts the information into the appropriate fields of a web page. Then updated information is submitted...

2. Filesystems, Disks and Memory

Receiving status code 39 when accessing files through program.

I'm working on a project to extract some information from archive file. I ran my program through MFCobol animator and I'm receiving a status code of 39(file not compatible) when opening the file for input. I have tried just about everything, rebuild, convert, etc. but I receive the same message....

3. UNIX for Advanced & Expert Users

accessing ms access from unix server...

Hello, I have a databse stored in my Unix server. I can't change the database because is used by a third party software. How Can I make some queries to this database (I want to extend the information for all the users using Apache + php on the unix server.) I looked at unixODBC but I...

4. Shell Programming and Scripting

problem accessing Multiple Variables from C Program to a Shell script

program name--test #!/bin/bash output1=`/home/user/a.c` output2=`/home/user/a.c` k=`$output1 + 1` m=`$output2 + 1` echo $k echo $m --------------------------------------------------------------------------- prgram name--a.c #include<stdio.h> int main()

5. Shell Programming and Scripting

bin program access

Hello, I was wondering if I have something in my bin dir and I want to access it from another directory to make a change how can I go about it. Thank you.

6. Shell Programming and Scripting

Accessing variable from awk program in shell

Hi, I want to access a variable outside the awk program. My program is as below:- I can not access the exact value of k (See the last line of the program). #!/usr/bin/sh j=10 k=1 #k is declared outside awk awk ' BEGIN { i=1; j1="'"$j"'" printf("\n ## Value of j1 is %d ##", j1); ...

7. Programming

Access a value in 2D array in C program

Hi All, I am new to c programming. I am getting compilation error in the below program. Can somebody help me? #include<stdio.h> #include<string.h> void main() { int i=j=0; char a={'f1',4,'f2','4'}; char count; for(i=0;i<2;i++) { for(j=1;j<=2;j++) { ...

LEARN ABOUT DEBIAN

iodbctest

iodbctest(1)						       iODBC Driver Manager						      iodbctest(1)

NAME

       iodbctest, iodbctestw - iODBC Demonstration programs

SYNOPSIS

       iodbctest ["DSN=xxxx[;UID=xxxx][;PWD=xxxx][;OPT=value]"]
       iodbctestw ["DSN=xxxx[;UID=xxxx][;PWD=xxxx][;OPT=value]"]

DESCRIPTION

       The  iodbctest  program and iodbtestw programs are simple ODBC sample programs, showing the strength of the ODBC API to connect to any ODBC
       enabled database, issue SQL commands and retrieve the query results.

       The iodbctest program uses the standard ODBC API calls to connect using any DSN, but retrieves all results in ASCII mode.

       The iodbctestw program uses the ODBC Unicode API calls to connect using any DSN, and retrieves all results in Unicode mode.

OPTIONS

       The iodbctest program uses the SQLDriverConnect function to make a connection using any available ODBC compliant driver.  This  allows  the
       user to override any ODBC connect attribute in the DSN string.

       Connect	strings  should  start with either a DSN=xxx or a DRIVER=xxxx attribute optionally followed by other DSN attributes separated by a
       semicolon e.g:

	    DSN=ora9;UID=scott;PWD=tiger;DATABASE=ora9u

       Any attributes required for a proper connection that are not entered in the DSN connect string, must be present in the odbc.ini file.

       If the connect string is passed as an argument to the iodbctest program, the string should be quoted as most shells use	the  semicolon	as
       their command separator. If the connect string is entered on the interactive prompt, no quotes should be used.

       After a successful connection has been established, the user is prompted for a SQL command to be send to the database. A SQL command cannot
       span multiple lines.

       If the SQL command returns one or more result sets, each result set is fetched using character buffers and displayed in a table.

       Additionally, the iodbctest program understands a few special commands:

       qualifiers
	       Show a list of qualifiers using the SQLTables catalog call.

       owners
	       Show a list of owners using the SQLTables catalog call.

       tables
	       Show a list of tables using the SQLTables catalog call.

       types
	       Show a list of tables types using the SQLTables catalog call.

       datatypes
	       Show a list of data types using the SQLGetTypeInfo catalog call.

       reconnect
	       Perform a disconnect/reconnect with the information saved during the first SQLDriverConnect.

       quit (or exit)
	       Exit the program and return to the shell.

EXAMPLES

       Start the iodbctest program and get a list of DSNs before making a connection:

	   $ iodbctest
	   OpenLink ODBC Demonstration program
	   This program shows an interactive SQL processor

	   Enter ODBC connect string (? shows list): ?

	   DSN				    | Driver
	   -----------------------------------------------------------------
	   ora9 			    | OpenLink Generic ODBC Driver
	   mysql			    | OpenLink Generic ODBC Driver
	   mysqllite			    | OpenLink Lite for MySQL
	   myodbc			    | MyODBC Driver
	   pgsql			    | OpenLink Generic ODBC Driver
	   tds				    | OpenLink Generic ODBC Driver

	   Enter ODBC connect string (? shows list): DSN=ora9;PWD=tiger
	   Driver: 05.20.0316 OpenLink Generic ODBC Driver (oplodbc.so)

	   SQL>

       Connect to an Oracle 9 instance which has been previously setup in the odbc.ini file:

	   $ iodbctest "DSN=ora9;UID=scott;PWD=tiger"
	   iODBC Demonstration program
	   This program shows an interactive SQL processor
	   Driver: 05.20.0316 OpenLink Generic ODBC Driver (oplodbc.so)

	   SQL>select * from emp

	   ID		    |NAME
	   -----------------+-------------------------------------------
	   1		    |Record 1
	   2		    |Record 2
	   2		    |Record 3

	    result set 1 returned 3 rows.

	   SQL> quit

COPYRIGHT

       Copyright (C) 1996-2009 by OpenLink Software

AUTHOR

       iODBC Administrator <iodbc@openlinksw.com>

3.52.7								   3 August 2005						      iodbctest(1)