Guest

• Jul 17th, 2006

 

Hi,

Do the following

1)go to Control panel and in that "administrative tools" and click on "ODBC Data Source".

2)Click on Add

3)Select the driver you want to setup.

4)suppose your database is in Ms-Access  select "Microsoft acess Driver(*.mdb)...and if it is in "Ms Sql Server" select " SQL Server" and click on "finish" (for instance take ur database is in Ms Sql server)

5)Give the dsn name in the name field and description is optional.Give the server name ..server name is the name (system nameSQLEXPRESS)which it displays when you connect to the sql server where you have server autentication.

6)click on next

7)select the radio button with sql server authentication with login username and password

   login:sa ,Password:sql123 (default)

8)Click on Next , if the username and password is correct then it connects otherwise it displays an error message.

9)check on the "Change the default database in order to select the database" for which you want to create DSN.

10)click on Next /finish... then ok.....

thus your dsn is created.

While creating a database checkpoint "click on the Connection string" and select the DSN name which was created recently.

Praveen Y

• Sep 5th, 2006

 

Can you please tell me how to connect to the Database where I am using IBM DB2.

kirangunna

 Profile Answers by kirangunna 

• Jul 1st, 2008

 

I am trying to connect DB2 from QTP, How do i do that
Any Ideas

fahadvr

 Profile Answers by fahadvr 

• Jan 12th, 2009

 

Use the below mentioned connection string for IBM DB2:

Server=myAddress:myPortNumber;Database=myDataBase;UID=myUsername;PWD=myPassword;

Hope this helps.