pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedConnecting settings in PsqlODBC
3+ messages / 2 participants
[nested] [flat]
* Connecting settings in PsqlODBC
@ 1998-07-17 13:05 wojtek <wojtek@itl.waw.pl>
1998-07-17 14:16 ` Re: [INTERFACES] Connecting settings in PsqlODBC Byron Nikolaidis <byronn@insightdist.com>
1998-07-17 21:20 ` Re: [INTERFACES] Connecting settings in PsqlODBC Byron Nikolaidis <byronn@insightdist.com>
0 siblings, 2 replies; 3+ messages in thread
From: wojtek @ 1998-07-17 13:05 UTC (permalink / raw)
To: pgsql-interfaces
Hello,
I use PostgreSQL ODBC driver. This is 6.30.0246 version of
that product.
One of the advanced options of the driver (in section 'Connection') is
field
called as 'Connecting settings'. It gives the ability to run SQL
commands
at the momment of connecting. They say, that if someone wants to run a
few commands, they should be separated by a semi-colon (;). My problem
is that it doesn't work on my computer! Does anyone have any suggestions
where the problem is?
I have no problem with running one command. When I put a few of
them, only the first one is run. I use ODBC on Pentium133 to connect
resources
of PostgreSQL database with Access97.
Thanks in advance
Wojtek Pietron
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] Connecting settings in PsqlODBC
1998-07-17 13:05 Connecting settings in PsqlODBC wojtek <wojtek@itl.waw.pl>
@ 1998-07-17 14:16 ` Byron Nikolaidis <byronn@insightdist.com>
1 sibling, 0 replies; 3+ messages in thread
From: Byron Nikolaidis @ 1998-07-17 14:16 UTC (permalink / raw)
To: wojtek <wojtek@itl.waw.pl>; +Cc: pgsql-interfaces
wojtek wrote:
>
> Hello,
>
> I use PostgreSQL ODBC driver. This is 6.30.0246 version of
> that product.
>
> One of the advanced options of the driver (in section 'Connection') is
> field
> called as 'Connecting settings'. It gives the ability to run SQL
> commands
> at the momment of connecting. They say, that if someone wants to run a
> few commands, they should be separated by a semi-colon (;). My problem
> is that it doesn't work on my computer! Does anyone have any suggestions
>
> where the problem is?
>
I was able to run multiple commands. Of course, only the first one
actually "responds" with anything, but the other commands were indeed
run.
BTW, what commands were you running?
Byron
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] Connecting settings in PsqlODBC
1998-07-17 13:05 Connecting settings in PsqlODBC wojtek <wojtek@itl.waw.pl>
@ 1998-07-17 21:20 ` Byron Nikolaidis <byronn@insightdist.com>
1 sibling, 0 replies; 3+ messages in thread
From: Byron Nikolaidis @ 1998-07-17 21:20 UTC (permalink / raw)
To: wojtek <wojtek@itl.waw.pl>; +Cc: pgsql-interfaces
wojtek wrote:
>
> Hello,
>
> I use PostgreSQL ODBC driver. This is 6.30.0246 version of
> that product.
>
> One of the advanced options of the driver (in section 'Connection') is
> field
> called as 'Connecting settings'. It gives the ability to run SQL
> commands
> at the momment of connecting. They say, that if someone wants to run a
> few commands, they should be separated by a semi-colon (;). My problem
> is that it doesn't work on my computer! Does anyone have any suggestions
>
> where the problem is?
Sorry, you were right. Only the first command is getting run *after*
the first connect. The reason is that the semicolans in the connect
settings is interfering with the semicolans used to separate the
SQLDriverConnect string.
I will fix it in the next release.
Byron
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1998-07-17 21:20 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-07-17 13:05 Connecting settings in PsqlODBC wojtek <wojtek@itl.waw.pl>
1998-07-17 14:16 ` Byron Nikolaidis <byronn@insightdist.com>
1998-07-17 21:20 ` Byron Nikolaidis <byronn@insightdist.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox