Getting data from "SyBase Sql Anywhere". (kind of a newbie question..)

Posted on 2006-04-21
Last Modified: 2008-02-07
Hi there.. first some information about the system :

The Webserver (for my webapp):
Solution : .NET 1.x application (mainly on VS 2003 .NET
Webserver : WIN 2003 Server

The Sybase server :
OS       : Win XP Professional
Sybase : Sybase SQL Anywhere 8
System-DSN : Wintid

* No IIS Installed
* No .NET framework installed
* On seperate server, but same domain as webserver..

What do i want to do ?
Connect to the sybase server, getting data from tables using OBDC connection (odbc best since i doesn't have .net on sybase server ?)

What i need help with :
1) Can i do this without using any *.dll files (connectors to the sybase server) ?
2) How do i create the connectionstring ? (i'm only used to mySql, Sql and Notes).
3) Do i have to import anything into my .net Assembly ? In that case... how ?

I found a guide but i just cannot see how i can get this to work :
1) Add a reference to the Adaptive Server Anywhere .NET data provider, as follows:
2) From the Project menu, choose Add Reference.
3) Click Browse.
4) Navigate to the following directory: C:\Program Files\Sybase\SQL Anywhere 8\win32.
5) Select ianywhere.Data.AsaClient.dll.
6) Click Open.

This is the .NET approach though.. but then i would have to have .NET and IIS installed on the Sybase server right ?
I dont have any SyBase installation on my webserver (where my .net web app lies)...

Hope this isn't too vague, and that u can understand what i'm after here :)

Best regards
NCIS Norway.
Question by:Kripos56
    LVL 17

    Accepted Solution

    As I understand it, you won't need .net, etc on the Sybase server, only on the machine that is running the .net app (you web server).  The latest EBF for the SAS version 8 client has the .NET ADO stuff in it.

    You could also simply install the SYS 8 network client piece on the web server, set up a machine level ODBC DSN, and away you got.  That's how I'm doing it where I work, though I'm doing the programming in PowerBasic (love having executables under 500k and only one small support DLL to make calls to *any* ODBC source)

    Author Comment

    Hi there :)

    Thanx for letting me on the right track BudDurland.. but.. the thing is that we do not have any installation-CD here.. This is because the server and applications on it was delivered to us directly.

    There is something called "Open Client" which _should_ have been downloadable from Sybases website.. but they have restricted it, so we wont be able to download it..

    Is there any other way to create a DSN, Odbc or something else.. to connect to the server ?
    Any other connectors, applications, drivers etc.. which are free of download ?


    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Suggested Solutions

    It can often be challenging to stay relevant in the rapidly evolving world of technology. This can make recruiting talent difficult for companies of all sizes.
    Read about the 3 stages of the buyer's journey: awareness, consideration, and decision.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now