[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 576
  • Last Modified:

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.
0
certogan
Asked:
certogan
  • 2
1 Solution
 
Anthony PerkinsCommented:
>>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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now