thanks nic......I will give this a try tonight at home.
Jeremy Coulter
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Nic Wise
> Sent: Tuesday, March 02, 1999 08:40
> To: Multiple recipients of list delphi
> Subject: Re: [DUG]: SQL Server or Interbase ??
>
>
> > 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
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
