Is there some modification that can be done to make it work without installing 32 bit python and 32 bit pyodbc? Not really. If you have 32-bit Office installed then you have the 32-bit version of the Access Database Engine (a.k.a. “ACE”), and only 32-bit applications can use it. The installer for the 64-bit version … Read more
For x86 win download http://www.microsoft.com/en-us/download/details.aspx?id=20098 for using with: $db[‘default’][‘dbdriver’] = ‘sqlsrv’; use the php_sqlsrv_XX_ts_vcX.dll in php.ini extension if your webserver and your database server are not on same server with your app, install this: http://go.microsoft.com/fwlink/?LinkID=188400&clcid=0x409 and for linux as webserver: $db[‘default’][‘dbdriver’] = ‘mssql’; download & install = php5-sybase + freetds <br/>edit /usr/local/etc/freetds.conf <br/>create pdo_dblib.so & … Read more
Thanks to @chooban I found out the connection session was using latin1 instead of utf8. Here are two solutions I found: For RMySQL, after connecting run the query SET NAMES utf8 to change the connection character set. For RODBC, connect using CharSet=utf8 in the DSN string. I was not able to run SET NAMES via … Read more
You can specify the connection string as one long string that uses semi-colons (;) as the argument separator. Working example: import pyodbc cnxn = pyodbc.connect(r’Driver=SQL Server;Server=.\SQLEXPRESS;Database=myDB;Trusted_Connection=yes;’) cursor = cnxn.cursor() cursor.execute(“SELECT LastName FROM myContacts”) while 1: row = cursor.fetchone() if not row: break print(row.LastName) cnxn.close() For connection strings with lots of parameters, the following will accomplish … Read more
using the /passive switch you can install 64-bit ace drivers even if 32-bit ms office is present: http://blog.codefluententities.com/2011/01/20/microsoft-access-database-engine-2010-redistributable/ Just be warned that installing the 2010 64-bit ACE engine on a machine with 2010 32-bit Office already installed CAN lead to some wacky behavior in your already existing Office 2010.
The Problem When using native PHP ODBC features (PDO_ODBC or the older odbc_ functions) and the Access ODBC driver, text is not UTF-8 encoded, even though it is stored in the Access database as Unicode characters. So, for a sample table named “Teams” Team ———————– Boston Bruins Canadiens de Montréal Федерация хоккея России the code … Read more
Since you are using Access to compose the query, you have to stick to Access’s version of SQL. To choose between several different return values, use the switch() function. So to translate and extend your example a bit: select switch( age > 40, 4, age > 25, 3, age > 20, 2, age > 10, … Read more
Odbc cannot use named parameters. This means that the command string uses placeholders for every parameter and this placeholder is a single question mark, not the parameter name. OdbcCommand.Parameters Then you need to add the parameters in the collection in the same order in which they appear in the command string OdbcCommand cmd = conn.CreateCommand(); … Read more
According to ADO: ActiveX Data Objects, a book by Jason T. Roff, published by O’Reilly Media in 2001 (excellent diagram here), he says precisely what MOZILLA said. (directly from page 7 of that book) ODBC provides access only to relational databases OLE DB provides the following features Access to data regardless of its format or … Read more
None of these did it for me. I did find the answer on MSDN. There were hints to it though. The architecture in the error is referring to 32 vs 64 bits. My solution was to find out which my app is running under (Access) which 2010 is 32b. I found this by looking in … Read more