Devart Forums

The latest SDAC build, 4.50.0.39.
Trying to use SQL 2008 client produces
---------------------------
Error
---------------------------
Unspecified error
---------------------------
OK
---------------------------

To duplicate:
Uninstall SQL 2005 client.
Have SQL 2008 client installed only, either with local SQL 2008 server or trying to connect to remote SQL 2008 Server

program TestSDAC_snac;

{$APPTYPE CONSOLE}

{
CREATE PROCEDURE dbo.spAPP_DoNothing @foo datetime
AS
go
}

uses
SysUtils, MSAccess, Activex, OLEDBAccess;

var
conn: TMSConnection;
proc: TMSStoredProc;
begin
CoInitialize(nil);

conn := TMSConnection.Create(nil);
conn.Server := 'vsic64';
conn.Database := 'inSIght_4_4';
conn.Authentication := auWindows;
conn.Open;

proc := TMSStoredProc.Create(nil);
try
proc.Connection := conn;
proc.StoredProcName := 'spAPP_DoNothing';
proc.Prepare;
proc.ParamByName('foo').AsDate := Now;

proc.Open;

finally FreeAndNil(proc); end;

end.

Please fix this.
thanks

Please specify the exact moment when the error is raised.

It happens when the “proc.Open” is called

This problem is caused by some peculiarities of SQL Server 2008. We are investigating the problem. As soon as we solve the problem we will let you know.

Any revelations on this issue? SDAC 4.7 does not address this issue, tested.

Please check if the latest SDAC build (4.70.0.42) solves the problem.

that specified build does not solve the problem.

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next SDAC build.