Delphi 2.0 and SQL server 6.5 
Author Message
 Delphi 2.0 and SQL server 6.5

I am relatively new to SQL 6.5 and Delphi and starting development of
a medium sized project.
Can anyone help me finding useful manuals, web pages which cover this
specific combination ?
Any feedback on positive / negative experience (or good tips and
hints) would be welcome too.
If replying, please post AND mail.

Thank you very much

Suzanne Acke
Antwerp, Belgium



Mon, 22 Feb 1999 03:00:00 GMT
 Delphi 2.0 and SQL server 6.5

Quote:

> I am relatively new to SQL 6.5 and Delphi and starting development of
> a medium sized project.
> Can anyone help me finding useful manuals, web pages which cover this
> specific combination ?
> Any feedback on positive / negative experience (or good tips and
> hints) would be welcome too.
> If replying, please post AND mail.

> Thank you very much

> Suzanne Acke
> Antwerp, Belgium

Hi,

I'm also using this combination. You can find some technical information
at the Borland Web site.

I understand you are using Delphi 2. My experience with this combination
is that it is about 2 to 3 times slower than when you are using Delphi 1
in combination with SQL server 6.5. Test this yourself and consider
developing in Delphi 1. I have read somewhere that Borland is aware of
this problem but they have no solution for this (yet?).

Besides this negative problem it is good combination to work with. A tip
to speed things up can be: do not auto-create all your forms because
that will increment the startup-time (all tables and queries have to be
created and filled with data during startup). Create those forms
yourself when they are needed. Use a construct like:
  If FormDetails = nil Then
    Application.CreateForm(TFormDetails,FormDetails);
  FormDetails.Show;
In this case only the first time you show this form it will take some
longer time.

Bert Hardeman



Sat, 27 Feb 1999 03:00:00 GMT
 Delphi 2.0 and SQL server 6.5

Quote:
>I understand you are using Delphi 2. My experience with this combination
>is that it is about 2 to 3 times slower than when you are using Delphi 1
>in combination with SQL server 6.5. Test this yourself and consider
>developing in Delphi 1. I have read somewhere that Borland is aware of
>this problem but they have no solution for this (yet?).

        I thought I heard that an update was available to fix this?

_
NOTE: This software is currently in early alpha. If you notice any

 \------------------------------------------------------------\


    \     Physically in Church Hill, TN - Logically Not Sure     \
     \------------------------------------------------------------\

Quote:
>>SQUID - The ultimate 95/NT offline databasing reader

**Special Compile: 3.000A (Alpha)


Sun, 28 Feb 1999 03:00:00 GMT
 Delphi 2.0 and SQL server 6.5

Quote:

> >I understand you are using Delphi 2. My experience with this combination
> >is that it is about 2 to 3 times slower than when you are using Delphi 1
> >in combination with SQL server 6.5. Test this yourself and consider
> >developing in Delphi 1. I have read somewhere that Borland is aware of
> >this problem but they have no solution for this (yet?).

>         I thought I heard that an update was available to fix this?

Do you mean version 2.01 of Delphi or some other fix?

Bert Hardeman



Tue, 02 Mar 1999 03:00:00 GMT
 Delphi 2.0 and SQL server 6.5

Quote:


>> >I understand you are using Delphi 2. My experience with this combination
>> >is that it is about 2 to 3 times slower than when you are using Delphi 1
>> >in combination with SQL server 6.5. Test this yourself and consider
>> >developing in Delphi 1. I have read somewhere that Borland is aware of
>> >this problem but they have no solution for this (yet?).

>>         I thought I heard that an update was available to fix this?

>Do you mean version 2.01 of Delphi or some other fix?
>Bert Hardeman

If there is a fix, it's not posted yet at Borlands web page. If you
find something or hear something please let me know. If it's true
about the speed issue, i'm in deep trouble ... performance is a main
issue in the project I'm working on.

Thanks

Suzanne



Thu, 04 Mar 1999 03:00:00 GMT
 Delphi 2.0 and SQL server 6.5

Hi Suzanne!

I talked to the german borland helpdesk and they told
me, that the update of Delphi 2.01 C/S will solve the
speed problem  and many other problems with MS-SQL6.x.

There are many more problems using Delphi and MS-SQL.
If you are more interested to this subject, please
reply or mail.

Stefan Kreidl
Managing Director
MusicNet AG, Regensburg, Germany



