Password Protected BE.

[Harold]

I run a series a SQL insert queries with an IN clause to
point to backend tables. These databases have a Password
on them, at the request of the client. Is there a way of
embedding the password in the SQL statement without going
to ODBC and giving up my IN clause? What might that syntx
look like?

Thanks

 

[Yuan Shao]

Hi Harold,

Thanks for your post. According to your description, I am not quite clear
what the problem is. I would like you to provide more information so that I
am able to understand what you want.
1. Do you mean that you created a query using linked table connecting to
SQL Server? Please describe it in detail.
2. Please provide a sample code. It helps us understand your accurate
concerns.

I am standing by for your response.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.