hi,
i have installed ODBC Driver and configure in ODBC-Manager
i have press "Test" and it say ok
but when call FiveDBU it does not appear ,,,
what i´m doing wrong
nageswaragunupudi wrote:You installed ODBC driver.
Not OLEDB provider.
PostgreSQL 10.7, compiled by Visual C++ build 1800, 32-bit
#include "fivewin.ch"
function Main()
local oCn
oCn := FW_OpenAdoConnection( "POSTGRE,localhost,postgres,postgres,India@1947", .t. )
if oCn == nil
? "failed to connect"
else
? "connected"
XBROWSER FW_AdoTables( oCn ) SETUP ( ;
oBrw:aCols[ 1 ]:bLDClickData := ;
{ |r,c,f,o| BrowseAdoTable( oCn, o:Value ) } )
oCn:Close()
endif
return nil
static function BrowseAdoTable( oCn, cTable )
local oRs := FW_OpenTRecSet( oCn, "select * from " + cTable )
XBROWSER oRs TITLE cTable FASTEDIT
oRs:Close()
return nil
local cStr := "Provider=MSDASQL;Driver={PostgreSQL ODBC Driver(UNICODE)};Server=localhost;Port=5432;Database=postgres;Uid=postgres;Pwd=India@1947;"
oCn := FW_OpenAdoConnection( cStr, .t. )
your ODBC Driver begin with "Provider" but psqlODBC Driver begin with "Driver"
Question : is Button ODBC in FiveDBU for OLEDB or ODBC
Return to FiveWin for Harbour/xHarbour
Users browsing this forum: Google [Bot] and 52 guests