Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rpc86
Posting Yak Master
200 Posts |
 Posted - 2007-09-26 : 00:00:14
|
| hi guys,I'm using MS SQL Server 2005 with MDAC 2.8. When I test my project into TCP/IP, the project does not pick the records completely.My connection string is using Provider=SQLNCLI.1Do I need to install SQL Native Client to work-stations ?Do I need to remove the MDAC ?Than you. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-26 : 01:50:47
|
I think you mix things up.MDAC can use several providers. One of them is SQL Native Client.You have to show us the query that faults.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
rpc86
Posting Yak Master
200 Posts |
Posted - 2007-09-26 : 02:13:31
|
| Peso, thank you.My problem is, our project runs in the development environment, but when it comes to remote areas using network TCP/IP, the system do not continue to pick records. Say, the expected records to be fetch are 30, the system would only return 12 records. But in the testing environment, the project would return even 100 records.We have tried this project using Dial-Up Connection and it runs smoothly.The work-stations do not have SQL Native Client, but only MDAC 2.7What is your advice? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-26 : 02:49:58
|
Post the query!1) If the data libraries are wrong, you can not even connect to the database.2) Data libraries do not interfere with resultsets.3) Are you 100% sure that you have the exact same data in both development environment and testing environment?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
Provider=SQLNCLI.1