OLEDB CONNECTION STRING

[raj_cipher]

HI,

I have a doubt in OLEDB connection.
In the conncetion string when i hard code the parameters for catalog & source it works fine,but when i pass parameters it is not working.

I have give below how i passed the parameters.Is there any thing wrong with
my approach ?

Connection String:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=#DSN#;Data Source=#Server#

Parameters i pass - DSN AND Server

[denzilsyb]

Stupid question -> are the parameters defined in the job? If they are, are they strings?

Try an ODBC trace and see what is actually being parsed.

[Kwang]

HI,

I have a doubt in OLEDB connection.
In the conncetion string when i hard code the parameters for catalog & source it works fine,but when i pass parameters it is not working.

I have give below how i passed the parameters.Is there any thing wrong with
my approach ?

Connection String:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=#DSN#;Data Source=#Server#

Parameters i pass - DSN AND Server

should be:
Parameters to pass: DATABASE AND Server

Connection string:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=#database#;Data Source=#Server#