mdbtools-dev

[mdb-dev] random patches 3/4

[Jeff S. <why...@ya...>]

src/sql/mdbsql.c:
  correct oversized arrays
  utilize MDB_PGSIZE in mdb_sql_listtables

__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway 
http://promotions.yahoo.com/design_giveaway/

[mdb-dev] random patches 2/4

[Jeff S. <why...@ya...>]

src/odbc/connectparams.c:
  a few trivial dialog fixes

__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway 
http://promotions.yahoo.com/design_giveaway/

[mdb-dev] random patches 1/4

[Jeff S. <why...@ya...>]

src/libmdb/write.c:
  fields[] order is not fixed-first. 

__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway 
http://promotions.yahoo.com/design_giveaway/

[mdb-dev] mdb-queries utility

[Leonard L. <lle...@ma...>]

Hello All,

I have the mdb-queries utility spitting out sql for queries in JET3
databases (there is a small glitch with JET4 which I am working on
still).

I'm looking for some JET3 (Access 97) test databases so I can further
test my utility.  Feel free to send them directly to me at
lle...@ma....

Thanks.

--
Leonard Leblanc

[mdb-dev] dont send me mails please

[giln <gi...@nl...>]

=20

Re: [mdb-dev] API Documentation

[<br...@br...>]

Unfortunately, this is still something on my todo list.  The
documentation will be added to the source code and extracted with
gtkdoc or doxy.  In the meantime, the sample programs are probably
your best bet, most of them are small enough to be considered "fair
use" if they are looked at and gleaned from.  Even if not, I'm not out
to sue people for using the libraries...

Word of warning though.  The API will not be fixed until we publish a
version 1.0 of MDB Tools, so while I'm not going to change things
willy nilly, the API is a little unstable for the forseeable future. 
A better idea if you need a stable API would be to rely on the ODBC
driver (which gives you the SQL engine anyway).

I hope to have an API reference in the coming months though.

Brian

On Fri, 02 Apr 2004 13:11:08 -0500, Michael Shanzer wrote:

> 
> So I know this sounds like a wussy question, but is there any 
> documentation for the various MDB API calls? I know I could look
> at the source for the included tools, however this work is for a 
> comercial product, and the tools are GPL, while the library is LGPL,
> so technically looking at the GPL tools for examples on how to use
the 
> API could be considered derived work.
> 
> I am of course willing and able to share and enhancements / bug fixes
> I 
> make to the MDB tools library, it is just that including GPL code
> in a comercial product gets my upper management nervous. Pointers
and 
> advice are greatly appreciated!
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

[mdb-dev] API Documentation

[Michael S. <sh...@fo...>]

So I know this sounds like a wussy question, but is there any 
documentation for the various MDB API calls? I know I could look
at the source for the included tools, however this work is for a 
comercial product, and the tools are GPL, while the library is LGPL,
so technically looking at the GPL tools for examples on how to use the 
API could be considered derived work.

I am of course willing and able to share and enhancements / bug fixes I 
make to the MDB tools library, it is just that including GPL code
in a comercial product gets my upper management nervous. Pointers and 
advice are greatly appreciated!

[mdb-dev] PHP extension around libmdb

[Hartmut H. <ha...@ph...>]

I'm glad to announce that PHP now supports this great library

   http://pecl.php.net/package-info.php?package=mdbtools

Documentation is available under

   http://cvs.php.net/co.php/pecl/mdbtools/manual/mdbtools.html?p=1

-- 
Hartmut Holzgraefe  <ha...@ph...>

RE: [mdb-dev] Article on mdb-tools

[Fergus A. <f_w...@ya...>]

I gota document not available 503.

Regards


Fergus Allan


-----Original Message-----
From: mdb...@li...
[mailto:mdb...@li...]On Behalf Of Marcel
(Free Thinker at Large) Gagne
Sent: 30 March 2004 17:40
To: mdb...@li...
Subject: [mdb-dev] Article on mdb-tools



Hello everyone,

You might be interested to know that an article covering mdbtools has just
been published in Oracle magazine . . . and yes, I wrote it. For the full
article, check out the following link.

     http://otn.oracle.com/pub/articles/gagne_access.html

