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.

dbODBC6.dll

5 posts in General Discussion Last posting was on 2003-01-24 13:17:33.0Z
Patrick_Prince Posted on 2003-01-21 20:16:20.0Z
From: Patrick_Prince
Date: Tue, 21 Jan 2003 15:16:20 -0500
Newsgroups: ianywhere.public.general
Subject: dbODBC6.dll
Message-ID: <D085389D78D08F62006F5C1185256CB5.006F5C2185256CB5@webforums>
Lines: 8
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:275
Article PK: 2094

Hi,

I'm trying to locate the following ODBC driver: dbodbc6.dll v 6.00.x.
I'd like to query a Sybase dB using MS Access. I haven't had any luck
scouring the web so far.

Thanks,
Patrick Prince


chaogao Posted on 2003-01-24 03:36:59.0Z
From: chaogao
Date: Thu, 23 Jan 2003 22:36:59 -0500
Newsgroups: ianywhere.public.general
Subject: Re: dbODBC6.dll
Message-ID: <728DB3AA156C72600013DDC585256CB8.0072D20185256CB5@webforums>
References: <D085389D78D08F62006F5C1185256CB5.006F5C2185256CB5@webforums>
Lines: 33
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:251
Article PK: 2070

Why I can't create multiple DSNs for ODBC connections using Adaptive
Server Anywhere???

I have a third party's software called Geographix, which uses Sybase
database. I have dbODBC6.dll which located in
C:\Program Files\GeoGraphix\AdaptiveServer70\win32. I an thinking that you
might want to download from somewhere free.

Acutually I am trying to do the similar thing as you are. But we have some
problems with Adaptive Server Anywhere 7.0.

I have created an Access Database and I tried to use this Access database
to connect to different Sybase databases. I used Adaptive Server Anywhere
7.0 to create serveral DSNs pointing these different Sybase databases.

Here is what I did. I created DSN1 (User DSN) for my Database1 using ODBC
Data Source Administrator. DSN1 worked ok. Then I created DSN2 the same
way, but pointing my Database2 and tested the connection using the Test
Connection button. I got message saying "Connection Successful!". So I
thought I was OK. When I was trying to link the tables or import the
tables, I found that I linked or imported the tables in the Database1
instead of the Database2. Then I deleted DSN1 and DSN2 and recreated DSN2.
Now this time, DSN2 is OK. Looks like I can use Adaptive Server Anywhere
7.0 to create only one DSN.

My question is: Why I can't use Adaptive Server Anywhere 7.0 to create more
than one DSNs just like other ODBC Drivers (e.g., SQL Server, Oracle,
Access, DB2 Drivers, etc.). Are there alternitives.
Maybe I can dynamically create DSN using Access VBA code everytime pointing
different database, then delete it dynamically after I use it. Is there any
sample code I can find somewhere?


Chad


Robert Waywell Posted on 2003-01-24 13:17:33.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <D085389D78D08F62006F5C1185256CB5.006F5C2185256CB5@webforums> <728DB3AA156C72600013DDC585256CB8.0072D20185256CB5@webforums>
Subject: Re: dbODBC6.dll
Date: Fri, 24 Jan 2003 08:17:33 -0500
Lines: 65
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <uikSQ26wCHA.344@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:246
Article PK: 2067

Please do not repeat your posts. I have commented on your other thread.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<chaogao> wrote in message
news:728DB3AA156C72600013DDC585256CB8.0072D20185256CB5@webforums...
>
> Why I can't create multiple DSNs for ODBC connections using Adaptive
> Server Anywhere???
>
> I have a third party's software called Geographix, which uses Sybase
> database. I have dbODBC6.dll which located in
> C:\Program Files\GeoGraphix\AdaptiveServer70\win32. I an thinking that you
> might want to download from somewhere free.
>
> Acutually I am trying to do the similar thing as you are. But we have some
> problems with Adaptive Server Anywhere 7.0.
>
> I have created an Access Database and I tried to use this Access database
> to connect to different Sybase databases. I used Adaptive Server Anywhere
> 7.0 to create serveral DSNs pointing these different Sybase databases.
>
> Here is what I did. I created DSN1 (User DSN) for my Database1 using ODBC
> Data Source Administrator. DSN1 worked ok. Then I created DSN2 the same
> way, but pointing my Database2 and tested the connection using the Test
> Connection button. I got message saying "Connection Successful!". So I
> thought I was OK. When I was trying to link the tables or import the
> tables, I found that I linked or imported the tables in the Database1
> instead of the Database2. Then I deleted DSN1 and DSN2 and recreated DSN2.
> Now this time, DSN2 is OK. Looks like I can use Adaptive Server Anywhere
> 7.0 to create only one DSN.
>
> My question is: Why I can't use Adaptive Server Anywhere 7.0 to create
more
> than one DSNs just like other ODBC Drivers (e.g., SQL Server, Oracle,
> Access, DB2 Drivers, etc.). Are there alternitives.
> Maybe I can dynamically create DSN using Access VBA code everytime
pointing
> different database, then delete it dynamically after I use it. Is there
any
> sample code I can find somewhere?
>
>
> Chad


Rick Blythe Posted on 2003-01-23 15:31:11.0Z
From: "Rick Blythe" <rickb@ianywhere.com>
References: <D085389D78D08F62006F5C1185256CB5.006F5C2185256CB5@webforums>
Subject: Re: dbODBC6.dll
Date: Thu, 23 Jan 2003 10:31:11 -0500
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <Bz8hQcvwCHA.351@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.141.16
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:259
Article PK: 2078

There's more to it than plugging in an odbc driver.
SQL Anywhere is client/server, meaning you need to be running either the
server and a standalone engine, plus you need the odbc components...

--
______________________
Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer
______________________
<Patrick_Prince> wrote in message
news:D085389D78D08F62006F5C1185256CB5.006F5C2185256CB5@webforums...
Hi,

I'm trying to locate the following ODBC driver: dbodbc6.dll v 6.00.x.
I'd like to query a Sybase dB using MS Access. I haven't had any luck
scouring the web so far.

Thanks,
Patrick Prince


Robert Waywell Posted on 2003-01-22 16:16:52.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <D085389D78D08F62006F5C1185256CB5.006F5C2185256CB5@webforums>
Subject: Re: dbODBC6.dll
Date: Wed, 22 Jan 2003 11:16:52 -0500
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <1wYgFRjwCHA.285@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:271
Article PK: 2091

This is part of the client install. When you install the ASA client you will
get the ODBC driver.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<Patrick_Prince> wrote in message
news:D085389D78D08F62006F5C1185256CB5.006F5C2185256CB5@webforums...
> Hi,
>
> I'm trying to locate the following ODBC driver: dbodbc6.dll v 6.00.x.
> I'd like to query a Sybase dB using MS Access. I haven't had any luck
> scouring the web so far.
>
> Thanks,
> Patrick Prince