odbc connection via access

Has anyone ever experienced the following.  When using MS Access with
read only priv. via an ODBC connection to ASA having duplicate rows of a
table displayed?  Upon investigating it's just that, the duplicates are
only being displayed (hundreds of times) the actual db is fine.  Any
suggestions.  It's version 5.5.04.

0
jtd
5/17/2000 8:06:15 PM
📁 sybase.sqlanywhere.general
📃 32637 articles.
⭐ 22 followers.

💬 5 Replies
👁️‍🗨️ 661 Views


If you have written a query with multiple tables you may have left off 
the necessary syntax to join the tables in a logical way.  If you leave 
off the join syntax you'll get a Cartesian join which joins every row 
with every other row from each table.
-- 
Jim Egan [TeamSybase]
Houston, TX
http://www.eganomics.com
Sybase Developers Network
http://sdn.sybase.com/sdn/mec/mec_home.stm
0
Jim
5/18/2000 2:56:13 AM
There is only one table being accessed and no query is being run against
it, just an opening of the table.

Jim Egan wrote:
> If you have written a query with multiple tables you may have left off
> the necessary syntax to join the tables in a logical way.  If you leave
> off the join syntax you'll get a Cartesian join which joins every row
> with every other row from each table.
> --
> Jim Egan [TeamSybase]
> Houston, TX
> http://www.eganomics.com
>
> Sybase Developers Network
> http://sdn.sybase.com/sdn/mec/mec_home.stm
0
jtd
5/18/2000 3:32:45 PM
jtd wrote:
> 
> Has anyone ever experienced the following.  When using MS Access with
> read only priv. via an ODBC connection to ASA having duplicate rows of a
> table displayed?  Upon investigating it's just that, the duplicates are
> only being displayed (hundreds of times) the actual db is fine.  Any
> suggestions.  It's version 5.5.04.
I'm scraping the bottom of my brain cells here, but you might want to
look into how Access deals with case-insensitive searches. As you know,
SQLA defaults to case-insensitive searches unless you change the
database option to do otherwise. We had this problem with the Borland
Database Engine; my partner modified the default SQLA (Dic850)
dictionary and we specified it in the BDE LANGDRIVER option. And no, I
don't know what modification he made. If somebody could refresh my
memory about how to extract the dictionary to an ascii file, I could
probably run a delta between what we're using and sademo.db.
HTH,
Kathleen
0
Kathleen
5/18/2000 5:08:43 PM
I don't know what else the problem could be.  I don't use access.
-- 
Jim Egan [TeamSybase]
Houston, TX
http://www.eganomics.com
Sybase Developers Network
http://sdn.sybase.com/sdn/mec/mec_home.stm
0
Jim
5/19/2000 2:12:05 AM
Hello
I also had the same problem with ASA 6.0.3
But in my case only some recods where dublicated.
How I remember it was related with field, and with his index.
Linas Kavolius

"jtd" <jdombrow@sybase.com> wrote in message
news:3922FBB7.83BDE166@sybase.com...
> Has anyone ever experienced the following.  When using MS Access with
> read only priv. via an ODBC connection to ASA having duplicate rows of a
> table displayed?  Upon investigating it's just that, the duplicates are
> only being displayed (hundreds of times) the actual db is fine.  Any
> suggestions.  It's version 5.5.04.
>
>
>

0
Linas
5/19/2000 6:40:00 AM
Reply: