We have a new set up of Windows Server 2008 R2 64 bits and need to connect to another server of the same where we have an ADS data base version 10.10 installed. In the past we have been using data sources and stored procedures without any issues. In this new environment it will not let us connect.

We have set up a data source in 'system dsn' and are using 'Advantage StreamlineSQL 10.10.0049' and creating a data source pointing to a data dictionary type .add.

The linked server is using provider Microsoft OLEDB Provider for ODBC Drivers and we are referencing the data source name. A test connection, nothing happens

I have also noticed that there is a provider for 'Advantage OLDEDB Provider' in the 'Linked Servers provider' - should I use this instead?

Any help is appreciated. Thank you.

asked 24 Oct '14, 12:54

snufse's gravatar image

snufse
1111
accept rate: 0%


Out of curiosity did you install the 64-bit ODBC driver?

Either the OLEDB provider or the ODBC driver should work.

link

answered 24 Oct '14, 14:28

Edgar%20Sherman's gravatar image

Edgar Sherman
5.4k13185
accept rate: 25%

We have installed adsodbc__x86_64 and also adsoledb_x86_x64 so it should work.

The linked server setup is working fine from a Windows 2003 server to the 2008 server where the ADS data base is located.

When we test using the 'run' command it will connect to the data base using the same connection string and just leaving out the WM2000DATA.add.

Is there another ADS driver we should try to install?

link

answered 27 Oct '14, 06:05

snufse's gravatar image

snufse
1111
accept rate: 0%

Either of these should work. It's hard to say with "nothing happens" as an error. Is the OLEDB provider giving the same issue?

Perhaps try setting an ODBC trace up and see if any additional information can be found. Another option is to maybe try the ODBC driver for 11.1

(27 Oct '14, 09:33) Edgar Sherman
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:

×43
×40

Asked: 24 Oct '14, 12:54

Seen: 2,091 times

Last updated: 27 Oct '14, 09:33

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.