girlswants_me
asked on
linking Database with Multi-user design
Please help me accessing this one. where can i find the
"DATABASE.GDB" file? and how can i put password on it?
what do "IB_SERVER" mean and what is this? can anybody teach me how to make a ".GDB" FILE and to add new tables inside
var
MyList: TStringList;
begin
MyList := TStringList.Create;
try
with MyList do
begin
Add('SERVER NAME=IB_SERVER:/PATH/DATAB ASE.GDB');
Add('USER NAME=MYNAME');
end;
Session1.AddAlias('NewIBAl ias', 'INTRBASE', MyList);
finally
MyList.Free;
end;
end;
"DATABASE.GDB" file? and how can i put password on it?
what do "IB_SERVER" mean and what is this? can anybody teach me how to make a ".GDB" FILE and to add new tables inside
var
MyList: TStringList;
begin
MyList := TStringList.Create;
try
with MyList do
begin
Add('SERVER NAME=IB_SERVER:/PATH/DATAB
Add('USER NAME=MYNAME');
end;
Session1.AddAlias('NewIBAl
finally
MyList.Free;
end;
end;
Interbase is a database server: http://www.borland.com/interbase/
You can create databases, tables, data in it using SQL.
You can create databases, tables, data in it using SQL.
ASKER
my question in how to use that "code" and how to access the GDB file
You were asking "where you can find database.gdb file" and "how to put password on it" so I assume you have no idea what you want and gave you the link to interbase site where you can start learning.
If you have Interbase installed then read the documentation which tells you precisely how to login to the server, create databases, attach to them and work with tables.
The code you posted seems to use BDE TSession component to create an alias using BDE INTRBASE driver.
If you have Interbase installed then read the documentation which tells you precisely how to login to the server, create databases, attach to them and work with tables.
The code you posted seems to use BDE TSession component to create an alias using BDE INTRBASE driver.
listening . . . firsttime :-)
hi tondrej ;-)
HI,
First of all, I assume you have ibserver (ibguard)
(Interbase Server and/or Interbase Gardian) running on your
computer.
Then you can go to f.e. SQL Explorer and open IBLocal (alias)
using User=SYSDBA and password=masterkey.
IBLocal must point to the file
\..borland shared\data\employee.gdb.
Then you open this db and can work on it.
If you want to create your own ".gdb" file you must launch the
WISQL (Interbase windows ISQL) and using SQL language create
your database (create database, create table and so on).
That's all.
Sincerely,
Nestorua.
First of all, I assume you have ibserver (ibguard)
(Interbase Server and/or Interbase Gardian) running on your
computer.
Then you can go to f.e. SQL Explorer and open IBLocal (alias)
using User=SYSDBA and password=masterkey.
IBLocal must point to the file
\..borland shared\data\employee.gdb.
Then you open this db and can work on it.
If you want to create your own ".gdb" file you must launch the
WISQL (Interbase windows ISQL) and using SQL language create
your database (create database, create table and so on).
That's all.
Sincerely,
Nestorua.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for such a brilliant answer.
No problems at all :) Just let me know if you have any more problems with the code or answer.
Stu
Stu
ASKER