Community discussion forum

Database connection

• • Reply

  11 months ago

  by marty08

  leonard wong

  kuala lumpur, Malaysia

  Joined 11 months ago
  hi i am very new to this vb.net enviroment. please guide me with this connection. i need to connect to oracle database to retireve the information and display the information neatly in a page. currently the server is on the remote host and not on my local computer. how should i do this? in windows application. what should i do in enabling the connection to the oracle database in application config file? and in my program what statement should i put? clould anyone show me how to do it thanks a lot
  Report abuse
• • Reply

  11 months ago

  by Slicksim

  Simon Cooper

  Lancaster, United Kingdom

  Joined 4 years ago
  Hi, Firstly, does the web server have the oracle client installed? without that, you won't be able to connect to the oracle database. You will need to add references in your project to the system.data.oracleclient library to get access to the functions. The connection string you need will look something like this: Data Source={Instance goes here};Persist Security Info=True;User ID={User ID goes here};PWD={Password goes here};Unicode=True;pooling=false;" You can then use the oracleconnection and other data commands from the system.data.oracleclient namespace. Regards Si
  Report abuse