Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Running SQL From/To an MS SQL Server Database

2 posts in Networking Last posting was on 2005-02-09 11:19:36.0Z
dean robinson Posted on 2005-02-07 12:11:56.0Z
Date: Mon, 07 Feb 2005 12:11:56 +0000
From: dean robinson <deanR@transactor.co.uk>
Organization: Pearce & Robinson LTD
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: Advantage.Networking
Subject: Running SQL From/To an MS SQL Server Database
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 212.158.208.54
Message-ID: <42075bf5@solutions.advantagedatabase.com>
X-Trace: 7 Feb 2005 05:15:49 -0700, 212.158.208.54
Lines: 9
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!212.158.208.54
Xref: solutions.advantagedatabase.com Advantage.Networking:507
Article PK: 1131932

dear folks, how do we run an SQL in an MS SQL Server, to read/modify
data in an ADS Database (dictionary) and vica verca.

Theres stuff in the help file about UNC connections, ditto ODBC/ADO,
ads.ini etc etc but i can't seem to find an explicit instruction or
example. We have both an MS SQL Server database and an advantage
database on the Windows 2000 network and we need them to speak to each
other. They are both located on the same physical server
thanks.


dean robinson Posted on 2005-02-09 11:19:36.0Z
Date: Wed, 09 Feb 2005 11:19:36 +0000
From: dean robinson <deanR@transactor.co.uk>
Organization: Pearce & Robinson LTD
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: Advantage.Networking
Subject: Re: Running SQL From/To an MS SQL Server Database
References: <42075bf5@solutions.advantagedatabase.com>
In-Reply-To: <42075bf5@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 212.158.208.54
Message-ID: <4209f2c3@solutions.advantagedatabase.com>
X-Trace: 9 Feb 2005 04:23:47 -0700, 212.158.208.54
Lines: 13
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!212.158.208.54
Xref: solutions.advantagedatabase.com Advantage.Networking:509
Article PK: 1131930


dean robinson wrote:
> dear folks, how do we run an SQL in an MS SQL Server, to read/modify
> data in an ADS Database (dictionary) and vica verca.
>
> Theres stuff in the help file about UNC connections, ditto ODBC/ADO,
> ads.ini etc etc but i can't seem to find an explicit instruction or
> example. We have both an MS SQL Server database and an advantage
> database on the Windows 2000 network and we need them to speak to each
> other. They are both located on the same physical server
> thanks.

I have re-posted this on the General forum because i got no answers
after a few days...