Internal Error 30002 Sybase
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 > ASE > Connectivity - ADO .NET > "Internal Error: 30002" Internal Error: 30002 16 posts in Connectivity - ADO .NET . Last posting was on 2009-07-13 17:10:40.0Z Germano Posted on 2003-11-25 17:18:11.0Z From: "Germano"
procedure is very small accepting 1 parameters and returningalways a small result set, see below.CREATE PROCEDURE sp_rpt_web_bycase( @i_id_case int )ASBEGINSELECT id_report, date_status,date_standard, current_statusFROM http://nntp-archive.sybase.com/nntp-archive/action/article/%3C3fc38ed3$1@forums-1-dub%3E rpt_tableWHERE id_case = @i_id_caseENDOther store procedures are receiving more parameters and executing complexprocesses and works fine.I am using Sybase.Data.AseClientAssembly Version & File Version & Product http://comp.databases.sybase.narkive.com/0bKV3I6u/internal-error-30002-sybase-data-aseclient Version1.0.152.0Comments"Adaptive Server Enterprise Managed Provider"LanguageLanguage NeutralAny help will be helpful.I also saw this linkhttp://www.pfcguide.com/_newsgroups/msgbody.asp?id=%3C40c5911f%2E1807%2E1681692777%40sybase%2Ecom%3E&no=238&group=sybase%2Epublic%2Econnectivity%2Eadonet RobertoPerez 2005-12-06 19:02:28 UTC PermalinkRaw Message In my case the problem was the "date" column. Changing the SELECT statementas follow solved the problem:SELECT id_report, date_status,CONVERT( VARCHAR(19), date_standard ),current_statusFROM rpt_tableWHERE id_case = @i_id_case 1 Reply 459 Views Switch to linear view Disable enhanced parsing Permalink to this page Thread Navigation RobertoPerez 2005-12-06 16:49:30 UTC RobertoPerez 2005-12-06 19:02:28 UTC about - legalese Loading...
ASP.NET http://forums.asp.net/t/1171002.aspx?Error+in+Query+ Community Standup Forums Help Home/ASP.NET Forums/Data Access/DataSource Controls http://sfh01.sapdevcenter.com/nntp-archive/action/article/%3C438b271e$1@forums-1-dub%3E - SqlDataSource, ObjectDataSource, etc/Error in Query Error in Query [Answered]RSS 8 replies Last post Oct 18, 2007 06:41 AM by ahmed_enani ‹ Previous Thread|Next Thread › Print Share Twitter internal error Facebook Email Shortcuts Active Threads Unanswered Threads Unresolved Threads Support Options Advanced Search Reply ahmed_enani Member 2 Points 21 Posts Error in Query Oct 17, 2007 03:19 AM|ahmed_enani|LINK DataSet myDataSet = new DataSet(); int myRimNo = internal error 30002 int.Parse(gvCustInfo.SelectedRow.Cells[1].Text); AseConnection mySybaseConn = new AseConnection("charset='cp1256';Data Source='1.22.1.108';Port='10001';UID='internet';Password='system12';Database='phoenix';"); AseCommand myComm = new AseCommand("SELECT d.rim_no , r.rim_type,r.tin,r.last_name,d.* from phoenix..rm_acct r, phoenix..dp_display d WHERE d.rim_no = r.rim_no AND d.rim_no = " + myRimNo + " and rim_type = 'Personal'", mySybaseConn);
AseDataAdapter myDataAdapter = new AseDataAdapter(myComm); myDataAdapter.Fill(myDataSet); the last line of code give me this error: Sybase.Data.AseClient.AseException was unhandled by user code Message="Internal Error: 30002" Source="Sybase.Data.AseClient" StackTrace: at Sybase.Data.AseClient.AseDataReader.CheckResult(Int32 res) at Sybase.Data.AseClient.AseDataReader.Read() at System.Data.ProviderBase.DataReaderContainer.Read() at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 stlinks 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 > ASE > Connectivity - ADO .NET > "Sybase 15 Developer Edition MSDTC & DTM" Sybase 15 Developer Edition MSDTC & DTM 10 posts in Connectivity - ADO .NET . Last posting was on 2005-12-02 23:22:54.0Z Carlos Alberto Costa Beppler Posted on 2005-11-28 15:49:50.0Z From: Carlos Alberto Costa Beppler