Add 1 to COBOL Forum

Hello, I’ve been trying to make kiska’s ESQL binary work with a MS Access database
I have used some sample that was on OpenCobol Forum but It can’t connect to the Database.
The Access database is working fine. I tested it with another program and I was able to do a Select * from the table inside the DB.
I think I’m doing something wrong because everything related to the connection is NULL.

Thank you

Here is what I get:

C:\OpenCobol\ESQL\release>esqlOC.exe TESTSQL.sqb
esqlOC.exe: ESQL for OpenCobol Version 2 Build Jun 24 2010

C:\OpenCobol\ESQL\release>cd ..

C:\OpenCobol\ESQL>cd ..

C:\OpenCobol>REM file TESTSQL.COB copied to this folder from release

C:\OpenCobol>cobc -x -debug –version TESTSQL.cob
cobc (OpenCOBOL) 1.1.20100520
Copyright (C) 2001,2002,2003,2004,2005,2006,2007 Keisuke Nishida
Copyright (C) 2006,2007,2008,2009,2010 Roger While
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
Built     Nov 24 2010 20:00:03
Packaged  May 19 2010 16:17:26 UTC

C:\OpenCobol>cobc -x -debug TESTSQL.cob
cob221.c

C:\OpenCobol>TESTSQL.exe
12431656 OCSQL: DB connect to DSN ‘(null)’ user = ‘(null)’
12431656 OCSQL: SQL code 0 : IM002 : [Microsoft][ODBC Driver Manager] Data sourc
e name not found and no default driver specified
12431656 OCSQL: DB connect using Native Driver to SERVER ‘(null)’ user = ‘(null)
‘
12431656 OCSQL: SQL code 0 : IM002 : [Microsoft][ODBC Driver Manager] Data sourc
e name not found and no default driver specified
SQLSTATE=IM002, SQLCODE=+000000000
SQL Error message:[Microsoft][ODBC Driver Manager] Data source name not found an
d no default driver specified
SQLSTATE=08003, SQLCODE=-000008003
SQL Error message:The connection does not exist.
SQLSTATE=08003, SQLCODE=-000008003
SQL Error message:The connection does not exist.
SQLSTATE=08003, SQLCODE=-000008003
SQL Error message:The connection does not exist.

C:\OpenCobol>



 This content is published under the Attribution-Share Alike 3.0 Unported license.