我用asp.net写了一个web程序,通过ODBC连接Oracle815数据库,会报错,格式如下: Dim strconn As String = ConfigurationSettings.AppSettings("ODBC")
Dim myconn As OdbcConnection = New OdbcConnection(strconn)
Dim cmd As OdbcCommand = New OdbcCommand() mzone = mainzone_list.SelectedItem.Value
jxno = jjxno_list.SelectedItem.Value myconn.Open()
cmd.Connection = myconn
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandTimeout = 7200 Dim pa As OdbcParameter, all_count As Integer = 0 pa = New OdbcParameter()
pa = cmd.Parameters.Add("linecenter", OdbcType.VarChar)
pa.Value = lid
pa.Direction = ParameterDirection.Input pa = New OdbcParameter()
pa = cmd.Parameters.Add("mzone", OdbcType.VarChar)
pa.Value = mzone
pa.Direction = ParameterDirection.Input pa = New OdbcParameter()
pa = cmd.Parameters.Add("jxno", OdbcType.VarChar)
pa.Value = jxno
pa.Direction = ParameterDirection.Input pa = New OdbcParameter()
pa = cmd.Parameters.Add("rows", OdbcType.Int)
pa.Direction = ParameterDirection.Output cmd.CommandText = "{call LF2005_PKG.FILTER_BY_JJXNO(?,?,?,?)}" '调用过滤存储过程",? Try
cmd.ExecuteNonQuery()
all_count = pa.Value Catch exp As Exception
msg.InnerText += exp.Message
Finally
cmd.Dispose()
End Try....
总是报错“引用的对象为空...”请高手指点!
Dim myconn As OdbcConnection = New OdbcConnection(strconn)
Dim cmd As OdbcCommand = New OdbcCommand() mzone = mainzone_list.SelectedItem.Value
jxno = jjxno_list.SelectedItem.Value myconn.Open()
cmd.Connection = myconn
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandTimeout = 7200 Dim pa As OdbcParameter, all_count As Integer = 0 pa = New OdbcParameter()
pa = cmd.Parameters.Add("linecenter", OdbcType.VarChar)
pa.Value = lid
pa.Direction = ParameterDirection.Input pa = New OdbcParameter()
pa = cmd.Parameters.Add("mzone", OdbcType.VarChar)
pa.Value = mzone
pa.Direction = ParameterDirection.Input pa = New OdbcParameter()
pa = cmd.Parameters.Add("jxno", OdbcType.VarChar)
pa.Value = jxno
pa.Direction = ParameterDirection.Input pa = New OdbcParameter()
pa = cmd.Parameters.Add("rows", OdbcType.Int)
pa.Direction = ParameterDirection.Output cmd.CommandText = "{call LF2005_PKG.FILTER_BY_JJXNO(?,?,?,?)}" '调用过滤存储过程",? Try
cmd.ExecuteNonQuery()
all_count = pa.Value Catch exp As Exception
msg.InnerText += exp.Message
Finally
cmd.Dispose()
End Try....
总是报错“引用的对象为空...”请高手指点!
解决方案 »
- UpdatePanel Repeater HyperLink分页 怎么局部刷新???
- jquery 为什么取不到返回的数组?
- profile到底是怎样嘛!怎么会乱变的?求助!
- web form 中我为什么引用不了 system.drwing命名空间呢!
- DataGrid 限制字符 和 超连接问题
- .net有没有计算当前日期是当年第几周的函数(急)
- 求助! 关于ASP.NET
- 求解:表单提交问题
- 用表格输出为什么是什么意思
- 在一个ASP.NET页面里有两个存储过程需要执行,都是返回记录集的。请问。。。
- 请问如何建立数据库信任连接
- !!!!光标显示DropDownList Item的值,在线等!!!!!!!!!!!
改为all_count = pa[3].Value
同事机子装的是oracle815,把我的web程序拷到他机子上就会报错;
用我的程序访问他的数据库,运行系统没问题。奇怪!
怎么不用odac了?
或者把第一句改为 cmd.CommandType = CommandType.commandtext,第二句不变oracle我不是很懂,大致情况应该如此