ORA-01019 error in win7 but not XP

[kawi6rr]

Having a hard time figuring out why I get this error in win7 but not winXP? There is an MS Access application that is using the connection string below. A few of our employees have been moved to win7 and are reporting this.

ERROR
ORA-01019: unable to allocate memory in the users side

CAUSE
connectStr = "Provider=msdaora;Data Source=HIDW.WORLD;User Id=xxxxx;Password=xxxxx"
conn.Open (connectStr)

Why would this work n XP and not win7? Does anybody know a work around for this? Any help is appreciated, thanks.

 

[CJ_London]

Someone else seems to be having a similar problem - see if these links address your issue

http://www.access-programmers.co.uk/forums/showthread.php?p=1320052#post1320052

http://answers.microsoft.com/en-us/windows/forum/windows_8-windows_install/possible-to-install-ms-access-2003-on-windows-8/ba6bf4ad-44d6-458e-bb87-e9479201fe85?msgId=63b571ed-9233-4b4d-9852-8cf04024f01e

 

[kawi6rr]

We're using win7 not win8 and all Access 2003 applications work on it just fine the only issue is the ODBC connection to the Oracle DB.

 

[CJ_London]

Sorry for trying to help

 

[kawi6rr]

I wasn't trying to be rude its hard to convey emotion when posting quick responses to forums replies

 

[WayneRyan]

kawi6rr,

This works for me in Windows 7:

strConnection = "Driver={Oracle In InstantClientx32};" & _
                "DBQ=ORCL;" & _
                "Database=EWDS_2012;" & _
                "Uid=xxxx;Pwd=xxxx;"

Wayne

 

[kawi6rr]

Thanks Wayne your post lead me in a direction for a solution. It ended up not being a coding issue but when work issued us new computers they had the tnsnames files in teh wrong folder. Adding this to the correct folder fixed the issue.