Connection issues Please assist

[fabri]

Hi guys we're having a huge issue at work, we've created a new access db and we've setup all the tns files and connections as per the DBA instructions. In access(2007) we cannot connect to our tables, we get an ODBC--connection to 'DATASOURCE' failed.

Any advice on how to rectify this will be greatly appreciated.

 

[DCrake]

What configuration have you got? what is your data stored in?

 

[boblarson]

When you set up the DSN (not tns), did you click the TEST button to see if the connection worked? If you set up a file DSN then you wouldn't have that capability and so post the contents of the file DSN (it is just a text file so you can use notepad to edit and then copy and paste it here).

 

[jdraw]

tns (tnsnames) is Oracle

IIRC you'll need an Oracle account and password, and the Oracle DBA will set up the tnsnames parameters.
It's been a few years ( and probably a version or 2 of Oracle since I used Access Oracle via ODBC).

This link may help
http://www.orafaq.com/wiki/ODBC_FAQ

 

[boblarson]

tns (tnsnames) is Oracle

IIRC you'll need an Oracle account and password, and the Oracle DBA will set up the tnsnames parameters.
It's been a few years ( and probably a version or 2 of Oracle since I used Access Oracle via ODBC).

This link may help
http://www.orafaq.com/wiki/ODBC_FAQ

Didn't know that tns had to do with that but I have connected to Oracle in the past using ODBC and the only thing I needed to do so was to have an ODBC drive installed on my machine. The only way I could do that was to install the Oracle client tools on my machine. Then I chose the Oracle driver just like using a SQL Server driver and it all worked swimmingly.

 

[fabri]

Hi Guys we actually changed our tns files, and our ODBC settings, everything was correct, we imported the tables based on the new new tns connection and this resolved the issue. Thanks guys