🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #137

Re: BCB6 ADO problem with Vista

#137
From: George P Boutwell
Date: Mon, 12 Nov 2007 03:07
23 lines
2305 bytes
"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;
Technical Details
Message-ID: <4737d17e$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsgate.cistron.nl!xs4all!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <4734a20d$1@newsgroups.borland.com> <4734c21d$1@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,d628bc7458729f40
X-Google-Attributes: gid10698b,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "George P Boutwell" <gboutwel@valleyhope.com>
Sender: "George P Boutwell" <gboutwel@valleyhope.com>
Reply-To: "George P Boutwell" <gboutwel@valleyhope.com>
Subject: Re: BCB6 ADO problem with Vista
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 204.96.148.15     
References: <4734a20d$1@newsgroups.borland.com> <4734c21d$1@newsgroups.borland.com>
NNTP-Posting-Host: 207.105.83.66
Message-ID: <4737d17e$1@newsgroups.borland.com>
Date: 11 Nov 2007 20:07:26 -0700
X-Trace: newsgroups.borland.com 1194840446 207.105.83.66 (11 Nov 2007 20:07:26 -0700)
Lines: 25
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsgate.cistron.nl!xs4all!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail