How to import the data.. from the text box...inside the string

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • radiation
    New Member
    • Jan 2008
    • 1

    How to import the data.. from the text box...inside the string

    hi all,

    in a requirement we need to request the user to enter the PROTOCOL, HOST and pass the value to the server and to check whether the TNS name is correct.
    but when we tried to work it out we were encountered with the following error as user inpurted data is not getting populated in the required place provided.

    herz the code..

    string oradb = "Data Source=(DESCRIP TION=(ADDRESS_L IST="
    + "(ADDRESS=(PROT OCOL="txt_proto col.text")(HOST ="txt_host.text ")(PORT=1521))) "
    + "(CONNECT_DATA= (SERVER=DEDICAT ED)(SERVICE_NAM E=Oracle10)));"
    + "User Id=yyy;Password =xxx";
  • PareshRathod
    New Member
    • Mar 2007
    • 28

    #2
    Hi Guy,

    where is the + sign before and after txt_protocol.te xt and txt_host.text ????

    Paresh

    Originally posted by radiation
    hi all,

    in a requirement we need to request the user to enter the PROTOCOL, HOST and pass the value to the server and to check whether the TNS name is correct.
    but when we tried to work it out we were encountered with the following error as user inpurted data is not getting populated in the required place provided.

    herz the code..

    string oradb = "Data Source=(DESCRIP TION=(ADDRESS_L IST="
    + "(ADDRESS=(PROT OCOL="txt_proto col.text")(HOST ="txt_host.text ")(PORT=1521))) "
    + "(CONNECT_DATA= (SERVER=DEDICAT ED)(SERVICE_NAM E=Oracle10)));"
    + "User Id=yyy;Password =xxx";

    Comment

    • kenobewan
      Recognized Expert Specialist
      • Dec 2006
      • 4871

      #3
      Use single quotes for these and if that doesn't work:
      Oracle connectionstrin gs

      Comment

      Working...