Windows Database Driver

[yoda824]

Hey all,

I'm attempting to get arsenal suite running in windows.  I have tried numerous methods but can still not get around the database driver issue. 
Has anyone else had more luck with some steps as to how to get arsenal suite running in windows, the wiki has poor instructions.
Attached is a screen cap of what ive been staring at for 2 days.

Any help would be much appreciated.

[Viet Nguyen]

If you're using the build that I posted, you'll have to make sure to set the Environment variables accordingly. Namely, add all of the relevant library directories to the path such as:
c:\arsenalsuite\lib;C:\Program Files\PostgreSQL\9.1\bin;C:\Qt\4.6.3\bin

I screwed up my development environment, so I can't say for sure that's all you'll need. Also add an environment variable for your QT installation:
QTDIR C:\Qt\4.6.3\

I would suggest setting up a batch file to set the environment variables so you don't mess up any other apps that might be reading from the environment.

[yoda824]

Thank you for the response.
I believe i have all of my environment variables and paths are set correctly. 
These are my paths:
C:\Python26;C:\Python26\Lib\site-packages;C:\Program Files (x86)\PostgreSQL\8.4\bin;C:\Qt\4.8.2;C:\Qt\4.8.2\qmake;C:\arsenalsuite\lib;

It can't seem to find any database drivers and trying any other driver beside QPSQL7 causes it to crash. 

Again thanks for the response and any other help you may be able to provide

[Viet Nguyen]

So actually, are you using the binaries that I uploaded, or did you build yourself?

[Noah Corradin]

I used the binaries from your Downloads page.

- SIP 4.13 Windows
- PyQT 4.8.5 Windows
- Arsenal PyQT Libs Windows
-Qt and other libs for Windows

I tried building my own from source but had problems building pyqt,
freezer, and burner.

If i missed a step or possibly a dependency lemme know.

[Viet Nguyen]

Ah okay. Let's try moving the C:\arsenalsuite\lib to the front of the PATH, in case it's trying to pick up your version of QT.

Also, add an environment variable
QT_PLUGIN_PATH=C:\arsenalsuite\lib

[Noah Corradin]

Hmm, changed the order of the PATH and added the environment variable.
Unfortunately no change/progress.
I've tried putting the DLLs for the sqldrivers in the freezer
directory as well but still no luck.
I have Qt 4.8.2 and the Supplied PyQt from the downloads.

Thanks

[Viet Nguyen]

Hm. Try running Dependancy Walker on af.exe as well as QtSql4.dll, qpsqlpsql4.dll from the arsenalsuite lib dir and see if there's any funny business. I would look for linking to the wrong version of things, or perhaps missing dependancies.

http://www.dependencywalker.com/depends22_x64.zip

[Noah Corradin]

Interesting. Dependency Walker finds problems with IEFRAME.DLL and
SHLWAPI.DLL when i test af.exe, QtSql4.dll, and qpsqlpsql4.dll
Both of which are in my System32 folder which is included in my paths.

What should i be looking for in terms of linking the wrong versions?
i will continue to get this to run, your help is much appreciated.

[Matthew Newell]

Qt caches whether each plugin can be successfully loaded. If
qsqlpsql4.dll failed to load because libpq.dll was not found in the
path, or some other issue, it will not attempt to load the same dll
again until the timestamp on it changes, or the cache entry is
removed. The cache entries are stored in the windows registry.

Putting the following in a file with a .reg extension will allow
clearing all of the plugin cache by simply exec'ing the file.

"""
Windows Registry Editor Version 5.00

[-HKEY_CURRENT_USER\SOFTWARE\Trolltech\OrganizationDefaults\Qt Plugin
Cache 4.6.false]

"""

Adjust for whatever version of Qt you are using.

If this doesn't fix your problem you can set the QT_DEBUG_PLUGINS=1,
which may give clues. Also you can actually run af.exe inside
dependency tracker by using the "Profile" functionality and it should
show you any link problems.

Matt