Board index » delphi » Sql Server 7.0 connections

Bernaert Dominique

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Sql Server 7.0 connections

Hello,

I'm using SQL Server 7.0 with Delphi 4 through ODBC.  When I run the
application once, it runs fine.  When I try to start a second instance of
the application, it 'hangs' until the other instance is closed after which
it continues.

I tried to connect with a demo version of Adonis and here there was no
problem with multiple instances.

Any idea how to solve this?

Thanks,

Bernaert Dominique
Email = max.berna...@unicall.be

 
Reid Roma

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Sql Server 7.0 connections


Is this ADO you are talking about?

Because kamiakADO components that I demo'ed allowed you to connect to
SQL Server without ODBC.  I did not check the concurrecny issue though.

Rkr

Quote
Bernaert Dominique wrote:

> Hello,

> I'm using SQL Server 7.0 with Delphi 4 through ODBC.  When I run the
> application once, it runs fine.  When I try to start a second instance of
> the application, it 'hangs' until the other instance is closed after which
> it continues.

> I tried to connect with a demo version of Adonis and here there was no
> problem with multiple instances.

> Any idea how to solve this?

> Thanks,

> Bernaert Dominique
> Email = max.berna...@unicall.be

Paul Lambadar

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Sql Server 7.0 connections


In article <7m5ua2$km...@forums.borland.com>, max.berna...@unicall.be
says...
Quote
> Hello,

> I'm using SQL Server 7.0 with Delphi 4 through ODBC.  When I run the
> application once, it runs fine.  When I try to start a second instance of
> the application, it 'hangs' until the other instance is closed after which
> it continues.

Just a thought. Make sure that the 2 instances have different private
dirs.

-------------------------------
Paul Lambadaris
Singular Computer Applications
mailto : p...@singular.gr
www    : http://www.singular.gr

Paul Lambadar

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Sql Server 7.0 connections


In article <7m5ua2$km...@forums.borland.com>, max.berna...@unicall.be
says...
Quote
> Hello,

> I'm using SQL Server 7.0 with Delphi 4 through ODBC.  When I run the
> application once, it runs fine.  When I try to start a second instance of
> the application, it 'hangs' until the other instance is closed after which
> it continues.

Just a thought. Make sure that the 2 instances have different private
dirs.

-------------------------------
Paul Lambadaris
Singular Computer Applications
mailto : p...@singular.gr
www    : http://www.singular.gr

Other Threads

1. SQL Server 7.0 connection

2. Connection between SQL Server 7.0 on win98 and SQL Server 7.0 on Win2000 advanced server

3. Exclusive connection to MS SQL Server 7.0

4. Connection with SQL Server 7.0

5. Connection is busy and SQL Server 7.0

6. Open connections with TTable-components to SQL - server 7.0 during runtime

7. Connection is busy and SQL Server 7.0

8. DE problem with connection on SQL Server 7.0 without connect to the NT Lan

9. Sql Server 2000 & Sql Server 7.0

10. How to link Oracle server from SQL server 7.0