Error 42000 Sybase Odbc Driver Syntax Error Or Access Violation
Tips/Tricks Top Articles Beginner Articles Technical Blogs Posting/Update Guidelines Article Help Forum Article Competition Submit an article or tip Post your Blog quick answersQ&A Ask a Question View Unanswered Questions View All Questions... C# questions Linux questions ASP.NET questions SQL questions VB.NET questions discussionsforums All Message Boards... Application Lifecycle> Running a Business Sales / Marketing Collaboration / Beta Testing Work Issues Design and Architecture ASP.NET JavaScript C / 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 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 Syntax error or access violation Rate this: Please Sign up or sign in to vote. See more: VB VB.NET hi..... Given below is my code to insert data int a table : USER. Dim myInsertQuery As String = "INSERT INTO USER (USERID,PASSWORD) Values('roll', 'name')" Dim mycommand As New OdbcCommand(myInsertQuery) mycommand.Connection = myConnection mycommand.ExecuteNonQuery() But the code is not working properly...i am getting the error message given below .....can any one suggest a solution please,thanks in advance.. 'ERROR [42000] [Sybase][ODBC Driver][Adaptive Server Anywhere] 'Syntax error or access violation: near 'USER' in INTO [USER] Posted 23-Feb-10 17:58pm vidhyaej482 Updated 23-Feb-10 18:16pm Sandeep Mewara505.4K v2 Add a Solution 3 solutions Top Rated Most Recent Rate this: Please Sign up or sign in to vote. Solu
links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center. Forums Archive > SQL Anywhere > General Discussion > "Upgrading from ASA 6.0.3 to ASA 9 problems" Upgrading from ASA 6.0.3 to ASA 9 problems 6 posts in General Discussion . Last posting was on 2004-01-14 15:47:59.0Z Mad Vlad Posted on 2004-01-13 16:48:20.0Z From: "Mad Vlad"
links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center. Forums Archive > PowerBuilder > Pocket error 42000 PowerBuilder > "Error Connecting to the Database" Error Connecting to the Database 2 posts in Pocket PowerBuilder . Last posting was on 2004-11-15 16:44:21.0Z jaguarz Posted on 2004-11-13 06:23:14.0Z Sender: 43aa.41955d27.1804289383@sybase.comFrom: jaguarzNewsgroups: sybase.public.pocketpowerbuilderSubject: Error Connecting to the DatabaseX-Mailer: error 42000 sybase WebNews to Mail Gateway v1.1tMessage-ID: <4195a84e.48aa.1681692777@sybase.com>X-Original-NNTP-Posting-Host: 10.22.241.42X-Original-Trace: 12 Nov 2004 22:23:10 -0800, 10.22.241.42Lines: 13X-Original-NNTP-Posting-Host: forums-2-dub.sybase.comX-Original-Trace: 12 Nov 2004 22:23:11 -0800, forums-2-dub.sybase.comNNTP-Posting-Host: forums-master.sybase.comX-Original-NNTP-Posting-Host: forums-master.sybase.comDate: 12 Nov 2004 22:23:14 -0800X-Trace: forums-1-dub 1100326994 10.22.108.75 (12 Nov 2004 22:23:14 -0800)X-Original-Trace: 12 Nov 2004 22:23:14 -0800, forums-master.sybase.comX-Authenticated-User: ngsysopPath: forums-1-dub!not-for-mailXref: forums-1-dub sybase.public.pocketpowerbuilder:4232 Article PK: 271485 When I run my program on the device, an error occur: Error connecting to the database.SQLSTATE=42000 [Sybase][ODBC Driver][Adaptive Server Anywhere] Syntax Error or access violation: Request to start/stop database denied. I appreciate any help from the group. thanks -jaguarz- David Fishburn Posted on 2004-11-15 16:44:21.0Z Newsgroups: sybase.public.pocketpowerbuilderSubject: Re: Error Connecting to the DatabaseFrom: David Fishburn