u need to installed "mysql-connector-odbc-3.51.27-win32", then w

How do you connect to database ,What is the script to
connect DATA BASE?

Question Posted / sandipgami84

2 Answers
6489 Views
Nokia, I also Faced
E-Mail Answers

Answer Posted / 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

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Anybody plz give, How do you test aframe in a web page? If page cotain text message or Images, tables?

2029

What are the different kinds of test steps?

1017

What are the different recording modes and how do they work?

1032

What is qtpro? What is quick test pro? What is a quick test professional?

1030

How to creating an output value using quicktest professional?

991

banking domain description for software tester for interview

3855

How to break the object spy ?

1125

Create flight reservation login descriptive programing (Condition: Remove the value and substitute with a variable, and then call the validation from Excel) Plz help me....... very urgent.........

2130

What does it mean when a check point is in red color? What do you do?

1029

Hi , I am facing issue QTP 10.0 with oracle ERP 11i .When QTP opens,click sub links on ERP ,FORM is not opening getting unexpected Internet explorer error message with send or don't send report.So unable to work with forms using QTP.

3810

What is checkpoints for quicktest professional?

954

To which environments does quicktest professional (qtp) supports?

956

Explain the features of quick test pro(qtp)?

974

What is action?

940

What are the differences between qtp and winrunner?

936