Connecting Navision to Navision using ADO

Any ever connected Navision to another Navision using ADO (ODBC). I did it before but can’t remember the connection string. It was something like this: Provider=MSDASQL.1;Password=xxxx;Persist Security Info=True;User ID=jwilder;Data Source=NavisionTest I used a valid password and the machine has an ODBC connection setup that is called NavisionTest. The error message I get is that The OLEDB Provider cannot establish a connection.

I was able to answer my own question, it was a security thing.