Hello,
Server PC:
Windows XP Pro
MSSQL 2005 Express
SDAC 4.10.0.9 Trial for Delphi7
Client PC:
Windows Vista Home
TEST1:
var
c :TMSConnection;
begin
c := TMSConnection.Create(nil);
c.ConnectString := 'Provider=SQLOLEDB.1;User ID=sa;Password=1881;Data Source=theblacksea\SQLEXPRESS;Initial Catalog=HTP2;Persist Security Info=True';
try
c.Open;
except
on E: Exception do
ShowMessage(e.Message);
end;
TEST2:
var
c :TMSConnection;
begin
c := TMSConnection.Create(nil);
c.Username := 'sa';
c.Password := '1881';
c.Server := 'theblacksea\SQLEXPRESS';
c.Database := 'HTP2'';
try
c.Open;
except
on E: Exception do
ShowMessage(e.Message);
end;
ERROR MESSAGE ON CLIENT PC : Wrong MDAC Version. Download latest MDAC Version.
Vista Problem
Please check at runtime what SDAC version do you use. Just check the value of the SdacVersion variable in an application that uses the MSAccess unit of SDAC. if the value is '4.10.0.9', perform another test. Run the following code in your application (e.g. by click on a button), and report us the exact text of the message:
Code: Select all
var
OSVersionInfo: TOSVersionInfo;
begin
OSVersionInfo.dwOSVersionInfoSize := SizeOf(TOSVersionInfo);
Windows.GetVersionEx(OSVersionInfo);
ShowMessage('OSVersionInfo.dwMajorVersion: ' + IntToStr(OSVersionInfo.dwMajorVersion));
end;