ODBC connection password

[Malchik]

Hi
I have problem connecting a secured SQL server with an ODBC through VB. I setup the ODBC, I can connect through the ODBC Manager. Here is the connection string:

Provider=MSDASQL.1;Persist Security Info=TRUE;PASSWORD= 1234;User ID=ABCD;Data Source=DataWeb

Here is the error message:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection

I know I have access. I can use the SQL manager with the same username and password

So I guess my Username and Password are not pass the right

Can somebody help me please.
Thanks


Mal'chik

 

[MarkSweetland]

Here's a helpful link you can refer to when troubleshooting connection parameters:

http://www.able-consulting.com/ADO_Conn.htm

Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach