Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: dcNiko Vujke
  Where is dcNiko Vujke?
 Belgrade
 Serbia
 dcNiko Vujke
 To: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 Tags
Subject: RE: Using connection of CA
Thread ID: 268449 Message ID: 268555 # Views: 34 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: ODBC, ADO and OLEDB
Date: Tuesday, July 13, 2010 8:43:08 AM         
   


> > OK, thanks.
> > But here we are creating a new connection. I thought to use same connection for CA and some SQL pass through (mostly the SELECT statements, never in transaction).
> > Is this possible?
> >
> > Regards.
>
> Yes we are creating a new connection and that is what I always suggest to do. I simply wouldn't suggest using an existing connection. Create the connection, do whatever, close it. I don't also suggest using SPT but ADO.
>
> Cetin Basoz
>
> .Net has got better.Think about moving - check my blog:
> Blog (main)
> Blog (mirror)

Thanks Cetin.

Then I will use two separate connections. I thought that it is better to decrease number of connections per form, but it seams that it is not a good idea.

Regards.

ENTIRE THREAD

Using connection of CA Posted by dcNiko Vujke @ 7/12/2010 11:27:25 AM
RE: Using connection of CA Posted by Cetin Basoz @ 7/12/2010 12:01:06 PM
RE: Using connection of CA Posted by dcNiko Vujke @ 7/12/2010 12:35:44 PM
RE: Using connection of CA Posted by Cetin Basoz @ 7/12/2010 2:05:00 PM
RE: Using connection of CA Posted by khubaib khalid @ 7/12/2010 2:48:56 PM
RE: Using connection of CA Posted by Cetin Basoz @ 7/12/2010 4:28:14 PM
RE: Using connection of CA Posted by dcNiko Vujke @ 7/12/2010 3:08:07 PM
RE: Using connection of CA Posted by Cetin Basoz @ 7/12/2010 4:27:01 PM
RE: Using connection of CA Posted by dcNiko Vujke @ 7/13/2010 8:43:08 AM
RE: Using connection of CA Posted by Cetin Basoz @ 7/13/2010 11:25:12 AM
RE: Using connection of CA Posted by Michael Kopljan @ 7/13/2010 11:37:29 PM
RE: Using connection of CA Posted by dcNiko Vujke @ 7/15/2010 11:03:43 AM