Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VB to Oracle 8 via ODBC - .Count = 0 on collections of fields

Status
Not open for further replies.
andymcd

andymcd

Programmer
Jul 30, 2001
3
GB
On just one user site, my VB(5) apps fail when trying to get Oracle(8) table details using a command like

iMaxSurnameLength = tTableDefCollection("TBLDAILY_STAFF").Fields("Surname").Size

Error is 3265 object not in this collection.

It turns out the .Count value for the Fields is always zero. Everything else (recordsets, directly executed SQL, running stored procedures) works fine! It's weird. I expect it's coincidence but this one site is running the apps under Citrix rather than direct on the user PC. As everything looks fine when querying through SQLplus, my suspicions are on the ODBC area. Has anyone else run into anything like this?
 
Status
Not open for further replies.

Similar threads

KeyserSoze
  • Locked
  • Question
TOAD for Oracle - Icons
Replies
1
Views
259
Andrzejek
Andrzejek
TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
234
TheLazyPig
TheLazyPig
Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
628
Andrzejek
Andrzejek
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
671
SkipVought
S
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
748
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top