2011. 10. 21. 08:33
출처: http://www.youtube.com/watch?v=nQvWNAldA1E&feature=related
2011. 10. 21. 08:22
We faced the same problem with VS 2005 typed datasets.
Error:
Generated SELECT statement.
Error in WHERE clause near '@'
Unable to parse query text
The problem is the syntax of the datasource used for query.
For SQL Server versions, you should use @parametername syntax to define a parameter.
However, for Access database, your should put ? for parameter definition.
Example;
SQL Server version:
SELECT *
FROM Projeler
WHERE (proje_id = @projectID)
Ms Access version and MySql:
SELECT *
FROM Projeler
WHERE (proje_id = ?)
출처: http://social.msdn.microsoft.com/forums/en-US/Vsexpressvb/thread/0c17511e-38a8-4040-b400-ac8eb103bd07/
2011. 10. 21. 08:05
Crystal Report 작성법..
mysql 연결하려면 ODBC 사용하면 됨..
mysql 연결하려면 ODBC 사용하면 됨..
mysql-connector-odbc-5.1.9-win32.msi
http://dev.mysql.com/downloads/connector/odbc/2011. 10. 21. 07:19
출처: http://www.youtube.com/watch?v=OJfYSZzZOP8&feature=related
2011. 10. 21. 07:18
출처: http://www.youtube.com/watch?v=4kBXLv4h2ig&feature=related
