TADOQuery Throwing "S1000HY000connection is busy with results..."
Hi. I asked this question back in 2011 and never got a satisfactory response. My supervisor told me to drop it. But this is now happening to a customer and has become a hot topic again. Hoping I'll get something more helpful this time around. :) Here are the details. I have an application written in Delphi 7. For my connection string, I check to see what operating system it is being run on. If the OS is Windows 8.0 and greater, I use sqlncli.11, otherwise I use sqlncli.1. The error happens ONLY when connected to a SQL2005 instance when on an XP. It never happens in any other ci...

TADOQuery Throwing "S1000HY000connection is busy with results..." #3
Hi. I asked this question back in 2011 and never got a satisfactory response. My supervisor told me to drop it. But this is now happening to a customer and has become a hot topic again. Hoping I'll get something more helpful this time around. :) Here are the details. I have an application written in Delphi 7. For my connection string, I check to see what operating system it is being run on. If the OS is Windows 8.0 and greater, I use sqlncli.11, otherwise I use sqlncli.1. The error happens ONLY when connected to a SQL2005 instance when on an XP. It never happens in any other ci...

Precedence of "where" ("of", "is", "will")?
Nobody on #perl6 today could answer this one. Is: Str | Int where { $_ } the same as: (Str | Int) where { $_ } or: Str | (Int where { $_ }) ? Followup questions, Mr. President: What kind of operators are "where", "of", "is", and "will"? Is there a reason that S03 doesn't list them? What are their precedence(s)? -- Chip Salzenberg - a.k.a. - <chip@pobox.com> Open Source is not an excuse to write fun code then leave the actual work to others. Chip Salzenberg writes: &...

.ALLCOL("%COLUMN%", " ", ", ", ", ")
Do you know anyway for me to exclude a subset of columns returned by this function. We have two columns (rec_user and rec_datetime) which are in all of our tables, but when generating triggers I want automatically generate a script which does not include those two columns but does include all other columns in that table. Bruce I should add that I am using PD 9.0.0.580. Bruce "Bruce Lamb" <lamb.bruce@mayo.edu> wrote in message news:6HgI315nCHA.155@forums.sybase.com... > Do you know anyway for me to exclude a subset of columns returned by this > function. ...

Delphi 2010 IDE throws error on "find" and "find in files"
I will greatly appreciate any advice how to cure the suddenly appeared misbehaviour: I just loaded the main project file and then tried to find code snippets fore re-use with "find" and "find in files" the Eurekalog extract is: 2.2 Address : 20EB30B6 2.3 Module Name : vclide140.bpl - (Integrated Development Environment Specific Components) 2.4 Module Version: 14.0.3593.25826 2.5 Type : EOutOfResources 2.6 Message : Unable to insert a line. 2.7 ID : 61FB 2.8 Count : 1 2.9 Status ...

Banshee 2.0 "export playlist" and "import playlist" results differ
I'm new to banshee but playing with it to see if I like it or not. I have a playlist of 634 tracks that I export to a file. I then try to import that same file and only 627 tracks get imported into the created playlist. The 7 tracks that are missing are: #EXTINF:125,Elvis Presley - Don't Be Cruel ../../../../media/LinuxHD/Music/Elvis Presley/Elv1s 30 #1 Hits/02. Don't Be Cruel.mp3 #EXTINF:189,Elvis Presley - Are You Lonesome Tonight? ../../../../media/LinuxHD/Music/Elvis Presley/Elv1s 30 #1 Hits/16. Are You Lonesome Tonight_.mp3 #EXTINF:181,Elvis Presley - Can't H...

quotes, quotes, quotes...
I am getting this error and I know what is causing it, but I have no idea how to fix it, any help would be great. The script steps through the /var/log/messages file on a linux server and puts The entries into a mysql database. However when it gets to the 'hlt' line in the messages file it just barfs. The single quotes are freaking it out. I know about quotes but not how to use in this situation. Thanks, Paul Error: May 27 17:53:00 localhost kernel: Checking 'hlt' instruction... OK. <----- doesn't like this in the messages file DBD::mysql::st exec...

