22
янв
Sql Anywhere Download
Posted:admin
Formerly known as SQL Anywhere Studio. 
SAP SQL Anywhere is a powerful relational database management software package that aims to provide professional developers with the tools they require to.
Hi All, I have a data migration project that requires data migrating from Sybase SQL Anywhere to SQL Server 2005. I had done similar projects (not with Sybase) before and able to query data in sql query analyzer using odbc. However, I am finding it difficult in linking sybase with SQL Server. Steps I did: • Install sybase SQL anywhere in the server inclusive its driver. This can be found at (developer edition).
This will install driver called 'Adaptive Server Anywhere 9' • Once above done, I created ODBC and connected Sybase Central using the ODBC. SQL Anywhere comes with userid -DBA and password -sql in order to have this connection. I could connect to Sybase SQL Anywhere using ODBC. • Now I wanted to create link server in MS SQL Server 2005 to that sybase database so that I can query syabase using ms query analyzer and I was not able to establish this link. I have sybase and ms sql both installed in the same server and also sybase installed remotely in another server.
I did all avenues to create link servers but I am not able to establish. Anyone can give me any information on this, that would be really appreciated. If you need any extra information, just let me know.
Popular Posts
Formerly known as SQL Anywhere Studio.
SAP SQL Anywhere is a powerful relational database management software package that aims to provide professional developers with the tools they require to.Hi All, I have a data migration project that requires data migrating from Sybase SQL Anywhere to SQL Server 2005. I had done similar projects (not with Sybase) before and able to query data in sql query analyzer using odbc. However, I am finding it difficult in linking sybase with SQL Server. Steps I did: • Install sybase SQL anywhere in the server inclusive its driver. This can be found at (developer edition).
This will install driver called \'Adaptive Server Anywhere 9\' • Once above done, I created ODBC and connected Sybase Central using the ODBC. SQL Anywhere comes with userid -DBA and password -sql in order to have this connection. I could connect to Sybase SQL Anywhere using ODBC. • Now I wanted to create link server in MS SQL Server 2005 to that sybase database so that I can query syabase using ms query analyzer and I was not able to establish this link. I have sybase and ms sql both installed in the same server and also sybase installed remotely in another server.
I did all avenues to create link servers but I am not able to establish. Anyone can give me any information on this, that would be really appreciated. If you need any extra information, just let me know.
...'>Sql Anywhere Download(22.01.2019)Formerly known as SQL Anywhere Studio.
SAP SQL Anywhere is a powerful relational database management software package that aims to provide professional developers with the tools they require to.Hi All, I have a data migration project that requires data migrating from Sybase SQL Anywhere to SQL Server 2005. I had done similar projects (not with Sybase) before and able to query data in sql query analyzer using odbc. However, I am finding it difficult in linking sybase with SQL Server. Steps I did: • Install sybase SQL anywhere in the server inclusive its driver. This can be found at (developer edition).
This will install driver called \'Adaptive Server Anywhere 9\' • Once above done, I created ODBC and connected Sybase Central using the ODBC. SQL Anywhere comes with userid -DBA and password -sql in order to have this connection. I could connect to Sybase SQL Anywhere using ODBC. • Now I wanted to create link server in MS SQL Server 2005 to that sybase database so that I can query syabase using ms query analyzer and I was not able to establish this link. I have sybase and ms sql both installed in the same server and also sybase installed remotely in another server.
I did all avenues to create link servers but I am not able to establish. Anyone can give me any information on this, that would be really appreciated. If you need any extra information, just let me know.
...'>Sql Anywhere Download(22.01.2019)