Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bmains
Starting Member
27 Posts |
 Posted - 2005-04-28 : 12:02:32
|
| Hello,I have a DTS package that has an ActiveX task. This task works with access to create databases and push out data to them. The problem is, I'm getting an error trying to establish a connection to the SQL Server database as such:set objConn = Server.CreateObject("ADODB.Connection")I get this as a resolution:http://support.microsoft.com/default.aspx?scid=kb;en-us;201740But I wasn't sure since I'm not dealing with ASP. I'm trying to run the task as myself manually, not scheduled also, for testing purposes. Any ideas?Thanks,Brian |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-04-28 : 23:47:22
|
| In DTS, when you use ActiveX its not Server.CreateObject its CreateObject.You use Server.CreateObject in ASP.This should work.Set objConn = CreateObject("ADODB.Connection")Karunakaran___________It's better to be loved and lost, than ever to be loved... |
 |
|
|
|
|
|
ActiveX problem in DTS