如何调用其他数据库存取过程?急!
在查询分析器里下面的均可执行,有数据:
exec dbinformation.dbo.asp_zhyw_YE '2005/03/15'
exec dbinformation..asp_zhyw_YE '2005/03/15'
exec zakj.dbinformation.dbo.asp_zhyw_YE '2005/03/15'
在程序里执行没任何数据(下面的程序调用connectstring里的数据库中的存取过程没问题):
Dim sqlCM As New SqlCommand("dbinformation..asp_zhyw_YE", cnn)
Dim sqlDA As New SqlDataAdapter
Dim ds As New DataSet
Dim sqlCB As SqlCommandBuilder
Dim sqlPM As SqlParameter
sqlCM.CommandType = CommandType.StoredProcedure
......
Dim sqlCM As New SqlCommand("dbinformation..asp_zhyw_YE", cnn)这里该怎么写?