Thursday, July 15, 2010

PyMSSql - import _mssql - ImportError: DLL load failed: The specific module could not be found

under windows xp pro,
When attempting to import pymssql.py,
I experienced the following error:


"
import _mssql
ImportError: DLL load failed: The specific module could not be found
"

So this is all a bit cryptic, but after googling, which suggested using a windows diagnostic tool [ProcessMonitor] to locate the failing process, it turns out that what is missing is an (accessible) copy of 'mscvr71.dll', which can be downloaded off the net, and should be copied to 'c:\windows\system32\', or 'c:\windows\system\' if running 64bit windows.

you then need to run 'regsvr32 msvcr71.dll' from the command line, in the directory that you copied the dll to.

cant find entrypoint

if you get a 'cant find entrypoint' type error message, its actually still all ok, pymssql should run just fine by that point.

Tuesday, July 13, 2010

Sunday, July 11, 2010

Python Client Consumes WCF Web Service


End-Point = ABC
- Address
- Binding
- Contract

WSDL Components

definition
    types
    message
    portType = interface implementation
        operation
            input
            output
    binding = abstract interface
        operation
            documentation
            input
            output
    service
        wsdl:port (name, binding)
            x:address (location)

 
Example Publicly Accessible / iNet WSDL

GlobalWeather.com
- http://www.webservicex.com/globalweather.asmx?wsdl

wsf.cdyne.com
- http://wsf.cdyne.com/WeatherWS/Weather.asmx?WSDL

thomas-bayer.com
- http://www.thomas-bayer.com/axis2/services/BLZService?wsdl
 
External Links

- Make a SOAP client with Python
- StackOverFlow - How can I consume a WSDL (SOAP) web service in Python?
- SourceForge - Python Web Services Project

Thursday, July 1, 2010

RSA ID Number Check-Sum Algorithm

infomation sourced from this site.

13 digit South African Identity Numbers have the following format

{YYMMDD}{G}{SSS}{A}{Z}

YYMMDD Date of birth
G Gender: 0-4 = Female, 5-9 = Male
SSS Sequence No. for DOB/G combination.
C Citizenship: 0 = SA, 1 = other
A generally, but not strictly = 8, 9
Z CheckSum Digit

Calculation of Checksum Digit = Z

A = sum of digits in odd position (excluding last checksum digit)
B = sum of all the digits of the product of 2 and the number formed from the original be removing all the odd digits
C = A + B
Z = 10 - (second digit of C)

Sunday, June 13, 2010

Test Driven Python Development [link]

http://www.slideshare.net/Skud/test-driven-development-tutorial

Linux Admin Blog [excellent]

Linux Admin Chris Siebenmann, @thatcks, maintains a rather excellent blog Wandering Thoughts @ http://utcc.utoronto.ca/~cks/space/blog/ .

Sunday, May 30, 2010

Unit Testing C# with NUnit

MonoDevelop
http://www.dijksterhuis.org/using-nunit-with-monodevelop/