There is actually an ODBC list vor PG availlable ;)
The drivers name is postgresql unicode
or postgresql ansi depending on your needs.
Driver={PostgreSQL UNICODE};DATABASE=X1;SERVER=X2;PORT=X3;UID=X4;PWD=X5;X6;
This is the connection string but you have to replace
X1 with the name of your database
X2 ...................... server
X3 your port ... ok this would probaply be 5432
X4, X5 your PG-username and password
X6 are ODBC parameters that you like to use e.g.
"BoolsAsChar=0;TrueIsMinus1=1;RowVersioning=1;"
This works at least for ADODB.
DAO had it like this:
ODBC;Driver=PostgreSQL
UNICODE;DATABASE=X1;SERVER=X2;PORT=X3;UID=X4;PWD=X5;X6;
marcelo Cortez schrieb:
Hi folks
Magnus thanks for respond, but i can't success full
with this.
Hi think it's string connection mater, but can't
connect, you try any time without pgsqlodbc
installed?.
I'm not using (vb) :D but using COM way.
Every time odcb reclaim for MS "dont know default
driver" or something like this, even psqlodb
installed.
Any suggestion will be appreciated?
best regards
MDC
--- Magnus Hagander <[EMAIL PROTECTED]> escribió:
On Mon, May 14, 2007 at 08:46:23PM -0300, marcelo
Cortez wrote:
hi all
there any was successful with connect to postgres
with psqlodbc in dsn less mode? It's wrong list
for
this subject? any pointer be appreciated
Certainly, all the time. For example (unix people
close your eyes, this is
vbscript):
dbconn.Open "Driver={PostgreSQL
UNICODE};DATABASE=admin;SERVER=my.server.se;uid=" &
wshshell.Environment("PROCESS")("USERNAME")
//Magnus
---------------------------(end of
broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will
ignore your desire to
choose an index scan if your joining column's
datatypes do not
match
__________________________________________________
Preguntá. Respondé. Descubrí.
Todo lo que querías saber, y lo que ni imaginabas,
está en Yahoo! Respuestas (Beta).
¡Probalo ya!
http://www.yahoo.com.ar/respuestas
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
