Urgent: Error accessing MySQL data (ASP.NET website) - production server only

Using VS 2008 SP1 with MySQL 5. Using DevArt's MyDirect.NET (latest version) to access the data.

Created a new, simple, asp.net web site. Created one new XSD dataset with one TableAdapter containing GetData. (I used the production server in my connectionstring, defined in the web.config.) Then I created one aspx page with a gridview which utilized GetData. On the local machine it runs perfectly.  Very simple website.

I uploaded all the files to the production server. When I go to the url I get this error. Any ideas?

Server Error in '/' Application.
Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: Failed to generate code. Exception of type 'System.Data.Design.InternalException' was thrown.

Source Error:

Line 1: <?xml version="1.0" encoding="utf-8"?>
Line 2: <xs:schema id="dsCompanyTypes" targetNamespace="http://tempuri.org/dsCompanyTypes.xsd" xmlns:mstns="http://tempuri.org/dsCompanyTypes.xsd" xmlns="http://tempuri.org/dsCompanyTypes.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
Line 3:    <xs:annotation>


Source File: /App_Code/DAL/dsCompanyTypes.xsd    Line: 1

Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053
LVL 9
RobertNZanaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

brwwigginsIT ManagerCommented:
Did you verify the asp.net version set for the website in IIS? I think by default it does 1.1

Open the IIS manager, right-click on the website or VD and go to properties. Double check the ASP.NET tab
0
RobertNZanaAuthor Commented:
Using IIS Manager (IIS V7) in Windows Server 6 SP1.

In Application Pools it shows up as v2.0.  Should v3.5 show up as "v3.5" or not?

I DEFINITELY need to use v3.5.  Let me look at it and get back to you in a second.  Please stick with me on this thread because it's really important to me.  Thanks!
0
RobertNZanaAuthor Commented:
Apparently the 3.0 and 3.5 are essentially extensions to the 2.0 system, and show as 2.0 in the IIS app pool display.

http://forums.iis.net/p/1147405/1861282.aspx

I think the problem is with MyDirect .NET provider, which gives me access to the MySql database.

Someone suggested that I manually add the provider to the web.config file, like this...
 <system.data>
  <DbProviderFactories>
   <add name="MyDirect .NET" invariant="CoreLab.MySql" description="CoreLab MyDirect .NET"
    type="CoreLab.MySql.MySqlDirectFactory, CoreLab.MySql" />
  </DbProviderFactories>
 </system.data>

But that didn't work either.  Any other ideas?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RobertNZanaAuthor Commented:
Actually that did work.

I also had to do a...

<remove name="CoreLab.MySql" /> before the add

Thanks and I hope this is useful to others...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.