我用ado连一个odbc的数据源,怎么知道数据库是什么类型的呢

Question

怎么判断他是sqlserver还是oracle呢?

Answer 1

当ADOCONNECT 打开以后 连接的Provider属性决定了是sqlserver还是oracle

Answer 2

uses
  Registry;
procedure TForm1.btn1Click(Sender: TObject);
var
  Reg:TRegistry;
  DataSource, DBServerName:string;
  SemicolonPos:Integer;
begin
  Reg:=TRegistry.Create;
  try
    Reg.RootKey:=HKEY_CURRENT_USER;
    Reg.OpenKeyReadOnly('Software\ODBC\ODBC.INI\ODBC Data Sources');
    DataSource:=Copy(con1.ConnectionString, Pos('Data Source=', con1.ConnectionString),
                Length(con1.ConnectionString)); //得到Data Source后面的字符串
    SemicolonPos:=Pos(';', DataSource);
    DataSource:=Copy(DataSource, Length('Data Source=')+1,
                SemicolonPos-Length('Data Source=')-1); //得到Data Source的值
    DBServerName:=Reg.ReadString(DataSource);
    ShowMessage(DBServerName); //显示数据库服务器的类型
  finally
    Reg.CloseKey;
    Reg.Free;
  end;
end;

Answer 3

用select @@version看返回的字符串是否有sql server这样的字符了没用过oracle,应该也支持