Win a copy of Svelte and Sapper in Action this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

Connecting to database

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi guys,
I need to know the procedure to connect to the data base.Data driven test is fine it works.
But when connecting to data base winrunner will set terminated in my system.Can any one help it out.
Also the TSL Code which connects to the database.
or some url where I can refer
Thanking you
 
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Ravi,
The tsl script for connecting to database will be of the short:
rc=db_connect(logical_name,connection);
"logical_name" is the name u give to the database connection.Now ur connection string should point to the database u want to connect.
Suppose connection string is "dsn=testDatabase;uid=test;pwd=test".So ur connection should be pointing to the connection string.
connection="dsn=testDatabase;uid=test;pwd=test";
will do it.
Now you have to make sure that u have a dsn named "testDatabase"(userid and password also set) set up in "DataSources".Also check the "tnsnames.ora" file in oracle which is situated at /ora81/network/admin for the connection of the oracle to the database.
If u feel any problem revert back to me.
 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hey ..
I am connecting to IBM DB2 using DB2 ODBC Driver.
But i am getting -10161 error.
i am passing parameters as rc=db_connect("test","DSN= wrtest; uid=user; pwd=rs1");
plz suggest how should i go aobut it..i have created my user dsn..
Thanks.
Lee
 
The airline is called "Virgin"? Don't you want a plane to go all the way? This tiny ad will go all the way:
the value of filler advertising in 2020
https://coderanch.com/t/730886/filler-advertising
    Bookmark Topic Watch Topic
  • New Topic