mySQL Connector with TableAdapters = no go!

[RFH Customer: Gilgamesh]

Hello RedFox people! hope you can give me a few pointers on using a mySQL database with .NET DataSets and TableAdapters

I've got all my code running quite happily here, using version 5.2.2.0 of the connector to access local mySQL or live mySQL on your Hydrogen box but when I try to deploy my code on the live server it won't run, I get a Parser Error like this:

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="DSPoll" targetNamespace="http://tempuri.org/DSPoll.xsd" xmlns:mstns="http://tempuri.org/DSPoll.xsd" xmlns="http://tempuri.org/DSPoll.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>

Intensive Googling tells me that the mySQL connector sometimes does this when a different version is used on live on development boxes, any chance you could tell me which version of the Connector is installed?

[RFH Customer: Gilgamesh]

Fixed my own problem!

The short answer is to deploy the website as a precompiled web instead of uploading all the source code.