Advertisement
Guest User

Untitled

a guest
Jul 6th, 2017
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.66 KB | None | 0 0
  1. try
  2. with dm.conServer do
  3. begin
  4. Server := 'localhost';
  5. Port := 5432;
  6. Username := 'postgres';
  7. Password := 'postgres';
  8. Database := 'newserver';
  9. Connected := True;
  10. end;
  11. except
  12. on E: Exception do
  13. ShowMessage(E.ClassName + ' Erro : ' + E.Message);
  14. end;
  15.  
  16. var
  17. UniConnection1: TUniConnection;
  18. ...
  19. UniConnection1.ProviderName := 'Oracle';
  20. UniConnection1.Username := 'scott';
  21. UniConnection1.Password := 'tiger';
  22. UniConnection1.Server := 'ORA1020';
  23. UniConnection1.SpecificOptions.Values['Schema'] := 'SCOTT';
  24. UniConnection1.Open;
  25.  
  26. UniConnection1.SpecificOptions.Add('Schema=SCOTT');
  27.  
  28. procedure TfrmMain.FormCreate(Sender: TObject);
  29. var
  30. appINI: TIniFile;
  31. Server, Username, Password, Database: String;
  32. Port: Integer;
  33. begin
  34. direxe := IncludeTrailingPathDelimiter(ExtractFilePath(Application.ExeName));
  35. appINI := TIniFile.Create(direxe + 'config.ini');
  36. try
  37. Server := appINI.ReadString('Server', 'Server', '');
  38. Port := appINI.ReadInteger('Server', 'Port', 5432);
  39. Username := appINI.ReadString('Server', 'Username', '');
  40. Password := appINI.ReadString('Server', 'Password', '');
  41. Database := appINI.ReadString('Server', 'Database', '');
  42. finally
  43. appINI.Free;
  44. try
  45. dm.conServer.DriverName := 'PG';
  46. dm.conServer.Params.Add('Server=' + Server);
  47. dm.conServer.Params.Add('Port=' + IntToStr(Port));
  48. dm.conServer.Params.Add('Database=' + Database);
  49. dm.conServer.Params.Add('User_name=' + Username);
  50. dm.conServer.Params.Add('Password=' + Password);
  51. dm.conServer.Connected := True;
  52. except
  53. on E: Exception do
  54. ShowMessage(E.ClassName + ' Erro : ' + E.Message);
  55. end;
  56. end;
  57. end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement