Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

making connections using Active X (VBScript task)

Status
Not open for further replies.
zhonghandle

zhonghandle

Programmer
Jul 17, 2002
12
US
Hi,

Suppose I am currently connected to a database "data1" (not the local server), and I want to make a connection to one of the tables (say, the table name is "table1") using VBScript code in a DTS package. How exactly should I do that?

I have tried to create a ADO object (Connection), but failed. Is it possible to make connection to "data1/table1" using a Active X script code?

Thank you SO much.
 
Status
Not open for further replies.

Similar threads

elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
938
Mike Lewis
Mike Lewis
Auguy
  • Locked
  • Question
Using UDF In Select, Bad Idea? 2
Replies
3
Views
528
Auguy
Auguy
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
993
Volvere
V
Niki_S
  • Locked
  • Question
Create view using two databases
Replies
4
Views
556
Chris Miller
Chris Miller
EM1107
  • Locked
  • Question
Copy folder and content using SQL Server TSQL.
Replies
6
Views
696
RobertPhillips
RobertPhillips

Part and Inventory Search

Sponsor

Back
Top