重发！请大家指点一下里边的一段程序为什么执行不下去。

[freeghost]

CDatabase database;


database.Open(NULL,false,false,_T(ODBC;DRIVER={SQL Server};Server=Abc;DATABASE=zcg;UID=sa;PWD=),true);
//确定以上连接数据库可以成功

CRecordset recordset(&database);
recordset.Open(AFX_DB_USE_DEFAULT_TYPE,"select * from printdata order by a1",CRecordset::readOnly);
...
...

请问这一段程序为什么在执行recordset.open时一直停在那里没有返回？该如何解决？

[freeghost]

"select * from printdata order by a1"
这一句在SQL Client中执行是可以通过的。并且有结果返回，而且如果这一句有问题地话在C里也会报错的。

[freeghost]

真的没人知道吗？

[guoduning]

在“select * from printdata order by a1”中不能有多余的空格。

变为 _T"select * from printdata order by a1"
还有可能是一个SQL的BUG：
BUG: Double Brackets in SQL Statements with MFC May Cause Error

Q257171


--------------------------------------------------------------------------------
The information in this article applies to:

The Microsoft Foundation Classes (MFC), used with:
Microsoft Visual C++, 32-bit Editions, version 6.0

--------------------------------------------------------------------------------


SYMPTOMS
An error may occur when, in order to preserve a set of square brackets, you add an extra set of brackets to an SQL statement. For example:



Select * from myview where [[tableA.field1]]
The error that is returned depends on which Open Database Connectivity (ODBC) driver is used and on the structure of the SQL statement, but can include a syntax error, an invalid table or field name, or a variety of other problems.



CAUSE
The Microsoft Foundation Classes (MFC) ODBC function CDatabase::ReplaceBrackets replaces square brackets in an SQL statement with a driver-dependent quote character (SQL_IDENTIFIER_QUOTE_CHAR). The CDatabase::ReplaceBrackets function, which is called by the CRecordset::Open function, is used frequently.

When double brackets are replaced with single brackets, the string length changes but the CDatabase::ReplaceBrackets function does not make the necessary adjustment. The SQL statement that is passed to the driver contains extra characters at the end of the string, which can cause errors.




WORKAROUND
Pad the end of your SQL statement with one blank space for each double bracket used. For example, in the following statement

"Select * from myview where [[tableA.field1]]"
place two spaces at the end of the statement:

"Select * from myview where [[tableA.field1]] "



STATUS
Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article.



MORE INFORMATION

Steps to Reproduce Behavior
Create a table in a Microsoft SQL Server database that uses a keyword for a field name (for instance "key"). If the Data Source Name (DSN) setting or connection string has quoted identifiers turned off, double brackets are needed. (Note that this is just an example; there are a number of other situations where double brackets are needed as well.)


Create an MFC ODBC application with a recordset based on this new table and make the following call:

keyRS.Open(AFX_DB_USE_DEFAULT_TYPE, "Select [[key]] from TableA");
This call produces the following error:


Invalid object name 'TableAeA'.
Statement(s) could not be prepared.
Set a breakpoint on the call to the CDatabase::ReplaceBrackets function inside of the CRecordset::BuildSQL function. You will see that before the call, m_strSQL contains the following

Select [[key]] from TableA
whereas after the call returns, m_strSQL contains the following:

Select [key] from TableAeA
The CDatabase::ReplaceBrackets function removed the extra set of brackets but didn't correctly terminate the string. The null terminator remains in its original position, which makes the table name invalid.



Additional query words: escape character square brace braces

[freeghost]

我把这一句改成：
recordset.Open(CRecordset::snapshot,_T("select * from printdata"),CRecordset::readOnly);
还是不行呀，到这里后就不反回一直在等。

[freeghost]

还是不行呀。