VWD 2008 Express Error 42000 MySQL ODBC 5.1 Driver mysqld-5.0.22 error in SQL Syntax

This is driving me a bit mad now trying to get this fixed.

 Have downloaded and install the mysql connector 5.2.0, have managed to connect fine to the database using ODBC, Can connect ok to the database in Access 2008 and see data.

In Visual Web Developer Express 2008 have managed to connect to the database ok, can see all the tables there. However when adding the SqlDataSource and configure, will connect ok,

However in the configure the Select Statement it doesn't retreive any of the columns in the specify columns from a table or view.

 If I do a specify a customer SQL Statement or stored procedure then I can select all the tables, if I do a test query it brings back all the data.

 Any ideas why the default option just gives the following error message?

Error 42000 MySQL ODBC 5.1 Driver mysqld-5.0.22 You have an error in your SQL Syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[rpt_teamstanding]' at line 1

The code from the page is as follows

    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:tuestriosmysql-conn %>"
        ProviderName="<%$ ConnectionStrings:tuestriosmysql-conn.ProviderName %>"
        SelectCommand="SELECT * FROM [rpt_teamstanding]"></asp:SqlDataSource>

Thanks in advance for any help

Stephen


 

0
Bob
6/3/2008 5:14:52 PM
asp.net.mysql 1929 articles. 0 followers. Follow

4 Replies
903 Views

Similar Articles

[PageSpeed] 2

Try it without the [square] brackets.


Steve Wellens

My blog
0
SGWellens
6/3/2008 6:13:01 PM

Thanks for that the code now works and displays properly in IE & Firefox, however any ideas now to get the auto wizard working properly?

 

Stephen 

0
Bob
6/3/2008 8:42:33 PM

Try posting the question about how to avoid square brackets in this forum:

http://forums.asp.net/1125.aspx

Hopefully the esteemed guru Mikhail Arkhipov, will response.


Steve Wellens

My blog
0
SGWellens
6/4/2008 2:35:06 PM

