Solved

is there a limit for odbc-sql connection

Posted on 2004-09-11
3
559 Views
Last Modified: 2012-05-05
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
Comment
Question by:certogan
  • 2
3 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 100 total points
ID: 12034744
>>is there a limit?<<
No there is not.
0
 
LVL 15

Expert Comment

by:jdlambert1
ID: 12034820
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
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 12034883
>>acperkins is referring to SQL Server specifically. <<
Thanks.  I should have clarified.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question