Answer / sandipgami84

u need to put above code in "GetSQLData" Function

Answer / sandipgami84

u need to installed "mysql-connector-odbc-3.51.27-win32",
then write down below code,

Dim objCon, ObjRecordSet
ConnString = "Driver=MySQL ODBC 3.51 Driver; server=ServerIP"
ConnString = ConnString &";database=DBName"
ConnString = ConnString &";user=DBusername"
ConnString = ConnString &";password=DBPassword"
Set objCon = createobject("ADODB.Connection")
objCon.Open(ConnString)
Set ObjRecordSet = CreateObject("ADODB.Recordset")
ObjRecordSet.Open CStr("Select * From tbName Where Id =
'1'),objCon
If (not ObjRecordSet.EOF) then
For I = 0 To ObjRecordSet.Fields.Count - 1
If I = 0 Then
On Error Resume Next
GetSQLData = Trim(Cstr(ObjRecordSet.Fields(I)))
Else
On Error Resume Next
GetSQLData = Trim(CStr(GetSQLData)) & "," &
Trim(CStr(ObjRecordSet.Fields(I)))
End If
Next
End If
ObjRecordSet.close
objCon.close
Set ObjRecordSet = Nothing
Set objCon = Nothing
DataBaseConnection = GetSQLData
GetSQLData = ""




-----------
Sandip Gami
+91-9714177088

What is expert view in qtp?

0 Answers  

---

I have the following Doubts Please clarify me with examples? 1.Could QTP cover entire application? or part of the application? 2.Shall we rewrite(modify) the Manual testcase to automate? 3.How can I execute my scripts through client mechine which is not having QTP installation 4.Few objects are not being identified by QTP afeter one month. what could be the reason for this (I am using trail version of 15 days)

2 Answers   Livetek,

---

What are different versions in Win Runner ,QTP ,Load Runner and Test Director till now and atleast please let me know new features for each version. Ex QTP8.2,QTP 8.5.QTP9.2 supports Mozilla 2.0

1 Answers   DELL,

---

Explain qtp(quick test professional)?

0 Answers  

---

How can I deploye a 'QTP Runtime environment only'

1 Answers   Indexis,

---

---

how to write script in qtp(vbscript)..i mean with out application deployed..and how to call script1 into script2?

8 Answers   INCA, Infosys, Logix, SLK Software, Symphony, Wipro,

---

I am Using QTP 9.1 version. I have created a Shared Object Repository. The size of Shared Object REpository is 9 MB. In my system i am able to execute the script very flexibly and it is very fast. But if i copy the same code into other system with the same configuration, it is executing very slowly(i.e dam slow). It is not happening in all machines it is in only some machines. Can please any one give th esolution. It is high priority to me as i need to give demo to client on their machines.

4 Answers   TCS,

---

How to Test Dynamic links ?

4 Answers   Wipro,

---

I am not able to record yahoomail browser.its giving error like "The browser Application can't be launched .Posssibly the URL is wrong" So anyone can tell me what setting i have to do in qtp??

1 Answers  

---

What is BPT?

2 Answers   Allied Group,

---

Suppose i have given 10 test cases all the test cases should be automated?

3 Answers   NTT Data,

---

WHAT IS THE DIFF BTW KEYWORD DRIVEN TESTING AND DATA DRIVEN TESTING?

1 Answers  

---