I want to connect winrunner with databse "MySQL" which is placed on server.For connection i tried to use "db_connect" function but it needs connection string,I don't know what will be in connection string.If anybody know the procedure to establish the connection with database then provide me a little example for that.Plz Reply if anybody know abt it.
Are your using windows os or something else.
if it is odbc then u need a driver from mysql
which is available on mysql\downloads. First create the driver in your odbc engine. From the odbc create dsn. For username, password and for server contact your developer or DBA.
Rememeber one thing u cannot create dsn directly from your winrunner. u should create it by ODBC only.
The simplest one would be to ask the DBA or whoever deals with the database in your organization for this particular database. He can give you the string in less than a minute and how this string and connection (DSN, connect, MS OLEDB, ODBC, JDBC) in less than an hour.
How many QA teams have there own DBA? I've never had one. WinRunner only suports ODBC - not JDBC. You don't need to come up with a connect string! You only need to install the ODBC driver and the connect string will be generated automatically from the function generator:
QA departments may not have their own DBA most of the time, but every QA job I have been in usually uses databases stored on the servers controlled by the company's DBA group, which put it under their ultimate control.
Insanity: doing the same thing over and over again and expecting different results
I just wanted him to learn some SQL and database stuff.
How much time does it take to learn how to connect to a database. People can use contacts with DBAs or some online tutorials.
To be frank just sick of non-technical people coming into testing. People who simple use Managerial skills, to survive.
I am not pointing at anyone here in this forum. Just want people to stop putting a bad name to QA and testing.