headers
Joel Fradkin | 1 Aug 2005 15:27

Re: IIS Postgres ASP ADO - Problem

James,

The odbc is not working well for me (I can connect but get intermittent
issues of the IIS server locking up in regards to connectivity).
My understanding is the snapshot version is the best odbc out at this time.

Also can you connect via pgadmin (IE have the hba and config files set to
allow external connections)?

My conection is not using dsn, but I did get dsn to work in testing.
My dsnless string is 

Session("StringConn") =
"DRIVER={PostgreSQL};DATABASE=wazagua;SERVER=192.168.123.121;PORT=5432;UID=p
ostgres;PWD=;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersi
oning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=
0;MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=0;CommLog=0;Optimizer=1;K
sqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsC
har=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;Up
datableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinar
y=0;UseServerSidePrepare=0"

My test using dsn used
Session("StringConn") ="DSN=postgresql;" & _
         "UID=postgres;" & _
         "PWD=;" & _
         "Database=wazuni;"

asp code to use connection is :
  dim Arec, Acmd, SQL ,AConn
(Continue reading)

Permalink | Reply | 1 comment |
headers
Peter Eisentraut | 1 Aug 2005 17:48
Picon
Gravatar

undefined symbol: ucs2_to_utf8

Regarding this bug

http://gborg.postgresql.org/project/psqlodbc/bugs/bugupdate.php?1176

can we install the proposed fix in the pre-libpq branch and do a quick new 
release, because this is really hurting the non-Windows users.

--

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq
Permalink | Reply | 0 comments |
headers
Dave Page | 1 Aug 2005 17:59
Picon

Re: undefined symbol: ucs2_to_utf8


> -----Original Message-----
> From: pgsql-odbc-owner <at> postgresql.org 
> [mailto:pgsql-odbc-owner <at> postgresql.org] On Behalf Of Peter Eisentraut
> Sent: 01 August 2005 16:49
> To: pgsql-odbc <at> postgresql.org
> Subject: [ODBC] undefined symbol: ucs2_to_utf8
> 
> Regarding this bug
> 
> http://gborg.postgresql.org/project/psqlodbc/bugs/bugupdate.php?1176
> 
> can we install the proposed fix in the pre-libpq branch and 
> do a quick new 
> release, because this is really hurting the non-Windows users.

I'll look at this tomorrow.

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org
Permalink | Reply | 0 comments |
headers
Marko Ristola | 1 Aug 2005 18:27
Picon
Picon

Re: Lowercase folding - simple patch?


Does somebody know, wether the following code is correct:

odbcapi.c:

RETCODE        SQL_API
SQLColumns(HSTMT StatementHandle, ...)
{
...

        if (SC_is_lower_case(stmt, conn)) /* case-insensitive identifier */
            ifallupper = FALSE;

In above there is one hidden problem:
SC_is_lower_case() is implemented as follows:

statement.h:#define     SC_is_lower_case(a, b) (a->options.metadata_id,
b->connInfo.lower_case_identifier)

GCC compiler complaints (-Wall enabled) about the definition:

odbcapi.c:140: warning: left-hand operand of comma expression has no effect

So this means, that a->options.metadata_id is not used at all. Maybe the
comma
should be replaced with && or || ?

Marko Ristola

---------------------------(end of broadcast)---------------------------
(Continue reading)

Permalink | Reply | 0 comments |
headers
Marko Ristola | 1 Aug 2005 19:14
Picon
Picon

Re: IIS Postgres ASP ADO - Problem


I found a crashing problem during CONNECT into a database.

Here is the problem description:

Used Environment:
libpq-API under PostgreSQL 8.0.3
CVS HEAD of psqlodbc

libpq does have a problem with freeing memory, that has not been alloced
with malloc()!

Here is the problem (I don't know, wether the PostgreSQL CVS HEAD has a
fix for this):

postgresql-8.0.3/src/interfaces/libpq/fe-connect.c, function
conninfo_parse():

        /* Make a working copy of PQconninfoOptions */
        options = malloc(sizeof(PQconninfoOptions));
...
         memcpy(options, PQconninfoOptions, sizeof(PQconninfoOptions));

Unfortunately PQconninfoOptions[] contains only char*val style pointers
instead of
char val[32] type character containers.
Because of this, the assumption, that memcpy() is enough to copy the
structure, is not
true anymore. You should NOT copy a static structure this way!
(Continue reading)

Permalink | Reply | 0 comments |
headers
Eric E | 1 Aug 2005 21:36

Re: [BUGS] problem odbc 8.0 with EOModeler

Hi YL,
    You may also want to check that EOModeler is not quoting strings 
