Re: Use ActiveX in DTS

#1

Why do you need to connect like this. What is it that you do like this that
we cannot do using the DTS tasks?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Mike Torain" <tst_mc (AT) hotmail (DOT) com> wrote

Quote:

I use ActiveX to connect to SQL database, for example:

dim myConn
dim myRecordset
dim iRowCount
set myConn = CreateObject("ADODB.Connection")
set myRecordset = CreateObject("ADODB.Recordset")
myConn.Open = "Provider=SQLOLEDB.1;Data Source=(local); _
Initial Catalog=Northwind;user id =
'prod_user1';password='prodpassword'"

Can I have some ways to hide my password? How to do it?
Thanks in advance.

-Mike

#2

In message <1F31917F-5491-44DA-A689-A5DED7AE4061 (AT) microsoft (DOT) com>, Mike
Torain <tst_mc (AT) hotmail (DOT) com> writes

Quote:

I use ActiveX to connect to SQL database, for example:

dim myConn
dim myRecordset
dim iRowCount
set myConn = CreateObject("ADODB.Connection")
set myRecordset = CreateObject("ADODB.Recordset")
myConn.Open = "Provider=SQLOLEDB.1;Data Source=(local); _
Initial Catalog=Northwind;user id =
'prod_user1';password='prodpassword'"

Can I have some ways to hide my password? How to do it?
Thanks in advance.

-Mike

Since you are local, then use integrated security. This is the only way
to not have a clear text password in a connection string at this level.

I agree with Allan that you should always look to using the DTS
connections and tasks first.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Use ActiveX in DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Use ActiveX in DTS - 04-27-2004 , 12:05 PM

Re: Use ActiveX in DTS - 04-27-2004 , 04:03 PM