DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: I can't connect to the database..please help.

  1. #1
    Join Date
    Feb 2001
    Posts
    53
    I am trying to connect to the database with developer form 6.0.
    when I try, it give me an error:
    TNS:could not resolve service name.

    I have check tnsname.ora and it look ok.

    I was able to do tnsping (database)

    what am I missing?

    I don't have to install the form server to get it to work do I?


    sorry, new at this stuff.


    thanks.

  2. #2
    Join Date
    Jun 2001
    Posts
    1
    Hi

    Check your tnsnames.ora available in your forms folder ( folder in which you have installed forms ) , if you have checked only the tnsnames.ora of your oracle client.

    Rgds

    San

  3. #3
    Join Date
    Mar 2001
    Posts
    635
    Hi

    Just copy the TNSNAMES.ora file from your Oracle Home directory to your forms directory it will work fine No problem.

    Regards
    Santosh

  4. #4
    Join Date
    Feb 2001
    Posts
    53

    thanks

    hey thanks,

    that work fine.

  5. #5
    Join Date
    Feb 2001
    Posts
    53

    Talking one more thing

    Does it work the same for Reports too?

    because I tried copying the tnsnames.ora over to Reports60 dir, but I was unable to connect.

    or do I need to do anything special for Reports.


    thanks in advanced,

    beginner..

  6. #6
    Join Date
    Mar 2001
    Posts
    635
    Hi James,

    You dont need to make any changes for reports it should connect.Follow the steps below

    1) Make sure you have the same copy of TNSNAMES.ora file in the following direcotry in the corrsponding home

    ORACLE_HOME,FORMS_HOME,REPORTS_HOME

    The folders in the above Home folders will be

    network/admin

    net80/admin

    so replace all the tnsnames.ora file with your original tnsnames.ora file from ORACLE_HOME directory to all the folders above

    Generally what I do is I have the same TNSNAMES.ora file in all places.

    If you want you can check connectivity to the database using the following commands

    1) tnsping databasename

    2) tnsping80 databasename

    The first command checks from network/admin/tnsnames.ora

    The second command checks from net80/admin/tnsnames.ora

    Forms,Reports and designer I think use net80 folder


    Hope this solves your problem for Reports as well.

    Regards
    Santosh

  7. #7
    Join Date
    Feb 2001
    Posts
    53

    thanks

    santos,

    thanks, that really clear it up.

    its working now..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width