with double quotes (") rather than single-quotes (') in ODBC, say by 
auditing the same call to MySQL.  And maybe check out which ODBC version 
calls EOModeler is calling, and sounds like it could potentially(!) be 
using legacy calls to the ODBC driver.  I can't say I know enough about 
ODBC to be able to guide you on that, but I believe the pgsql-odbc list 
has a number of members who can.

Cheers,

EE

YL wrote:

>Hi Kevin, you're right. When i type
>pname = '\'Elim\''
>in the EOModeler, it works (fetches the right match).
>i can even do
>pname like '\'Eli*\''
>with the right results.
>But what this mean in odbc level? (i don't need to add additional quotes for
>other odbc data sources)
>
>When query against numerical columns, things works quite well
>
>----- Original Message ----- 
>From: "Kevin Grittner" <Kevin.Grittner <at> wicourts.gov>
>To: <whalesuit <at> bonbon.net>; <elim <at> pdtnetworks.net>;
><pgsql-bugs <at> postgresql.org>
(Continue reading)

Permalink | Reply | 0 comments |
headers
Joel Fradkin | 2 Aug 2005 15:42

Re: psqlODBC 08.00.0102 available for download

So is it ready for prime time?

Joel Fradkin

Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel.  941-753-7111 ext 305

jfradkin <at> wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
 This email message is for the use of the intended recipient(s) and may
contain confidential and privileged information.  Any unauthorized review,
use, disclosure or distribution is prohibited.  If you are not the intended
recipient, please contact the sender by reply email and delete and destroy
all copies of the original message, including attachments.

-----Original Message-----
From: pgsql-odbc-owner <at> postgresql.org
[mailto:pgsql-odbc-owner <at> postgresql.org] On Behalf Of Dave Page
Sent: Tuesday, August 02, 2005 4:16 AM
To: pgsql-odbc <at> postgresql.org
Subject: [ODBC] psqlODBC 08.00.0102 available for download

I've uploaded psqlODBC 08.00.0102 to
ftp://ftp.postgresql.org/pub/odbc/versions/. This is a bug fix release
of the pre-libpq version of the driver, specifically to fix a bug
(Continue reading)

Permalink | Reply | 1 comment |
headers
Dave Page | 1 Aug 2005 21:23
Picon

Re: Lowercase folding - simple patch?


> -----Original Message-----
> From: pgsql-odbc-owner <at> postgresql.org 
> [mailto:pgsql-odbc-owner <at> postgresql.org] On Behalf Of Marko Ristola
> Sent: 01 August 2005 17:28
> To: Merlin Moncure
> Cc: Eric E; pgsql-odbc <at> postgresql.org
> Subject: Re: [ODBC] Lowercase folding - simple patch?
> 
> 
> Does somebody know, wether the following code is correct:
> 
> odbcapi.c:
> 
> 
> RETCODE        SQL_API
> SQLColumns(HSTMT StatementHandle, ...)
> {
> ...
> 
>         if (SC_is_lower_case(stmt, conn)) /* case-insensitive 
> identifier */
>             ifallupper = FALSE;
> 
> In above there is one hidden problem:
> SC_is_lower_case() is implemented as follows:
> 
> statement.h:#define     SC_is_lower_case(a, b) 
> (a->options.metadata_id,
> b->connInfo.lower_case_identifier)
(Continue reading)

Permalink | Reply | 3 comments |
headers
Dave Page | 2 Aug 2005 16:03
Picon

Re: psqlODBC 08.00.0102 available for download


> -----Original Message-----
> From: Joel Fradkin [mailto:jfradkin <at> wazagua.com] 
> Sent: 02 August 2005 14:43
> To: Dave Page; pgsql-odbc <at> postgresql.org
> Subject: RE: [ODBC] psqlODBC 08.00.0102 available for download
> 
> So is it ready for prime time?

Well, as much as 08.00.0101 was, with the addition of the Unix fix I
mentioned. Oh, and there's a small memory leak fix I back patched as
well. I doubt you'll see much difference though unless you were seeing
memory leaks with prepared statements.

I would wait for the next libpq version if I were you - that has lots
more fixes, and I believe I sorted the Unicode bug today (finally - it
only took about 3 days on and off to figure it out!) - it fixes
Philippe's problem in all my tests, and I hope it will also fix the
Borland BDE and 'blank varchar/text' column issues others have been
seeing as well. If so, it should then be as good as the earlier 07
versions :-)

I expect to release in the next day or two.

/D

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo <at> postgresql.org so that your
       message can get through to the mailing list cleanly
(Continue reading)

Permalink | Reply | 1 comment |
headers
Joel Fradkin | 2 Aug 2005 15:41

Re: IIS Postgres ASP ADO - Problem

Excellent, Glad that worked.
I wrote a .net app to move from sqlserver to postgres (uses npgsql
components rather then odbc).
I also saw in the archive mention of dumping to deliminited data and reading
it directly into a database.

Best of luck.

Joel Fradkin

Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel.  941-753-7111 ext 305

jfradkin <at> wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
 This email message is for the use of the intended recipient(s) and may
contain confidential and privileged information.  Any unauthorized review,
use, disclosure or distribution is prohibited.  If you are not the intended
recipient, please contact the sender by reply email and delete and destroy
all copies of the original message, including attachments.

-----Original Message-----
From: James Dornan [mailto:james <at> catch22.com] 
Sent: Monday, August 01, 2005 5:51 PM
To: Greg Campbell
(Continue reading)

Permalink | Reply | 0 comments |

Gmane