Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Oledb connection...

2 posts in General Discussion Last posting was on 2004-04-07 03:43:12.0Z
Chandresh Patel Posted on 2004-04-07 00:13:44.0Z
From: "Chandresh Patel" <bapashree@yahoo.com>
Newsgroups: ianywhere.public.general
Subject: Oledb connection...
Lines: 11
Organization: Shreeji Smart Solution
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: ac841d19.ipt.aol.com
Message-ID: <407339a4$1@forums-2-dub>
X-Original-Trace: 6 Apr 2004 16:13:40 -0800, ac841d19.ipt.aol.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 6 Apr 2004 16:13:42 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 6 Apr 2004 16:13:44 -0800
X-Trace: forums-1-dub 1081293224 10.22.108.75 (6 Apr 2004 16:13:44 -0800)
X-Original-Trace: 6 Apr 2004 16:13:44 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2927
Article PK: 6396

Hi,

I try to create oledb connection in Crystal Report using Sybase Anywhere
9.0.1.1108 and I am unable to connect with database.

how can i connect. What is data source name (server or dsn name).


Thanks in Advance.


Chris Keating (iAnywhere Solutions) Posted on 2004-04-07 03:43:12.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <407339a4$1@forums-2-dub>
Subject: Re: Oledb connection...
Lines: 56
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: cpe0080c6f83676-cm012059936305.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpe0080c6f83676-cm012059936305.cpe.net.cable.rogers.com
Message-ID: <40736ac0$1@forums-1-dub>
Date: 6 Apr 2004 19:43:12 -0800
X-Trace: forums-1-dub 1081305792 24.112.219.219 (6 Apr 2004 19:43:12 -0800)
X-Original-Trace: 6 Apr 2004 19:43:12 -0800, cpe0080c6f83676-cm012059936305.cpe.net.cable.rogers.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2931
Article PK: 6400

I am not familar with CR and its OLEDB connectivity. Is there a specific
reason why you need to connect using OLEDB given that CR allows connectivity
using a ODBC?

You can use the DSN name for that value and the connection properties
defined in the DSN will get used to establish the connection asuming that
you have selected ASAProv.90 as your OLEDB provider. If you are using the
bridge, ODBC will be used to make the connection. You can also avoid the
ODBC DSN (since ODBC is not needed) by setting the the OLEDB extended
properties value to be the connection string.

The .Net IDE View | Server Explorer | Data Connections may be helpful when
working to get OleDB connectivity settings.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

****************************************************************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

****************************************************************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

****************************************************************************
*

"Chandresh Patel" <bapashree@yahoo.com> wrote in message
news:407339a4$1@forums-2-dub...
> Hi,
>
> I try to create oledb connection in Crystal Report using Sybase Anywhere
> 9.0.1.1108 and I am unable to connect with database.
>
> how can i connect. What is data source name (server or dsn name).
>
>
> Thanks in Advance.
>
>