"Unspecified Error" error with SQL 2008
"Unspecified Error" error with SQL 2008
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
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