I'm attempting to connect to ADS 10.1 from MS SQLServer 2008R2. I have ADO 64bit drivers installed.

I use the following connection string:

Provider=Advantage OLE DB Provider; ServerType=ADS_REMOTE_SERVER; Data Source=d:\data\dictionary.add; User ID=adssys; Password=mypassword; TableType=ADS_ADT;

I get the following:

Cannot initialize the data source object of OLE DB Provider 'Advantage OLE DB Provider' for linked server
Linked server returned message Error 7078.  The ADS cannot authenticate the user.  Make sure the user name and password are correct.

Well, I know 100% that the username / password are correct. I tried several user names / passwords and they all return the same result...

I did set the "Allow inprocess" option on the Providers page.

I am using the Management Studio to set this up.

Anyone know how to get past the user/password issue?

asked 23 May '14, 07:29

Tony%20DB's gravatar image

Tony DB
accept rate: 0%

edited 26 Feb '15, 09:29

Jens%20M%C3%BChlenhoff's gravatar image

Jens Mühlenhoff

Check out ads_err if there are any other errors logged the same time.


answered 23 May '14, 07:55

Joachim%20Duerr's gravatar image

Joachim Duerr
accept rate: 18%

Your answer to the original question.
If responding to a request for additional information, please edit the question or use the comment functionality.
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 23 May '14, 07:29

Seen: 1,917 times

Last updated: 26 Feb '15, 09:29

Advantage Developer Zone Contact Us Privacy Policy Copyright Info

Powered by Advantage Database Server and OSQA
Disclaimer: Opinions expressed here are those of the poster and do not necessarily reflect the views of the company.