I hope you enjoy it and I hope it brings more people this way. Feel free to
comment.

Take care out there.

--
Marcel (Writer and Free Thinker at Large) Gagné
Note:  This massagee wos nat speel or gramer-checkered.
Mandatory home page reference - http://www.marcelgagne.com/
Author : "Moving to Linux: Kiss the Blue Screen of Death Goodbye!"
   Also by Marcel : Linux System Administration, A User's Guide
Join the WFTL-LUG : http://www.salmar.com/marcel/wftllugform.html


-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id70&alloc_id638&op=ick
_______________________________________________
mdbtools-dev mailing list
mdb...@li...
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

[mdb-dev] Article on mdb-tools

[Marcel (F. T. at L. G. <mg...@sa...>]

Hello everyone,

You might be interested to know that an article covering mdbtools has just=
=20
been published in Oracle magazine . . . and yes, I wrote it. For the full=20
article, check out the following link.

     http://otn.oracle.com/pub/articles/gagne_access.html

I hope you enjoy it and I hope it brings more people this way. Feel free to=
=20
comment.

Take care out there.

=2D-=20
Marcel (Writer and Free Thinker at Large) Gagn=E9
Note:  This massagee wos nat speel or gramer-checkered.
Mandatory home page reference - http://www.marcelgagne.com/
Author : "Moving to Linux: Kiss the Blue Screen of Death Goodbye!"
   Also by Marcel : Linux System Administration, A User's Guide
Join the WFTL-LUG : http://www.salmar.com/marcel/wftllugform.html

Re: [mdb-dev] Re: ODBC PHP DB2 Help!

[Jeff S. <why...@ya...>]

It appears that when compiling PHP, this time it compiled against iODBC rather
than DB2Connect or unixODBC.

This page should help out in compiling PHP to use unixODBC.  It is a little
out of date, but steps 2, 3, and 4 should be essentially correct.

  http://www.unixodbc.org/doc/php3.html


If unixODBC is installed in the default place, you can put odbc.ini and
odbcinst.ini in /etc or perhaps /usr/local/etc.

odbcinst.ini contains *driver* configurations (e.g. mdbtools, MySQL, DB2)
odbc.ini contains configuration for System DSN's.
$HOME/.odbc.ini contains configuration for User DSN's.

If I used any terminology you are still unsure about, I would be glad to
go into more detail.

 -- Jeff Smith


--- Shannon Sumner <SS...@co...> wrote:
> Hello all,
> 
> I still could use your help.  I tried compiling PHP with UnixODBC instead of
> DB2 and then use UnixODBC to talk to DB2, but I received an "iODBC" error
> instead of my "[IBM][CLI Driver]" error.  I realize that I do not understand
> ODBC at all.  I'm not sure where to put my "odbc.ini" file (or should it be
> ".odbc.ini") and I'm not sure what's the difference between this file and
> the "odbcinst.ini" file.  Can someone direct me to a tutorial regarding this
> or perhaps explain it to me.  I'm sure this is a large part of my problem.
> Also, is there a way to test my connection to databases without having to
> recompile PHP?  I hate to take down my sites even for a half an hour if I
> don't have too.
> 
> Thanks,
> 
> Shannon D. Sumner 
> Webmaster
> Country Curtains Inc. 
> 413-243-1474
> www.countrycurtains.com

__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html

Re: [mdb-dev] Re: ODBC PHP DB2 Help!

[Luca C. <lu...@pc...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello,

on 03/29/04 16:50, Shannon Sumner wrote:
> [...]  Can someone
> direct me to a tutorial regarding this or perhaps explain it to me.  I'm
> sure this is a large part of my problem.  Also, is there a way to test
> my connection to databases without having to recompile PHP?  I hate to
> take down my sites even for a half an hour if I don't have too.
well, all the docs about unixODBC are on the unixODBC site, there're a lot of
docs, also about PHP and DB2 ;-)
	http://www.unixodbc.org/doc/

