ODBC & browse box

[dEraCh2000]

Hello,
I'm using an ODBC connection to database server. Reason for ODBC is that I'm using Postgre database. When I use the file loading method in the browse box, it takes some time until it lodes the data. Then i change to page load method. It works very fast, but the is i new problem. When i scrol down it does not load new data it just repeats tne last one that was displeyed when the data was loades the first time. If anyone has encountered such a problem, or has an advice in how to fix this, I would be very grateful.
Regards

 

[ShankarJ]

Hi!

I hope you have an Unique Primary key for the Table and the Primary Key is part of the either the Browse Columns or Hot Fields.

Given below is an example PostGres connection string as posted by another user ::

Well, here are all the settings XP gives me (I've got an existing dsn psql-mydb setup with the defaults (and the Use/Declare Fetch set):

DSN=psql-mydb;DATABASE=mydb;SERVER=localhost;PORT=5432;UID=postgres;SSLmode=disable;ReadOnly=0;Protocol=7.4-1;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=255;MaxLongVarcharSize=8190;Debug=0;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=1;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0;LowerCaseIdentifier=0;XaOpt=1

You can of course make it DSN-less by including the DRIVER=... and removing the DSN=...