Re: Datasource-less connection (Re: DSN Less Connections with PG ODBC: Yes you can)

Dear Corey,

I'm afraid it didn't help me.

First of all, I don't know how could I use ADO-thingie to set an ODBCExpress
connection (hDbc).

Second, I'm (also) interested in specific parameters such as "Int8_as" and
the like. We could try things, once we have idea about the exact attribute
names, since hDbc's Attributes property is a stringlist.

I've also had a look at the source with no success. I don't even know what
exactly to search for.

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

---------------------------- cut here ------------------------------
----- Original Message -----
From: "Corey W. Gibbs" <cgibbs(at)westmarkproducts(dot)com>
Sent: Monday, May 12, 2003 8:03 PM

> Check into DSNless connections.
>
> Once the driver is installed on the workstation, you can refer to it in
your program
> here is a visual basic example using ADO
>
> dim cn as ADODB.Connection
> dim rs as ADODB.Recordset
>
> cn.Open
"Driver={PostgreSQL};Server=server4;Port=5432;Database=foobar;Uid=postgres;"
>
> at that point you can point to another database besides foobar
>
> Once the driver's been installed and registered on teh workstation, this
method will work.
>
> hope it helps
> corey
>
>