I'm having issues with oracle ODBC and access 2007

[PuddinPie]

Hello all,

I'm having an issue with using an ODBC connection with a pass-through query in access 2007.

I have Oracle 9i installed and am on Windows 7 32 bit. This only seems to be effecting Windows 7 users and not XP users.
The error in the SQL Log is this.

CLDemoFE 1694-162c EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 0x00787430
HWND 0x000501FC
WCHAR * 0x6D3A8B34 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x6D3A8B34
SWORD -3
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
DIAG [NA000] [Microsoft][ODBC driver for Oracle][Oracle]ORA-01019: unable to allocate memory in the user side (1019)
DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0)
DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0)


I've been looking all over the internet and can't find an answer to the issue and decided to post it to see what other people thought.

Thank you in advance.

 

[PuddinPie]

I figured it out. It was a corrupt tsnnames.ora file.