.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

Upgrade to 4.0 - "Arithmetic operation resulted in an overflow Error" - MySQL driver issue

Posted By:      Posted Date: October 31, 2010    Points: 0   Category :ASP.Net
 

I upgraded to 4.0 and I'm now getting "Arithmetic operation resulted in an overflow Error" whenever I try to call information from the database. I'm using MySQL ODBC 5.1 for the site.

When I first started getting the error I could only return integer values and was using the connection string:

Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=myDataBase;User=myUsername;Password=myPassword;Option=


View Complete Post


More Related Resource Links

SQL Server JDBC Driver 1.2 Issue

  
I am using JDBC 1.2 driver to connect to Sql Server 2005 database and i am facing the application crash issues several times and javacores shows that the crash happens during JDBC call. This issue is happening several times in our application, please let me know if an upgraded driver version will fix the problem or to investigate the driver issue further NULL            1XMCURTHDINFO  Current Thread Details NULL           ---------------------- 3XMTHREADINFO      "WebContainer : 8" (TID:0x5946E100, sys_thread_t:0x51D052F0, state:R, native ID:0x000008AC) prio=5 4XESTACKTRACE          at com/microsoft/sqlserver/jdbc/PLPInputStream.getBytes(Bytecode PC:64(Compiled Code)) 4XESTACKTRACE          at com/microsoft/sqlserver/jdbc/DDC.xmlPLPToObject(Bytecode PC:132(Compiled Code)) 4XESTACKTRACE          at com/microsoft/sqlserver/jdbc/ServerDTVImpl.getValue(Bytecode PC:216(Compiled Code)) 4XESTACKTRACE          at com/microsoft/sqlserver/jdbc/DTV.getValue(Bytecode PC:216(Compiled Code)) 4XESTACKTRACE          at com/micro

MySQL Membership Provider issue

  
Hi all,I managed to set up the membership and roles providers for MySQL using the MySQL .NET Connector. I got the mysql tables for membership and roles autogenerated, managed to add users and roles from the Website Administration tool, but now I have a very strange problem: if I user the CreateUserWizard control (absolutely no customization - just dragged it to the webform) everything works fine. The user is created and I can see it in my mysql table.on the other hand I tried using the Login control to authenticate users and implemented the OnAuthenticate="Login1_Authenticate" event using the code below:protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)         {             if (FormsAuthentication.Authenticate(Login1.UserName, Login1.Password))             {                 Response.Redirect("Secret.aspx");             }             else             {                 e.Authenticated = false;             }         }protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)

Outer join operators *= and =* are not supported in 90 or later compatibility modes Upgrade issue

  
Hi all In processes of upgrading SQL Server 2000 to SQL Server 2008 I held up with one issue I am not a good pragrammer If some helps me how to modify this query,realy it help for me. "Outer join operators *= and =* are not supported in 90 or later compatibility modes" Here this query SELECT Brnd.Name, Dev.Devype FROM Prd,PrdRel, Rel, RelVer, DevSoft, DevCla, Dev, Brnd,OVer WHERE Prd.ID = PrdRel. Product AND Rel.ID = PrdRel.Release AND RelVer.Release = Rel.ID AND DevSofte.ReleaseVersion = RelVer.ID AND DevSoft.DeviceClass = DevCla.ID AND DevCla.ID = Dev.DeviceClass AND Brnd.ID = Dev.Brand AND OVer.ID =* Dev.OSVersion AND RelVer.Latest = 'Y' AND Prd.ID = @Product AND Rel.OS IN (@OS) Please some help me how to code  to come out from the problem. your help going to be greate for me.  SNIVAS

SharePoint 2007 upgrade to 2010 without UI update masterpage issue

  
I have a public facing site on a SharePoint 2007 farm that will be upgraded to 2010.  This site has a very customized look and feel that will not initially be updated to the 2010 UI.    I have run into one small issue with 2010's handling of legacy 2007 UIs.In SharePoint 2007,  to have a different master page for the application pages and dialog boxes we utilized an HTTP Module to switch the master page on the fly.    After migrating the SP2007 into our 2010 beta test environment the HTTP Module no longer worked properly.   I did some debugging and found out that SharePoint 2010 is returning a NULL value for MasterPageFile property on the pages in the _layouts folder.   I would have expected to see the URL pointing to the application.master page (or dialog.master).   Any ideas if this is a bug in SP2010 beta and will be fixed in RTM or is this the intended behavior.If it is the intended behavior in SP2010 how could I update my HTTP Module to allow the site to continue functioning as it did on 2007?   

