Paste your .odbc.ini settings to us. (blank out any confidential info)
I think you need to tweek the settings in it.
MS Access connection
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
System DSNray.wurlod wrote:Did you create a System DSN or File 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....
BR
Dan
Dan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: