Error 7330
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn microsoft sql server error 7399 linked server more about Stack Overflow the company Business Learn more about hiring developers or posting
Msg 7330, Level 16, State 2
ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community sql server error 7399 access denied Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up sql server - bulk insert error up vote 7 down msg 7399 level 16 state 1 line 1 access denied vote favorite 1 I am using bulk insert and getting below error: Note: The data in the load file is not beyong the configured column length Running Command: bulk insert load_data from 'C:\temp\dataload\load_file.txt' with (firstrow = 1, fieldterminator = '0x09', rowterminator = '\n',MAXERRORS = 0, ERRORFILE = 'C:\temp\dataload\load_file') Contents of load file: user_name file_path asset_owner city import_date admin C:\ admin toronto 04/12/2012 Error: Msg 4863, Level 16, State
Microsoft Sql Server Error 7399 Invalid Authorization Specification
1, Line 1 Bulk load data conversion error (truncation) for row 1, column 6 (validated). Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error. Msg 7330, Level 16, State 2, Line 1 Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)". sql sql-server share|improve this question edited Dec 4 '12 at 23:01 Clockwork-Muse 8,43031733 asked Dec 4 '12 at 22:47 Bruce 77592143 Can you provide load_data schema? –Hamlet Hakobyan Dec 4 '12 at 22:53 Is column 6 by chance the last field in the row? It sounds like the field or rowterminator may be incorrect. I've seen this in the past. Since it doesn't find the terminator, it thinks the field/row extends on to the next field or row. Just a guess. –brian Dec 4 '12 at 22:55 You don't appear to have 6 columns... Also, formatting is a little different than you might otherwise expect here on SO, so I tweaked your data so that it lines up... which unfortunately resulted in the delimiter tabs going missing (although personally I prefe
SQL; Server; linked; server Technote msg 7303, level 16, state 1, line 1 (troubleshooting) Problem(Abstract) When running a SQL statement within Microsoft SQLServer via
Cannot Fetch A Row From Ole Db Provider "bulk" For Linked Server "(null)".
a linked server and the IBM Informix OLEDB provider, one might encounter Microsoft error 7399 and 7330. Symptom Msg http://stackoverflow.com/questions/13713351/sql-server-bulk-insert-error 7399, Level 16, State 1, Line 1 The OLE DB provider "ifxoledbc" for linked server "myserver" reported an error. The provider did not give any information about the error. Msg 7330, Level 16, State 2, Line 1 http://www-01.ibm.com/support/docview.wss?uid=swg21427734 Cannot fetch a row from OLE DB provider "ifxoledbc" for linked server "myserver". Resolving the problem Changing the provider to run in process resolves the issue. Here is a link describing the different provider options: http://msdn.microsoft.com/en-us/library/ms188095.aspx Link describing comparisons between Process and Out of Process: http://msdn.microsoft.com/en-us/library/aa242100(VS.60).aspx Related information How to define a Microsoft SQL Server linked server to Document information More support for: Informix Tools Informix Client Software Development Kit (CSDK) Software version: 3.5, 3.7, 4.0 Operating system(s): Windows Reference #: 1427734 Modified date: 2010-07-30 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2008 » SQL Server 2008 - General » Error while querying http://www.sqlservercentral.com/Forums/Topic1416739-391-1.aspx Linked server Error while querying Linked server Rate Topic Display Mode Topic Options Author Message venkat9.sqlvenkat9.sql Posted Wednesday, February 6, 2013 2:25 PM SSC Veteran Group: General Forum Members Last Login: Tuesday, August 18, 2015 9:41 AM Points: 229, Visits: 253 Hi all, I am a newbie to SQL Server. I have SQL Server 2008 R2 installed on a server machine and a linked server setup to an AS400 database using error 7399 a IBMDASQL OLEDB Provider. I was able to run queries against the AS400 database via the linked server using the four part query approach "Linkedserver"."Database"."Schema"."Table" till recently. For exampleSelect * from "AS400"."AS400DB"."SPRDQY"."CRYRECDL6"All of a sudden when my queries started to fail throwing of an error about the provider.Msg 7399, Level 16, State 1, Line 1The OLE DB provider "IBMDASQL" for linked server "AS400" reported an error. The provider did not give any sql server error information about the error.Msg 7330, Level 16, State 2, Line 1Cannot fetch a row from OLE DB provider "IBMDASQL" for linked server "AS400".The strange part is that when I run the same select statement in ssms on my client machine connected to the same server instead of directly in the ssms on the server machine, the query works fine and gets me the data from the AS400. SSMS on both machines is sql server 2008 r2.I am wondering what settings in my SSMS on the server machine that are different than the one on my client thats causing the error.Any help would be appreciated.. ___________________________________________________________________If I can answer a question then anyone can answer it..trying to reverse the logic.. Post #1416739 Vedran KesegicVedran Kesegic Posted Wednesday, February 6, 2013 5:31 PM Old Hand Group: General Forum Members Last Login: Tuesday, September 27, 2016 4:59 AM Points: 370, Visits: 1,250 Quoted_identifier _____________________________________________________Microsoft Certified Master: SQL Server 2008XDetails Addin - for SQL Developersblog.sqlxdetails.com - Transaction log myths Post #1416769 venkat9.sqlvenkat9.sql Posted Thursday, February 7, 2013 10:26 AM SSC Veteran Group: General Forum Members Last Login: Tuesday, August 18, 2015 9:41 AM Points: 229, Visits: 253 Thanks for the reply..Quoted identifier is already on. turning it off is throwing incorrect syntax error. I believe it has s