关于DTS的问题

0551

我用SQL的导出，生成了用语VB的模块，代码如下 Set oConnection = goPackage.Connections.New("Microsoft.Jet.OLEDB.4.0") oConnection.ConnectionProperties("Data Source") = c:\abc.mdb oConnection.ConnectionProperties("Mode") = 3 oConnection.Name = "连接2" oConnection.ID = 2 oConnection.Reusable = True oConnection.ConnectImmediate = False oConnection.DataSource = c:\abc.mdb oConnection.ConnectionTimeout = 60 oConnection.UseTrustedConnection = False oConnection.UseDSL = False 'If you have a password for this connection, please uncomment and add your password below. 'oConnection.Password = "" goPackage.Connections.Add oConnection Set oConnection = Nothing 这个是用SQL的DTS工具生成的模块，我在VB中引用了。 我在打包安装到别的机器上后 在这一句提示我错误 Set oConnection = goPackage.Connections.New("Microsoft.Jet.OLEDB.4.0") 错误提示是“无效引用字符串” 请问是什么原因引起的？ 怎么解决？ 谢谢

zijing

在运行程序的电脑上安装一下sql2000的客户端即可