To be able to use PHP5 PDO with MS Access mdb files the following is required
(the same applies for the PHP4 style of using odbc_X except for the
obviously PDO specific requirements):
In Linux this is achieved by intalling the php5-odbc package:
| DROP FUNCTION IF EXISTS fn_remove_accents; | |
| DELIMITER | | |
| CREATE FUNCTION fn_remove_accents( textvalue VARCHAR(10000) ) RETURNS VARCHAR(10000) | |
| BEGIN | |
| SET @textvalue = textvalue COLLATE utf8_general_ci;; | |
| -- ACCENTS | |
| SET @withaccents = 'ŠšŽžÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÑÒÓÔÕÖØÙÚÛÜÝŸÞàáâãäåæçèéêëìíîïñòóôõöøùúûüýÿþƒ'; |
| #!/usr/bin/env python | |
| """ One-way sync to an SMB/CIFS server (needs pysmb) """ | |
| import logging, socket, os, sys, math | |
| from datetime import datetime | |
| try: | |
| from smb.SMBConnection import SMBConnection | |
| from smb.base import NotReadyError, NotConnectedError | |
| from nmb.NetBIOS import NetBIOS |
To be able to use PHP5 PDO with MS Access mdb files the following is required
(the same applies for the PHP4 style of using odbc_X except for the
obviously PDO specific requirements):
In Linux this is achieved by intalling the php5-odbc package: