Puneet Wadhwa's BIOINFORMATICS BLOG

Friday, January 27, 2006

Sybase ADO.NET (Internal Error 30002) FIX


Hey Friends:

This post is more relevant to those who are using Sybase ADO.NET drivers in their .NET applications to connect to Sybase databases. I recently came across a wierd SYBASE Exception which had a description: Internal Error 30002, while I was trying to insert records into my Sybase database tables. I could not find any explanation on Sybase tech support pages, and also not much helpful information on the search engines.

I opened up a Tech support case with Sybase as my company has their support subscription, and they advised us to upgrade the .NET PC Client to the latest EBF (ebf13008). This magically solved all these internal error problems.

I hope some of you who may be facing these errors might get help.

Thanks,
Puneet Wadhwa

posted by Puneet Wadhwa at 4:02 PM

11 Comments:

  • where can i get the ebf13008

    By Anonymous Anonymous, at 2:46 AM  

  • Aside from inserts, another condition that raises this error is if your query outputs a column that is SMALLDATETIME NOT NULL

    By Anonymous Anonymous, at 11:39 AM  

  • Hi,

    I m plnning to take up a course in bioinformatics, please tell me abt the scope of the field, my mail Id is sush_anand2002@yahoo.co.in.

    I look forward to receving your reply,

    Thanks

    sushil

    By Anonymous Anonymous, at 1:45 PM  

  • Hi Punnet,
    Thank you very much for the information. I also faced same problem. I have a stored procedure, which was working fine till recently. Now, it is giving that nasty error(Internal error : 30002) when it is called from .NET programs. Though when it is called from back-end, it is giving no problems.

    Thanks,

    Nirmal Jana (nirmal_jana2001@hotmail.com)

    By Anonymous Nirmal Jana (nirmal_jana2001@hotmail.com), at 5:50 AM  

  • I'm not sure about ebf13008, but I am getting this error with this latest managed driver from Sybase:

    Sybase.AdoNet2.AseClient.dll

    Version: 1.15.325.0

    Released 15th August 2008

    By OpenID Andy, at 7:11 PM  

  • Hello.
    Where did you get that EBF from?
    I can't get it from the download page....

    By Blogger Arijull, at 1:40 PM  

  • Hi,
    The output of my query dont have any smalldatetime fields, however i get the "Internal Error: 30016 ".
    Also, where will i get the EBF? is it freely available on the internal. Could you please reply?

    By Blogger monali, at 7:08 AM  

  • typo "on the internet".
    Also i have been facing this error intermittently on some stored procs. Mostly when it tries to retrieve huge data, 100 columns table with 100-200 rows fetched.

    By Blogger monali, at 7:10 AM  

  • Stainless Steel Watch #EW9300-54A have dominated the watch industry and they are more or less in control of it and Black Watch #EW9215-01E this position has been further consolidated after the introduction of their diving watches which were waterproof as Citizen Men’s Gold-Tone Watch well as were able to withstand water pressure that was another first for this watch company. Citizen is just some of those popular brands Womens Corso Citizen Watch that comes also with different styles and looks with Men’s Corso BM8400-50A different functionality also.

    By Anonymous Modern Sport Watches, at 3:25 AM  

  • I do not have the knowledge about this topic can you please educate me with that.

    By Anonymous scope of bioseoinformatics, at 4:15 AM  

  • this is nice post..but i have no any idea about this blog...please anyone provide me complete information about this

    By Anonymous jasmine25, at 1:03 AM  

Post a Comment

<< Home