> At work, we us VB(agh puke puke !!!) and SQL Server 7 and I must admit, I
> find it quite slow compared to SQL Server 6.5.....and its not just me.....it
> might be a configuration thing, but then is it ment to be "Smart" when it
> decides how much mem. it uses etc.
Trust me, its not. the default config is OKish with a load of memory,
but
you REALLY need to tweek it. BTW, if you have a few dev's on it (ie,
6 or so) and you have less then 128meg, kick the CFO and get 128
ATLEAST.
> I had a play with interbase last night, but I couldn't see how to create
> table, and when I tried to connect to a database, it gave some sort of
CREATE TABLE blah (
somekey INTEGER NOT NULL,
somefield VARCHAR(128),
)
And then you declare the primary key, which I dont remember how to do,
'cos I generally use StarDesigner for it :)
If you have visual Interdev, create an ODBC source to talk to IB, and
then use VID to make the tables and stuff - or DB Explorer :) - very
easy.
But yes, it is lacking a little in the table maint, and admin area. I'm
told
things are moving in that area, but I dont know specifics or when.
To connect to a db, do something like:
1) Fire up the server manager. Hit the first speed button. Enter "remote
server"
(unless you only have local IB), enter tha name of the machine, select
your
protocol (IP recommended), enter "sysdba" as the user and "masterkey" as
the PW
(these are the defaults). Hit connect. It should work. If not, have a
play
with the connection diagnostics app.
To open a DB, either hit the 3rd button and enter the path (try
c:\program files\interbase corp\interbase\examples\employee.gdb for a
start)
or open the iSQL tool (from the menus), and connect there - its the same
form as connecting to a server, but you also select which DB to open.
Then its all SQL commands, unless you use DB explorer or StarDesigner or
similar
(SD can be gotten in demo form from whoever it is that does
PowerBuilder)
Also, if it asks for just a connection string, use something like:
machine(seperator)path-to-db
where:
machine = the machine name
(seperator) = a protocol specifier: ":" = IP, "@" = IPX, "\" = NetBEUI
(YUCK!)
path-to-db = the full path to the database.
eg:
buster:c:\program files\interbase corp\interbase\examples\employee.gdb
(my machine is called buster)
Hope that helps a load. If you are still confuzzed, drop me a line (on
or off the
list) and I'll see what I can do.
Nic.
--
Nic Wise - Inprise New Zealand Ltd. [EMAIL PROTECTED]
09-360-0231 (wk), 021-676-418 (mob), [EMAIL PROTECTED] (hm)
My opinions do not reflect the opinions of my employer,
or myself at times.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