Thu, 04 Mar 1999 03:00:00 GMT
 Delphi 2.0 and SQL server 6.5

Quote:

>Hi Suzanne!
>I talked to the german borland helpdesk and they told
>me, that the update of Delphi 2.01 C/S will solve the
>speed problem  and many other problems with MS-SQL6.x.
>There are many more problems using Delphi and MS-SQL.
>If you are more interested to this subject, please
>reply or mail.
>Stefan Kreidl
>Managing Director
>MusicNet AG, Regensburg, Germany

Hi Stefan,

First thing I'll do today (after this message) is to order the
upgrade.
Yoy talk about other problems using MSSQL with Delphi, could you be
more precise ??

Thanks for your help

Suzanne



Fri, 05 Mar 1999 03:00:00 GMT
 Delphi 2.0 and SQL server 6.5

Hello Suzanne,

one of the most confusing problems for us:

We fetch a record from a master table and fetch
then a set of records from the detail-table using
two TQuery objects. For the first time the detail
query shows all the detail records, the second time
you open the query it will not show you all information,
it shows to you a random amount of lines of the table.
Only a restart of the program can solve the problem for
a single open of the query. We try it now with ODBC.

If you can order the upgrade please let me know, because
in Germany it isn't yet available.

Thank you!

Greetings from Germany
Stefan Kreidl



Fri, 05 Mar 1999 03:00:00 GMT
 Delphi 2.0 and SQL server 6.5

Quote:

>First thing I'll do today (after this message) is to order the
>upgrade.
>Yoy talk about other problems using MSSQL with Delphi, could you be
>more precise ??

Well, if you want to work with blob and alike you'll have to figure
out how to do it. As long as it's text there's almost no problem.
However when it comes to binary data I've not come up with a workable
solution yet.

Anders Gregersen / CD-Danmark



Fri, 05 Mar 1999 03:00:00 GMT
 Delphi 2.0 and SQL server 6.5

Quote:

> Hi Suzanne!

> I talked to the german borland helpdesk and they told
> me, that the update of Delphi 2.01 C/S will solve the
> speed problem  and many other problems with MS-SQL6.x.

> There are many more problems using Delphi and MS-SQL.
> If you are more interested to this subject, please
> reply or mail.

> Stefan Kreidl
> Managing Director
> MusicNet AG, Regensburg, Germany

Hi Stefan,

I replied to Suzanne about the performance of this combination.
I already installed version 2.01 C/S and it really makes no difference.

Bert Hardeman



Sat, 06 Mar 1999 03:00:00 GMT
 Delphi 2.0 and SQL server 6.5

Hi Anders,

Quote:

> >You talk about other problems using MSSQL with Delphi, could you be
> >more precise ??

> Well, if you want to work with blob and alike you'll have to figure
> out how to do it. As long as it's text there's almost no problem.
> However when it comes to binary data I've not come up with a workable
> solution yet.

try ODBCExpress - it's blazingly fast with binary or text BLObs

check it out at http://www.adam.co.za

Regards,

Rob
--
Rob McGillivray
Manager: Client/server Software Development
DataSoft - "Voted Top Development House in South Africa - 1994"



Mon, 08 Mar 1999 03:00:00 GMT
 Delphi 2.0 and SQL server 6.5

Quote:

> Hi Suzanne!

> I talked to the german borland helpdesk and they told
> me, that the update of Delphi 2.01 C/S will solve the
> speed problem  and many other problems with MS-SQL6.x.

> There are many more problems using Delphi and MS-SQL.
> If you are more interested to this subject, please
> reply or mail.

> Stefan Kreidl
> Managing Director
> MusicNet AG, Regensburg, Germany

Hi Stefan,

I have been trying to use Delphi 2.0 & 2.01 with MS SQL Server 6.0 &
6.5. I have noticed several problems with memo fields that were supposed
to be fixed in 2.01.

