Fwd: Re: [NOVICE] OK..time for STUPID to say somthing - Mailing list pgsql-odbc

This is from work...

I'm using the ODBC from the PGSQL site (www.postgresql.org) with a link to gborg...
http://gborg.postgresql.org/project/psqlodbc/projdisplay.phpis the link. 

For the ODBC thing:  I've just got the PGSQL driver set up in the ODBC_32 business.  I did not fill in much; I do that
inthe connection string.  Hint:  When you get the CONNECTION going, check out the CONNECTION.ConnectionString:  it will
showeverything, and you can then configure your own connection string... 

My connection setupis as follows:

Set CONN = New ADODB.Connection
CONN.ConnectionTimeout = 5 'I've got no idea why I did this
CONN.ConnectionString = "DSN=PostgreSQL30;UID=postgres;DATABASE=caro_data;SERVER=xxx.xx.xx.xxx;PORT=5432;"
CONN.Open

That opens the connection.

For recordsets that use a server-side cursor (for updating). I'd do this

CONN.cursorlocation = 2 ( or adUseServer)

HTH.

John.

Confidentiality Notice:  This message, including any attachments, is intended solely for the use of the named
recipient(s)and may contain confidential and/or privileged information.  Any unauthorized review, use, disclosure or
distributionof this communication(s) is expressly prohibited.  If you are not the intended recipient, please contact
thesender by reply e-mail and destroy any and all copies of the original message.   


>>> "John K. Herreshoff" <jkherr@centurytel.net> 07/08/03 11:22AM >>>


----------  Forwarded Message  ----------

Subject: Re: [NOVICE] OK..time for STUPID to say somthing
Date: Tue, 8 Jul 2003 07:47:10 -0700
From: "Herbie McDuck" <herbie@faams.net>
To: "John K. Herreshoff" <jkherr@centurytel.net>

John,

Whos ODBC are you using? I'm using the one from OpenLink.

Can you send the initial connection phrase to the PostgreSQL database that
you are using so that I can make sure my syntax is correct.

--Herbie McDuck

----- Original Message -----
From: "John K. Herreshoff" <jkherr@centurytel.net>
To: "Herbie McDuck" <herbie@faams.net>
Sent: Tuesday, July 08, 2003 2:49 AM
Subject: Re: [NOVICE] OK..time for STUPID to say somthing

> FWIW, I fiddle with PGSQL with a VB5 front end.  I found that the dynaset
> thing did not work too well.  You have to set the connection up to use

server

> side rather than client side cursor location.  I did not like that, so

I've

> been rewriting update and inserts to use connention.execute sql

statements,

> such as connection.execute "INSERT INTO fubar (junk) VALUES (more_junk);"

or

> "UPDATE furble SET fubar = more_junk where id_num = 6161;"  These execute
> statements run quickly and I've learned a bit of SQL along the way.
>
> My 2 cents.
>
> John.
>
> On Tuesday 08 July 2003 01:57, you wrote:
> > OK, when do I put my foot into my mouth?
> >
> > Because of some market demands, I *HAVE* to develop my latest version of

my

> > application on a Visual Basic 6 frontend. When you have finished gagging

I

> > will proceed...<<GRIN>>
> >
> > Client:  Windoze XP 512Mb RAM
> >            VB 6 MDAC Version: 3.520.9030.0?
> >            100 BaseT Network
> >
> > Server: Linux SuSE 8.2
> >            PostgreSQL Version 7.3.0
> >
> > The VB6 project goes well. We can connect to the database. We can do the
> > locate records. We can display the records in the application.
> >
> > BUT !! When we try to add a record. Ding ! Dong ! We get the vaunted
> > 80004005 ERROR that indicates we do no have permission form what I can
> > tell.
> >
> > I made sure that on the table we have full GRANT permissions.
> >
> > I've done all that I know to do to solve the problem including a

personal

> > relationship with Google.
> >
> > Any help? Directions? Or reading of 'Tea Leaves'?
> >
> > --Hal
> > Davison Consulting
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

-------------------------------------------------------