tag:blogger.com,1999:blog-6139068054528692587.post250724186272812911..comments2023-08-01T17:26:27.413+05:30Comments on QTP Scripts and Selenium Webdriver Scripts: QTP Script for connecting to databaseF n Khttp://www.blogger.com/profile/05610206689452577513noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-6139068054528692587.post-49583306639593715342015-05-19T04:30:19.208+05:302015-05-19T04:30:19.208+05:30Hey i am getting following error, can anybody help...Hey i am getting following error, can anybody help:<br /><br />"Data source name not found and no default driver specified"Sreekanth's Projectshttps://www.blogger.com/profile/04523187567178593168noreply@blogger.comtag:blogger.com,1999:blog-6139068054528692587.post-60089239855847556012011-08-18T17:56:08.448+05:302011-08-18T17:56:08.448+05:30The above script i tried but i am getting an error...The above script i tried but i am getting an error for the path. Anybody can tell me other then mdb, we can us any other extension.Shirihttps://www.blogger.com/profile/17089977503069377665noreply@blogger.comtag:blogger.com,1999:blog-6139068054528692587.post-71291953229541184412011-08-18T17:53:17.451+05:302011-08-18T17:53:17.451+05:30Hi guys,
For the above script, i am getting error...Hi guys, <br />For the above script, i am getting error in path. Anybody can tell me, other then mdb, we can use any other extension.Shirihttps://www.blogger.com/profile/17089977503069377665noreply@blogger.comtag:blogger.com,1999:blog-6139068054528692587.post-28945313478031967802008-03-28T13:27:00.000+05:302008-03-28T13:27:00.000+05:30Hi,check this link for ur query http://funandknowl...Hi,<BR/><BR/>check this link for ur query <BR/><BR/>http://funandknowledge.blogspot.com/2008/03/qt.htmlF n Khttps://www.blogger.com/profile/05610206689452577513noreply@blogger.comtag:blogger.com,1999:blog-6139068054528692587.post-15546968415815751222008-03-19T10:40:00.000+05:302008-03-19T10:40:00.000+05:30HI..Can u also provide script for connecting to da...HI..<BR/><BR/>Can u also provide script for connecting to database that is sqlserver..<BR/><BR/>I am trying this since many days but not able to succeed.. i would be very thankful if u provide me the script for connecting sql serverAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6139068054528692587.post-90220871830403765712008-01-19T02:03:00.000+05:302008-01-19T02:03:00.000+05:30hi manasa,thnx for ur comment but u need to change...hi manasa,<BR/><BR/>thnx for ur comment but u need to change ur script to get correct output.<BR/><BR/>in line rs.open"select*from table1"<BR/>u have to specify name of table.<BR/><BR/>n other mistake is while setting values of val1 and val2 u need to specify column names as<BR/> set val1=rs.fields("column1name")<BR/> set val2=rs.fields("column2name")<BR/>if u correct this remaining code is F n Khttps://www.blogger.com/profile/05610206689452577513noreply@blogger.comtag:blogger.com,1999:blog-6139068054528692587.post-41015324079631305572008-01-18T16:28:00.000+05:302008-01-18T16:28:00.000+05:30Try this.... its workingDim con,rsSet con=createob...Try this.... its working<BR/><BR/>Dim con,rs<BR/>Set con=createobject("adodb.connection")<BR/>Set rs=createobject("adodb.recordset")<BR/>con.provider="microsoft.jet.oledb.4.0"<BR/>con.open"C:\Documents and Settings\C5107978\My Documents\db1.mdb"<BR/>rs.open"select*from table1",con<BR/>Do while not rs.eof<BR/> Reporter.ReportEvent micPass, "access opened"," emp"<BR/> Dim val1,val2<BR/>set val1= manasahttps://www.blogger.com/profile/09102402853835055861noreply@blogger.com