Network error during DTS/Table Copy

, I use Enterprise to create DTS Packages and populate a few tables on a remote SQL server. Until recently everything was working fine. Now, I can't complete a DTS. Well i'll clarify. I can complete a DTS locally, just not remotely. When I try to copy the locally created table to the remote server I cannot. I always get a network error. Specifically:

[DBNETLIB][Connection(send()).]General network error

The kicker is if I try to do anything small (140k) it works fine. But as soon as it gets in the 1meg range forget it.

I've had my hosting service increase my database size. (they've also told me that there is nothing wrong which I can't really prove) I've also tried various timout values in enterprise. I'm stumped.

Posted On: Tuesday 20th of November 2012 03:53:19 AM Total Views:  276
View Complete with Replies

Related Messages:

Error Accessing MSAccess database on network drive   (514 Views)
On a network drive accessed by all users,I have created a directory with all security permissions to . Copied the MSAccess database to this directory and granted full control to Everyone.From a personal web server on my machine , I am trying to access a MSAccess database on a network drive and get the following error.I also created a folder on my C: drive.When I change the database path/namt to clannedactivitypact.mdb everything works fine.But when I try to access the database on the network drive, I get the following errorError Type:Microsoft JET Database Engine (0x80004005)The Microsoft Jet database engine cannot open the file 'gperationssupportplannedactivitypact.mdb'. It is already opened exclusively by another user, or you need permission to view its data./html/html/Jon/jon_entry.asp, line 79Browser Type:Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) Page:GET /html/html/Jon/jon_entry.asp Would appreciate some help with thi
SQL Server registration errors (NEWBIE)   (313 Views)
Odd problem - I'm running SQL 7 (client install) and cannot connect to the server, but only from my machine. From any other machine on the LAN that I've tried (after installing the client and adding my domain acct to the machine) I get in fine. I cannot connect using ISQL either. Any ideas I'm really hoping to avoid a machine reformat.
SQL server remote connection error   (348 Views)
I am getting this error when I execute a query on a remote server. [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionCheckForData (CheckforData()). [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation. Connection Broken This only happens when my query is run between these dates '5/1/2003' '5/30/2003' The query returs an extended cost- I have checked the totals for that quarter is over 1900000.00 If I run for the first quarter of this year the total is just under 1800000.00 and it executes fine. here is my query SELECT TOP 15 t.description, Amount = CASE WHEN t.Extcost_priceUSD IS NULL THEN 0 ELSE t.Extcost_priceUSD END FROM ( SELECT DISTINCT a.description, (SELECT sum(d.Extcost_priceUSD) FROM POS_DataTable d WHERE d.description = a.description AND d.ship_date >= '5/1/2003' AND d.ship_date = '5/1/2003' AND ship_date
The "undefined error"-problem   (183 Views)
hi! i wonder why I sometimes get a message saying "undefined error on line X". The SAME script can work several times before this error turns in, but when it well has turned in there's no return.... it'll stay there.... Now my question is WHY do I get this message..The error ALWAYS occour at the line WHERE this code is written:RecSet.Open SQL, Connect, adOpenStatic, adLockOptimistic
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'   (346 Views)
I am trying to update a table but unfortunately i see the following error: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '('. /Sales/RS/rs_display_po_am.asp, line 192 from the code below. Not sure why it is playing up Sub ScomInsertSOCust(psinvadd, psdeladd, psackadd) set comInsertSOCust = Server.CreateObject("ADODB.Command") comInsertSOCust.ActiveConnection = MM_conn_to_EFACs_STRING_ap comInsertSOCust.CommandText = "UPDATE dbo.salesorders (scustadd, sdeladd, sackadd) VALUES ('"& psinvadd &"', '"& psdeladd &"', '"& psackadd &"')" comInsertSOCust.CommandType = 1 comInsertSOCust.CommandTimeout = 0 comInsertSOCust.Prepared = true comInsertSOCust.Execute() End Sub
Why do i get this relationship error?   (291 Views)
Hi , how are you all I get the following error when i try to create a relationship between two tables: 'tblProductTypes' table saved successfully 'tblProducts2Displays2Stores' table - Unable to create relationship 'FK_tblProducts2Displays2Stores_tblProductTypes'. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_tblProducts2Displays2Stores_tblProductType s". The conflict occurred in database "intranet", table "dbo.tblProductTypes", column 'productTypesID'. ..but i dont understand why The datatypes are both the same, so surely this should not happen
How to display SQLServer error messages?   (314 Views)
. Simply put This is the error message that I get when I use the wrong credentials to log in to my sql server 2000 database, via ASP login page. Code: Technical Information (for support personnel) Error Type: (0x80040E14) /baselogin.asp, line 11 What I need it was something like this: Code: Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E14) Column 'tblCustomers.cust_id' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause. /baselogin.asp, line 11 Why can't I get a full error message I'm using Win2k Advanced Server, and MS SQL 2000. I've tried disabeling: "Friedly HTTP error messages" in internet explorer I've tried enabeling: "Send detailed ASP error message to client" in iss default web site properties Can someone help me
Syntax error converting datetime from character string   (352 Views)
hi I'm having problem with sql query i'll explain u what i'm trying to do when a user sends enquiry for a product it goes to table propertyhittable where hitid the index. if the receiver replies to the enquiry, his reply goes to table mailbox and all subsequent mail correspondence goes to mailbox. now on my Inbox Page i have to dispaly all the enquiries like gmail (each mail clustered with all past correspondence) I used the following query: select HitId,hitid as mailid,Login_Id,Star,Subject,Prop_Code,visitdate, replydate,mailread from propertyhittable where login_id'71727' and deleted=0 and prop_code in (select prop_code from resi_sell where login_id='71727' union select prop_code from comm_sell where login_id='71727' union select prop_code from land_sell where login_id='71727') union (select mb1.Login_Id,mb1.Star,mb1.Subject,mb1.Prop_Code,mb 1.maildate as visitdate, mb1.maildate as replydate,mb1.mailread,mb2.hitid,mb2.mailid from (select hitid,max(mailid) as mailid from mailbox group by hitid) as mb2 inner join mailbox as mb1 on mb1.hitid = mb2.hitid and mb2.mailid = mb1.mailid where login_id71727 and deleted=0 and mb2.hitid in (select hitid from propertyhittable where login_id='71727') ) order by replydate desc i got Server: Msg 241, Level 16, State 1, Line 1 Syntax error converting datetime from character string.
Transfer/copy to local computer   (194 Views)
Originally Posted by SidO Hi all, I am new to mssql i would appreciate your help. I am working on an existing website (ASP+MSSQL) i want to save a copy of the db on my computer to work on the change & only then get it back on the server. How can i get a copy of the db that is now on the server to my computer Cheers, Sid Originally Posted by ProEdge Backup the database on your server and just copy the file to your computer. Seems pretty simple no nah, it doesn't work for me either. i can enter a path on the backup form, so i entered c:\backup\dadshop and it backed up no probs... to the sql server's harddrive. i have no access to the sql server, other than the standard sql interface. i cannot figure out how to backup my data to my local computer!!!
Microsoft OLE DB Provider for ODBC Drivers error '80004005'   (367 Views)
I received an error message that I can't seem to resolve. The following: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Text Driver] Query must have at least one destination field. /process1.asp, line 16 Any assistance with the above will be greatly appreciated.
Incorrect Syntax error   (294 Views)
I amgetting this error in SQL. Error in SELECT clause: expression near '='. Missing FROM clause. Missing or incomplete SELECT clause. Unable to parse query text. Code: SELECT dbo.TestResult.RunId, dbo.TestResult.TestName AS Project, dbo.TestResult.IsRunnable, dbo.TestResult.Owner, dbo.TestResult.CategoryFullName, dbo.TestResult.CategoryId, dbo.TestResult.StartTime, dbo.TestResult.EndTime, dbo.TestResult.SubTestCount, dbo.TestResult.SubTestPass, dbo.TestRun.Name, dbo.TestRun.FileStorage, dbo.TestRun.TestsTotal, dbo.TestRun.TestsExecuted, dbo.TestRun.TestsPassed, dbo.TestRun.TestsCompleted, dbo.TestRun.TestsFailed, dbo.TestRun.TestsNotRun, dbo.TestRun.TestsInconclusive, dbo.TestRun.TestsAborted, dbo.TestRun.RunUser, dbo.TestRun.PublishUser, dbo.TestRun.DateCreated, dbo.TestRun.DateQueued, dbo.TestRun.DateStarted, dbo.TestRun.DateFinished, dbo.TestRun.RunHasCoverage, dbo.TestRun.RunPassed, dbo.TestRun.BuildUri, dbo.TestRun.TeamProject, NSEQAEngine.dbo.TestProducts.Product AS Product, NSEQAEngine.dbo.TestProducts.Script AS Script, NSEQAEngine.dbo.TestProducts.Component, NSEQAEngine.dbo.TestProducts.Description, NSEQAEngine.dbo.TestProducts.Responsible, NSEQAEngine.dbo.TestProducts.ResponsibleEmail, NSEQAEngine.dbo.TestProducts.Manual, NSEQAEngine.dbo.TestProducts.Comment, dbo.TestResult.TestOutcome As Status = CASE WHEN dbo.TestResult.TestOutcome = 'Completed' THEN 'Passed' WHEN dbo.TestResult.TestOutcome = 'Failed' THEN 'Failed' WHEN dbo.TestResult.TestOutcome = 'Incomplete' THEN 'Debatable' WHEN dbo.TestResult.TestOutcome Is null THEN 'Debatable' END, dbo.TestResult.TestType = CASE WHEN dbo.TestResult.Testtype = 'Unknown' THEN 'TestComplete' WHEN dbo.TestResult.Testtype = 'other' THEN 'NSE QA Portal Test Type' WHEN dbo.TestResult.Testtype Is null THEN 'Invalid' END, FROM dbo.TestResult INNER JOIN dbo.TestRun ON dbo.TestResult.RunId = dbo.TestRun.RunId LEFT OUTER JOIN NSEQAEngine.dbo.TestProducts ON dbo.TestResult.RunId = NSEQAEngine.dbo.TestProducts.RunID WHERE (NSEQAEngine.dbo.TestProducts.Component '')
Finding Auto ID during "insert into"   (314 Views)
Not sure if this is the right place, but I figure if you know SQL you'll know this. I'm inserting data into a DB from a form. The DB is auto-incrementing the ID #. Thing is, I need to know what that ID is on the same page as the insert comand. As I'm writing I'm thinking that I need to run a query that tells me how many records are in the table after the insert query and that should tell me what the last id was, yes Is there a better way to do it T.I.A.
UPDATE: worked around the code = 3001 error   (238 Views)
I replaced the recordset command line with adCmdTableDirect and it fixed that error right up. I have another error now.. I'm a SQL noob any help is appriciated. -- Database error Procedure = usp_Childs_Name The database could not retrieve the Birth record(s) because of the following unexpected error: Procedure 'usp_Childs_Name' expects parameter '@ChildsLast', which was not supplied. Microsoft OLE DB Provider for SQL Server Return code = -2147217904
what's the error in my mssql statement? :(   (250 Views)
hi i always used this type of command PHP Code: response.write("") response.write("") response.write("") response.write("") response.write("") to send out my data to mssql.. but problems will occur when the users fill in the CommonName fields with values with whitespaces and/or ' how should i fix this in java there's some method called preparedstatement.. how about in asp any help is greatly appreciated.
Syntax error near keyword 'BEGIN'   (207 Views)
never mind
error checking in ASP   (259 Views)
hi !! i have another problem in my coding... how can i add an error checking in my page because i have a customer registration page where a customer will input items the page... how can i have an error checking in the page, just like having an error like "username should not be more than 12 characters" or to have an error checking account like "the password you have entered is not the same" because there will be a field with "password" and "re-type password..."
Timeout expired error on SQL Server query with subquery   (400 Views)
hi, i have an ASP page that is querying an SQL database, and a SQL timeout expired '80040e31' error occurs on the line. The query is resonably standard, except there is a correlated subquery to do a COUNT of 'other users' who registered lately against the same school. Is there a way to make the query more efficient, (uncorrelate the subquery or something) so that the timeout error does not occur I could take out the subquery, and then do a seperate query on each userID to see if there are 'other users' for that user, but i think that might be less efficient than using the subquery (only about 1 in 10 users has 'other users'). The users table has about 40000 records, and no field is very large, varchar 300 would be about the biggest.
ORA-12560: TNS:protocol adapter error   (232 Views)
hi ppl, i tried to connect oracle server installed in a remote machine located in the same network and oracle client is installed in my local machine. when i try to execute the SQL statements from my client machine i am experiencing the following problem :- ERROR: ORA-12560: TNSrotocol adapter error i had given the oracle server machine's IP address correctly in the "Net Configuration Assistant". kindly reply me at the earliest, regards, Ramamoorthy
How to trap error for duplicate key   (259 Views)
With VFP, I have created a Form based on remote view of a table in MS SQL Database, that have a primary key. If the record is new, after I have enter the primary key, I need to control if the code exist already. I have not problem with the dbf file, but I have some difficulty with SQL database. Someone can help me, in order to resolve this problem Thank you. Best
Timeout error   (218 Views)
I have an excel program that runs every 10 minutes that gets data from files and inserts it in a table in the SQL server. Most of the time it runs ok. However when the network has heavy use, it generates a "Timeout" error. How do I prevent this