You can test if it works using OpenOffice.org and about this last, MySQL and
unixODBC a good HOWTO is at
	http://www.unixodbc.org/doc/OOoMySQL9.pdf
There're also indications where you should put your 'odbcinst.ini' and
'odbc.ini', I've them on /etc/ (where they stay for general settings), but you
can have '$HOME/.odbc.ini' for per-user settings.

Thx, bye,
Gismo / Luca
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Debian - http://enigmail.mozdev.org

iD8DBQFAaDrtVAp7Xm10JmkRAlZJAJwIxQ0kX1ZhpTsr986FVXNkPjHbtwCfWpxs
iZeq7E07GUw+wyVuog3doXY=
=VCe7
-----END PGP SIGNATURE-----

[mdb-dev] Re: ODBC PHP DB2 Help!

[Shannon S. <SS...@co...>]

Hello all,

I still could use your help.  I tried compiling PHP with UnixODBC =
instead of
DB2 and then use UnixODBC to talk to DB2, but I received an "iODBC" =
error
instead of my "[IBM][CLI Driver]" error.  I realize that I do not =
understand
ODBC at all.  I'm not sure where to put my "odbc.ini" file (or should =
it be
".odbc.ini") and I'm not sure what's the difference between this file =
and
the "odbcinst.ini" file.  Can someone direct me to a tutorial regarding =
this
or perhaps explain it to me.  I'm sure this is a large part of my =
problem.
Also, is there a way to test my connection to databases without having =
to
recompile PHP?  I hate to take down my sites even for a half an hour if =
I
don't have too.

Thanks,

Shannon D. Sumner=20
Webmaster
Country Curtains Inc.=20
413-243-1474
www.countrycurtains.com

=A0


************************************************=20
This message has been scanned for computer=20
viruses and none were found.=20

Country Curtains Information Systems Department=20
************************************************=20

Re: [mdb-dev] ODBC PHP DB2 Help!

[<br...@br...>]

Actually, iODBC is broken.  We have a global (g_mdb_sql) used for the
lex/yacc stuff and for whatever reason iODBC didn't like a global in a
shared library and just didn't work right.  I'd like to have a
resolution on this at some point but there are more important fish to
fry.

Re: ODBC.  IFAIK, DB2 CLI is API compatible with ODBC but only
optionally uses a driver manager (direct linking).  So, the trick here
would likely be to compile PHP with --with-unixODBC and *not* with
--with-ibm-db2 (from memory, may have the option a little wrong), and
then configure unixODBC with the so library for DB2 (I can probably
look up the proper file tomorrow at work, but you may be better off
checking the unixodbc mailing list archive).

Sorry, but this is the extent of my knowledge on the subject.

Brian

On Thu, 25 Mar 2004 09:09:47 -0800 (PST), Jeff Smith wrote:

