Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
83dons
Starting Member
3 Posts |
 Posted - 2010-01-11 : 15:19:17
|
| HiI am using a simple Pass Through Query in MS Access to pull data from a Sybase database and populate a table in Access. This query has always worked in the past but has recently been throwing back the following error message:ODBC -- call failed.[Sybase][ODBC Driver][Adaptive Server Anywhere]SELECT returns more than one row(#-185)I have not changed the query so I am guessing this must be down to a data limit for the query being reached, a time out in connection or perhaps a duplicate row in the database or maybe a wrongly populated row?I have tried the google search and found nothing to help - the table in Access did have a lot of rows at about 380,000 but it should manage more than this I reckon as the limit for an Access table is 2GB. Cananyone help please? Spent 2 days on this already! Maybe an alternative SQL query is needed. The current query is somehing like:SELECT column1, column2, ...etcFROM tablename;SO basically selects all rows in a table in Sybase and certain columns and then puts them in an Access table. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SELECT returns more than one row