No announcements
Found 19974 threads
-
1 Votes
Query database using array(i)
query the mysql database as below: select * from e1 where A = 1 AND B = 2 AND C = 3 AND D = 4 How can I write the query ...Answered | 1 Replies | 696 Views | Created by bangla - Friday, February 6, 2015 4:53 PM | Last reply by Dave Patrick - Friday, February 6, 2015 5:11 PM -
0 Votes
"Attempted to read or write protected memory" Error in Excel 2016 on Query to MySQL DB to pull data (with Macros)
>Below is the error text. I have an Excel Power query to a MySQL database which now crashes Excel when run. It seems that it is not the correctAnswered | 1 Replies | 1034 Views | Created by JTH94 - Thursday, March 24, 2016 6:10 PM | Last reply by Jack Zhai-MSFT - Monday, March 28, 2016 6:38 AM -
0 Votes
Login MySQL Md5 Hash
; 'MySQL query (where to call for information) Dim myAdapter As New ...Unanswered | 3 Replies | 1838 Views | Created by DRads - Tuesday, June 11, 2013 7:24 PM | Last reply by Devon_Nullman - Friday, June 14, 2013 12:17 AM -
0 Votes
Problem with query
get best resulst by posting in mysql forums That being said ANSI based query syntax should work fine in most systems As per that I think you ...Proposed | 1 Replies | 534 Views | Created by Lokisame - Wednesday, October 3, 2018 6:36 PM | Last reply by Visakh16 - Wednesday, October 3, 2018 7:24 PM -
1 Votes
Registering a MySQL data context type in C#
I am having an issue with trying to use a MySQL data base for my Dynamic Data Linq to SQL web site. I have created my class file with DBMetal and included it in the project. But when I run ...Answered | 1 Replies | 6808 Views | Created by gdyck_79 - Monday, November 14, 2011 5:45 AM | Last reply by Wang Huang - Tuesday, November 15, 2011 1:57 PM -
0 Votes
Connection Pooling
: 1.connection string 2.new mysql connection 3.connection open 4.insert ...Unanswered | 1 Replies | 7176 Views | Created by SyntaxError43 - Monday, December 13, 2010 10:30 PM | Last reply by Sheng Jiang 蒋晟 - Tuesday, December 14, 2010 12:05 AM -
0 Votes
got error when i try to insert datetime to MySQL
Convert.ToDateTime(_AllDate).ToString() depend on the date and time formats setting on your computer, it may provide the wrong date string for MySQL query, so,Unanswered | 3 Replies | 909 Views | Created by E_gold - Tuesday, January 21, 2014 6:57 PM | Last reply by Barry Wang - Wednesday, January 22, 2014 11:13 AM -
0 Votes
How i can learn MYSQL in C# ?
Using a MySQL query from C# is the same as with any other DBType: Find the Connection and Command classes associated with MySQL. Use those. It ...Proposed | 6 Replies | 900 Views | Created by KDST - Friday, August 26, 2016 4:26 PM | Last reply by Christopher84 - Sunday, August 28, 2016 11:18 AM -
0 Votes
how to connect remotely C# and Mysql ( HTTP tunneling ) using MySql Connector/Net 5.0.9
Hello, I didnot get your query?Is your MYSQL server in a remote pc from where your net pc is located? Also the url you have provided is not ...Unanswered | 1 Replies | 7620 Views | Created by learnerlearner - Tuesday, October 26, 2010 5:20 AM | Last reply by abhijit.aiem - Thursday, October 28, 2010 8:37 AM -
0 Votes
Developing a database profiler
Hi, I want to develop a database profiler. The basic functionality I want to achieve is to intercept the query that is being fired. I plan to do it for Sybase, MySql and ...Unanswered | 2 Replies | 7516 Views | Created by Asim Patnaik - Monday, December 29, 2008 7:11 AM | Last reply by Asim Patnaik - Tuesday, December 30, 2008 9:44 AM -
0 Votes
How to optimize mysql subquery performance?
significant impact. If you have TOP function in MySQL then you can re-write your sub query as "SELECT top 1 col3 FROM tablename WHERE col1=m.col1 order by ...Proposed | 3 Replies | 8030 Views | Created by Jayaram P - Monday, November 23, 2009 6:52 AM | Last reply by Dharmalinga Raja - Tuesday, November 24, 2009 10:08 AM -
0 Votes
MySQL - C#
Please post questions related to using MySQL in C# in the MySQL forums.Michael Taylor http://www.michaeltaylorp3.netUnanswered | 1 Replies | 806 Views | Created by Markus Freitag - Tuesday, June 19, 2018 4:19 PM | Last reply by CoolDadTx - Tuesday, June 19, 2018 7:57 PM -
1 Votes
Pages slow to load on WSBS2011
Hello. We have a Windows Small Business Server 2011 in our office, running with a MySQL database and serving up PHP pages to access the database. If I ...Answered | 3 Replies | 2202 Views | Created by Swanside - Tuesday, October 2, 2012 12:48 PM | Last reply by James Xiong - Thursday, October 4, 2012 6:54 AM -
0 Votes
Entity framework performance with mysql
Hi, I would really appreciate if anybody can point me to the right direction on how to solve this issue. I have the follow query in entity framework. The ...Unanswered | 1 Replies | 7154 Views | Created by Q Zee - Monday, August 2, 2010 5:59 AM | Last reply by Michael Sun [MSFT] - Tuesday, August 3, 2010 12:32 PM -
0 Votes
c# dbase3 greek charset
=NO;CHARSET=928"; OdbcConnection connection = new OdbcConnection(strAccessConn); // Open the connection, and if open successfully, ...Unanswered | 1 Replies | 975 Views | Created by Vagelis Dermos - Friday, October 17, 2014 8:15 PM | Last reply by Kristin Xie - Monday, October 20, 2014 5:48 AM -
1 Votes
excel 2010 gives wrong result for timefield from MSQuery
when I query our mySQL database for time items I can see the right time (15:03:00) in MSQuery. Importing this data in excel 2010 gives only ...Unanswered | 1 Replies | 12142 Views | Created by alamens - Monday, October 18, 2010 2:39 PM | Last reply by Cor_de_Kruijf - Wednesday, December 29, 2010 7:27 PM -
0 Votes
VBscript - Empty SQL Record Set Value (CM12795), Date Format (CM12574)
MySql 'SQL = "select date_format (invdate,'%d/%m/%y'), taxinvnumber, drname from hfrsched.tblloadschedule where invnumber = '" + INVOICENUMBER + "'" ...Unanswered | 3 Replies | 1028 Views | Created by GregoryLock - Monday, August 19, 2013 1:24 PM | Last reply by jrv - Monday, August 19, 2013 7:05 PM -
0 Votes
MySQL Command Line will not insert into a table.
Query OK, 1 row affected (0.00 sec) mysql>describe mapdata; Field ...Unanswered | 2 Replies | 1420 Views | Created by dndeed - Thursday, August 22, 2013 7:45 PM | Last reply by Anna Cc - Friday, August 23, 2013 3:18 AM -
0 Votes
Getting the error “A socket operation was attempted to an unreachable network 0.0.12.234:3306”
Entity Framework MySql Server 5.0 MySql Connector 6.6.5 The same App works well on "Windows Server 2003 R2 - 64-bit" machine. ...Unanswered | 1 Replies | 1427 Views | Created by ZaheerJimmy - Tuesday, May 28, 2013 11:28 AM | Last reply by Amanda Zhu - Wednesday, May 29, 2013 6:41 AM -
0 Votes
copy local access table to remote mysql db programmatically
Hi, Welcome to MSDN. I am afraid that this is not the proper forum for this issue sicne it is mainly related to the query about Access and ...Unanswered | 1 Replies | 780 Views | Created by DesignLoverCodeHater - Friday, December 27, 2013 1:43 PM | Last reply by Carl Cai - Monday, December 30, 2013 4:55 AM
No announcements