After returning a query (I'm using BDE and ODBC), I can cause an error
if there are more than about 50 records returned by going to the last
record, first record, next record etc. Eventually the Memo too Large
error from Delphi 2.0 returns.

Also, I seem to hang up the system in the development environment if I
have a SQL syntax error and try to make the query active.

Also, I get Access Violation errors when I exercise the program, and run
and re run several queries. I do not use any special user defined
controls, or objects, not even Null strings. All I am using are standard
Delphi controls and Delphi data controls.

The Access error do not happen if I use the local Interbase for testing.

I think Borland has bugs in their BDE and ODBC and I am looking at using
ODBCExpress to get to SQL Server.

What do you think, what kind of luck are you having with Delphi and SQL
Server?

Thanks,

Austin



Sat, 20 Mar 1999 03:00:00 GMT
 Delphi 2.0 and SQL server 6.5

Quote:

> I have been trying to use Delphi 2.0 & 2.01 with MS SQL Server 6.0 &
> 6.5. I have noticed several problems with memo fields that were supposed
> to be fixed in 2.01.

Make absolutely sure you have the *latest* ODBC drivers from SQL 6.5.
Reinstall from SQL 6.5/client directory if you are not sure.

Quote:
> Also, I seem to hang up the system in the development environment if I
> have a SQL syntax error and try to make the query active.

I have that here too.

Quote:
> Also, I get Access Violation errors when I exercise the program, and run
> and re run several queries. I do not use any special user defined
> controls, or objects, not even Null strings. All I am using are standard
> Delphi controls and Delphi data controls.

You run out of connections are your SQL server. Increment the number of user
connections too 100-200 or more (from the default 15).
--
Groetjes,

Berend. (-:

compuserve: 100120,3121



Sat, 20 Mar 1999 03:00:00 GMT
 Delphi 2.0 and SQL server 6.5

Austin McCracken wrote in an article appearing in comp.lang.pascal.delphi.databases:

Quote:
>What do you think, what kind of luck are you having with Delphi and SQL
>Server?

None at all.

On a badness scale of 1-10 where 10 is eternal torment in Hell, I would
rate the BDE support for SQL Server at 9.95.

--

* In this world of toil and sin
  Your scalp grows bald, but not your chin. - Burma Sig



Sun, 21 Mar 1999 03:00:00 GMT
 Delphi 2.0 and SQL server 6.5

Hi Austin!

Quote:

> Hi Stefan,

> I have been trying to use Delphi 2.0 & 2.01 with MS SQL Server 6.0 &
> 6.5. I have noticed several problems with memo fields that were supposed
> to be fixed in 2.01.

> After returning a query (I'm using BDE and ODBC), I can cause an error
> if there are more than about 50 records returned by going to the last
> record, first record, next record etc. Eventually the Memo too Large
> error from Delphi 2.0 returns.

> Also, I seem to hang up the system in the development environment if I
> have a SQL syntax error and try to make the query active.

> Also, I get Access Violation errors when I exercise the program, and run
> and re run several queries. I do not use any special user defined
> controls, or objects, not even Null strings. All I am using are standard
> Delphi controls and Delphi data controls.

> The Access error do not happen if I use the local Interbase for testing.

> I think Borland has bugs in their BDE and ODBC and I am looking at using
> ODBCExpress to get to SQL Server.

And how's it going with the product???  We have many SQL Server developers out there raving about
ODBCExpress - we would be very keen to hear from you!

BTW, ODBCExpress v1.10 will be released on Monday, October 7.  This release sports a number of new
features.  The 16bit version is still freeware while the 32bit remains shareware.

Regards,

Rob
--
Rob McGillivray
Manager: Client/server Software Development
DataSoft - "Voted Top Development House in South Africa - 1994"



Thu, 25 Mar 1999 03:00:00 GMT
 
 [ 20 post ]  Go to page: [1] [2]

 Relevant Pages 

1. Delphi 2.0 and MS SQL Server 6.5 Problem

2. Stored Procedure MS Sql Server 6.5 and Delphi 2.0

3. SQL Server 6.5 - Delphi 2.0

4. Delphi 2.0 & SQL Server 6.5

5. SQL Server 6.5, Delphi 2.0 and Grid updates

6. Delphi 2.0 & SQL SERVER 6.5

7. Delphi 2.0 and Microsoft SQL 6.5 maillingllist

8. Delphi 2.0 and Microsoft SQL 6.5 maillingllist

9. Delphi 2.0 / SQL 6.5 upgrade problem

10. Delphi 2.0 and Microsoft SQL 6.5 maillingllist

11. Delphi 2.0 and Microsoft SQL 6.5 maillingllist

12. Delphi 2.0 and Microsoft SQL 6.5 maillingllist


 
Powered by phpBB® Forum Software