Even if you don't have a complete answer, the original poster will appreciate any thoughts you have! Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. Locally executing the INSERT on VIEW on Server A works fine. It's quick & easy.
You cannot edit other topics. share|improve this answer answered Oct 20 '11 at 13:44 Ray 3,46411850 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign satya, Dec 7, 2006 #2 MohammedU New Member How many total connectins you see any sql for this app? The common cause I have seen is a updatable recordset with SUM(),COUNT(*) etc... http://www.sqlservercentral.com/Forums/Topic131089-5-1.aspx
You’ll be auto redirected in 1 second. SERVER B -------------- Create 2 tables, 1 view, 1 trigger (instead of) CREATE TABLE T1 (c1 INT) GO CREATE TABLE T2 (c2 INT) GO CREATE VIEW vt (cv) Any ideas on howto resolve these constant errors?Thanks. 1 Reply 249 Views Switch to linear view Disable enhanced parsing Permalink to this page Thread Navigation Jacco Schalkwijk 2003-11-20 16:38:59 UTC Shabba SQLSTATE (ODBC Error Codes) SQL Server 2016 Other Versions SQL Server 2014 SQL Server 2012 Warning SQL Server Native Client (SNAC) is not supported beyond SQL Server 2012.
US travel visa after an overstay Does Antimagic Field supress all divine magic? Register now while it's still free! Already a member? Browse other questions tagged sql sql-server spring websphere or ask your own question.
Post #131708 Patrick DaltonPatrick Dalton Posted Thursday, January 13, 2005 1:25 PM Forum Newbie Group: General Forum Members Last Login: Tuesday, October 20, 2015 10:12 AM Points: 1, Visits: 11 This Sql Error 16937 Error: 16955, Severity: 16, State: 2 Error: 16945, Severity: 16, State: 1 Error: 16955, Severity: 16, State: 2 Error: 16945, Severity: 16, State: 1 Error: 16955, Severity: 16, State: 2 Error: share|improve this answer answered Oct 19 '11 at 16:43 Joel Coehoorn 248k92440661 I added with and redeployed; I get the same error. –Ray Oct 19 '11 at 18:12 add http://www.tek-tips.com/viewthread.cfm?qid=935103 Learning resources Microsoft Virtual Academy Channel 9 MSDN Magazine Community Forums Blogs Codeplex Support Self support Programs BizSpark (for startups) Microsoft Imagine (for students) United States (English) Newsletter Privacy & cookies
You cannot delete your own events. Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Microsoft SQL Server: JennyPeters (Programmer) (OP) 15 Oct 04 11:34 Wow, thanks mihaildamjan,I'm reviewing all those articles now and will let you know the result. You cannot post or upload images.
Post your question and get tips & solutions from a community of 418,416 IT Pros & Developers. https://blogs.msdn.microsoft.com/dataaccesstechnologies/2011/02/22/executing-an-insert-statement-on-a-view-in-linked-server/ In the ODBC case, we are really going through MSDASQL/ODBC Driver of 2 layers that interact with SQL Engine. Sql Error 16955 CREATE TRIGGER vt_trig ON vt INSTEAD OF INSERT AS BEGIN INSERT INTO t2 (c2) SELECT i.cv FROM INSERTED i END SERVER A -------------- Create linked server on Server A to Error 42000 Microsoft Odbc Sql Server Driver Sql Server Incorrect Syntax Near ' ' RESOLUTIONTo resolve this problem, obtain the latest service pack for Microsoft Data Access Components 2.6.
In the ODBC case the cursor gets downgraded to a read-only cursor (you can see the message in in the Profiler, The cursor was not declared). Is 8:00 AM an unreasonable time to meet with my graduate students and post-doc? The Microsoft ODBC Driver for SQL Server provides native connectivity from Windows to Microsoft SQL Server and Microsoft Azure SQL Database. actually when i run the application on my machine i didn't find any connection leak but on production machine i find connection leak.
These are the messages: 16945 The cursor was not declared. 16955 Could not create an acceptable cursor. You cannot post HTML code. You cannot delete other topics. I keep my eyes open and see if there is anything else.Thanks again,Jenny Red Flag This Post Please let us know here why this post is inappropriate.
What does a publishing company make in profit? It indicates to the SQL Engine that an Updateable rowset is returned. You cannot upload attachments.
Cheers,Sugeshkumar Rajendran SQL Server MVPhttp://sugeshkr.blogspot.com Post #376891 « Prev Topic | Next Topic » Permissions You cannot post new topics. In the SQLNCLI case we are going directly to the OLE DB provider (SQLNCLI or SQLNCLI10). This problem was first corrected in Microsoft Data Access Components 2.6 Service Pack 1. This could give you the bonus that there might be entire topic to troubleshoot the problem.
So the workaround for SQLNCLI would be to use a stored procedure executed remotely: CREATE PROCEDURE [dbo].[UpdateViewStoredProc] @Param1 int AS BEGIN SET NOCOUNT ON; INSERT into Test.dbo.vt(cv) values (@Param1) END Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! You cannot edit other events. Copyright © 2002-2016 Simple Talk Publishing.
JennyPeters (Programmer) (OP) 15 Oct 04 10:04 When using the Profiler to assess some hangups in one of our VB applications, I keep randomly seeing these two errors:Error 16937 and 16945Any Members Members Quick Links Registered Members Current Visitors Recent Activity Help Help Quick Links Smilies BB Codes Trophies Search titles only Posted by Member: Separate names with a comma. Why INSERT on VIEW with SQLNCLI fails ------------------------------------- SQL Server wants to do a rowset-based INSERT (cursor based INSERT) operation through the OLE DB API IRowsetChange interface. The latter syntax is no longer supported on recent versions of sql server.
Are you aComputer / IT professional?Join Tek-Tips Forums! If a native error number does not have an ODBC error code to map to, the SQL Server Native Client ODBC driver returns SQLSTATE 42000 ("syntax error or access violation"). Hot Network Questions I start with a "he” and end the same Why were hatched polygons pours used instead of solid pours in the past? INSERT into Test.dbo.vt(cv) values (9) – this executes fine.
This workaround is less than ideal, but will work just fine for my purpose. By joining you are opting in to receive e-mail. SQL Server Native Client Programming SQL Server Native Client (ODBC) Handling Errors and Messages Handling Errors and Messages SQLSTATE (ODBC Error Codes) SQLSTATE (ODBC Error Codes) SQLSTATE (ODBC Error Codes) Processing You may download attachments.
Also create another linked server with MSDASQL and ODBC DSN (set up ODBC DSN using SQLODBCsrv driver) and call it MSDASQL_SQL2008. kwim? –John MacIntyre Oct 19 '11 at 17:00 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote Try saying WITH (nolock) rather than just (nolock). It is using the SQL ADO provider, MDAC 2.82.1830.0, SQL Server 8.00.2039 (SP4), Windows 5.2 (3790),SP4 for SQL Server. Solve this and the errors will go away.The other error 16945 ( The cursor was not declared.) isa consequence ofthe first error of course.--Jacco SchalkwijkSQL Server MVPRPC: [email protected] = 'exec DMG_IH_IFY
So what you in a such situation like this is this: select * from master..sysmessages where error in (16955, 16945) You could also have looked up the errors in Books Online, However, MSDASQL has additional logic here to simulate an updateable cursor. Both the SQL Servers are SQL Server 2008 SP2 on Windows 2008. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed