Board index » delphi » SQL Server param query problem

shoem...@itsoptimum.com

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

SQL Server param query problem

I'm having problems with parameterized queries to SQL Server through ODBC.
Whenever I try to open the query (SELECT * FROM ACCOUNT WHERE ACCOUNTID =
:myAccountID), I get:

  Operation not applicable

The SQL Server ODBC driver is the latest at Ver. 3.50.0305 as are Delphi
(3.02) and the BDE (4.51).  SQL Monitor is not showing the parameter, it
doesn't appear anything shows on the ODBC trace, and nothing at all is getting
to SQL Server (SQL Trace).

The same works fine with Solid Server and Access ODBC drivers, in addition to
native SQL Server, Access and Interbase.

Would this be a BDE issue?

Thanks.

Harry Shoemaker
Optimum Quality Grains, L.L.C.

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/   Now offering spam-free web-based newsreading

 
Kevin McCar

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:SQL Server param query problem


You might try going back to version 2.65.0251 of the SQL Server ODBC
driver.  I have had problems with the new SQL Server ODBC driver and
Delphi.

Kevin McCarty
McCarty Consulting Systems
kevinmcca...@usa.net

Quote
On Wed, 25 Mar 1998 10:24:19 -0600, shoem...@itsoptimum.com wrote:
>I'm having problems with parameterized queries to SQL Server through ODBC.
>Whenever I try to open the query (SELECT * FROM ACCOUNT WHERE ACCOUNTID =
>:myAccountID), I get:

>  Operation not applicable

>The SQL Server ODBC driver is the latest at Ver. 3.50.0305 as are Delphi
>(3.02) and the BDE (4.51).  SQL Monitor is not showing the parameter, it
>doesn't appear anything shows on the ODBC trace, and nothing at all is getting
>to SQL Server (SQL Trace).

>The same works fine with Solid Server and Access ODBC drivers, in addition to
>native SQL Server, Access and Interbase.

>Would this be a BDE issue?

>Thanks.

>Harry Shoemaker
>Optimum Quality Grains, L.L.C.

>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/   Now offering spam-free web-based newsreading

Other Threads

1. sql query with a param using %param%

2. param SQL return no record using SQL server

3. How to use the SQL-Monitor/Param-Query does not work

4. Long String Param value and SQL Server text field

5. Query parameters problem ORDER BY :param

6. Problem querying a linked SQL Server through ADO

7. MS SQL Server problem with linked queries

8. Problems while executing queries in SQL Server 2000

9. Problem querying a linked SQL Server through ADO

10. Problems running parametrized query with LIKE operator against SQL server nvarchar datatype