on 07-23-2015 2:34 PM
Hello,
We are using Symantec Netbackup and OpsCenter. The backend DB server is Sybase,but I am not familiar with Sybase, so I am not sure what type of Sybase DB server it is (it could be SQL Anywhere).
select @@version reports 12.0.1.4127.
I want to connect to the Sybase database from VB.Net application I am developing. Visual Studio is version 2003, it is installed on a 32 bit Windows Server 2003 machine.
I just need a suitable .NET v.1.1 Data Provider to be able to connect to the Sybase database server from the VB.Net application. Subsequently the VB.Net app will be run on the latest OS too (like Windows 8.1).
The reason for using old .Net Framework and VB.Net versions is the use of old licensed Infragistics Components.
I downloaded ASE_15_5_nt386.zip and installed it. When I try connecting to the Sybase Server from the VB.Net app I get column @@pagesize not found error. I get the same error when trying to define a new ODBC Data Source.
Any help will be appreciated.
Best Regards
Sezgin
Thanks for the replies.
I downloaded the SAP SQL Anywhere 12.0.1 Client and installed it(thanks to Jose Ramos for the link).
In Visual Studio 2003 I was able to connect to SQL Anywhere 12 by using a ADODB.Connection (provider = SAOLEDB). As a better alternative I imported the solution to VS 2013 and connected to SQL Anywhere 12 by using iAnywhere.Data.SQLAnywhere.SAConnection (referenced iAnywhere.Data.SQLAnywhere.v4.0.dll), project target .Net Framework setting= 4 . The VS 2013 compiled app runs fine even on Windows Server 2012 R2, with no .NET Framework v.1 or v.1.1 installed - I found that interesting, because the Infragistics .dll's compiled .Net runtime version is reported as v1.0.3705.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
NetBackup does indeed use SQL Anywhere, so the ASE download would not help you.
However, you should work directly with Symantec if you need access to the database outside the NetBackup approved applications/interfaces.
--Jason
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.