VicRoads Traffic Camera Live

Installing MDAC 32 bits on Windows 64 bits

I am trying to read xlsx file through CodeReady which requires ODBC 32bits. When installing MDAC 2010 32 bits on a Windows 10 64 bits, it ended up with a warning.

You cannot install the 32-bit version of Microsoft Access Database Engine 2010 because you currently have 64-bit Office products installed. If you want to install 32-bit Microsoft Access Database Engine 2010, you will first need to remove the 64-bit installation of Office products. After uninstalling the following product(s), rerun setup in order to install 32-bit version of Microsoft Access Database Engine 2010:
Microsoft Access database engine 2010 (English)

It seemed to be a nightmare. But the solution was far simple than that. I didn't uninstall everything 64bits. All I need was to install the 32 bits driver in the command line with the magic parameter /passive

AccessDatabaseEngine.exe /passive

It was just as simple as that. It was done nicely without giving me a headache.

It was a happy day!

Microsoft Dynamics AX Workflow

A very clear demonstration from setup to application.

Using ODBC with classic ASP in IIS

I have a website developed in classic ASP with ADO. Basically, the IIS in Windows 10 (64 Bits) still supports running ASP. You will able to run ASP pages after installing the IIS with ASP enabled.

Go to Control Panel > Program > Programs and Features > Turn Windows Features on or of > Internet Information Service > World Wide Web Services > ASP

It is now all set for ASP pages.

However, there is still one more thing to do for running a ASP page with ODBC connection. 

Working with 64-bit Systems

Unfortunately there are no 64-bit ODBC drivers, so on 64-bit systems you will have to run your applications in 32-bit mode. To do so, use the following steps:

1. On the taskbar, click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.
2. In the Connections pane, click Application Pools.
3. Highlight the application pool for your application, then click Advanced Settings... in the Actions pane.
4. In the Advanced Settings dialog, specify True for Enable 32-Bit Applications.
5. Click OK to close the Advanced Settings dialog.

https://docs.microsoft.com/en-us/iis/application-frameworks/running-classic-asp-applications-on-iis-7-and-iis-8/using-classic-asp-with-microsoft-access-databases-on-iis

It is all done.

timedelta64[D] is always coerced to timedelta64[ns]

I encountered the same problem when calculating timedelta in a dataframe. It even ended with an error when I tried to call the days attribute. I am using Numpy 1.6.1

AttributeError: 'Series' object has no attribute 'days'

Problem

df_trans['DELTA'] = df_trans['DATE2'] - df_trans['DATE1']

print df_trans['DELTA'].dtype

timedelta64[ns]

print df_trans['DELTA']

0 8 days, 00:00:00
1 15 days, 00:00:00
2 5 days, 00:00:00

df_trans['DELTA'] = df_trans['DELTA'].astype('timedelta64[D]')
print df_trans['DELTA'].dtype

Name: DELTA, dtype: timedelta64[D]

print df_trans['DELTA']

0 8 days, 00:00:00
1 15 days, 00:00:00
2 5 days, 00:00:00
Nothing changed at all

print df_trans['DELTA'].days

AttributeError: 'Series' object has no attribute 'days'

I get rid of the problem by putting it in to a list for the conversion.

            Ss_timedelta = df_trans['DATE2'] - df_trans['DATE1']
            ls_timedelta = Ss_timedelta.values.astype('timedelta64[D]').tolist()
            for i in range(0, len(ls_timedelta)):
                    ls_timedelta[i] = ls_timedelta[i].days / 1000                        
            df_trans['HOLDDAYS'] = pd.Series(ls_timedelta)

Full discussion at GitHub
https://github.com/pydata/xarray/issues/1143

Download csv into DataFrame

import urllib
import urllib2
import csv
import pandas

#Calling this function will download a csv and return it in a dataframe
#21 AUG 2018
#David Tsang

def downloadasdataframe(url):

    req = urllib2.Request(url)
    response = urllib2.urlopen(req)
    reader = csv.reader(response)
    ls_data = list(reader)
    headers = ls_data[0]
    df_data = pandas.DataFrame.from_records(ls_data[1:], columns=headers)
    return df_data

Unable to find vcvarsall.bat - TA-lib

I hit the "Unable to find vcvarsall.bat" when installing TA-Lib using PIP. I am running Python 2.7.8 on Windows 10 64bits.

Here is how I get rid of the problem.

1. Downloading Microsoft Visual C++ Compiler for Python 2.7

https://www.microsoft.com/en-us/download/confirmation.aspx?id=44266

If you are running other version of python, you may seek help from this link

https://blogs.msdn.microsoft.com/pythonengineering/2016/04/11/unable-to-find-vcvarsall-bat/

2. Upgrade the setup tools and wheel

pip install --upgrade pip setuptools wheel

check the setuptools version by using pip list.

upgraded my setuptools to 40.0.0

3. Install TA-LIB

pip install TA-LIB

Good to go!