Delphi问题还是ADO与ole驱动问题,请大家跟进
在Delphi程序中使用ADO控件遇到以下问题,程序与数据库的连接provider使用SQLOLEDB.1,编译好的程序在一台机器上能顺利连接到指定的数据库服务器上,而在另一台机器上不能,不同的是,能连的机器ADO版本为2.62而不能连的ADO版本是2.60(编译机器是2.62版)。在另一台ADO版本为2.70的机器上却出现莫名其妙的错误,或者是运行一段时间后出现异常说非法访问MSADO15.dll的某一地址。我在其他网站也看到其他的人也和我遇到差不多的问题,下面是我在看到另一位反映的问题:
TADOStoredProcedure error
From: IanJ (ijohansson@bigfoot.com)
Date: Wed Feb 27 2002 - 17:29:35 CET
Next message: Raymond Knapp, Jr.: "ADOQuery"
Previous message: Mike Collier: "Re: Problem to connect with ADO to ODBC"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Hi,
D5 (latest update, latest ADO update), Windows2000 Professional
I have a TADOStoredProcedure that executes a SQL Server 6.5 stored procedure
or at least it did until I upgraded to MDAC2.7. I am now getting the error
message '...[Microsoft ODBC SQL Server Driver] Optional feature not
implemented...' when the Stored procedure tries to open. The code is
detailed below (I thought it might have had something to do with
ParamByName('...') so I changed it to Parameters[Index] but the error
remains the same). As I've said, this worked fine until MDAC 2.7...
WhereSP.Close;
WhereSP.Parameters[1].Value := CurrData.FieldByName('misc3').AsString;
WhereSP.Parameters[2].Value :=
CurrData.FieldByName('rmlcreatedate').AsDateTime;
WhereSP.Open;
ADO queries using the same ADO connection all work OK but I can't get this
stored procedure to work. I've tried connecting using the OLE DB for SQL
Server but the error remains.
Hope you can help
Ian
到底是ADO驱动的问题,还是Delphi5的问题呢?请各位发表高见