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
-------------------------------------------------------