upgrade sql 2005 to 2008 issue

  
i am trying to upgrade sql server 2005 Enterprise edition sp2 to Sql server 2008 R2 Data center Edition on a windows 2003 Enterprise edition SP2. Up gradation fails to give 'FeatureUpgradeMatrixCheck' error. any ideas ? i don't find much online. I would like to upgrade ::: [Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)     Enterprise Edition on Windows NT 5.2  ] to [Microsoft SQL Server 2008 R2 (RTM)   Data Center Edition ] possible ? thx, jason

SSRS in place upgrade from 2005 to 2008 issue

  

I did an inplace upgrade of SSRS 2005 to 2008 and now the reports are throwing the following error. The reports were all working fine and there is a datasource with the name 'Data Source Name' without the '_'.  Please help.

  • An error has occurred during report processing. (rsProcessingAborted)
    • The data source 'Data_Source_Name' cannot be found. (rsDataSourceNotFound)

Visual Upgrade SiteDirectorySettings.aspx issue

  

After completing a SharePoint 2007 to 2010 migration I perfomed a Visual Upgrade on my site collections.  I noticed that the Site Directory Settings page (SiteDirectorySettings.aspx )  in the site settings section is not rendering properly.  It looks like it is still trying to render using the old SharePoint 2007 look/feel.

Has anyone else noticed this issue?

Repo steps:

  1. Database attach migration from 2007 to 2010
  2. Perform Visual Upgrade
  3. Go to Site Actions, Site Settings, choose Site Directory Settings under the Site Collection Administration grouping

 


If you get your question answered, please come back and mark the reply as an answer.  
If you are helped by an answer to someone else's question, please mark it as helpful.
Mike Hacker | Blog: http://blog.mikehacker.net 


AJAX Upgrade Issue

  

We have a DNN site and we use the AJAX Toolkit.  We upgraded from AJAX 30930 to 40412.  We changed the script manager to a ToolkitScriptManager.  I have a image button that posts back and calls a modal popup.show() method.  When I click the button I get a javscript error before the post back:


Error: Sys.WebForms.PageRequestManagerServerErrorException: This version of MicrosoftAJAX does not offer the ScriptManager.RegisterClientScriptBlock method.


Any suggestions would be helpful.  I will obviously provide more detail if needed.


Issue with Registering to Redistribute SQL JDBC Driver

  

At the link http://msdn.microsoft.com/en-us/sqlserver/aa937725.aspx -  Register for Microsoft SQL Server JDBC Driver Redistribution Rights.

It appears that you can register to redistribute the SQL jdbc.jar.  Yet, when you click the I Accept -- you get a "broken link" or 404.    I registered with the Site Feedback for the SQL server site.   Anyone done this in the past or know if Microsoft still supports this?

Thanks! 


SQL 2008 Reporting Services Report Parameter and Analysis Services issue after upgrade

  
I have upgraded my SQL 2000 database and analysis server and SQL 2005 reporting services server to a new instance of SQL 2008 running database engine, analysis services and reporting services.

The analysis services database migrated successfully and I have got the database into a state where it processes fine but I am having the following problems.

- My Reports show in reporting services but the drop down list parameters are all empty.
If I change the parameter in report builder to use the display name instead of the uniquename then the drop down list populates and works until I select a value that contains a space character and then it reports a problem with the dataset used by the report.

Query for the dataset used to populate my parameter.
with member [Measures].[GroupUniqueName] as '[Site].CurrentMember.UniqueName' member [Measures].[GroupDisplayName] as'[Site].CurrentMember.Name' select { [Measures].[GroupUniqueName], [Measures].[GroupDisplayName] } on columns, { [Site].[Group].members } on rows FROM [Invoice Reporting]

Query used by the report, filtering on the selected parameter value from the drop

IT Workspace upgrade to SP 2010 issue

  
After doing a database upgrade (WSS 3.0 to SP2010 Enterprise) the Knowledge Base Article content type from the IT Workspace site definition (From the FAB 40) is not working.  The items created with this content type will not render properly the page is blank and when attempting to create new items the create page is also blank.  Does anyone have a fix for this yet.

How to fix "ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]MySQL server has gone awa

  

Hi Experts ,

I have hosted my web application into server . I got below error on and off but when i refresh the page , the error disappear . Im unable to figure out what is the problem because the error is normal happen after using the application about 10 to 20 mins . But when i run in localhost , there is no problem at all .  

I read lot of articles and testing on it but still failed .  Pls help . Im using asp.net C# and mysql .

Million Thanks ..

 

 

-----------------------------------------------------------------------------------------------------

ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]MySQL server has gone away

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]MySQL server has gone away

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and lo

