VB.NET accessing an Informix database via ODBC

This is a discussion on VB.NET accessing an Informix database via ODBC within the ODBC forums in Framework and Interface Programming category; 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 --------------------------------...

Go Back   Application Development Forum > Framework and Interface Programming > ODBC

Object Mix

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 07-18-2003, 03:44 PM
Bill Nguyen
Guest
 
Default VB.NET accessing an Informix database via ODBC

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
--------------------------------


Reply With Quote
Reply


Thread Tools
Display Modes


All times are GMT -5. The time now is 07:00 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
vB Ad Management by =RedTyger=

In an effort to better serve ads to our visitors, cookies are used on objectmix.com. For more information, check out our Privacy Policy.