cursoradapter not loading data on large table

Question

Hi folks,
I am using cursoradapters in VFP8 SP1 to upgrade an existing app to use SQL Server database. I have realized that when I have a large cursor on the dataenvironment, either itself, or other cursors do not load, and I get "Table does not exists" error when I try to browse. However, when I remove the large cursor, the other tables load. I am using the cursoradapter wizard to create the cursors. I specify to use ODBC, and Use existing Connection Handle, which am establishing at program load. Has anyone come across this problem? Another interesting thing is that when I use ODBC and use a DSN, all the data loads without a problem. Any suggestions/ideas on how to overcome this?

Answer 1

Phita,

Is this still an issue?

Thanks!

---

Ed Price (a.k.a User Ed), SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!