This snippit (below) is exactly what you need to connect (assuming you have
set up a system DSN after having installed the ODBC driver). Use VB6, Ado
(2.7 for example) and the postgreSQL ODBC and you're off. SQL constructs
are passed through exactly as shown below. I've been doing it before this
On Tue, 26 Apr 2005, Michal Hlavac wrote:
> I have this code:
> ResultSet rs = stmt.executeQuery("SELECT attr FROM table WHERE id=1");
> System.out.println(rs.getFetchSize());
>
> rs.getFetchSize() everytime returns 0... why???
The fetch size is a hint for the driver to know how many rows at a
I have made some good progress today since your help in makeing VB talk to
Postgresql through ODBC.
My application will run on a small p2p network of 5 Dell computers, one of
which is a server for Postgresql. The other workstations can access the
server through ODBC.
The owner, who is ag
On Fri, Apr 29, 2005 at 10:44:53PM -0600, [EMAIL PROTECTED] wrote:
> Tom Lane wrote:
> > [EMAIL PROTECTED] writes:
> >> LOG: redo starts at F1/A0A4E09C
> >> PANIC: Invalid page header in block 68122 of 17006
> >> LOG: startup process (pid 1959) was terminated by signal 6
> >> LOG: aborting star
Hello.
I
tried the pgcrypto contrib module with the AES default encryption. It works
pretty nice, but I understand that it's using 128 bit key strength. Is there
any built-in support for the 256 bit key strength? Or it should be used via
external libraries?
AFAIK,
the support of mha
> > Maybe you could return a refcursor pointing to the EXPLAIN ANALYZE of
> > the query inside the function.
>
> The raw materials exist to do this: if you know which elements of a
> query will be replaced by plpgsql variables, you can duplicate the
> results via
>
> PREPARE foo(...) AS ...
Apologies - sent this to the wrong list by accident.
R.
On 30 Apr 2005 at 20:56, Raymond O'Donnell wrote:
> On 23 Apr 2005 at 12:43, Gerard H. Pille wrote:
>
> > Now I would like to retrieve (and show) these images, but using
> > unixODBC. I have no problem retrieving them using pgsql, but the
On 23 Apr 2005 at 12:43, Gerard H. Pille wrote:
> Now I would like to retrieve (and show) these images, but using
> unixODBC. I have no problem retrieving them using pgsql, but the
> images are damaged when I try to do it with odbc.
Correct me if I'm wrong, but I think there's a limit (32k or
s
http://gborg.postgresql.org/project/psqlodbc/genpage.php?howto-visualbasic
Thanks for the link Jeff, that was exactly what I needed, plus a little
brushing up in Visual Basic.
Here is the code which finally worked!
It DOES want the DSN to equal "PostgreSQL", rather than something
else.
Thanks Jeff, and all, for suggestions:
http://gborg.postgresql.org/project/psqlodbc/genpage.php?howto-visualbasic
I have Visual Basic 6.0
The code at this page looks like exactly what I need.
I anticipate my problems as follows:
1:) A reference in the VB project to Microsoft ActiveX
Jeff Eckermann wrote:
--- [EMAIL PROTECTED] wrote:
I DID Succeed in doing the sort of things I want in
VBA script in MSAccess,
but that does me no good at work because we cant get
the money to purchase
copies of Access.
I own a copy of Visual Basic, and if I could find a
good example of
--- [EMAIL PROTECTED] wrote:
> I DID Succeed in doing the sort of things I want in
> VBA script in MSAccess,
> but that does me no good at work because we cant get
> the money to purchase
> copies of Access.
>
> I own a copy of Visual Basic, and if I could find a
> good example of
> acce
Tino, thanks so much for your reply. This listserve is very
helpful
>Please tell us what this means "... not succeeded in getting it
to>work..."
I had the postgres server installed and working on one machine, but could
not access it from the other machine using rekall or pgexplorer (UN
I don't think you can do that. While savepoints let you roll a
transaction back to a specified point, each sql statement is still
atomic and the only way to call a function is within a sql statement.
>>> "Mahesh S." <[EMAIL PROTECTED]> 4/30 3:08 am >>>
Ian,
I want to use a separate fu
Am Freitag, den 29.04.2005, 16:40 -0400 schrieb [EMAIL PROTECTED]:
> I can connect to the database on the server machine using pgadminIII
> and, it installed as a windows service. And I created one test
> database called usfo
>
> I have not succeeded in getting it to work yet using pg explorer fr
I was very pleased today, to be successful in connecting to the windows
postgresql server across our simple p2p connection. (It all had to do with
turning off the windows fire wall, after folks here helped me with the .conf ip
address settings, and listening). What is nice is that I have syg
16 matches
Mail list logo
