| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
| |||
| |||
| below is the code in VB6.0 How does it look like in VB.NET using the same ODBC driver (Merant Informix9 ODBC driver). Thanks a million. Bill ------------------------------------ sconnect = "" sconnect = sconnect & ";DSN=dsn" sconnect = sconnect & ";UID=user" sconnect = sconnect & ";pwd=password" cnBol.ConnectionString = sconnect cnBol.Open cmdBOL.ActiveConnection = cnBol cmdBOL.CommandText = "bol_data" cmdBOL.CommandType = adCmdStoredProc Set prmSDate = cmdBOL.CreateParameter("getbol_date", adDate, adParamInput) cmdBOL.Parameters.Append prmSDate Set prmEDate = cmdBOL.CreateParameter("getbol_date2", adDate, adParamInput) cmdBOL.Parameters.Append prmEDate prmSDate.Value = CDate(txtSDate) prmEDate.Value = CDate(txtEDate) rstFactor.Open cmdBOL -------------------------------- |
![]() |
| Thread Tools | |
| Display Modes | |
In an effort to better serve ads to our visitors, cookies are used on objectmix.com. For more information, check out our Privacy Policy.