ADODB connect string will not function w/login password embedded

A

andy.novak

I found out that the Integrated Security=SSPI in essence overrides the
userid/password supplied in a connect string. However, when I remove
"Security=SSPI", the login fails and I'm certain the login and
password are valid and have access to then reporting database.

Conn.ConnectionString = "Provider=SQLOLEDB;Initial
Catalog=ProjectServer_Reporting;Data
Source=xxxxxxx;UID=xxxxxx;PWD=xxxxxx;"

Any and all suggestions will be greatly appreciated.

Thanks
Andy Novak
UNT
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADODB connect string will not function w/login password embedded 0
PS2007 Impersonation using VBA (not PSI) 6
Easy Question 2 0
VBA Compile Error: User-Defined Type Not Defined-Please Help : ) 8
Connection string causes "identity" problems 0
Import data from Microsoft SQL Server into Microsoft Excel 0
SQL server does not exist or access denied 2
VBA Compile Error: User-Defined Type Not Defined-Please Help : ) 1

Top