Dbexpress Error 0x0009
dbexpress, MS SQL 2000. I am trying to convert an existing app from BDE/Interbase to dbexpress/MS SQL 2000. I've searched through the newsgroups and tried all the suggestions by I'm still stumped. I have several dbexpress datasets with a query like: SELECT * from MyTable where MyTablesField = :MyParam The MyTablesField and MyParam are of Integer types. (Those aren't the real names :) ) The errors are reproducible by trying to run the query via the client or by trying to add fields to the fields editor for the dataset. These are errors I get: "dbExpress Error: [0x0009]: Invalid Parameter SQL-Server Error: Multiple-Step OLE-DB operation generated errors. Check OLE-DB status value, if available. No work was done." or "dbExpress Error: [0x0009]: Invalid Parameter" or "SQL Server Error: SQL State HY000, SQL Error Code: 0 Invalid input parameter values. Check the status values for errors" I've read a lot of postings regarding a bug in the MS driver. Here are the things I have tried to solve this. 1. Installed the Delphi 7 service pack. It seems to have installed fine except that when I check the Delphi Help..About.., it says version 7.0 and not 7.1. 2. Installed the service pack 3a for MS SQL 2000 that should have the latest MDAC components and drivers. 3. I tried using core labs trial version of the driver and connection component. 4. I tried the Ramesh driver on the BDN download site. 5. I have gone over the table definition to see if there could be other issues. The field that I am querying on is defined in MS SQL as an integer value and has been indexed. 7. I have fiddled with the query to search by other fields in the table and it works just fine. 8. I have checked other queries in my application and all of the ones that look up based on an integer fields have the same error message. None of the above seems to have worked. What could I be missing? Any suggestions wou
FoxPro (Native Driver) General Informix InterBase Local Drivers (Paradox & dBASE) MS-SQL ODBC OLE-DB Oracle Oracle 8 Paradox Sybase You are not logged in. Help Print Public Report Report From: Delphi-BCB/Database/Drivers/MS-SQL [ Add a report in this area ] Report #: 3689 Status: Closed Can't use Integer Parameters with dbExpress / SQL Server Project:Delphi Build #: 4.453 Version: 7.0 Submitted By: Kevin Davidson Report Type: Crash / Data loss / Total failure Date Reported: 3/5/2003 2:15:26 PM Severity: Critical / Show Stopper Last Updated: 3/20/2012 2:24:39 http://www.delphigroups.info/2/12/1062383.html AM Platform: All versions Internal Tracking #: 143510 Resolution: Cannot Fix(Resolution Comments) Resolved in Build: : 7.0.8.1 Duplicate of:None Voting and Rating Overall Rating: (5 Total Ratings) 4.60 out of 5 Total Votes: 9 Description Using an integer as a parameter in a Query causes various error messages, including: dbExpress Error: Invalid Parameter and SQL State: HY000, SQL http://qc.embarcadero.com/wc/qcmain.aspx?d=3689 Error Code: 0 Invalid input parameters. Check the status valur for detail. Note this is NOT a master/detail query as described in the known problem in the readme.txt for Delphi 7 Steps to Reproduce: New Application, D7 Ent Build 4.453, SQL Server dbExpress Driver Update installed. Verified that only one copy of dbexpmss.dll exists on the workstation, and it is dated: 10/10/2002 7:01AM file version 7.0.2.113 Drop TSQLConnection and TSQLDataSet on form. Set Connection to connect to Microsoft SQL Server 7.0 database Set Connected to True. Create a SQL Server table, CTFILE,with an Integer primary key called PATIENT_NO. Using the CommandText Editor in the IDE, set the DataSet's Command Text property to: select PATIENT_NO from CTFILE where PATIENT_NO = :patno Open the Params property of the DataSet. The "patno" param ls listed. Set its properties as follows: DataType: ftInteger Leave others as default including Value.Type as Unassigned Right-click on the DataSet to bring up the Fields Editor Right Click on the Fields Editor and select "Add Fields" The first time you do this, you get : SQL State: HY000, SQL Error Code: 0 Inva
Danish English French German German (Informal) Italian Portuguese (Brazil) Swedish Turkish Unread posts dbexpress error Unreplied threads Threads of the last 24 hours Advanced Search Advanced Search Round Solutions M2M and wireless Support Forum Forumwcf.header.menu.pageMenuItem6 The dbexpress error 0x0009 link you are trying to reach is no longer available or is invalid. Help Legal Notice Terms of use Change style Round Solutions WoltLab Basic WoltLab Blue Sunrise Change style ----------------------- Round Solutions WoltLab Basic WoltLab Blue Sunrise Thursday, October 6th 2016, 5:18pm Go to the top of the page Forum Software: Burning Board 3.1.8, developed by WoltLab GmbH Remember me?