Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Emerson Reed
  Where is Emerson Reed?
 Americana - SP
 Brazil
 Emerson Reed
 To: Ugur YILMAZ
  Where is Ugur YILMAZ?
 Istanbul
 Turkey
 Ugur YILMAZ
 Tags
Subject: RE: Date in a CA (PostgreSQL using ADO)
Thread ID: 288970 Message ID: 288979 # Views: 38 # Ratings: 0
Version: Visual FoxPro 9 Category: ODBC, ADO and OLEDB
Date: Monday, December 27, 2010 2:02:42 PM         
   


> > Hi Folks!
> > I'm having a problem with a Date field in a PostgreSQL 9 database that is handled with a CA in VFP 9.
> > Using ODBC, I'm converting the date using a function in ConversionFunc that returns a date string like this: YYYY-MM-DD and it's working like a charm.
> > Using ADO, this isn't woking.
> > Any idea on how to solve this?
> >
> > Thanks a lot!
> >
> > Emerson Santon Reed
> > http://weblogs.foxite.com/emersonreed
> > http://emersonreed.spaces.live.com
>
> Hi Emerson;
>
> If I remember well; you need PostgreSQL OleDbProvider for using ADO in VFP.
>
>
> http://www.postgresql.org/about/news.1153
>
> http://www.google.com.tr/search?source=ig&hl=en&rlz=1G1ACAW_TRTR319&q=PostgreSQL+OleDB&btnG=Google'da+Ara&aq=f&oq=
>
> Ugur
> Amateur Programmer
> VFP 9 SP2, Win7 64 Bit

Hi Ugur.
I'm actually using this provider: http://pgfoundry.org/projects/oledb/

Emerson Santon Reed
http://weblogs.foxite.com/emersonreed
http://emersonreed.spaces.live.com

ENTIRE THREAD

Date in a CA (PostgreSQL using ADO) Posted by Emerson Reed @ 12/27/2010 12:28:44 PM
RE: Date in a CA (PostgreSQL using ADO) Posted by Ugur YILMAZ @ 12/27/2010 1:31:40 PM
RE: Date in a CA (PostgreSQL using ADO) Posted by Emerson Reed @ 12/27/2010 2:02:42 PM
RE: Date in a CA (PostgreSQL using ADO) Posted by Ugur YILMAZ @ 12/28/2010 11:44:45 AM
RE: Date in a CA (PostgreSQL using ADO) Posted by Emerson Reed @ 12/28/2010 1:43:30 PM
RE: Date in a CA (PostgreSQL using ADO) Posted by M. Tanveer Ul Hassan Shaheen @ 12/29/2010 8:56:55 AM
RE: Date in a CA (PostgreSQL using ADO) Posted by Emerson Reed @ 12/30/2010 5:44:17 PM