Sample for using Sybase & Delphi

[jeho...@my-deja.com]

Hi,

Can someone please tell me where to find an example (source code) of
using Delphi and Sybase.

Peter

[Al Kirk]

www.nativedb.com. Native DB is the cleanest way to use sybase with
Delphi, and also the lowest learning curve.

[Richard Biffl]

Sybase has a white paper with (poorly formatted) code snippets, "Borland
Delphi Using SQL Anywhere Studio," at
http://www.sybase.com/detail?id=1010193. It shows various ways to interface
Delphi and SQL Anywhere. The BDE/ODBC interface comes with Delphi, but I
prefer using the NativeDB components, http://www.nativedb.com, which
eliminate the need for either the BDE or ODBC and give fuller access to SQL
Anywhere's capabilities. The NativeDB components have their own (well
formatted <g>) code snippets in their documentation, and their support is
excellent.

Richard

<jeho...@my-deja.com> wrote in message
news:3b90b92...@forums.sybase.com...

[jeho...@my-deja.com]

Hi,

Thanks Al & Richard. Also, I found some links

http://www.kylecordes.com/bag/whynotbde.html

http://www.geocities.com/ctlibcomps/index.htm

Peter

[Richard Biffl]

Peter, note that the CTLib components talk to SQL Anywhere through the
obsolete ct-lib interface. Well, I guess it's not obsolete for Adaptive
Server Enterprise, but it's not included in Adaptive Server Anywhere (SQL
Anywhere) anymore. To use the CTLib components with ASA, you'd need to
purchase Sybase's Open Client library. According to the SQL Anywhere 7.03
documentation, "When to use Open Client: You should consider using the Open
Client interface if you are concerned with Adaptive Server Enterprise
compatibility or if you are using other Sybase products that support the
Open Client interface, such as Replication Server." In other words, don't go
that way unless you use ASE.

Richard

<jeho...@my-deja.com> wrote in message
news:3b92bee6...@forums.sybase.com...
>
> http://www.geocities.com/ctlibcomps/index.htm

[Peter Richards]

Hi Richard,

Okay, thanks. All I want to actually do is to view some data from a
sybase db, by using Delphi 6 Pro. There weren't any examples in D6,
and even with the BDE, there are errors. Oh well.

Peter

[Richard Biffl]

If you use the BDE with ASA's ODBC driver, be sure to configure the ODBC
data source and select both "Microsoft applications (Keys in SQLStatistics)"
and "Delphi applications."

"Peter Richards" <jeho...@my-deja.com> wrote in message
news:3b930721...@forums.sybase.com...

[Peter Richards]

On Mon, 3 Sep 2001 01:53:10 -0400, "Richard Biffl"
<sybas...@NOSPAMblacklettersoftware.com> wrote:

>If you use the BDE with ASA's ODBC driver, be sure to configure the ODBC
>data source and select both "Microsoft applications (Keys in SQLStatistics)"
>and "Delphi applications."

I don't have any (sybase) ODBC drivers, unless they are part of the
Delphi 6 setup, and weren't installed. I don't have any Sybase
products either, just some data I would like to view.

When I used the BDE, I just used "SYBASE" as the database driver name,
but I that isn't the same as (ODBC) driver name, right ?

If I try to open the alias in BDE admin, I get an "Cannot open the
IDAPI service library, File: SQLSSC32.DLL " message. If I try to find
_that_ file on the system, it isn't there (surprise, surprise, eh).

Peter

[Richard Biffl]

You won't be able to see the data in the database without a database server.
You can download a trial version from www.sybase.com.

You call it a Sybase database; do you know what kind of Sybase database?
Anywhere? Enterprise? IQ? Because this is the SQL Anywhere newsgroup, I've
assumed it's SQL Anywhere, but you need to know. The BDE's SQL Links driver
called "Sybase" is for Sybase SQL Server or Sybase Adaptive Server
Enterprise, and I don't think it works, at least not completely, with SQL
Anywhere. You should just use the BDE's ODBC connectivity. When you install
the trial version of the server, the ODBC driver will be installed on your
system.

Richard

"Peter Richards" <jeho...@my-deja.com> wrote in message

news:3b932c34...@forums.sybase.com...

[Peter Richards]

Hi Richard,

Thanks for all your help.

Peter

[Steve Moran]

I recommend www.odbcexpress.com , that's what I chose to use. There are good
reasons for using ODBC rather than native drivers, if like me you want to
stay generic. By and large, with it your code then works against SqlAnywhere
and the other main databases.

Steve

<jeho...@my-deja.com> wrote in message
news:3b90b92...@forums.sybase.com...

[Peter Richards]

Hi Richard,

>You call it a Sybase database; do you know what kind of Sybase database?
>Anywhere? Enterprise? IQ?

Can you point me to a document somewhere please, that clearly explains
all the different 'versions/flavours" of Sybase databases, from the
"Watcom" to present. I'm stuck on names and acronyms at present, just
need something that clearly outlines what each one is/does.

Peter

[Peter Richards]

Hi Steve,

On Thu, 6 Sep 2001 11:50:39 +0100, "Steve Moran"
<spamyen...@letyenotspam.silverlink.co.uk> wrote:

>I recommend www.odbcexpress.com , that's what I chose to use. There are good
>reasons for using ODBC rather than native drivers, if like me you want to
>stay generic. By and large, with it your code then works against SqlAnywhere
>and the other main databases.

Thanks. Yes, now I'm starting to see that some of the products that
are termed 'native' or 'direct' have limitations. For instance, one
product _only_ connects to SQL Anywhere, so if the user starts using
another 'flavour' of a sybase db, I'm marooned.

Peter

[Richard Biffl]

I don't know of such a document, but Sybase advertises 3 database servers on
its website at http://www.sybase.com/products/databaseservers: SQL Anywhere
Studio (which includes the Adaptive Server Anywhere server), Adaptive Server
Enterprise, and Adaptive Server IQ.

SQL Anywhere began life as Watcom SQL, then became Sybase SQL Anywhere, then
Adaptive Server Anywhere (ASA), and now it's usually called SQL Anywhere
again.

Adaptive Server Enterprise (ASE) was Sybase's original product, formerly
named Sybase SQL Server. IQ was developed by Sybase, as far as I know, and
is meant for data warehouses.

Richard

"Peter Richards" <jeho...@my-deja.com> wrote in message

news:3b97fa4...@forums.sybase.com...