> 
> OK, I am finally up to speed.  After rereading your original message,
> I see that while mdbtools and unixodbc are fine, the issue is that
> PHP is using the DB2 Connect libraries rather than the unixodbc ones.
> 
> To my knowledge, mdbtools has only been tested against iodbc and
> unixodbc.  Unfortunately, I have no idea how DB2 Connect stores
> DSN information.  Is there a free version (preferably for i386 Linux)
> of it available that could be used for testing this out?
> 
>  -- Jeff Smith
> 
> 
> --- Shannon Sumner <SS...@co...> wrote:
> >  
> > Hello, 
> > I'm using Bryan Mills post located at
> > http://bryanmills.net:8086/archives/000099.html
> > <http://bryanmills.net:8086/archives/000099.html>  to connect PHP
on
> my
> > Linux Server to an Access database located on my network. I'm
having
> no
> > problems installing UnixODBC and MDBTools. I can get MDBTools to
> connect to
> > the database so I know it's not a network issue. I've completed
> Bryan Mills
> > installation steps word for word and yet have not been able to get
> PHP to
> > access the data. 
> > Here's the error I get: 
> > odbc_connect(): SQL error: [IBM][CLI Driver] SQL1013N The database
> alias
> > name or database name "GAL" could not be found. SQLSTATE=42705, SQL
> state
> > 08001 in SQLConnect in /home/mis/access.php on line 2
> > I'm convinced since I have IBM DB2 Connect personal addition
> installed on my
> > server and use the PHP function odbc_connect to access data on my
> AS400 that
> > I cannot use this function to access databases of another type. I'm
> also
> > convinced that the DB2 Connect installation has altered my system
so
> that
> > ODBC.ini no longer contains the information about ODBC drivers. 
> > Do you know how to fix this problem? Does anyone know what file IBM
> DB2
> > connect uses to access it's database drivers? If I had this
> information -
> > perhaps I could alter this file as I would the ODBC.ini and receive
> the
> > correct data. As you can see I'm totally lost. Any help would be
> > appreciated. 
> > Thanks, 
> > Shannon Sumner 
> > My odbcinst.ini file looks as this:
> >  
> > [PostgreSQL]
> > Description             = ODBC for PostgreSQL
> > Driver          = /usr/lib/libodbcpsql.so
> > Setup           = /usr/lib/libodbcpsqlS.so
> > FileUsage               = 1
> > [MDBToolsODBC]
> > Description = MDB Tools ODBC drivers
> > Driver = /usr/lib/libmdbodbc.so.0
> > Setup =
> > FileUsage = 1
> > CPTimeout =
> > CPReuse =
> >  
> > My odbc.ini file looks as this:
> >  
> > [PostgreSQL]
> > Description             = ODBC for PostgreSQL
> > Driver          = /usr/lib/libodbcpsql.so
> > Setup           = /usr/lib/libodbcpsqlS.so
> > FileUsage               = 1
> >  
> > [GAL]
> > Description = Global Address Database
> > Driver = MDBToolsODBC
> > Database = /root/GAL.mdb
> > Servername = localhost
> > UserName =
> > Password =
> > port = 5432
> >  
> > My ODBC entries in PHP Info look like this:
> >  
> > ODBC Support enabled 
> > Active Persistent Links  0  
> > Active Links  0  
> > ODBC library  db2  
> > ODBC_INCLUDE  -I/home/db2inst1/sqllib/include  
> > ODBC_LFLAGS  -L/home/db2inst1/sqllib/lib  
> > ODBC_LIBS  -ldb2  
> > Directive Local Value Master Value 
> > odbc.allow_persistent On On 
> > odbc.check_persistent On On 
> > odbc.default_db no value no value 
> > odbc.default_pw no value no value 
> > odbc.default_user no value no value 
> > odbc.defaultbinmode return as is return as is 
> > odbc.defaultlrl return up to 4096 bytes return up to 4096 bytes 
> > odbc.max_links Unlimited Unlimited 
> > odbc.max_persistent Unlimited Unlimited
> >  
> > 
> > 
> > ************************************************ 
> > This message has been scanned for computer 
> > viruses and none were found. 
> > 
> > Country Curtains Information Systems Department 
> > ************************************************ 
> > 
> > 
> >   
> > 
> 
> 
> __________________________________
> Do you Yahoo!?
> Yahoo! Finance Tax Center - File online. File on time.
> http://taxes.yahoo.com/filing.html
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

[mdb-dev] mdb-export

[Hedgren, W. (hedgreww) <HED...@UC...>]

Hello list,

First, let me say that this is a great project.  It is the answer for those
of us who have to deal with access tables but don't want to do asp.

I would also like to help out but would need some suggestions as to how...

That being said, here's a problem that I've been having:  When I use
mdb-export on a 84,000 record table, I get the following error "./mdbsql:
line 22: 17536 Segmentation fault" (mdbsql is the shell script name).  It
seems that the failure happens at the 22nd record in the table at the 4th
column (if that means anything).

Any help would be appreciated..

Here are the stats:
Redhat ES 3
mdbtools ver 0.5
mdb file = Access 2000

Thanks,

Wade W. Hedgren
IT Systems Administrator
University of Cincinnati
Dept. of Cell Biology, Neurobiology & Anatomy
(513) 558-4365 (513) 558-1164 Fax
Personal home page: http://cna.uc.edu/Wade/
Department Site: http://cna.uc.edu/