Delphi XE3 "Connection is busy with results for another command"
Hi, I have a little program in DelphiXE3 connecting to MSSQL Sqlexpress 2012 that uses three DbExpress parametrized querys connected to a TSQLConnection that has these parameters: DriverName=MSSQL GetDriverFunc=getSQLDriverMSSQL LibraryName=dbxmss.dll VendorLib=sqlncli10.dll The querys open cascade and when I try to open the last one I get a "TDBXError with message Connection is busy with results for another command" If I use the same program connecting to Firebird, Informix or Oracle databases I dont have this trouble. Any help will be appreciated, Hernando. I...

"2.1pre" (RC2) and search results--can't do much in "Search Messages" window
I am running RC2 on Windows 7, 64-bit and find that when I use the "search messages" window, there is very little I can do with the listed search results. Click, double-click, and right-click do nothing on a search result item. While I can select any search result item, and highlight it, I can't open it with the "Open" button. (I can however delete it with the "Delete" button. "Open Message Folder" will open a new message window with the message selected.)) This is stuff I used to do all the time with earlier versions of SeaMon...

Difference between passing "?" versus ":1", ":2", ":3" etc in prepare in Perl DBI !
------=_Part_26521_25854351.1225691891708 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi What's the difference between passing "?" versus ":1", ":2", ":3" etc in prepare in Perl DBI ? For example, what's the difference between following two scenarios :- *Scenario 1* $sth = $dbh->prepare("insert into tablename values (:1, :2, :3)"); $sth->execute($var1,$var2,$var3); *Scenario 2* $sth = $dbh->prepare("insert into tablename values (?, ?, ...

ADSIImport for users retrieves from AD "\" + firstName" + " " + lastName as Username (ver 2.1.2)
Hi, I've installed both TTTASDIAdmin and ASDIImport and they both seem to run well. I have a problem with importing users from an Active Directory of a subdomain (win2k server). Instead of getting the username as well as other details, all I get is: First Name: firstName" + " " + lastName Last Name: (empty) Username: "\" + firstName" + " " + lastName email: firstName" + " " + lastName +@myMailserver.org.au (reads the mail server from ASDI setting) My ASDI setting are: Win Authentication RootDomain: subDomain.Do...

Using "+" or "||"
Using SQLAnywhere 5.5.04, I've gotten into the habit of using "||" in ISQL to indicate a string concatenation. I needed to paste my SQL statement into the PowerBuilder script painter for some embedded SQL, and PB didn't like the "||" very much at all. I changed it to "+" and it seems to be ok. Do these two operators indicate ~exactly~ the same thing? moin, afaik these two's are not the same! if you're using "||" and any term is NULL then in the resultstring the term will be ignored if you use "+" then the resu...

Results of "hiatory" or "autocomplete" search
Name: Peter Herklotz Email: softwareatpch-edvdotcom Product: Minefield Summary: Results of "hiatory" or "autocomplete" search Comments: Hello, in your release note you mention that the new display makes finding the web site you're searching for easier. In my opinion the opposite is true. The new display - at first glance a seemingly unstructured mixture of different font sizes - makes finding the result rather quite hard. What used to be findable with one short look at the result list now requires a really concentrated review of all the lines appear...

replace the "." with a ","
Oi.... I need to build a small programm in ASP.NET and chose to use C# for it.Now i got everything working but there's one little problem.the first textbox is a double. I need to make it so that when someone enters a "." then it gets replaced by a ","any ideas?Ghan  string blah = "4.2.2.2";blah = blah.Replace(".", ",");Ryan Ryan OlshanASPInsider | Microsoft MVP, ASP.NEThttp://ryanolshan.comHow to ask a question...