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
11112
accept rate: 0%

edited 26 Feb '15, 09:29

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

Jens Mühlenhoff
1.3k51037


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

link

answered 23 May '14, 07:55

Joachim%20Duerr's gravatar image

Joachim Duerr
8.7k1031133
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

By RSS:

Answers

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

Tags:

×16
×9

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.