Re: [mdb-dev] ODBC PHP DB2 Help!

[Jeff S. <why...@ya...>]

OK, I am finally up to speed.  After rereading your original message,
I see that while mdbtools and unixodbc are fine, the issue is that
PHP is using the DB2 Connect libraries rather than the unixodbc ones.

To my knowledge, mdbtools has only been tested against iodbc and
unixodbc.  Unfortunately, I have no idea how DB2 Connect stores
DSN information.  Is there a free version (preferably for i386 Linux)
of it available that could be used for testing this out?

 -- Jeff Smith


--- Shannon Sumner <SS...@co...> wrote:
>  
> Hello, 
> I'm using Bryan Mills post located at
> http://bryanmills.net:8086/archives/000099.html
> <http://bryanmills.net:8086/archives/000099.html>  to connect PHP on my
> Linux Server to an Access database located on my network. I'm having no
> problems installing UnixODBC and MDBTools. I can get MDBTools to connect to
> the database so I know it's not a network issue. I've completed Bryan Mills
> installation steps word for word and yet have not been able to get PHP to
> access the data. 
> Here's the error I get: 
> odbc_connect(): SQL error: [IBM][CLI Driver] SQL1013N The database alias
> name or database name "GAL" could not be found. SQLSTATE=42705, SQL state
> 08001 in SQLConnect in /home/mis/access.php on line 2
> I'm convinced since I have IBM DB2 Connect personal addition installed on my
> server and use the PHP function odbc_connect to access data on my AS400 that
> I cannot use this function to access databases of another type. I'm also
> convinced that the DB2 Connect installation has altered my system so that
> ODBC.ini no longer contains the information about ODBC drivers. 
> Do you know how to fix this problem? Does anyone know what file IBM DB2
> connect uses to access it's database drivers? If I had this information -
> perhaps I could alter this file as I would the ODBC.ini and receive the
> correct data. As you can see I'm totally lost. Any help would be
> appreciated. 
> Thanks, 
> Shannon Sumner 
> My odbcinst.ini file looks as this:
>  
> [PostgreSQL]
> Description             = ODBC for PostgreSQL
> Driver          = /usr/lib/libodbcpsql.so
> Setup           = /usr/lib/libodbcpsqlS.so
> FileUsage               = 1
> [MDBToolsODBC]
> Description = MDB Tools ODBC drivers
> Driver = /usr/lib/libmdbodbc.so.0
> Setup =
> FileUsage = 1
> CPTimeout =
> CPReuse =
>  
> My odbc.ini file looks as this:
>  
> [PostgreSQL]
> Description             = ODBC for PostgreSQL
> Driver          = /usr/lib/libodbcpsql.so
> Setup           = /usr/lib/libodbcpsqlS.so
> FileUsage               = 1
>  
> [GAL]
> Description = Global Address Database
> Driver = MDBToolsODBC
> Database = /root/GAL.mdb
> Servername = localhost
> UserName =
> Password =
> port = 5432
>  
> My ODBC entries in PHP Info look like this:
>  
> ODBC Support enabled 
> Active Persistent Links  0  
> Active Links  0  
> ODBC library  db2  
> ODBC_INCLUDE  -I/home/db2inst1/sqllib/include  
> ODBC_LFLAGS  -L/home/db2inst1/sqllib/lib  
> ODBC_LIBS  -ldb2  
> Directive Local Value Master Value 
> odbc.allow_persistent On On 
> odbc.check_persistent On On 
> odbc.default_db no value no value 
> odbc.default_pw no value no value 
> odbc.default_user no value no value 
> odbc.defaultbinmode return as is return as is 
> odbc.defaultlrl return up to 4096 bytes return up to 4096 bytes 
> odbc.max_links Unlimited Unlimited 
> odbc.max_persistent Unlimited Unlimited
>  
> 
> 
> ************************************************ 
> This message has been scanned for computer 
> viruses and none were found. 
> 
> Country Curtains Information Systems Department 
> ************************************************ 
> 
> 
>   
> 


__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html

Re: [mdb-dev] ODBC PHP DB2 Help!

[Jeff S. <why...@ya...>]

OK, you say "I can get MDBTools to connect to the database".  Which tool did
you use to test this?

If you are confident that mdbtools is connecting, the next link in the chain
is to check unixodbc.  The easiest way I know to do that be run "isql GAL".
If it comes up without warnings, that means that part is working, and you
may immediately quit the program.

 -- Jeff Smith


--- Shannon Sumner <SS...@co...> wrote:
>  
> Hello, 
> I'm using Bryan Mills post located at
> http://bryanmills.net:8086/archives/000099.html
> <http://bryanmills.net:8086/archives/000099.html>  to connect PHP on my
> Linux Server to an Access database located on my network. I'm having no
> problems installing UnixODBC and MDBTools. I can get MDBTools to connect to
> the database so I know it's not a network issue. I've completed Bryan Mills
> installation steps word for word and yet have not been able to get PHP to
> access the data. 
> Here's the error I get: 
> odbc_connect(): SQL error: [IBM][CLI Driver] SQL1013N The database alias
> name or database name "GAL" could not be found. SQLSTATE=42705, SQL state
> 08001 in SQLConnect in /home/mis/access.php on line 2
> I'm convinced since I have IBM DB2 Connect personal addition installed on my
> server and use the PHP function odbc_connect to access data on my AS400 that
> I cannot use this function to access databases of another type. I'm also
> convinced that the DB2 Connect installation has altered my system so that
> ODBC.ini no longer contains the information about ODBC drivers. 
> Do you know how to fix this problem? Does anyone know what file IBM DB2
> connect uses to access it's database drivers? If I had this information -
> perhaps I could alter this file as I would the ODBC.ini and receive the
> correct data. As you can see I'm totally lost. Any help would be
> appreciated. 
> Thanks, 
> Shannon Sumner 
> My odbcinst.ini file looks as this:
>  
> [PostgreSQL]
> Description             = ODBC for PostgreSQL
> Driver          = /usr/lib/libodbcpsql.so
> Setup           = /usr/lib/libodbcpsqlS.so
> FileUsage               = 1
> [MDBToolsODBC]
> Description = MDB Tools ODBC drivers
> Driver = /usr/lib/libmdbodbc.so.0
> Setup =
> FileUsage = 1
> CPTimeout =
> CPReuse =
>  
> My odbc.ini file looks as this:
>  
> [PostgreSQL]
> Description             = ODBC for PostgreSQL
> Driver          = /usr/lib/libodbcpsql.so
> Setup           = /usr/lib/libodbcpsqlS.so
> FileUsage               = 1
>  
> [GAL]
> Description = Global Address Database
> Driver = MDBToolsODBC
> Database = /root/GAL.mdb
> Servername = localhost
> UserName =
> Password =
> port = 5432
>  
> My ODBC entries in PHP Info look like this:
>  
> ODBC Support enabled 
> Active Persistent Links  0  
> Active Links  0  
> ODBC library  db2  
> ODBC_INCLUDE  -I/home/db2inst1/sqllib/include  
> ODBC_LFLAGS  -L/home/db2inst1/sqllib/lib  
> ODBC_LIBS  -ldb2  
> Directive Local Value Master Value 
> odbc.allow_persistent On On 
> odbc.check_persistent On On 
> odbc.default_db no value no value 
> odbc.default_pw no value no value 
> odbc.default_user no value no value 
> odbc.defaultbinmode return as is return as is 
> odbc.defaultlrl return up to 4096 bytes return up to 4096 bytes 
> odbc.max_links Unlimited Unlimited 
> odbc.max_persistent Unlimited Unlimited
>  
> 
> 
> ************************************************ 
> This message has been scanned for computer 
> viruses and none were found. 
> 
> Country Curtains Information Systems Department 
> ************************************************ 
> 
> 
>   
> 


__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html

Re: [mdb-dev] Fix in preparation for SQLTables implementation

[<br...@br...>]

Commited.

On Mon, 22 Mar 2004 09:25:37 -0800 (PST), Jeff Smith wrote:

> 
> In _SQLFreeStmt, please add these definitions:
> 
>   struct _hdbc *dbc = (struct _hdbc *) stmt->hdbc;
>   struct _henv *env = (struct _henv *) dbc->henv;
>   MdbSQL *sql = env->sql;
> 
> and inside the fOption == SQL_DROP block, add this call
> 
>   mdb_sql_reset(sql);
> 
> This is needed for my SQLTables implementation which I
> should be submitting some time this week.
> 
>  -- Jeff Smith
> 
> __________________________________
> Do you Yahoo!?
> Yahoo! Finance Tax Center - File online. File on time.
> http://taxes.yahoo.com/filing.html
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

Re: [mdb-dev] mdb-queries utility

[Leonard L. <lle...@ma...>]

I did some quick analysis on the MSysQueries table and from what I could
see it did include all of the necessary information (at least on the
basic queries that I was trying).

I wasn't sure if this was how the queries were handled by jet(3|4) or if
they were given there own page in the database (query pages could simply
be the data page(s) of the MSysQueries table). 

I may move forward in trying to use the MSysQueries table since I hit a
road block with trying to pull any relevant information from the page
returned in entry->table_pg for any given query.

Any thoughts on this from the list?

I like your idea of porting some of this functionality over to the
mdb-sql utility to allow the execution of queries directly.  I will keep
this in mind as I am working on figuring out exactly how queries work.

On Tue, 2004-03-23 at 20:28, br...@br... wrote:
> Excellent!  I started looking at this probably a year ago and shelved
> it to work on other things.  Glad to see somebody picking up the
> mantle.
> 
> As I recall the MSysQueries table had everything needed except
> something (operators?) were stored as enumerated values.  Hard to
> remember, it's been a while.
> 
> A cool feature along these lines would be to allow queries to be
> executed as stored procedures in the SQL engine.  So, issuing "exec
> myquery" would build a query tree (with or without the intervening
> SQL, although certainly with SQL is easier on the first pass) and
> execute it.  Of course, the mdb-query program is invaluable for
> porting to other databases (be carefudQL-dialect specific
> language comes up) and as a general tool.

Re: [mdb-dev] mdb-queries utility

[<br...@br...>]

Excellent!  I started looking at this probably a year ago and shelved
it to work on other things.  Glad to see somebody picking up the
mantle.

As I recall the MSysQueries table had everything needed except
something (operators?) were stored as enumerated values.  Hard to
remember, it's been a while.

A cool feature along these lines would be to allow queries to be
executed as stored procedures in the SQL engine.  So, issuing "exec
myquery" would build a query tree (with or without the intervening
SQL, although certainly with SQL is easier on the first pass) and
execute it.  Of course, the mdb-query program is invaluable for
porting to other databases (be careful where SQL-dialect specific
language comes up) and as a general tool.


On Tue, 23 Mar 2004 01:45:44 -0600, Leonard Leblanc wrote:

> 
> Hello List,
> 
> I've started work on an mdb-queries utility.
> 
> The idea behind the utility is to allow the extraction of queries in
> SQL
> format.  The results could then be piped to mdb-sql for execution.
> 
> I currently have it listing the names of the queries that are in the
> database when no query name is passed.  When a query name is passed
the
> utility dumps the querys 'page' in hex format (along with some other
> information from 'entry').  
> 
> At least, that's what I think I'm doing.  Some review and next steps
> from another (experienced) developer would be appreciated.
> 
> --
> Lenny

Re: [mdb-dev] mdb-queries utility

[Leonard L. <lle...@ma...>]

I have come across that singer while googling my name.  No relation to
me though. :)

--
Lenny

On Tue, 2004-03-23 at 08:35, Jeff Smith wrote:
> P.S. Strange... I was looking through my CD collection the other day, and
> I have a CD from a singer named Lenny LeBlanc.

Re: [mdb-dev] mdb-queries utility

[Jeff S. <why...@ya...>]

I have not had a chance to test it, but this looks to be a pretty useful
tool.  Hopefully, I can test this soon and give you some feedback.

 -- Jeff S

