Page 1 of 1
Posted: Mon Nov 24, 2014 8:55 am
by PaulVL
Paste your .odbc.ini settings to us. (blank out any confidential info)
I think you need to tweek the settings in it.
Posted: Mon Nov 24, 2014 3:59 pm
by ray.wurlod
Did you create a System DSN or File DSN? DataStage will not work with a User DSN.
Posted: Tue Nov 25, 2014 12:08 am
by BillB
Also try checking the setting of your TMP and TEMP environment variables, in the context of the user that is running the DataStage job. This is easiest done by looking at the log entry headed 'Environment variable settings'.
The user that is running the ODBC job needs to be able to create subfolders in the TMP/TEMP folder. It can't always do this if the variable is set to some default value, eg C:\Windows\system32\config\systemprofile\AppData\Local\Temp.
Posted: Tue Nov 25, 2014 2:41 am
by tine_bi
PaulVL wrote:Paste your .odbc.ini settings to us.
Looks like this
[ODBC 32 bit Data Sources]
MS_Access_TINE_Felles=Microsoft Access Driver (*.mdb, *.accdb) (32 bit)
[MS_Access_TINE_Felles]
Driver32=C:\PROGRA~2\COMMON~1\MICROS~1\OFFICE14\ACEODBC.DLL
Posted: Tue Nov 25, 2014 2:44 am
by tine_bi
ray.wurlod wrote:Did you create a System DSN or File DSN?
System DSN
But i now see something I am not sure is correct.
It resides in the 64- bit ODBC driver, when opening the 32-bit it is not listed, however, if I look at the odbc.ini I find this
[ODBC 32 bit Data Sources]
MS_Access_TINE_Felles=Microsoft Access Driver (*.mdb, *.accdb) (32 bit)
[MS_Access_TINE_Felles]
Driver32=C:\PROGRA~2\COMMON~1\MICROS~1\OFFICE14\ACEODBC.DLL
Not sure if that has anything to do with it....
Posted: Tue Nov 25, 2014 2:47 am
by tine_bi
BillB wrote:Also try checking the setting of your TMP and TEMP environment variables
Both resides in C:\WINDOWS\TEMP
Posted: Tue Nov 25, 2014 3:25 pm
by ray.wurlod
Use the 32-bit ODBC Administrator (odbcad32.exe) to create a 32-bit DSN. You will probably find this in the SysWOW64 folder.