Ora-12154 when running select statement from pro*fortran

 Hi All,

This is my first post so don't know the formalities (if any from this form).

My problem is when i try to include a select statement in my pro*fortran code
I am getting Ora-12154 TNS could not resolve service name

The select query is given below.

EXEC SQL SELECT PERIOD_NAME, UBR, UER
1 INTO :ENAME, :SAL, :COMM
2 FROM TEST

 I am not getting any errors when I run only the conect statement.

I am using the 32bit version of libraries and the compilation is happening without any problem.
Earlier when i tried with 64 bit libraries i was getting errors during compilation.