Re: DAO TO ODBC

On Wed, Oct 15, 2008 at 3:25 PM, Richard Broersma
<richard(dot)broersma(at)gmail(dot)com> wrote:
> On Wed, Oct 15, 2008 at 3:17 PM, salman Sheikh <salman_sheikh(at)web(dot)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