[DB-SIG] mxodbc & mxdatetime

[M.-A. Lemburg]

Midha_Sanjeev/ny_technology@explorer.siny.com wrote:
> 
> We downloaded mxdatetime v 1.2.0 and mxodbc  v1.01 modules and
> installed it on win32 machine (NT as well as 98 & 95).
> 
> I am getting following error while importing MxDateTime module .
> ===================== Beging Error Stack ==========================
> Traceback (innermost last):
>   File "<interactive input>", line 1, in ?
>   File "C:\Program Files\Python\DateTime\__init__.py", line 20, in ?
>     from DateTime import *
>   File "C:\Program Files\Python\DateTime\DateTime.py", line 8, in ?
>     from mxDateTime import *
>   File "C:\Program Files\Python\DateTime\mxDateTime\__init__.py", line 7, in ?
>     from mxDateTime import *
> ImportError: DLL load failed: The specified procedure could not be found.
> ===================== End Error Stack ===========================

This is probably because you are using Python <1.5.2b2. I suggest
upgrading to the latest version (in older versions the APIs
PyString_InternXXX() were not properly exported in the WinXX DLL).

The alternative is recompiling. The mxpyapi.h header file should
then apply the following fix automatically:

/* These are missing from PC/python_nt.def and thus didn't get included
   in python1.5.lib on Windows platforms. */
#ifdef MS_WIN32
# define PyString_InternInPlace(x)
# define PyString_InternFromString(x) PyString_FromString(x)
#endif


> Similarly trying import odbc module and getting the following error message
> 
> ===================== Beging Error Stack ==========================
> Traceback (innermost last):
>   File "<interactive input>", line 1, in ?
> ImportError: DLL load failed: The specified module could not be found.
> ===================== End Error Stack ==========================

mxODBC uses mxDateTime, so you get the same error here.

> Similarly trying import ODBC.MySQL module and getting the following
> error message
> 
> ===================== Beging Error Stack ==========================
> Traceback (innermost last):
>   File "<interactive input>", line 1, in ?
> NameError: Case mismatch for module name ODBC
> (filename C:\Program Files\Python\win32\odbc.pyd)
> ===================== End Error Stack ==========================

You have obviously installed the win32all package from Mark
Hammond. There are instructions in the docs on what to do
about the naming conflict (there is an odbc module in win32all
too; it's a different one, though).

> Based on ur instructions, looks like I need to compile the modules
> using vc++, but I am having difficulty compiling the same.
> 
> IS THERE ANYWAY I COULD get COMPILED Distribution of the above

In about a month I expect to be developing on WinXX too, so
I'll include my own binaries in the extensions. Right now,
I'm relying on others to help me (and thereby helping others ;).

-- 
Marc-Andre Lemburg                               Y2000: 274 days left
---------------------------------------------------------------------
          : Python Pages >>> http://starship.skyport.net/~lemburg/  :
           ---------------------------------------------------------