Thread: Datasource-less connection

Datasource-less connection

From
"SZŰCS Gábor"
Date:
Dear Fellows,

I searched through the archives but couldn't find the answer; if you can,
please show me to the right direction.

QUESTION: is it possible to make a datasource-less connection via psqlodbc
driver in Windows?

EXPLANATION: we use ODBCExpress, and it states in a whitepaper that hdbc can
be configured either via DSN or by hand, which is driver specific.

We'd like to know if PostgreSQL supports this kind of connection and what
are the allowed attribute names and values.

TIA,

G.
--
while (!asleep()) sheep++;

---------------------------- cut here ------------------------------


Re: Datasource-less connection

From
Chris Gamache
Date:
To create a string suitable for a DSN-Less connection in Windows, create an
empty file with the extension ".udl". Double-click the file and select the
options you want for your connection. Close the Universal Data Link Editor, and
re-open the file with notepad. You'll see a connection string. Make sure, if
you've referenced a DSN, to remove the reference and replace it with an
explicit declaration (in Extended Properties) of the driver name to use.
ex: DRIVER={PostgreSQL+ (Beta)};

HTH.

--- SZ�CS G�bor <surrano@mailbox.hu> wrote:
> Dear Fellows,
>
> I searched through the archives but couldn't find the answer; if you can,
> please show me to the right direction.
>
> QUESTION: is it possible to make a datasource-less connection via psqlodbc
> driver in Windows?
>
> EXPLANATION: we use ODBCExpress, and it states in a whitepaper that hdbc can
> be configured either via DSN or by hand, which is driver specific.
>
> We'd like to know if PostgreSQL supports this kind of connection and what
> are the allowed attribute names and values.
>
> TIA,
>
> G.
> --
> while (!asleep()) sheep++;
>
> ---------------------------- cut here ------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com


Re: Datasource-less connection

From
Janet Borschowa
Date:
Hi,
You might try using SQLDriverConnect with a connect string like:

"DRIVER={PostgreSQL};SERVER=your.server.name;PORT=5432;DATABASE=yourDatabase
;UID=yourUID;PWD=yourPassword";

Which works fine for me with no DSN entry.

If you have problems try enabling debugging by going to the registry:
HKEY_LOCAL_MACHINE | ODBC | ODBCINST.INI  and find the entry for PostgreSQL
and edit the Debug key. This is also the place to look for allowed
attributes that could be set in the connect string (e.g.
MaxLongVarcharSize).

========================
Janet Borschowa
Software Engineer, Database Products
Rogue Wave Software
http://www.roguewave.com



-----Original Message-----
From: SZUCS Gábor [mailto:surrano@mailbox.hu]
Sent: Monday, May 12, 2003 10:01 AM
To: pgsql-odbc@postgresql.org
Subject: [ODBC] Datasource-less connection


Dear Fellows,

I searched through the archives but couldn't find the answer; if you can,
please show me to the right direction.

QUESTION: is it possible to make a datasource-less connection via psqlodbc
driver in Windows?

EXPLANATION: we use ODBCExpress, and it states in a whitepaper that hdbc can
be configured either via DSN or by hand, which is driver specific.

We'd like to know if PostgreSQL supports this kind of connection and what
are the allowed attribute names and values.

TIA,

G.
--
while (!asleep()) sheep++;

---------------------------- cut here ------------------------------


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster