Re: OLEDB not work !

["pcspace" <wineforum-user@xxxxxxxxxx>]

I get it's source code :)
Delphi6 update2 + MS SQL Server2000 Sp4


unit Conn_Unit;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Buttons, DB, ADODB, ExtCtrls,winsock, ShlObj;

type
  TConnForm = class(TForm)
    Panel1: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    UserNameEdit: TEdit;
    Label6: TLabel;
    DBNameEdit: TEdit;
    ADOConn: TADOConnection;
    ConnTestBtn: TBitBtn;
    PassWordEdit: TEdit;
    MYIPAddress: TEdit;
    procedure ConnTestBtnClick(Sender: TObject);
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  ConnForm: TConnForm;

implementation

{$R *.dfm}


procedure TConnForm.ConnTestBtnClick(Sender: TObject);
var
IPAddress,DBName,UserName,PassWord,ConnStr:String;
begin

 IPAddress := Trim(MyIPAddress.Text) ;
 DBName    := Trim(DBNameEdit.Text) ;
 UserName  := Trim(UserNameEdit.Text);
 PassWord  := Trim(PassWordEdit.Text);


 if Trim(DBName) = '' then
    begin
     DBNameEdit.SetFocus ;
     Application.MessageBox('Please input database name!','Error');
     Exit;
    end;

 if Trim(UserName) = '' then
    begin
     PassWordEdit.SetFocus ;
     Application.MessageBox('Please input username!','Error');
     Exit;
    end;

 ConnStr:='Provider=SQLOLEDB.1;Password='+PassWord+';Persist Security Info=True;User ID='+UserName+';Initial Catalog='+DBName+';Data Source='+IPAddress;

 ADOConn.Connected :=False;
 ADOConn.ConnectionString :=ConnStr;

   try
   ADOConn.Connected :=True;
   Application.MessageBox('Link To Database!','OK');
   Exit;
   except
   Application.MessageBox('Can not link to database!','Fail');
   Exit;
   end;






end;

procedure TConnForm.FormShow(Sender: TObject);
begin


       MyIPAddress.Text    := '127.0.0.1';
       DBNameEdit.Text     := '';
       UserNameEdit.Text   := '';
       PassWordEdit.Text   := '';

end;

end.