Fwd: Re: [NOVICE] OK..time for STUPID to say somthing

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.php is 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 in the connection string. Hint: When you get the CONNECTION going, check out the CONNECTION.ConnectionString: it will show everything, 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 distribution of this communication(s) is expressly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy any and all copies of the original message.

>>> "John K. Herreshoff" <jkherr(at)centurytel(dot)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(at)faams(dot)net>
To: "John K. Herreshoff" <jkherr(at)centurytel(dot)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(at)centurytel(dot)net>
To: "Herbie McDuck" <herbie(at)faams(dot)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(at)postgresql(dot)org

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