In addition to this, mysql uses the ` character to enclose reserved names. not the usual [bracket]. so queries could look like

SELECT `table_name`.`column_name` FROM `table_name`;


Happy coding!

 

Cheers,

CLIPER 


------------------------------------------------
Believe nothing, no matter where you read it, or who said it, no matter if I have said it, unless it agrees with your own reason and your own commonsense. ---Buddha (563BC-483BC)
0
CLIPER
6/4/2008 2:52:42 PM
Reply:

Similar Artilces:

ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP Address of the server'(10048) ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP of the server' (10
Hi, I am randomly getting the following error message in my application. ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP Address of the server'(10048) ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP of the server' (10048) I am using .Net 2.0 with VS2005 having ODBC 3.51.14 Driver.  Can any body point out the core reasons of the above error message? Thanks. Nouman Khawaja. I do have the same problem, help me out. Thanks  If the going seems easy, You are going DownHill... When I was writing ...

Errors using hotmail after latest major update: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.8) Gecko/20061025 Firefox/1.5.0.8
Name: William Green Email: wjgreen_at_hotmail.com Product: Firefox Summary: Errors using hotmail after latest major update: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.8) Gecko/20061025 Firefox/1.5.0.8 Comments: After I installed the latest update and rebooted, every time I go to open an email in hotmail.com (this does NOT occur in other email sites I use), I get the following three Alert messages that I have to click through to get to my email: [object XPCNativeWrapper [object HTMLBodyElement]] [object XPCNativeWrapper [object HTMLScriptElement]] TypeError: d...

ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-4.0.24-nt]
Hi Frndz,why am I getting this error on deploying it? It runs fine locally. what can be the problem on server side? is the version problem? pl elaborate it. what steps should i take to avoid this kind of error again in future deployments???ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-4.0.24-nt]You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '('2/5/2008','%m/%d/%Y') and call_end <= (str_to_date('5/15/2008ThanksPrashant    i think you are using MySql w...

HMC 4.5 Using SQL 2008 running Windows 2008 64-bit error .Net 1.1 missing
HelloTrying to build hosted exchange 2007 4.5 in my lab.As my sql server i;m using non-clustered SQL 2008 64-bit running on Windows 2008 64-bit. Everything is going well until the step W03-DWSPV.31 deploying MPS Core platform, specifically step MPF Audit and Recovery to add new server. According to the manual i should be pointing to my SQL 2008 server which i did except that it gives me an error: Server abdc missing required .NET version 1.1 runtime and it will not proceed. I downloaded net 1.1 and installed it and rebooted the box, but still te same error shows up on the MPS server. Is wind...

FATAL ERROR: ERROR 0 while starting database SQL Anywhere Server 5.5.0.4
hi, after some disk problems, one of my databases won't start and after "Starting checkpoint" and before "Finished checkpoint" produce dialog box with folowing error: FATAL ERROR: Error 0. database consist of 3 files: db1.db - 1MB - contains table definitions, procedures db2.db - 1,3GB (DBSPACE) contains tables datas + indexes db3.db - 3,4GB (DBSPACE) contains tables datas + indexes no LOG file accidently one of a tables in db2.db has(had) 2,8 milion rows <-- can this be a problem ?, three days ago everything was running fine ==========...

5.5.04 ODBC Driver Error ( Memory allocation error )
Hi all, I have upgraded to SQL Anywhere 5.5.04. My app is accessing the database though ODBC 3.0. With 5.5.03 it worked well, however in 5.5.04 it is now giving me an ODBC driver error "Memory Allocation Error" when I insert data into one of the tables ( not all tables ) The table does have a blob, but so do the others that do work. This problem has been tested on a number of different machines and is always the same. Any suggestions ( is it a new but in the ODBC driver 5.5.04? ) Thanks, Wayne born2code@cablelan.net Are you possibly trying to load more than 32K int...

mysql 5.0.24 gives error "Can't find messagefile '\MYSQL\bin/\MYSQL\bin/sys:/mysql/share/english/errmsg.sys'"
Hi All I've just tried to do a small mysql update to 5.0.24, but it gives me an error: Can't find messagefile '\MYSQL\bin/\MYSQL \bin/sys:/mysql/share/english/errmsg.sys' I've tried adding basedir=sys:/mysql to the my.cnf: [mysqld] default-character-set=latin1 language=english bind-address=0.0.0.0 port=3306 datadir=web:/mysqldb basedir=sys:/mysql skip-locking skip-innodb but it didn't do any difference, does anybody have an idea to this? NetwareGuy, It appears that in the past few days you have not received a response to your posting. That co...

Re: mysql 5.0.24 gives error "Can't find messagefile '\MYSQL\bin/\MYSQL\bin/sys:/mysql/share/english/errmsg.sys'"
Is there a solution for this? Netware Guy posted it on 05 Aug 06. Thanks. ...

Firefox 1.5.0.2 / 1.5.0.3 build errors
I've been trying all day to build Firefox 1.5.0.2 and 1.5.0.3 under Windows XP Pro, using a fresh install of cygwin, and MS Visual Studio 2003 (i.e., VC7.1). I've followed all the steps on the web site, I've set my environment variables appropriately, and no matter what I do, I end up with an error in c:\mozilla\dist\include\string\nsString.h(55): error C2006: '#include' : expected a filename, found 'identifier'. When I look at the line in question, it's "# include NEW_H"--which is obviously invalid. The only reference I've fo...

MySQL Community Server 5.1.54 on openSUSE 11.1 (SLES 11 sp1) Error 2003 /var/lib/mysql.sock
Yesterday MySQL stopped working on my server. I can't connect remotely, at the command line or locally. I've tried using localhost which returns the error can't create /var/lib/mysql/mysql.sock I've tried using 127.0.0.1 which returns the error 2003 (Can't connect to MySQL server on 127.0.0.1 (111) I've tried installing MySQL 5.0.67 and removing MySQL Community Server. I've also tried updating to 5.1.30 and no matter what I do I can't establish a connection. When I check restart the server (sudo /etc/init.d/mysql restart) The server shuts dow...

Microsoft.Data.Odbc.OdbcException: ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-3.23.54]
Hello, My application is running online. At times it throws following error, and in the second attempt it starts working just fine. It happens only once in a while. The query error pointing to as erroneous is simple select and where statement, and I am sure nothing is wrong with that, as the query runs fine normally. Waitinf for replies!!! Server Error in '/phaseI' Application. -------------------------------------------------------------------------------- ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-3.23.54]You have an error in your SQL syntax near ''shakil'' at line 1 ...

Umlaut error with 2.22.1 and MySQL 5
Hi, since the migration of bugzilla to a new server (before: bugzilla 2.22.1 with MySQL 5.0.21 and Apache 1.3.x, now bugzilla 2.22.1, MySQL 5.0.30 and Apache 2.2.x) on some pages German characters like Umlaute (�, �, �) or � are not displayed correctly on some pages. E.g. the bug lists are ok, but if I click on a bug and show_bug.cgi loads, all special characters are displayed as a question mark. Some weeks ago I recognized the same behavior as I did some testing with the utf8 parameter, I had to turn it off again to see the bugs with the correct char set. But this was not th...

SQL Error after migrating from 5.5.05 to 8.0.1.3015
Environment Prior to migration: PB - 6.5.1 SQL Anywhere - 5.5.05 Build #2509 Environment After migration: PB - 8.0.2.9506 ASA - 8.0.1.3015 A datawindow when retrieved through PowerScript gives the following error : Select error: SQLSTATE = 01004 [Sybase][ODBC Driver]Data truncated DB-ErrorCode=2 SqlSyntax=SELECT "n_td_intt"."intt_amt", "n_td_intt"."tds_amt", "n_td_intt"."cr_intt2_cd", "n_td_intt"."cr_intt2_ac_cd", "n_td_intt"."cr_intt2_br_cd", "...

5.5.0.4 on Novell 5.1 with time sync error
After installing Novell 5.1 I cannot connect to the database, receive server not found. TCPIP ping successful Dbclienw.... -xtcpip{host=<<serverip>>;myip;dobroadcast=no} unsuccessful Receiving Time sync error on server sporadically, will be in sync then out. Data runs fine on NT. Any suggestions? Gregg First off, I assume that you have a build of 5504 greater than 1929 right? When the database server starts up, in the server console window, can you check and see whether the TCP/IP link starts up sucessfully? Look for something like : Trying to start TCP/IP L...

Web resources about - VWD 2008 Express Error 42000 MySQL ODBC 5.1 Driver mysqld-5.0.22 error in SQL Syntax - asp.net.mysql

Resources last updated: 12/15/2015 5:26:00 PM