Обсуждение: DAO TO ODBC

hi freinds,
I have an application software which has connection with MS Access through DAO.I want to use same software without any changing with my new databank Postgresql through Odbc.
I dont think so,that i can change it,I must develope whole software with odbc for postgresql.
can any body help me?
thanks
sheikh

"Run, Fatboy, Run" sowie "Rails & Ties" kostenlos anschauen!    Blockbuster-Gutscheine sichern unter http://www.blockbuster.web.de

On Wed, Oct 15, 2008 at 3:17 PM, salman Sheikh <salman_sheikh@web.de> wrote:
> hi freinds,
> I have an application software which has connection with MS Access through
> DAO.I want to use same software without any changing with my new databank
> Postgresql through Odbc.

> I dont think so,that i can change it,I must develope whole software with
> odbc for postgresql.
> can any body help me?

I don't see where the problem would be.  You can still use DAO to
connection to PostgreSQL via an ODBC connection or an ODBC connection
wrapped in a DSN.  There is extra work required to setup the DAO
connection, but once it is created everything else should be the same.


--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

On Wed, Oct 15, 2008 at 3:25 PM, Richard Broersma
<richard.broersma@gmail.com> wrote:
> On Wed, Oct 15, 2008 at 3:17 PM, salman Sheikh <salman_sheikh@web.de> wrote:
>> hi freinds,
>> I have an application software which has connection with MS Access through
>> DAO.I want to use same software without any changing with my new databank
>> Postgresql through Odbc.
>
>> I dont think so,that i can change it,I must develope whole software with
>> odbc for postgresql.
>> can any body help me?
>
> I don't see where the problem would be.  You can still use DAO to
> connection to PostgreSQL via an ODBC connection or an ODBC connection
> wrapped in a DSN.  There is extra work required to setup the DAO
> connection, but once it is created everything else should be the same.

Here is the ODBC documentation sample using the DAO api.


http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/~checkout~/psqlodbc/psqlodbc/docs/howto-accessvba.html?rev=1.1&content-type=text/plain


--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug