Thread: What happend to odbc.sql & odbc-drop.sql
I am attempting to use the directions at http://kandalaya.org//download/oo-pgsql.html to configure odbc with pgsql and OpenOffice.org on a Fedora Core 4 system. I found a message at: http://archives.postgresql.org/pgsql-odbc/2003-09/msg00087.php which points to the psqlodbc cvs, but that appears empty. And when I got psqlodbc-08.01.0100.tar.gz (that is the correct one to use with postgresql-8.0.6 right?) and looked in it, there was no mention of the odbc.sql & odbc-drop.sql scripts, or even what should replace them. So is there a reason why these went away? What should they be replaced with? Or should I just dig out an old copy of postgresql-7.X and grab them from there for posterity? -- Todd Denniston Crane Division, Naval Surface Warfare Center (NSWC Crane) Harnessing the Power of Technology for the Warfighter
> -----Original Message----- > From: pgsql-odbc-owner@postgresql.org > [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Todd Denniston > Sent: 13 February 2006 15:58 > To: pgsql-odbc@postgresql.org > Subject: [ODBC] What happend to odbc.sql & odbc-drop.sql > > I am attempting to use the directions at > http://kandalaya.org//download/oo-pgsql.html > to configure odbc with pgsql and OpenOffice.org on a Fedora > Core 4 system. > > I found a message at: > http://archives.postgresql.org/pgsql-odbc/2003-09/msg00087.php > which points to the psqlodbc cvs, but that appears empty. > > And when I got psqlodbc-08.01.0100.tar.gz (that is the > correct one to use with > postgresql-8.0.6 right?) and looked in it, there was no > mention of the > odbc.sql & odbc-drop.sql scripts, or even what should replace them. > > So is there a reason why these went away? > What should they be replaced with? > Or should I just dig out an old copy of postgresql-7.X and > grab them from > there for posterity? It was removed because it is no longer required: http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodbc/convert.c? rev=1.117&content-type=text/x-cvsweb-markup Regards, Dave.
> And when I got psqlodbc-08.01.0100.tar.gz (that is the correct one to use The psqlodbc-08.01.0200 is the most up to date stable release. This version (08.01.XXXX has some limitations which older drivers doesn't have (older = 08.00 and older). Regards, Luf
Dave Page wrote: > > > >>-----Original Message----- >>From: pgsql-odbc-owner@postgresql.org >>[mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Todd Denniston >>Sent: 13 February 2006 15:58 >>To: pgsql-odbc@postgresql.org >>Subject: [ODBC] What happend to odbc.sql & odbc-drop.sql >> >>I am attempting to use the directions at >>http://kandalaya.org//download/oo-pgsql.html >>to configure odbc with pgsql and OpenOffice.org on a Fedora >>Core 4 system. >> >>I found a message at: >>http://archives.postgresql.org/pgsql-odbc/2003-09/msg00087.php >>which points to the psqlodbc cvs, but that appears empty. >> <SNIP>... >>there was no >>mention of the >>odbc.sql & odbc-drop.sql scripts, or even what should replace them. >> >>So is there a reason why these went away? <SNIP> > > > It was removed because it is no longer required: > > http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodbc/convert.c?rev=1.117&content-type=text/x-cvsweb-markup > > Regards, Dave. > So with postgresql-8.0.6 and postgresql-odbc-08.00.0100 as installed by Fedora, I should be able to just skip section 5.1 of the kandalaya document then? It might be good to add that little tidbit to your faq.html {patch attached, but needs spell checked}. and on the subscription page, the link to the FAQ seems broken too. http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&func=lists-long-full&extra=pgsql-odbc Thanks for the update. -- Todd Denniston Crane Division, Naval Surface Warfare Center (NSWC Crane) Harnessing the Power of Technology for the Warfighter --- docs/faq.html.orig 2006-02-13 18:31:15.000000000 -0500 +++ docs/faq.html 2006-02-13 18:43:01.000000000 -0500 @@ -16,3 +16,3 @@ <p>The most recent version of this document can be viewed at <a href= - "http://gborg.postgresql.org/cgi-bin/cvsweb.cgi/~checkout~/psqlodbc/docs/faq.html?content-type=text%2Fhtml;cvsroot=psqlodbc">http://gborg.postgresql.org/cgi-bin/cvsweb.cgi/~checkout~/psqlodbc/docs/faq.html?content-type=text%2Fhtml;cvsroot=psqlodbc</a>.</p> + "http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/~checkout~/psqlodbc/psqlodbc/docs/faq.html?rev=1.3">http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/~checkout~/psqlodbc/psqlodbc/docs/faq.html?rev=1.3</a>.</p> @@ -40,2 +40,3 @@ <a href="#3.4">3.4</a>) Does psqlODBC support encrypted login for connections?<br> + <a href="#3.5">3.5</a>) What happend to odbc.sql & odbc-drop.sql?<br> @@ -223,2 +224,8 @@ + <h3><a name="#3.5">3.5</a>) What happend to odbc.sql & odbc-drop.sql?</h3> + <p> + Functionality in convert.c removed the need for them. You can safely skip over any steps + in old procedures that called for these scripts. + </p> + <h2>4) Advanced</h2>
> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Todd Denniston
> Sent: 13 February 2006 23:47
> Cc: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] What happend to odbc.sql & odbc-drop.sql
>
>
> So with postgresql-8.0.6 and postgresql-odbc-08.00.0100 as
> installed by
> Fedora, I should be able to just skip section 5.1 of the
> kandalaya document then?
I would guess so, but I have no knowledge of that document.
> It might be good to add that little tidbit to your faq.html
> {patch attached,
> but needs spell checked}.
Thanks, but as you're the first person I recall to ever ask that
question, I don't think it really counts as a faq :-) An update to the
kandalaya document would seem more appropriate.
> and on the subscription page, the link to the FAQ seems broken too.
> http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&
> func=lists-long-full&extra=pgsql-odbc
No, that's maintained by Majordomo, the mailer software. I'm not sure if
we can change that - I'll ask the admin.
Thanks, Dave.