RE: [DUG]: IB Objects/ IBX/ Interbase experiences

2001-05-27 Thread James Low
As far as I can see the benefits of IBO over IBX are painless migration from BDE (distinct plus or a minus - plus for me) and slightly handling of transactions ie over several datasets. -Original Message- From: Pat Sheehan [mailto:[EMAIL PROTECTED]] Sent: 28 May 2001 15:38 To: Multiple r

RE: [DUG]: MS SQL, IIS and Delphi API

2001-05-27 Thread Jim Zheng
Hi, I do get going to access MS SQL via API, but only in Windows application. Once I build this into ActiveX component, then the code passed dbInit, but stuck at dbLogin. Regards, Jim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED

RE: [DUG]: MS SQL, IIS, Delphi

2001-05-27 Thread Jim Zheng
Dennis, I am using SQL 6.0, the untility I could find is called SQL Server Client Configuration Utility. Then I go Advanced page add my server and TCP/IP sockets. Still not go. What else shall I do? dbLogin doesn't take any parameter, but returns a pointer, which point to LOGINREC. Then I call d

Re: [DUG]: Delphi 6 launch TOMMOROW (and Wednesday and Thursday)

2001-05-27 Thread Mark Derricutt
Arrrg just got told by the boss theres a meeting scheduled 1pm ish tomorrow. Gah :( Heres hoping I can get out of the meeting.. --On Monday, 28 May 2001 2:51 p.m. +1200 Nic Wise <[EMAIL PROTECTED]> wrote: > just a reminder that the Delphi 6 - and JBuilder 5 - launch is tomorrow in -

Re: [DUG]: IB Objects/ IBX/ Interbase experiences

2001-05-27 Thread Pat Sheehan
What is wrong with IBX? Have used then on three ( simple ) app to date with no adverse productivity ,but I do agree with staying with Dialect 1 in IBO Patrick Sheehan ( P+A Computing ) Patrick Anthony Associates Ltd - Original Message - From: "Sandeep" <[EMAIL PROTECTED]> To: "Multiple

RE: [DUG]: ttASCII Schema file

2001-05-27 Thread Michael Pelly
Thanks, Nello, that should do the trick. MP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Nello Sestini Sent: Monday, May 28, 2001 10:03 AM To: Multiple recipients of list delphi Subject: Re: [DUG]: ttASCII Schema file > There must be a way of setting

RE: [DUG]: MS SQL, IIS and Delphi API

2001-05-27 Thread Stephen Barker
Jim, If you're still having problems, have you looked at the Zeos components? They include direct API access to popular db's including MS SQL. I can't get onto their web site (http://www.zeoslib.org/) just now but an extract from the readme is: Zeos Database Objects is a Delphi's components se

[DUG]: Delphi 6 launch TOMMOROW (and Wednesday and Thursday)

2001-05-27 Thread Nic Wise
Hi everyone just a reminder that the Delphi 6 - and JBuilder 5 - launch is tomorrow in Auckland, Wednesday in Wellington and Thursday in Christchurch. If you haven't registered, its not too late - or, alternatively, just turn up :) More info at http://register.borland.co.nz/ebusiness Nic.

Re: [DUG]: IB Objects/ IBX/ Interbase experiences

2001-05-27 Thread Neven MacEwan
James If it is cheap you want then I'd suggest kbmMemTable and mODBC, Gives you a client side dataset with transactions and a resolver, you can then use mODBC to fill/update the Server, Also the methodologies involved would be more portable to dbExpress HTH Neven - Original Message - Fr

RE: [DUG]: IB Objects/ IBX/ Interbase experiences

2001-05-27 Thread James Low
Probably, but cannot (as much as I would like) warrant the cost at this early stage. Seems though that dbExpress might be the way to go later on ... so will definitely try to keep that door open (as best I can). -Original Message- From: Neven MacEwan [mailto:[EMAIL PROTECTED]] Sent: 28 Ma

RE: [DUG]: MS SQL, IIS, Delphi

2001-05-27 Thread Dennis Chuah
Jim, > Could you tell me how to set up TCP/IP connection to MS > SQL. One of the client utilities SQL server installs is the Client Network Utility (Should be somewhere in the start menu). Run this, click on the add button, type in the server name (or an alias name), select TCP/IP, type in the

Re: [DUG]: IB Objects/ IBX/ Interbase experiences

2001-05-27 Thread Neven MacEwan
James Would you not be better investing in D6 and looking at dbExpress Has native mode IB support and 'midas' clientdatasets (and you code is portable to Linux!) Neven - Original Message - From: James Low <[EMAIL PROTECTED]> To: Multiple recipients of list delphi <[EMAIL PROTECTED]> Sen

RE: [DUG]: IB Objects/ IBX/ Interbase experiences

2001-05-27 Thread James Low
Sort of ... I was referring to the FIBPlus components ...and mistakenly typed "Firebird" which I had no idea was a database. Thanks. -Original Message- From: Nello Sestini [mailto:[EMAIL PROTECTED]] Sent: 28 May 2001 12:16 To: Multiple recipients of list delphi Subject: Re: [DUG]: IB Obje

Re: [DUG]: IB Objects/ IBX/ Interbase experiences

2001-05-27 Thread Nello Sestini
> IBO seems a little > more est'd the Firebird+ (love the name) though it does seem (read) pretty > good too. > maybe I am reading too much between the lines here - but I'll mention in case there is some confusion. Firebird is not an alternative to IBO.Firebird is an alternative to Interbas

RE: [DUG]: MS SQL, IIS, Delphi

2001-05-27 Thread Jim Zheng
Thank you Dennis, Could you tell me how to set up TCP/IP connection to MS SQL. As my code is stuck in dbLogin, which doesn't take any parameter, how do I code to log in as another user? Regards, Jim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Denni

Re: [DUG]: ttASCII Schema file

2001-05-27 Thread Nello Sestini
> There must be a way of setting the index for the new table in the schema > file. Does anyone know what it is? i don't know how you can do it in the schema - but you could put something like this: create index CCKEY ON TPAKHIST (CCCODE,PROCDATE); in a query and execute it after your batch

RE: [DUG]: IB Objects/ IBX/ Interbase experiences

2001-05-27 Thread James Low
Thanks all - great to get some feedback before I leap in. IBO seems a little more est'd the Firebird+ (love the name) though it does seem (read) pretty good too. -Original Message- From: Peter Hyde [mailto:[EMAIL PROTECTED]] Sent: 28 May 2001 11:23 To: Multiple recipients of list delphi S

[DUG]: ttASCII Schema file

2001-05-27 Thread Michael Pelly
Hi there, I am attempting to do a batch move using TBatchMove component, moving contents of a Text file into a db table. It is working ok, except that I am, thus far, unable to work out how to incorporate indexing. My schema file looks like this: [TPAKHIST] Filetype=Fixed CharSet=ascii Field1=PRO

Re: [DUG]: MS SQL, IIS and Delphi API

2001-05-27 Thread Bevan Edwards
Hi Jim, Sorry, can't be much help with that. I've been considering going down that same path because of a number of issues with ODBC (with MS SQL and Informix), but as yet I haven't taken the plunge. Good luck! Regards, Bevan Jim Zheng wrote: > > Hi Bevan, > > Thanks for your reply. > >

RE: [DUG]: MS SQL, IIS, Delphi

2001-05-27 Thread Dennis Chuah
Jim, I think your problem is security - when running under IIS, your Active-X component effectively runs under the guest user's privileges. This user may not be able to access the database, especially if you are using named pipes. Try setting up the connection as TCP/IP (use the client config t

Re: [DUG]: IB Objects/ IBX/ Interbase experiences

2001-05-27 Thread Peter Hyde
James asked: > scaling/ trying to get some performance. Are there any hidden gotchas > and, in D5/Pro, is IBX as impossible to use as the IBO hype suggests? Can't speak for IBX. In my experience, IBO is a good solution. The gotchas in the past have tended to be related to the frequency of rele

RE: [DUG]: IB Objects/ IBX/ Interbase experiences

2001-05-27 Thread Nahum Wild
As well as IBO and IBX there is also FIBPlus (http://www.second-dream.ru/eng/index.htm) which I came across the other day. The author has written an article about it also well. (http://www.delphipages.com/news/detaildocs.cfm?ID=47) Hope thats its helpfull in some way. :) Nahum. > -Origina

Re: [DUG]: IB Objects/ IBX/ Interbase experiences

2001-05-27 Thread Sandeep
On 28 May 2001, at 10:26, James Low wrote: > This is possibly more directed at Ed who recently advised on the use of IB > objects as opposed to IBX. My app prototype is using BDE/ ODBC against a IB > DB - and it seems IBO is the obvious next step in scaling/ trying to get > some performance. Are

RE: [DUG]: Just in time debug error on Win98 SE

2001-05-27 Thread Damien Long
What I have done is install the Delphi 5 update and usually removes the problem of just in time debug. Just my 2 cents worth.   Damien -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dedy DarmayantoSent: Sunday, 27 May 2001 7:14 PMTo: Multiple

RE: [DUG]: MS SQL, IIS and Delphi API

2001-05-27 Thread Jim Zheng
Hi Bevan, Thanks for your reply. Actully I am not that far yet. The stuck point is dbLogin which doesn't take any parameter. I am using API to access MS SQL directly, not DBE or ODBC is required. Jim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [E

[DUG]: IB Objects/ IBX/ Interbase experiences

2001-05-27 Thread James Low
This is possibly more directed at Ed who recently advised on the use of IB objects as opposed to IBX. My app prototype is using BDE/ ODBC against a IB DB - and it seems IBO is the obvious next step in scaling/ trying to get some performance. Are there any hidden gotchas and, in D5/Pro, is IBX as i

Re: [DUG]: MS SQL, IIS and Delphi API

2001-05-27 Thread Bevan Edwards
Hi Jim, I had a similar problem recently with a new Win2k Server and IIS installation. The CGI application worked fine on NT4 (Workstation and Server) with IIS4, but I had repeated problems on Win2k and IIS5. Anyway, there were a number of issues that cropped up. First of all, we had to use r

[DUG]: MS SQL, IIS and Delphi API

2001-05-27 Thread Jim Zheng
I've got the header files now. Thank you Nello. BUT, I still have trouble with MS SQL and IIS. I don't know whether I miss something on system settings, like security problem. This is first time I am working with MS SQL. My problem is the following. I am using API in Delphi to talk to MS SQL lo

Re: Re: [DUG]: Compiler Switches

2001-05-27 Thread Jason L. Coley
I managed to get around this problem, but by compiling the .pas file first with the appropriate define then compiling the project, but this still sounds a little strange. Regards Jason Coley Manawatu Software Solutions http://www.software-solutions.co.nz -Original Message- From: Nello S

Re: [DUG]: Fetching details in a ClientDataSet

2001-05-27 Thread Neven MacEwan
Moises For this type of behaviour you are probably better to code the master detail link yourself. I have a component that does this, you may have the source if you wish by emailing me direct at [EMAIL PROTECTED] Neven - Original Message - From: Moises Lopez <[EMAIL PROTECTED]> To: Multi

[DUG]: Just in time debug error on Win98 SE

2001-05-27 Thread Dedy Darmayanto
Hi,   I have just installed Delphi 5 Interprise in Windows 98 Second Edition   When I try to run delphi, a message was appear : Just in time debug and then I click Yes or No the computer always HUNG, and must be reset by hardware (keyboard doesn't respon)   but, if I installed on windows NT