is there a limit for odbc-sql connection

we want to fetch some data with our sdk and use odbc connection for connecting sql server 2000 (full patched)
os is w2000 server sp4

we only get 4000 results (query is from various tables but unique is user id) meaning 4000 users are imported with their resğpective attributes.

but there is 38000 rows/users

is there a limit?

if there is not we will trace our sdk code.
also we use c++ 6.0 visual c microsoft for sdk development.

thanks.
certoganAsked:
Who is Participating?
 
Anthony PerkinsConnect With a Mentor Commented:
>>is there a limit?<<
No there is not.
0
 
jdlambert1Commented:
acperkins is referring to SQL Server specifically. There is obviously a limit somewhere that you need to find, but don't waste your time looking for it in SQL Server itself.
0
 
Anthony PerkinsCommented:
>>acperkins is referring to SQL Server specifically. <<
Thanks.  I should have clarified.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.