Messages

1

ThumbsPlus v7-v9 Questions / Database error: SQL Connect Error; Windows 8.1 conflict?

« on: 2014-03-03 23:01:24 »

> My bad - I mis-typed the release numbers; it's 3935 I got the error on and 3928 I installed successfully, and then updated

Tried 3928. Still, sadly, the same errors.  

I am waving the white flag for now. Maybe when SP1 comes out for TP 9, I will try again. Hope that will be soon. If not, I am just going to have to finally, after many years (a decade) and wasted money on my recent upgrading to pro version, need to find something else to take TP's place. Just there isn't a TP competitor program that I am as happy with using as I was with TP. But that's life. I need to move on as I have some personal projects on hold because of this issue.

My thanks to everyone for your time and trouble in trying to help me with this issue. I am at my wits end, and out of options for now. Win 8.1 hath killed TP for me. Thanks Microsoft.  Maybe upgrades from Win 7 are OK, but starting from a clean Win 8 install and then upgrading to Win 8.1 apparently can have TP issues for some folk.

2

ThumbsPlus v7-v9 Questions / Database error: SQL Connect Error; Windows 8.1 conflict?

« on: 2014-02-27 23:22:13 »

Drat, they don't have build 3528 available for download. I tried installing version 7 Sp1, and Version 8 before, but they would not run either (same errors). Does look like ThumbsPlus and Windows 8.1 are not friends by any means. Is there some place one can download build 3528? The archive on the Cerious Website does not go earlier than build 3919 for version 9.


> Note: I had a problem installing ThumbsPlus9 (3595) on Windows 8.1 with the error on the SQLite3 ODBC drivers.  Downloaded a prior version (3528) and installed it successfully.  Then was able to upgrade to 3595.
>
> Seems to be a problems with the latest release on a clean Windows 8.1 install.

3

ThumbsPlus v7-v9 Questions / Database error: SQL Connect Error; Windows 8.1 conflict?

« on: 2014-02-22 16:30:35 »

Looking at the "ThumbPlus is starting" message box, I see "Thumbs.tpdb8:Driver={Microsoft Access Driver(*.mdb)}" -- I don't have Access installed, so that's the issue? How do I change the driver? I am very inexperienced with ODBC Data Source Administration (as you probably can tell by now).

4

ThumbsPlus v7-v9 Questions / Database error: SQL Connect Error; Windows 8.1 conflict?

« on: 2014-02-22 15:53:18 »

OK, I realized one error. The 32-bit and the 64-bit versions of the ODBC Data Source Admin tool have the exact same file name. And the 32 bit is in the SysWow64 folder while the 64 bit is in the System32 folder. Same file name, 64-bit version in the 32 folder, 32-bit version in the 64 folder. I got confused.

5

ThumbsPlus v7-v9 Questions / Database error: SQL Connect Error; Windows 8.1 conflict?

« on: 2014-02-22 15:45:13 »

> There are more programs that have similar or the same problem, see e.g. these discussions:
>
>   http://www.interfaceware.com/manual/odbc_64.html

Looking at this page, they say " The error occurs at this point because the data source was created using the 64-bit ODBC Administrator tool, and Iguana cannot find the sources made by that tool.

To fix this issue:

    Set up an ODBC connection using the 32-bit ODBC Administrator tool located in the following directory: %SystemRoot%\SysWow64\odbcad32.exe"

I run %SystemRoot%\SysWow64\odbcad32.exe, and I get a "ODBC Data Source Administrator (64-Bit)" window. 64 bit. Not 32 bit, even though I ran the 32-bit ODBC Administrator tool. Shouldn't running %SystemRoot%\SysWow64\odbcad32.exe give me a "ODBC Data Source Administrator (32-Bit)" window? Could this be the issue, that I do not have a real 32-bit ODBC Admin tool (just a 64-bit one masquerading as a 32-bit one)?

6

ThumbsPlus v7-v9 Questions / Database error: SQL Connect Error; Windows 8.1 conflict?

« on: 2014-02-22 15:36:49 »

>
> If you're not ready to give up just yet, there's an installer for SQLite here:
>   http://www.ch-werner.de/sqliteodbc/

Installed, but still, the same errors as before. I've not given up yet - been using TP for about a decade now and gotten quite used to it (spoiled by it), that I really want it to keep working.

>
> I'll let you know if I think of anything else.

Thanks.

7

ThumbsPlus v7-v9 Questions / TP v9 does not allow compatibility mode Win 8

« on: 2014-02-20 20:37:17 »

Trying to get TP v9 to work on Win 8.1, I got advice to try compatibility (since TP v9 did work on Win 7 for me, even Win 8, just not Win 8.1).

However, when I try to run in compatibility I get a message window that has an issue with it - it asks "Do you wish to remove this compatibility layer and restart ThumbsPlus?" and gives you three options: Yes, No, and Cancel. But these are fake options. There is no choice - you cannot click "NO", for you will just get the same message window. You cannot click "Cancel" for again, you will just get the same message window. You can only choose "Yes".

So why give us options if there is only one option that will work? Just say, sorry, compatibility layers are not allowed, TP will now remove the compatibility layer and restart.

8

ThumbsPlus v7-v9 Questions / Database error: SQL Connect Error; Windows 8.1 conflict?

« on: 2014-02-20 16:17:41 »

>
> You should be able to run "%SystemRoot%\SysWOW64\odbcad32.exe" from Start | Run to get to Windows' ODBC driver setup. It has a tab called Tracing where you can turn on a


Ran it, first got the warning:



clicked OK, ran through the errors, exited TP, turned off logging. I now have a log, but heck if I understand it (screenshots below).

>
> TP itself has a diagnostic startup option too that you can access from Windows' Start | Programs menu (look under ThumbsPlus | Utilities).

