That is a very smart idea. I shall try it this weekend and let you know if

there are any problems.

Have a nice weekend

Rafael Copquin

----- Original Message -----

From: "Grigore Dolghin" <gdolghin@gmail.com>

To: <profoxtech@leafe.com>

Sent: Friday, May 01, 2009 6:16 PM

Subject: Re: vfp9 and sql server express

>I am sorry, my mistake. Guess that's what happens when one talks from

> (bad) memory.

>

> You are creating the connection using SQLSTRINGCONNECT() or

> SQLCONNECT(). Both commands have a lSharable parameter which, if is

> .T., allows multiple CAs to share the same connection.

> In order to achieve this you should create the connection and store

> the handle in a public variable or (better) a property of a

> permanently visible object, such as _Screen.

>

> _Screen.AddProperty("ConnectionHandle")

> _Screen.ConnectionHandle = SQLCONNECT("myDNSName",.T.)

>

> or

>

> _Screen.AddProperty("ConnectionHandle")

> _Screen.ConnectionHandle = SQLSTRINGCONNECT("ConnectionStringHere",.T.)

>

> To set the cursoradapter classes to use the previously created

> connection, open them in class designer, right click, builder, and

> check "Use existing connection handle" and enter

> _Screen.ConnectionHandle in that textbox.

>

> On Fri, May 1, 2009 at 4:51 PM, Rafael Copquin <rcopquin@ciudad.com.ar>

> wrote:

>> Thank you Grigore

>> But I get the message: 'the property is readonly'

>> What am I doing wrong?

>> Rafael

>>

>>

>> ----- Original Message -----

>> From: "Grigore Dolghin" <gdolghin@gmail.com>

>> To: <profoxtech@leafe.com>

>> Sent: Thursday, April 30, 2009 7:32 PM

>> Subject: Re: vfp9 and sql server express

>>

>>

>> Issue the following line somewhere in the beginning of your program

>> (before connecting to SQL Server):

>>

>> SQLSetProp(0,"Shared",.T.)

>>

>> This will force VFP to force first connection that will be made to be

>> shared.

>>

>>

>>

[excessive quoting removed by server]