Re: dns less connection

Andreas ,Magnus

 I do where you say me but...

' ''IM002: [Microsoft][ODBC Driver Manager] Data
source name not found and no default driver
specified''')
 i'm follow your instrutions and replace parts of
connectString but don't work .
Later a try with debugging options.
best regards

MDC

--- Andreas <maps.on@gmx.net> escribió:

>
> 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 <magnus@hagander.net>
> 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/
>



      __________________________________________________
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