ODBC - Recordset missing value when i migrate to postgresql 8.1
am 04.03.2006 00:39:08 von Theerasak ManeeneimI was migrated postgresql from 7.4 to 8.1.2.
It has some problem in our application,Microsoft Access, which query
data on postgresql through pgSQLODBC.
*Server *: Postgresql 8.1.2
OS : Linux Redhat 7.3
Encoding : UTF8
*Client *: Windows XP Service Pack 1,2
ODBC : PostgresODBC 8.01.0200 Unicode
*Application *: VBA on Microsoft Access
*Connection *: DAO --> ODBC
Set gWS_ODBC = DBEngine.CreateWorkspace("ODBCWorkspace", "orssss",
"", dbUseODBC)
'CURSOR SET (SERVER CURSOR)
gWS_ODBC.DefaultCursorDriver = dbUseServerCursor
'ODBC CONNECT CHARACTER
gODBC_str =
"ODBC;DSN=DSST;DATABASE=DSST;SERVER=192.168.1.12;PORT=5432;U ID=aid;PWD=drmm;"
gODBC_str = gODBC_str & "C2=dd_;;CX=186503ab"
Set gCON_ODBC = gWS_ODBC.OpenConnection("Connection1",
dbDriverComplete, False, gODBC_str)
*Recordset *:
Set lTB1 = gCON_ODBC.OpenRecordset(lMYSQL1, dbOpenDynaset)
SQL :
Select m.Childno as Childno , 0 as act_data , '0' as org_data ,
'' as acc_whcd
from m_part as m
The result on recordset:
lTB1!Childno --> 'PK00302'
lTB1!act_data --> 0
but when I get data from
lTB1!org_data
it show error :
Not positioned on a valid row for GetData.
----------------------
Next : I'm change my sql to :
SQL :
Select m.Childno as Childno , 0 as act_data , 0 as org_data ,
'' as acc_whcd
from m_part as m
i can get data from lTB1!org_data --> 0
but it has error at lTB1!acc_whcd
------------------------
I have the same problem when select some user function on postgresql.
-------------------------
I was not found this problem on
Database : postgresql 7.4
Encoding : UNICODE
ODBC : Postgresql ODBC 7.xx.xx...
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster