• 用dbExpress页的SQLConnection1连接sql server2000怎么设置。 [问题点数:0分]


    在d7或者c6已经支持了。
    贡献一下我的代码吧:
    dbeConn:= TSQLConnection.Create(nil);
          dbeConn.Params.Clear;
          dbeConn.Params.Values['DriverName']:= 'MSSQL';
          dbeConn.Params.Values['HostName']:= FDataSource.address;
          dbeConn.Params.Values['Database']:= FDataSource.serviceName;
          dbeConn.Params.Values['USER_NAME']:= FDataSource.userName;
          dbeConn.Params.Values['Password']:= FDataSource.passWord;
          dbeConn.Params.Values['BlobSize']:= '-1';
          dbeConn.Params.Values['ErrorResourceFile']:= '';
          dbeConn.Params.Values['LocaleCode']:= '0000';
          dbeConn.Params.Values['MSSQL TransIsolation']:= 'ReadCommited';
          dbeConn.Params.Values['OS Authentication']:= 'False';
          randomize;
          dbeConn.ConnectionName:= 'hwsycmss' + Trim(IntToStr(random(99999)));
          dbeConn.DriverName:= 'MSSQL';
          dbeConn.GetDriverFunc:= 'getSQLDriverMSSQL';
          dbeConn.VendorLib:= 'oledb';
          dbeConn.LibraryName:= 'dbexpmss.dll';
          dbeConn.SQLHourGlass:= true;
          dbeConn.KeepConnection:= false;
          try
            dbeConn.Open;
            FActived:= true;
            Result:= true;
            err.SetMessage('MSSQL database Connected OK!',0);
            exit;
          except
            On E:Exception do
            begin
              err.SetMessage('MSSQL Database Connected Failed!' + E.Message,8003);
              FActived:= false;
              Result:= false;
              exit;
            end;
          end; 

  • 相关阅读:
    浅谈SQL Server 对于内存的管理
    【JSON解析】JSON解析
    SQLSERVER吞噬内存解决记录
    数据schemaAvro简介
    Windows命令查看文件MD5
    均分纸牌(贪心)
    an easy problem(贪心)
    导弹拦截问题(贪心)
    活动选择(贪心)
    整数区间(贪心)
  • 原文地址:https://www.cnblogs.com/jijm123/p/10586772.html
Copyright © 2020-2023  润新知