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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

import from mysql problem

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


I'm using SQL Management Studio 2008 to import a mysql dump. The dump was created with phpmyadmin with mssql compatibility turned on.This is what the dump looks like:

INSERT INTO frequencies (tx, rx, `mode`, description, `type`, location, `user`, modified, added) VALUES(163.11250, '', 'Nfm', test trunked radio system control. Watertower Cobh', 'Garda', 'Cork', 'Mike', '2005-02-03 23:00:00', '2005-03-15 10:38:30');

When I execute that sql I get an error

Msg 102, Level 15, State 1, Line 21

Incorrect syntax near '`'.


It looks like the syntax is wrong.Can anyone point me in the right direction. Thanks.

View Complete Post

More Related Resource Links

MySql.Data assembly problem



I added refernece MySql.Data to my project. My web.config looks like that:

<?xml version="1.0"?>
                <add assembly="MySql.Data, Version=, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>

But when in ServerExplorer I try "Add Connection..." I can't find "MySql Database" in the "Choose Data Source" dialog box?

What the problem can be?

EF 4: Function Import problem with Stored Procedures


I have the following SP which includes a temp table:

 DECLARE @pos int

--create table to hold parsed values
CREATE TABLE #list (val varchar

Import contacts on Mysql

Hello,   I am in the process of transferring data and contacts onto a Mysql database. I have had some help and am trying to get a software solution.   So main features would be to migrate large amounts of data and contacts every day. The migration would be done manually.  Thanks for the help.

Connection Problem with mysql and asp.net

i'm using this string to connect with mysql and asp.net but still agot the connection problem. the connection is not going to open............. i got the following error....... ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified please help me come from this problem "DRIVER={MySQL ODBC 3.51 Driver};DSN=sql4;SERVER=;DATABASE=myppw; UID=kraft; PASSWORD=myka; OPTION=3"

Problem with import using SharePoint Content Deployment and Migration API

Hi all, I have a requirement to develop a web part to copy folder (With sub folders and files) between document libraries of different site collection. I am using SharePoint Content Deployment and Migration API for this project and getting following error on import.   Does anyone have any idea what is the meaning of the following error?     I will appreciate if anyone can point me the direction to get rid of this error..   Thank you in advance for your valuable time and effort.   -MMRAhman    Error:   “Cannot complete this action. Please try again.”   stackTrace from log :   [8/1/2010 10:54:24 PM]: Progress: Starting content import. [8/1/2010 10:54:24 PM]: Progress: De-Serializing Objects to Database. [8/1/2010 10:54:24 PM]: Progress: Importing Folder /sites/projects/mmr/Documents/Forms/Document. [8/1/2010 10:54:24 PM]: Progress: Importing Folder /sites/projects/mmr/Documents/Forms/Folder. [8/1/2010 10:54:24 PM]: FatalError: Cannot complete this action.   Please try again.    at Microsoft.SharePoint.Library.SPRequest.UpdateField(String bstrUrl, String bstrListName, String bstrXML)    at Microsoft.SharePoint.SPField.set_SchemaXml(String value)    at Microsoft.SharePoint.Deployment.ContentTypeSerializer.UpdateContentTypeFields(SPContentType sourceContentType, SPContentType targe

Problem Linking SQL 2008 with MySQL

Hi, Iam trying to add a Linked Server in sql2008 with a MySQL database. My OS is Windows SERVER 2008 64bit. My Odbc connection works just fine using mysql odbc connector 5.1 The Problem is that i cannot  establish the new linked server connection . I receive the following message : Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "B2B1". (.Net SqlClient Data Provider) Any Ideas? Thanks in advance  

data type problem in import data from excel file


Dear All,

I am importing the data from excel file using following code.

connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(strFolderFileName) & ";Extended Properties=HTML Import;"
                conn = New OleDbConnection(connstr)
                Dim strSQL As String = "SELECT * FROM [" & strWorkSheetName & "]"

                Dim cmd As New OleDbCommand(strSQL, conn)

                Dim da As New OleDbDataAdapter(cmd)

Now the problem is if a coulmn vlaue start with a number value like "15" then the other string value like "W15" in that column is ignored in the datatable.

eg. The excel column value     Column1


Export MySQL and import into CRM


I'd like to export an non-MS MySQL database and re-import it into CRM but I'd like to keep the relationships (foreign keys) between tables in the MySQL database in the CRM system. Does anyone know the best way to do such a thing?


MySql connector/net problem


I have a asp.net 4.0 site that can't connect to my hosting company's Mysql server

im using Mysql connector/net 6.3.4 also installed on host server.
i can run the site from my dev server or from my web Hosts server. as long as the connection string host name points to my dev mysql server ....all is good work great.
i have also tried using another company's hosted mysql server... everything works good.

all three databases were created from same dump file...

all three Mysql servers are v5

It would seem to me that my web site code is good.

whenever i change the server host name in the web.config file back to my hosting company's mqsql server i get this error.

This is the error:
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Unable to initialize provider.  Missing or incorrect schema.

Source Error:

Line 50:         <add applicationName="/" name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider" />
Line 51:      &nbs

Site Definition Import 2007 - 2010 - navbarlink problem



I have a problem to import a site definition from 2007 to 2010.

In this site definition i have navbar and navbarlink.

In 2007 i could use Resources in navbarlink Url like this :

<NavBar Name="$Resources:CFS,RootSiteDef_Nav_Request;" Url="$Resources:core,lists_Folder;/$Resources:CFS,RootSiteDef_Nav_Request;/" ID="1005">
   <NavBarLink Name="$Resources:CFS,RootSiteDef_Nav_Request_ByStatus;" Url

problem with import from CSV in SSIS


Hi all,

i have a strange problem, i am trying to create a import package to import data from a CSV file.

When I create a flat file source and take a look at the preview I see that the fields are mixed up. Some fields are ok, but quet a few arent.

When I open the CSV in excel or a other program it looks good, all rows are ok.

When i import the CSV in access it is also ok. So I'm a bit confused where the problem lies.

Does anyone have a idea?


all the settings are standard.

The strangest thing is that when i replace al the semicolons to for instance tab's the problem keeps.





Import from excel into mysql in ASP.net C# ?


Hi friends ,

Can you pls help how to do import an excel file into my MYSQL database in ASP.net C# ?

Pls help and thanks a lot ...



Profile synchronization problem - can successfully import single users but not from a group - can yo


I can successfully import a single user into SharePoint 2010 from AD (proves settings permissions are correct) and the number of user profiles increases and I can locate the user including profile data from active Directory. But when I try to import an Active Directory global security group no users get migrated. In fact the single users profile gets deleted.

Can somebody explain whether it is possible to migrate users into SharePoint 2010 from with security groups in Active Directory?

Also when I retried to import the group of users it deleted the single user that I had successfully imported, I didn’t think this was possible, I ran an incremental synchronization, i need to import roughly 2000 users and was going to do it in stages to make sure all users were imported but if the process can remove users then each sync run could be adding users and removing users, how will I ever keep track?

Below is the synchronization run report, are there logs files that could give me more information?

SQL SERVER 2005 - problem with Import Wizard


I am importing some tables from a MS Access to SQL server 2005 and I am using the import wizard but I am not seeing the data mapping tool, I need to have the ability to delete the data from the destination server and allow the identity.  I had done many times in the past, but I just got a new computer and I installed the SQL server 2005 workstation in it.  Is a setting that I need to change? that will allow me to have the data mapping.

Thanks a lot


Problem in fetching data from Mysql



    I want to fetch data from mysql database to asp.net dropdown control. How can I do this.

I can fetch data from ms sql server to asp.net page. Please help me to fetch data from mysql database.


problem to connect mysql remote db


hi friends,

i am getting problem to connect to my remote sqlserver database..

i have connection string as follows


add name="ConnStr" connectionString="DRIVER={MySQL ODBC 3.51 Driver};SERVER=;PORT=3306;DATABASE=mydb name;UID=username;PASSWORD=mypasswd;OPTION=3;" />


i am giving all information correctly..

Mysql - Data instert/update problem


Hi all,

I developed a web site more then a year ago with .net2.0/c#/mssql 2005. it works fine but i was asked to replace mssql with mysql.

I wrote a class to complete data access works (unfortunately, I didnt use nhibernate or other data access tools :((

I edited the class to use System.Data.Odbc objects rather than System.Data.SqlClient.

It works fine in selecting data but not manipulating data. when i try to insert new data it adds null data for all fields in the table.

in debug mode, i noticed that it might be caused by OdbcParameter but not sure.

any idea??

thanks in advance

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