P.S. Strange... I was looking through my CD collection the other day, and
I have a CD from a singer named Lenny LeBlanc.

--- Leonard Leblanc <lle...@ma...> wrote:
> Hello List,
> 
> I've started work on an mdb-queries utility.
> 
> The idea behind the utility is to allow the extraction of queries in SQL
> format.  The results could then be piped to mdb-sql for execution.
> 
> I currently have it listing the names of the queries that are in the
> database when no query name is passed.  When a query name is passed the
> utility dumps the querys 'page' in hex format (along with some other
> information from 'entry').  
> 
> At least, that's what I think I'm doing.  Some review and next steps
> from another (experienced) developer would be appreciated.
> 
> --
> Lenny

__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html

[mdb-dev] mdb-queries utility

[Leonard L. <lle...@ma...>]

Hello List,

I've started work on an mdb-queries utility.

The idea behind the utility is to allow the extraction of queries in SQL
format.  The results could then be piped to mdb-sql for execution.

I currently have it listing the names of the queries that are in the
database when no query name is passed.  When a query name is passed the
utility dumps the querys 'page' in hex format (along with some other
information from 'entry').  

At least, that's what I think I'm doing.  Some review and next steps
from another (experienced) developer would be appreciated.

--
Lenny

[mdb-dev] Fix in preparation for SQLTables implementation

[Jeff S. <why...@ya...>]

In _SQLFreeStmt, please add these definitions:

  struct _hdbc *dbc = (struct _hdbc *) stmt->hdbc;
  struct _henv *env = (struct _henv *) dbc->henv;
  MdbSQL *sql = env->sql;

and inside the fOption == SQL_DROP block, add this call

  mdb_sql_reset(sql);

This is needed for my SQLTables implementation which I
should be submitting some time this week.

 -- Jeff Smith

__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html

Fwd: Re: [mdb-dev] Hello

[Jeff S. <why...@ya...>]

 Leonard,
 
 I know that what works for one person doesn't always work for another, but
 I will tell you how I started out in open-source development just in case
 it helps.
 
 The first open-source project I did development on was TinyCOBOL.  I knew
 C pretty well but knew squat about COBOL, so I set out to learn it.  I got
 a couple of books on discount and started trying things out.  Whenever I
 would run into something that did not work, I would dig into the code.  If
 it was something simple, I would write up a patch and send it to the list.
 
 When I started looking at mdbtools, I only knew a little SQL and absolutely
 no ODBC.  If you do not know either SQL or ODBC, I would say find some good
 references online or in print.  Then start trying out the examples using
 mdbtools (for SQL testing) and unixODBC (for SQL and ODBC testing).  If you
 run into something you don't understand, I am sure someone will be able to
 help you out.
 
  -- Jeff Smith
 
 
> --- Leonard Leblanc <lle...@ma...> wrote:
> > Hi Jeff,
> > 
> > It would be nice if I could start with a bug fix to get acquainted with
> > the project. 
> > 
> > I should also say that this is the first time that I have decided to
> > help with an open-source project so I am new to how open-source
> > development works.  Also, I am fairly new to development in C, however I
> > am not new to programming in general (10+ years experience).
> > 
> > I look forward to contributing and thank everyone for their patience
> > while I learn the ins and outs of working on an open source project.
> > 
> > Lenny
> > 
> > On Fri, 2004-03-19 at 10:13, Jeff Smith wrote: 
> > > Welcome, there is *plenty* of work left to go around.  :-)
> > > 
> > > I have only been here a little while, but from what I have seen, Brian
> > > does the bulk of real development.  I have submitted several small bug
> > > and warnings fixes and have an almost-working implementation of
> > > SQLTables for the ODBC driver ready (there is a bug in deleting
> > > temporary tables that I have not yet tracked down that is causing
> > > problems in testing it).  After that on my TODO list is SQLColumns.
> > > Implementing SQLTables and SQLColumns should help some of the unixODBC
> > > tools work with mdbtools better.
> > > 
> > >   -- Jeff Smith


__________________________________
Do you Yahoo!?
Yahoo! Mail - More reliable, more storage, less spam
http://mail.yahoo.com