I am trying to create an oracle connection in vs 2005. The first error I received when setting the connection was:

attempt to load oracle client libraries threw badimageformatexception. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.

I did not have a 32 bit oracle client installed at that time.

I am running windows 7 on a 64bit box, with 64bit oracle client.

I googled the error an tried all the things I found with no luck.

I installed the 32bit oracle client and now I'm receiving this error:

ORA-12154: TNS could not resolve service name

I have the TNSnames.ora located in my oracle folder, and I also checked my permissions on the folder.

How do I fix this?