Re: Two connections with Delphi 7 Professional?

From: Martijn Tonies (m.tonies_at_upscene!nospam!.com)
Date: 01/28/04 

Date: Wed, 28 Jan 2004 14:19:16 +0100

Hi Marcello,

> IŽll check the timeouts

The timeout value is also a property of TADOConnection ( CommandTimeout ).

>,but How can I check What version of SQL Server its
runing(PersonalEnterprise),

Use "SELECT @@VERSION"

>Do personal edition let
> more than one connection at a time,without any restrictions?

I think so, but I'm not overly familiar with different MS SQL Server
versions. 

--
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com

Relevant Pages

  • Re: Large Number Of Inserts
    ... > SQL server 2000. ... CommandTimeout properties of the Connection object or the CommandTimeout ...
    (microsoft.public.data.ado)
  • Re: Reconnect does not work TADOconnection
    ... We've dealt with similar issues using ADO and SQL Server. ... close the connection it also closes any open ADOdataset's that are bound to ... TADOconnection. ... Using an exception handler something like this: ...
    (borland.public.delphi.database.ado)
  • Re: SQL Timeout Error
    ... I am using Express versions of SQL Server 2005 and SQL Server ... "Robert Lakinski" wrote: ... and how do I set the CommandTimeout property? ... Whether SqlConnection object establishes connection to the sql server ...
    (microsoft.public.sqlserver.server)
  • TAdoConnection Disconnect
    ... (Delhi 7, Sql Server 2000) ... I have a TAdoConnection and I open this connection with starting program ... After a button click I want to close connection (after this time user can ...
    (borland.public.delphi.database.ado)
  • Re: Why all the connections?
    ... It reads through the result rows, opening another TADODataSet (SourceLookup) for each row in the result. ... a record is inserted in another database connected to another TADOConnection. ... Since the SourceConnection is Active all the time, returning the large result set, I can't see why SourceLookup with the same TADOConnection should be making a new connection. ... MS SQL Server Developer Edition SP4 ...
    (borland.public.delphi.database.ado)