hi

im a seasoned sql server/.net developer, but havent ever touched advantage.

i need to connect to an add database remotely

ive managed to set up a oledb connection on a local machine on the wan, but cant figure out how to make it work over the internet

i tried the following connection string

Provider=Advantage.OLEDB.1;Password=pass;User ID=user;Data Source=\\99.99.99.99\datafolder\database.add;Persist Security Info=True

but i get a discovery error. now im not sure on which port adv is listening, if at all. i scoured all ads.ini files on the server but couldn't find any mention of "INTERNET_"

so how do i confirm that adv is listening remotely and on which port?

thanks

asked 02 Jul '14, 02:06

yisman's gravatar image

yisman
1111
accept rate: 0%


Whow....5 steps in one;)
First of all you need to make sure ADS remote is working in the local network (LAN). So, check for the IP Port in the configuration (configuration utility | communications | LAN Port) and connect to it using a path like

Data Source=\\IP:PORT\folder\database.add
The 'folder' has to be a share and the local SYSTEM group requires full access to it.
Then open your data dictionary with Data Architect and check for the internet access (dictionary properties | security | internet access | [x] Enabled) - or
EXECUTE PROCEDURE sp_ModifyDatabase('Enable_Internet','True');
Then check if your user has inter access enabled (user properties | [x] Enable Internet Access), or
EXECUTE PROCEDURE sp_ModifyUserProperty('myuser','Enable_Internet','True' );
Now you can check for a connection to the internet port:
Data Source=\\IP:INTERNET_PORT\folder\database.add
You can find the internet port on the same config tab as the IP Port. If it's 0, change the value to an unused port (e.g. 6363) and restart the server.

Does ADS have a public IP address and is the internet port being routed (TCP AND UDP) to the server? If so, you can test from outside your LAN using the public IP instead of the private one.

link

answered 02 Jul '14, 02:26

Joachim%20Duerr's gravatar image

Joachim Duerr
8.7k1031133
accept rate: 18%

thanks. sorry for the delay. i'm waiting to get admin creds to the remote server. as soon as i can proceed i will update. all the best.

(06 Jul '14, 02:16) yisman
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:

×154
×16

Asked: 02 Jul '14, 02:06

Seen: 1,488 times

Last updated: 06 Jul '14, 02:16

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.