🚀 go-pugleaf

Check that you have set Connected = false for all TADOConnection objects and 
Active = false for all ADO TDataSet descendants (TADOQuery, TADODataSet) in 
all forms and data modules in IDE, and make sure that you connect to MS SQ 
Server only from code. Lock-up can happen if MS SQL Server provider tries to 
connect to server that does not exist (i.e. server with specified name does 
exist on your development machine but does not exist on computer where 
program locks up).

>   str = "Provider=SQLOLEDB.1;Integrated Security=SSPI;";
>   str += "Data Source=")+_Server+_T(";";
>   str += "Initial Catalog=")+_Database+_T(";";

What is a type of str? Anyway it seems that you combine ASCII and Unicode 
(strings in form _T"..."). Try to use either ASCII or Unicode, better to use 
WideString. Check what is exactly in TADOConnection.ConnectionString just 
before you call Connected = true (or Open()), to see that string is not 
mangled by combining ASCII and Unicode. Try to have str of type WideString 
and use all constants without _T.

WideString str = WideString("...") + WideString("...")

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)


"George P Boutwell" <gboutwel@valleyhope.com> �������/�������� � �������� 
���������: news:4737d17e$1@newsgroups.borland.com...
>
> "Clayton Arends" <nospam_claytonarends@hotmail.com> wrote:
>>Hey George, long time no talk.  Looks like you're doing some legacy 
>>support?
>
> :) Yeah.  Didn't realize that you did ADO and would be in the same shoes. 
> Yeah, been I while, sorry I hadn't chatted.  :)
>
>>Our main product is an ADO tool that we currently still compile with BCB6.
>>I develop on Vista and we haven't had this problem on any of our Vista
>>boxes.  Have you tried making a new app that connects to a DB with ADO and
>>executes a simple query?  What database driver are you using?  Does it 
>>work
>>using a Jet driver to a simple Access (MDB) database?
>>
>
> Yes, we see the problem even debugging our application in BCB6 under 
> Vista.  We see the problem creating a new BCB6 application with just an 
> ADOConnection dropped on it and the string below 'built' using the ADO 
> String Builder wizard/helper.  We lock/freeze when we run the app in 
> debugger, with UAC turned off completely or turned on - deson't seem to 
> matter.  It's an MS SQL app using ADO to connect with it.
>
> ADO Connection String is something like this:
>
>   str = "Provider=SQLOLEDB.1;Integrated Security=SSPI;";
>   str += "Data Source=")+_Server+_T(";";
>   str += "Initial Catalog=")+_Database+_T(";";
>
> so:
>  Provider=SQLOLEDB.1;Integrated Security=SSPI;Data Source=MyServer;Initial 
> Catalog=MyDB;
>
>