ZSchedFix Beta Support and Suggestions

[zehd]

Please feel free to post any comments or concerns regarding ZSchedFix

http://gbpvr.com/pmwiki/pmwiki.php/Utility/ZSchedFix

Download from here...
http://gbpvr.com/pmwiki/pmwiki.php/Utility/ZTools

[-Oz-]

Downloaded it, double clicked to run it; it crashed, not a vb crash but a windows one.

[zehd]

Downloaded it, double clicked to run it; it crashed, not a vb crash but a windows one.

LOL

Well Well... I'll do some checking. Glad to have you on board for this one Oz. Though currently, the one function (when working) is quite basic. Works or doesn't...

[martint123]

Likewise the windows crash. module was sqlite3vb.dll

I just unzipped it into a temp directory, installed the two VB bits you mentioned in the wiki.

my program files dir is on E drive if that is of any consequence.

cheers
Martin

[zehd]

Likewise the windows crash. module was sqlite3vb.dll

I just unzipped it into a temp directory, installed the two VB bits you mentioned in the wiki.

my program files dir is on E drive if that is of any consequence.

cheers
Martin

Yeah that's what's probably causing you guys greif. I'm big on Defaults. (have I said that enough) and so now I will have to confirm the operation with Windows and Program Files on different partitions... It shouldn't be too hard to add some logging and find exactly where the troubles lays. Check back in a few hours

[martint123]

I copied the database and some other stuff into my temp playing directory in the hope that it might have a look in "current dir" first - seems not though.

[zehd]

I copied the database and some other stuff into my temp playing directory in the hope that it might have a look in "current dir" first - seems not though.

I'm looking into the possibility that sqlite3vb.dll was compiled and hardcoded to use c:\windows\system32 ONLY that would suck... I know that my software would go anywhere.

Just so you all know, that what happens when ZSchedFix starts is it tests for existence of sqlite3vb.dll in the %SystemDir%. (eg c:\windows\system32) If not, it sends a copy of sqlite3vb.dll to that location... From then on, My programs work cause the dll is in the right place...

I will be adding code that logs the test for existence...

I think I might have to donate to sqlite3vb.dll in order to get him to change the pathing, if that's the issue.

[-Oz-]

zhed, i'm using the dll in one of my programs but the code in your vb6 sample did not properly move the dll to the windows directory. It couldn't get the windows dir.

Try this code:

Const MAX_PATH = 255

Private Declare Function GetWindowsDirectory Lib "kernel32" _
Alias "GetWindowsDirectoryA" (ByVal lpBuffer As String, _
ByVal nSize As Long) As Long

Public Function GetWindowsDir() As String
Dim strRet As String, lngRet As Long

strRet = String$(MAX_PATH, 0)
lngRet = GetWindowsDirectory(strRet, MAX_PATH)
GetWindowsDir = Left(strRet, lngRet)

End Function

then called and handled with the following:

Dim fso As New FileSystemObject

'SQLite3VB.dll must be in the windows path. Copy if needed
If fso.FileExists(GetWindowsDir() & "\SQLite3VB.dll") = False Then
If fso.FileExists(App.Path & "\SQLite3VB.dll") = False Then
MsgBox "This program needs SQLite3VB.dll in the app path. Exiting"
Unload Me: End
End If
FileCopy App.Path & "\SQLite3VB.dll", GetWindowsDir() & "\SQLite3VB.dll"
End If

Make sure you have Microsoft Scripting & Runtime references as the FileSystemObjects need it. And i'm using mine just in C:\Windows

[zehd]

zhed, i'm using the dll in one of my programs but the code in your vb6 sample did not properly move the dll to the windows directory. It couldn't get the windows dir.

Try this code:


then called and handled with the following:


Make sure you have Microsoft Scripting & Runtime references as the FileSystemObjects need it. And i'm using mine just in C:\Windows

Thanks Dan. I just realized that I should be refering to the Windows not the Weindows/System33 dir. (Windows was the case in my code...)

I had a copy procedure similar to your code. And there was a time when my code failed and did notg get the windir path properly. I thought I had it...

When I get home, and check, if it's not obvious, I'll be stealing your code snippet... (I never did show you mine did I? remind me again...)

[zehd]

zhed, i'm using the dll in one of my programs but the code in your vb6 sample did not properly move the dll to the windows directory. It couldn't get the windows dir.

Try this code:


then called and handled with the following:


Make sure you have Microsoft Scripting & Runtime references as the FileSystemObjects need it. And i'm using mine just in C:\Windows

(Freaky actually how my code looks like yours.... Cool....)