After SharePoint 2007 upgrade to SharePoint 2010 issue with custom site(s)

  

With our 2007 site(s) we had a custom module (we developed) to swap out the application.master with our own master page which resembled the site default.master.  This worked great.

After the upgrade, out site's main pages looked fine however when navigating to the admin type pages (settings/viewlists etc.) pages the module stopped working.

1.) I have figured out something things with respect to what is going on but am still at a loss to how best resolve.  We want the layouts/admin pages to have the same master page as the main user pages.   I have read in 2010 this is now possible.  How can I achieve this?

 

2.) Currently, when navigating to the sites/settings page the site is using template/layouts/layoutsv3.master as the master page.  The settings.aspx page has DynamicMasterPageFile="~masterurl/default.master" .  It was my understanding that when DynamicMasterPageFile was set to default.master it would use the master page from the site.  So, with that said I am confused why it is using layoutsv3.master

any help would be appreciated

-dave


dave

CQWP and Event Content Type Issue After Upgrade from 2007

  

If you can answer this question it will be greatly appreciated.  I know it's a weird one and I know most of you guys on the forums are top notch, but it might stump the lot of you.  So I challenge you to help me out if you can.

I am working with a colleague and he upgraded the a very large farm with about 20-30 servers.  It has about 60,000 users.  All the other site collections and applications work fine, but one.  We are having a weird issue with the Content Query Webpart.  We cannot get it to work right when we scope it to an event list.  In the drop down it's not showing any content types when it should show List Content types -> Event.  In the list type it's show greyed out "Asset Library".

Now I did notice the event content type was hidden, so I went through the fix to move it to List Content Types.  I thought this is sure going to fix my issue right?  You would think so, but it didn't fix the issue.  So I am thinking there is something corrupt with this content type.  If any of you have an idea or some suggestions I'm all ears.  I'm looking for really crazy thinking out of the box answers.  Thanks for any help in advance.  If you help me I'll try and pay it forward to the next person.  If you don't I'll still pay it forward by answering other question

Upgrade issue from SQL 2005 x64 to SQL 2008 x64

  

Hi,

I am facing an issue while upgrade from SQL server 2005 x64 to SQL server 2008 x64. After upgrade all the componets are not showing on Start menu program Files and while upgrade I am getting only 2 features to upgrade. Please see the attached images.

http://lh3.ggpht.com/_sXjLsZULhuI/TLQxA35TjfI/AAAAAAAAABA/lXdbTi6_doc/1.JPG

http://lh3.ggpht.com/_sXjLsZULhuI/TLQxBmzo5YI/AAAAAAAAABI/hHnwTa0nE2c/2.JPG

 I tried to upgrade SQL 9.00.1399.06 standard to 10.0.3798.0 standard version. Is there any known issue in upgrading 2005 to 2008 on 64 bit platform?

Any help will be greatly appreciated...

 

Regards,

Bineesh


Linked server issue on test box, post upgrade 2005 to 2008 R2

  

In an effort to do some testing prior to upgrading our environment to 2008 R2, I made a test instance on our Dev box.  2005 instance, copied as many things as I could think of from various other instances.  Made a basic linked server to our main cluster, had a repeating job to email me results of a query across that link every few hours.

 

Everything was working fine until the upgrade finished.  It completed at ~7pm.  The email at 6PM came through fine (while the upgrade was in progress), the email at 8pm didn't come through.  Checked various things (DB mail was still working, tested fine).  It couldn't access the data across the linked server.  I tried deleting that link and remaking it.  Errors out.  Tried running the same scripts we use to create our standard linked servers, error out.  The only ones that I can set up and function are links to other instances on the same box.

I've looked around at other fixes for this error message and none seem to make any difference.  Log in with Domain cred's, log in with the sa account, no difference.  I can connect from other instances & servers back to this one, just not outbound from this one.  And it worked prior to the upgrade I applied to it.  All other instances on the box are 2005 as well.

Here is the message I ge

Connection pooling issue with microsoft enterprise library in mysql

  

I am using microsoft enterprise libarary to connect to mysql using mysql .net connector (latest version 6.2.3)

But i am facing a problem of too many connections and connection pool reached maximum limit issue.

As connection is disposed by enterprise library iteself so i dont close the connection anywhere.

So after two or three hours i found i have 100 mysql connections in sleep mode which are doing nothing and are not being reused from the code .

So i want to ask is there any issue with my code or is there any issue with mysql connector

please suggest me a solution so that i can rectify this issue as it is causing a lot of trouble to me.



Regards,

Ajay Singh Beniwal



Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend