Обсуждение: 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
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