MS SQL with vb 6

[manjunatha mattikoppa]

Hey , i am new to mysql, i have written a simple program in vb and backed as mysql database. i have created DSN setting and every thing work fine in my pc, such as adding data,deleting, and retriving etc,

but same code dosent work in other machine when i try to add the data it says error message "ODBC Driver dosent support the requested Properties". the coding is given below please help me

can use other coding style appart form ADODB in vb, if yes tell me how

Dim strConnString As String
Dim rsData As ADODB.Recordset

Set glbConn = New ADODB.Connection
strConnString = "DSN=RAJALAXMI"
glbConn.ConnectionString = strConnString
glbConn.Open


Set rsData = New ADODB.Recordset
rsData.CursorLocation = adUseServer

rsData.Open "Select * From WOODRANGE ", glbConn, adOpenDynamic, adLockOptimistic

.........................................