Omer Zak wrote: > Thanks to John Fabiani's tips, I made some progress in narrowing down > the problem of connecting to MS-SQL Server from software run by the Dabo > engine. > > It turns out that the Dabo Runtime Installer for MS-Windows > (ftp://dabodev.com/dabo/win/DaboRuntimeSetup.exe and > ftp://dabodev.com/dabo/win/DaboRuntimeSetupConsole.exe) do not include > the pymssql module. So an attempt to import it, as a result of setting > the DB type to "mssql", fails. >
You are right, the runtime installer docs should note which modules are included. I added a ticket for this: http://trac.dabodev.com/ticket/1139 > I also found that errors are logged to the file error.log in Dabo's main > directory - something which was not suggested by documentation which a > newcomer would see immediately. > > The Dabo Runtime Installer-provided Connection Editor should at least > provide some diagnostics. Or at least refer the evaluator to error.log. > > Since the PC, on which I made the above experiments, has also a regular > Python 2.5.1 installation which includes pymssql, I tried to copy > pymssql.py and _mssql.pyd to Dabo's main directory and to have them > imported. In another experiment, I added the regular Python 2.5.1 > site-packages directory to the import path (sys.path). > > Both experiments had the outcome that the following error message "Dabo > Runtime Engine has encountered a problem and needs to close", in a > MS-Windows standard dialog, which offers to send some diagnostic > information to Microsoft (a favor, which I declined). > Runtime Installer is meant as a quick to run minimum to look at Dabo. Using your existing python installation gives much more flexibility. You can use modules which are not included in the runtime installer. If you want to use your existing python installation, look here: http://dabodev.com/wiki/InstallingDabo http://dabodev.com/wiki/InstallationOnWindows Feel free to ask questions if necessary. > So, the Dabo Runtime Installer proved to be useless for me. I'll > install dabo-0.8.3.zip, which will use the regular Python 2.5 > installation and evaluate it instead. > > [The following part is for Dabo developers] > >>From my experience so far, the following improvements to the Dabo > Runtime Installers are advised: > > 1. Integrate pymssql.py (including the Leafe patch, if necessary), to > serve people, who already have MS-SQL Server DB, to which they wish > to connect using Dabo-powered applications. Dabo doesn't include any necessary db-modules besides sqlite, which comes with python >= 2.5. > 2. Have the Connection Editor provide detailed diagnostics when testing > a newly-created connection fails - or at least display a message > pointing the newbie developer to the appropriate error.log file. > 3. It would be a good idea for the Dabo Runtime Installers to reuse > an existing Python 2.5.1 installation if it is found (by adding the > appropriate directories to sys.path, and without installing files > in its standard lib/site-packages). > --- Omer > The runtime installer isn't meant to install Dabo into a existing python. Read: http://dabodev.com/wiki/InstallationOnWindows Uwe _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
