SQL Anywhere for Linux - MS SQL Server as Remote Server

Author

MS SQL Server as Remote Server

Marcelo Hille

2005-07-13, 9:23 am

Hey everybody!

I would like to create some proxy tables with MS SQL Server / MSDE on ASA9
using ODBC connections (remote server). Is it possible?

Thanks!

Marcelo Hille

Joshua Savill

2005-07-13, 9:23 am

Yes, Create a Remote Server for the connection to the MS SQL Server, then
create the proxy table.

ASA SQL User's Guide
Accessing Remote Data
Working with remote servers
Creating remote servers

Online:
http://www.ianywhere.com/developer/...n9/00000602.htm

ASA SQL Reference
SQL Statements
CREATE EXISTING TABLE statement

Online:
http://www.ianywhere.com/developer/...n9/00000362.htm

--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

"Marcelo Hille" <marcelo.cpd@sankoespumas.com.br> wrote in message
news:42d51548$1@foru
ms-2-dub...
> Hey everybody!
>
>
> I would like to create some proxy tables with MS SQL Server / MSDE on ASA9
> using ODBC connections (remote server). Is it possible?
>
> Thanks!
>
> Marcelo Hille
>

Marcelo Hille

2005-07-13, 11:23 am

Ok, but, what about the ODBC driver configuration?
Witch library should I use?

Do you have an example for odbc.ini using MS SQL Server?

Thanks again.

"Joshua Savill" <jsavill@ianywhere.com> escreveu na mensagem
news:42d5268c$1@foru
ms-2-dub...
> Yes, Create a Remote Server for the connection to the MS SQL Server, then
> create the proxy table.
>
> ASA SQL User's Guide
> Accessing Remote Data
> Working with remote servers
> Creating remote servers
>
> Online:
> http://www.ianywhere.com/developer/...n9/00000602.htm
>
> ASA SQL Reference
> SQL Statements
> CREATE EXISTING TABLE statement
>
> Online:
> http://www.ianywhere.com/developer/...n9/00000362.htm
>
> --
> Joshua Savill
> iAnywhere Solutions - Product Support Analyst
>
> "Marcelo Hille" <marcelo.cpd@sankoespumas.com.br> wrote in message
> news:42d51548$1@foru
ms-2-dub...
>
>

Greg Fenton

2005-07-13, 8:23 pm

Marcelo Hille wrote:
> Ok, but, what about the ODBC driver configuration?
> Witch library should I use?
>
> Do you have an example for odbc.ini using MS SQL Server?
>

SQLAnywhere does not ship with an ODBC driver for MSSQL on Linux. You
might be able to use the ASE driver as both ASE and MSSQL support TDS
communications. That driver is wqase19.so.

Alternatively, you might find an open source TDS driver (e.g. freeTDS)
or other ODBC driver for MSSQL (Google is your best bet here).

Note: I have not tried any of these approaches myself.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Chris Gruber

2005-07-15, 11:23 am

I think DataDirect does offer a Linux ODBC driver for MSSQL. I also believe
that DataDirect provides a sample odbc.ini as well.

Chris Gruber
iAnywhere Solutions
"Marcelo Hille" <marcelo.cpd@sankoespumas.com.br> wrote in message
news:42d5432b@forums
-2-dub...
> Ok, but, what about the ODBC driver configuration?
> Witch library should I use?
>
> Do you have an example for odbc.ini using MS SQL Server?
>
>
>
> Thanks again.
>
>
>
> "Joshua Savill" <jsavill@ianywhere.com> escreveu na mensagem
> news:42d5268c$1@foru
ms-2-dub...
then[color=darkred]
http://www.ianywhere.com/developer/...e/0902/en/html/
dbugen9/00000602.htm[color=darkred]
http://www.ianywhere.com/developer/...e/0902/en/html/
dbrfen9/00000362.htm[color=darkred]
>
>

Marcelo Hille

2005-07-15, 1:23 pm

I tried freetds odbc driver with unixODBC (thanks Greg).

Using the isql command utility that comes with unixODBC, the connection
looks great.

But I'm having some difficulties to connect to the remote server via Sybase
Central.

Follows connection information set on remote server properties:

Driver=/usr/lib/libtdsodbc.so;DSN=mssql

The DSN is the same configured on odbc.ini on Linux box.

I think the unixODBC driver manager should be used in this case. Not the
Sybase driver manager.

But I don't know how to do that.

Any idea?

"Chris Gruber" <chris.gruber@ianywhere.com> escreveu na mensagem
news:42d7d82d@forums
-1-dub...
>I think DataDirect does offer a Linux ODBC driver for MSSQL. I also
>believe
> that DataDirect provides a sample odbc.ini as well.
>
> Chris Gruber
> iAnywhere Solutions
> "Marcelo Hille" <marcelo.cpd@sankoespumas.com.br> wrote in message
> news:42d5432b@forums
-2-dub...
> then
> http://www.ianywhere.com/developer/...e/0902/en/html/
> dbugen9/00000602.htm
> http://www.ianywhere.com/developer/...e/0902/en/html/
> dbrfen9/00000362.htm
>
>

Sponsored Links