MYOB Forums are brought to you by Anit Limited
  Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
What errors mean
 MYOB Forum - Anit Limited : What errors mean
Subject Topic: Data Base Errors Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
rajneesh
Newbie
Newbie
Avatar

Joined: 07 April 2008
Location: India
Posts: 2
Posted: 07 April 2008 at 13:20 | IP Logged Quote rajneesh

I am using MYOB ODBC to fetch Data from MYOB. But when I am inserting using insert statement in MYOB Database it gives me error

"{System.Data.Odbc.OdbcException: ERROR [08004] [MYOB ODBC]Cannot execute an INSERT IN read-only mode.
   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBeha vior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBeha vior behavior, String method, Boolean needReader)
   at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
   at nsMYOB.ProjectActions.InsertActivitySlip_ToMYOB(ProjectParam s oProjectParams) in d:\Myob_TestApp\App_Code\BLL\Project.cs:line 205}"
Back to Top View rajneesh's Profile Search for other posts by rajneesh
 
myobsupport
Admin Group
Admin Group
Avatar

Joined: 01 October 2003
Location: United Kingdom
Posts: 120
Posted: 13 April 2008 at 14:45 | IP Logged Quote myobsupport
Hi Rajneesh,
I by default the ODBC is read only and you have to purchase a license or join the MYOB developers programme to be able to write to the database.

The error in your first line seems to indicate that you only have read only access.

I'd contact MYOB.

Cheers,
Alan.


__________________
Balance sheet:-
The blind drawn by accountants to keep management in the dark.
MYOB Training
Back to Top View myobsupport's Profile Search for other posts by myobsupport Visit myobsupport's Homepage
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

Powered by Web Wiz Forums version 7.51a
Copyright ©2001-2003 Web Wiz Guide

This page was generated in 0.3589 seconds.
MYOB Forums are brought to you by Anit Limited