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 |
|
kapilarya
Yak Posting Veteran
86 Posts |
 Posted - 2005-09-12 : 08:11:52
|
| I am using VC++ as front end and Sql Server as database.My problem is : i am copying data from one table of database to another database.when i put both the database on my machine, it works fine. when i put on my office server then also it works fine but when i do the same on clients PC it fails.it fails after copying certain no of data like first time it fails after 1301 records,then next time it fails after 1100 records and error it gives "SERVER DOESNOT EXIST OR ACCESS DENIED".but problem doesnot stop here. i modified the VC++ code and put 1 sec pause between each read. then it reads well from first database and also insert into the second database.i dont understand why after reading some records this message comes and when i put delay of 1 sec it works perfectly fine.SQL Configartion is SQLSERVER2000 with service pack 3.Kapil Arya |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-09-12 : 08:52:47
|
some delays or locks, maybe?could be that your app is requesting rows that are locked to perform operation on them.Go with the flow & have fun! Else fight the flow  |
 |
|
|
|
|
|
ERROR : SERVER DOESNOT EXIST OR ACCESS DENIED