Is it possible to execute big SQL query in Hibernate?

MS SQL query causes vague error message?

• I am converting an ASP script to a PHP script. The current script runs on an IIS 6.0 server running ASP.NET and PHP 4.4.8. The script connects to a database in the form of a .MDB file. I can successfully connect to the database using the PHP method odbc_connect, but I cannot execute the queries that the original script used. I get the following vague error message: SQL error: [Microsoft][ODBC Microsoft Access Driver] Unknown, SQL state 37000 in SQLExecDirect The query I'm trying to perform is something like the following: select name from table; I can, however, execute the more generic "SELECT * FROM table" query just fine (using odbc_exec). By getting the results of that query, I was able to verify that the table actually has a column called "name". So what's the problem?

• Answer:

  "Name" is a restricted word in Microsoft Access and SQL Server. Try changing your query to: SELECT [Name] FROM Table Note that restricted words should be enclosed in [] brackets. [EDIT] Try to install the latest release of the FastCGI Handler for IIS 6.0 http://forums.iis.net/1103.aspx