Oracle Syntax Error Or Access Violation
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 error [42000] [oracle][odbc]syntax error or access violation this site About Us Learn more about Stack Overflow the company Business
Microsoft Odbc Sql Server Driver Syntax Error Or Access Violation
Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Microsoft ODBC driver for Oracle Syntax error or access violation (-2147217900) up vote 0 down vote favorite I have a large VB program that connects to Oracle database. strCn = "Driver={Microsoft ODBC for Oracle};" & _ "SERVER=PSPROD;" Set Cn = New ADODB.Connection Cn.ConnectionString = strCn Cn.CursorLocation = adUseNone Cn.Open There are many users of my program so I have a table that contains each user's login name and their access rights to the various tables. I create a recordset of all users when the program is started and then select USERNAME and GRANTED_ROLE from the record set where USERNAME and PASSWORD are found. I use a "Set role 'GRANTED_ROLE' identified by 'password'" statment and Cn.Execute statement to set up the user's access rights. This is all done in a Module. On a form, I want to call a Stored Procedure that will SELECT, INSERT and UPDATE information into another schema's tables. I am able to call and run the stored procedure when I create a new connection to the database with this code: Dim cmd5040 As ADODB.Command Dim conn5040 As ADODB.Connection Dim param5040 As ADODB.Parameter Set conn5040 = New ADODB.Connection conn5040 = "Driver={Microsoft ODBC for Oracle};" & _ "SERVER=PSPROD; UID=XXXXXXX; PWD=XXXXXXXX" conn5040.Open Set cmd5040 = New ADODB.Command With cmd5040 .ActiveConnection = conn5040 .CommandType = adCmdStoredProc .CommandText = "S4115040_IMPORT_NEWBIDITEMSPES.S4115040_CheckTime" .Parameters.Append .CreateParameter(, adInteger, adParamInputOutput, 5) .Parameters.Append .CreateParameter(, adVarChar, adParamInputOutput, 400) End With cmd5040(0) = 0 cmd5040(1) = "" cmd5040.CommandTimeout = 300 cmd5040.Execute conn5040.Close However, I get the error message "-2147217
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > [Microsoft][ODBC driver for Oracle]Syntax error or access violation Error Want to Advertise Here? Solved [Microsoft][ODBC driver for Oracle]Syntax error or access violation Error Posted on 2004-06-10 Oracle Database 1 Verified Solution 4 Comments 2,307 Views Last Modified: 2010-08-05 Hi http://stackoverflow.com/questions/2030531/microsoft-odbc-driver-for-oracle-syntax-error-or-access-violation-2147217900 all, I get this error when I try to call a package from my ASP page. Does anyone know why? Thanks, xyz 0 Question by:MaryZhou Facebook Twitter LinkedIn Google LVL 1 Best Solution bymtae We've had similar problems, unfortunately error messages from ASP for Oracle are pretty vague. When we've had this problem it has been because number of records coming back from Oracle are greater than Go to https://www.experts-exchange.com/questions/21021178/Microsoft-ODBC-driver-for-Oracle-Syntax-error-or-access-violation-Error.html Solution 2 Comments LVL 7 Overall: Level 7 Oracle Database 6 Message Expert Comment by:bvanderveen2004-06-10 Because you have done something wrong. The actual error message would help :-) Check your parameters first, are they the correct number and the correct type to start with. 0 LVL 1 Overall: Level 1 Oracle Database 1 Message Accepted Solution by:mtae2004-06-11 We've had similar problems, unfortunately error messages from ASP for Oracle are pretty vague. When we've had this problem it has been because number of records coming back from Oracle are greater than the size of the recordset definied in ASP. For some reason you have to guess the size of the recordset that is going to come back!! This can take up valuable memory on the web server if you make the recordset to big and can cause the problem above if it's too small. If you are trying to return a recordset try increasing the size of it in the ASP and see if that helps. Unfortunately that error could be due to many things... 0 Write Comment First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone.
Tips/Tricks Top Articles Beginner Articles Technical Blogs Posting/Update Guidelines Article Help Forum Article Competition Submit an http://www.codeproject.com/Questions/612480/ERROR-Oracle-ODBC-Syntax-error-or-access-vio article or tip Post your Blog quick answersQ&A Ask a Question View Unanswered Questions View All Questions... Linux questions C# questions ASP.NET questions SQL questions fabric http://www.orafaq.com/forum/t/49503/ questions discussionsforums All Message Boards... Application Lifecycle> Running a Business Sales / Marketing Collaboration / Beta Testing Work Issues Design and Architecture ASP.NET JavaScript C syntax error / C++ / MFC> ATL / WTL / STL Managed C++/CLI C# Free Tools Objective-C and Swift Database Hardware & Devices> System Admin Hosting and Servers Java .NET Framework Android iOS Mobile SharePoint Silverlight / WPF Visual Basic Web Development Site Bugs / Suggestions Spam and Abuse Watch features Competitions syntax error or News The Insider Newsletter The Daily Build Newsletter Newsletter archive Surveys Product Showcase Research Library CodeProject Stuff communitylounge Who's Who Most Valuable Professionals The Lounge The Insider News The Weird & The Wonderful The Soapbox Press Releases Non-English Language > General Indian Topics General Chinese Topics help What is 'CodeProject'? General FAQ Ask a Question Bugs and Suggestions Article Help Forum Site Map Advertise with us About our Advertising Employment Opportunities About Us Ask a Question All Questions All Unanswered FAQ ERROR [42000] [Oracle][ODBC]Syntax error or access violation Rate this: Please Sign up or sign in to vote. See more: ASP.NET Imports System.Data Imports System.Data.Odbc Partial Class _STUDENTTABLE Inherits System.Web.UI.Page Dim CON As OdbcConnection Dim comm As OdbcCommand Dim instance As OdbcDataAdapter Dim a As Integer Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load End Sub Protected Sub BTNINSERT_Click(ByVal sender As Object,
E-mail to friend Query Engine Error 42000:[Microsoft][ODBC data for oracle]- syntax error or access violation [message #130016] Wed, 27 July 2005 13:02 pdaulagar Messages: 1Registered: July 2005 Junior Member Hi I created a package and procedure with parameters ref curor and deptno. 2) Compiled the procedure 3) create system DSN and trying to access stored procedure from report designer I am getting the following error Query Engine Error 42000:[Microsoft][ODBC data for oracle]- syntax error or access violation 4) I tried connecting sample stored procedures, getting the same error If any body knows about it, post the reply CREATE OR REPLACE PACKAGE Types AS TYPE cursor_type IS REF CURSOR; END Types; / CREATE OR REPLACE PROCEDURE GetEmpRS (p_deptno IN emp.deptno%TYPE, p_recordset OUT Types.cursor_type) AS BEGIN OPEN p_recordset FOR SELECT ename, empno, deptno FROM emp WHERE deptno = p_deptno ORDER BY ename; END GetEmpRS; / Report message to a moderator Previous Topic: ORA-01858: a non-numeric character was found where a numeric was expected : HELP NEEDED Next Topic: Delete records of table within proc? Goto Forum: - SQL & PL/SQLSQL & PL/SQLClient Tools- RDBMS ServerServer AdministrationBackup & RecoveryPerformance TuningSecurityNetworking and GatewaysEnterprise ManagerServer Utilities- Server OptionsRAC & FailsafeData GuardReplicationStreams & AQSpatialText & interMedia- Developer & ProgrammerApplication Express, ORDS & MOD_PLSQLFormsReports & DiscovererDesignerJDeveloper, Java & XMLWarehouse BuilderPrecompilers, OCI & OCCI- Fusion Middleware & Colab SuiteWeblogic & Application ServerBusiness IntelligenceWebCenter Suite & PortalCollaboration & Content ManagementSOA Suite, BPEL and OWSM- ApplicationsOracle Fusion Apps & E-Business SuitePeopleSoft, JD Edwards & SiebelPrimaveraOther Application Suites- InfrastructureHardwareUnixLinuxWindowsOther Operating Systems- Open SourceProgramming InterfacesMySQL- OtherGeneralTraining & CertificationMarketplaceCommunity HangoutSuggestions & FeedbackTest- Non-English ForumsArabicDutchFrenchGermanJapanesePortugueseRussianSpanish -=] Back to Top [=- [ Syndicate this forum (XML) ] [ ] Current