Didn't do anything different than if I just started up regularly (I get all the same errors as before. TP will not get past starting up - it never finishes starting up).

Some %SystemRoot%\SysWOW64\odbcad32.exe screenshots:





Some screenshots of the SQL.LOG (the four screenshots cover the first half of the log file):

9

ThumbsPlus v7-v9 Questions / Database error: SQL Connect Error; Windows 8.1 conflict?

« on: 2014-02-19 23:01:26 »

"Old problem" still unsolved. Some new info, and some screenshots included this time.

I just tried the latest update, ThumbsPlus 9 build 3935, hoping to get TP back to working order. TP worked on Windows 7. Worked on Windows 8. But it is no longer is working on Windows 8.1.

Latest versions of TP will not allow me to change compatibility settings.

TP does not run. It installs, but does not run. I install with default settings every time, but always get when I try to run it:



Nothing I do fixes the problem:

[*] Creating a new database
[*] Open an existing database
[*] Uninstalling, reinstalling
[*] Deleting Thumbs.tpdb8
[/list]

I tried running older versions: version 7 sp2 (Standard), version 8 (Standard). Same error.

I am logging on to Windows with an account that has administrator rights.

I even paid for an upgrade to Pro (yes, I now know, you get the same download file - I was getting desperate to get this to work).

Windows 8.1 64-bit
.tpdb8 database
ThumbsPlus 9 build 3935
TP Error Message <5015*8036>

Screenshots:

1. Try to run:



2. Click OK and get:



3. Click "Open default database" and get:



4. Click OK and get:


(I search, and Thumbs.tpdb8 does exist at This PC > OS(C:) > ProgramData > ThumbsPlus)

5. Click OK and get:



6. Click Exit to finally exit.



Result of selecting Open database:

10

ThumbsPlus v7-v9 Questions / Version 8 SP 1 with Windows 8.1

« on: 2014-02-07 18:42:01 »

Version 9 is not working with Windows 8.1 either. I can't even get Version 7 to work on Windows 8.1. Really beginning to just love Windows 8.1. And for the Sheldons in the group, that was indeed sarcasm. :-)

11

ThumbsPlus v7-v9 Questions / Database error: SQL Connect Error: Cannot use for months now

« on: 2014-02-07 18:39:00 »

Running the Windows Program Compatibility Troubleshooter (what Windows 8.1 calls it), set compatibility mode to Windows 7, and clicked on "Test the program..."

TP is now giving me this message:

"Windows has loaded a compatibility layer, which may cause crashes or other problems in ThumbsPlus. Do you with to remove this compatibility layer and restart ThumbsPlus?"

ThumbsPlus Message <6039>

Clicking No gives me the same above message. I'm in a loop.  

Now I'm clicking "Cancel" but all I get is a repeat of the above message. Looks like I'm really in a loop.

Ah, I click "Yes" and I'm out. Back to the Test compatibility settings for the program window.

I'll skip the Test the program button and just click Next and then "Yes, save these settings for this program."  

Click on TP, and get my old "friend" the Database error: SQL Connect Error. Drat. Square 1.

OK, let's try the right-click --> properties and just ignore that Program Compatibility Troubleshooter.  I choose Windows 7 and Run this program as administrator. Run TP. And get the "Windows has loaded a compatibility layer..."

Apparently TP does not want to be put into compatibility mode.

Again, back to square 1. Like Edison, I keep finding ways that don't work. But hopefully like Edison, 1 way will eventually work. Just hope it's not, like Edison, after many thousands of tries!

12

ThumbsPlus v7-v9 Questions / Database error: SQL Connect Error: Cannot use for months now

« on: 2014-02-06 22:44:25 »

> Sorry, I should remember not to reply to threads before my first coffee; I misread it and thought you were running MySQL!

Understand that. My moto is "I drank coffee, therefore I think."
>
> Have you tried installing the Microsoft Access Database Engine 2010 Redistributable?  (http://www.microsoft.com/en-us/download/details.aspx?id=13255)

Didn't think about that. I downloaded and installed the x32 version, but, alas, alack, and wail away, again to no avail. What the bejeebers is going on with my Windows 8 machine? TP worked on Windows 7. But that PC died (big time - PSU went, taking the mobo with it.) So, got a new PC with "lovely" Windows 8. Hmm, TP worked with Windows 8, but now that it is Windows 8.1, it's not working. Maybe a coincidence.

13

ThumbsPlus v7-v9 Questions / Database error: SQL Connect Error: Cannot use for months now

« on: 2014-02-06 17:45:28 »

I checked HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI but did not find a "ODBC Data Sources" key. Shouldn't there be a "ODBC Data Sources" key?

14

ThumbsPlus v7-v9 Questions / Database error: SQL Connect Error: Cannot use for months now

« on: 2014-02-06 17:25:31 »

> Which version of the MySQL ODBC driver are you using, 32 or 64 bit?
>
> As TP is a 32 bit app, it must use the 32 bit ODBC driver even though you may be using the 64 bit version of MySQL.
>
> Also make sure you have this line in my.ini:-
>
> sql-mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,ANSI_QUOTES"
>
> By default ANSI_QUOTES is not included in that setting.

I don't have MySQL installed. It has been a loooong time since I've worked with MySQL.

15

ThumbsPlus v7-v9 Questions / Database error: SQL Connect Error: Cannot use for months now

« on: 2014-02-06 17:24:34 »

I have tried reinstalling using "run as administrator" to no avail. I reinstalled Word 2013, using online repair, and then reinstall ThumbsPlus using "ruan as administrator" and, again, to no avail. Same error messages. Does look like something in Windows' ODBC database system is broken, just have no idea how to fix it yet.