OK, first let me say that I am no DB person.
But I have a user here who keeps getting this error
whenever she does, whatever it is she does, with
databases...
A google search takes me to various forums where
I am forced to sign up before I can read any answers.
Interesting note here is that the guy in the office next
to her can run this same query without any problems.
So, can this be a hardware issue?
If I threw more RAM at this problem would that do?
Or is this strickly a coding issue?
Why would one machine run this query ok, yet another
machine generates this error?
Any pointers that you guys could throw my way would
be greatly appreciated.
Thanks
*$ 4 8945
Starbuck,
I am afraid you haven't provided enough information to be of help. What
error is she getting? What statement is she running? etc.
By the way, you can search the archive of the public Microsoft
SQL-Server forums on Google (without registration). Have a look at http://groups.google.com/groups?hl=e...blic.sqlserver
Hope this helps,
Gert-Jan
Starbuck wrote: OK, first let me say that I am no DB person.
But I have a user here who keeps getting this error whenever she does, whatever it is she does, with databases...
A google search takes me to various forums where I am forced to sign up before I can read any answers.
Interesting note here is that the guy in the office next to her can run this same query without any problems.
So, can this be a hardware issue? If I threw more RAM at this problem would that do?
Or is this strickly a coding issue? Why would one machine run this query ok, yet another machine generates this error?
Any pointers that you guys could throw my way would be greatly appreciated. Thanks
*$
--
(Please reply only to the newsgroup)
The error message is "Query is too complex".
The Query that is being run combines 2 tables into
a table query. There is only one join.
The issue seems to be that this query runs on another
machine just fine... They have similar hardware,
and software, but it fails with a "Query is too complex"
error on her machine.
We dont feel that this is in fact a "complex" query.
Point is, I need this to run on her machine, but I am
unable to determine what the differences are.
Could this be a connection issue?
I'm really shooting in the dark here, so any suggestions
are greatly appreciated.
thanks again.
*$
On Thu, 05 Aug 2004 19:43:08 +0200, Gert-Jan Strik
<so***@toomuchspamalready.nl> wrote: Starbuck,
I am afraid you haven't provided enough information to be of help. What error is she getting? What statement is she running? etc.
By the way, you can search the archive of the public Microsoft SQL-Server forums on Google (without registration). Have a look at http://groups.google.com/groups?hl=e...blic.sqlserver
Hope this helps, Gert-Jan
Starbuck wrote: OK, first let me say that I am no DB person.
But I have a user here who keeps getting this error whenever she does, whatever it is she does, with databases...
A google search takes me to various forums where I am forced to sign up before I can read any answers.
Interesting note here is that the guy in the office next to her can run this same query without any problems.
So, can this be a hardware issue? If I threw more RAM at this problem would that do?
Or is this strickly a coding issue? Why would one machine run this query ok, yet another machine generates this error?
Any pointers that you guys could throw my way would be greatly appreciated. Thanks
*$
Starbuck (St******@BogusDomain.com) writes: The error message is "Query is too complex".
The Query that is being run combines 2 tables into a table query. There is only one join.
The issue seems to be that this query runs on another machine just fine... They have similar hardware, and software, but it fails with a "Query is too complex" error on her machine.
We dont feel that this is in fact a "complex" query.
Point is, I need this to run on her machine, but I am unable to determine what the differences are.
Could this be a connection issue?
I'm really shooting in the dark here, so any suggestions are greatly appreciated.
If you are in the dark, guess how dark we are in, who don't even know
what environment you are using, or how the query looks like.
That much I can tell, that the message "Query is too complex" does not
appear in master..sysmessages, so it is not likely to be a message from
SQL Server. To be able to assist further we need to see the query,
we need to know what environment the user gets this error in, and we
need to know which database engine you are working with. (It should be
MS SQL Server, else you are posting to the wrong newsgroup.)
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
"Starbuck" <St******@BogusDomain.com> wrote in message
news:sp********************************@4ax.com... OK, first let me say that I am no DB person.
But I have a user here who keeps getting this error whenever she does, whatever it is she does, with databases...
A google search takes me to various forums where I am forced to sign up before I can read any answers.
Interesting note here is that the guy in the office next to her can run this same query without any problems.
So, can this be a hardware issue? If I threw more RAM at this problem would that do?
Or is this strickly a coding issue? Why would one machine run this query ok, yet another machine generates this error?
Any pointers that you guys could throw my way would be greatly appreciated. Thanks
*$
I've never heard of this error before - as Erland pointed out, this is not a
native MSSQL error - however some Googling suggests that it is likely to be
either an MS Access issue, or something related to some very old data access
components (the most recent exact hit for this error in Google newsgroups is
in the year 2000). For example: http://support.microsoft.com/default...NoWebContent=1 http://support.microsoft.com/default...NoWebContent=1 http://www.dotnet247.com/247referenc...43/216266.aspx http://www.google.com/search?sourcei...ry+too+complex
Without more information, however, it's very difficult for anyone to give
any good advice. What is the database (Access, MSSQL), what is the client
(Access, in-house app, third-party app), what are the operating systems, the
servicepacks, how is the query submitted, what is the definition of the
query and tables, what difference is there between the workstations where
the query works and does not (OS, hardware) etc.
My best guess is that you are querying an MS Access database, and the "guy
in the next office" has a more recent Windows version than the user with the
error (and therefore more recent data access components), but that's purely
speculation and very likely to be wrong. If you're not using MSSQL, then as
Erland said, you will get a better response in a forum dedicated to your
database platform.
Simon This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Robin Tucker |
last post by:
Hi,
Can anyone tell me how to select the "most recent" date values from a
grouped query? Consider the following:
CREATE TABLE . ( NOT NULL , NOT
NULL , NOT NULL ) ON
This is a...
|
by: Brian Angliss |
last post by:
I'm relatively new to scripting in JavaScript, so I'm not too
surprised I'm having difficulty scripting up an animation effect for
my personal site.
What I'm trying to do is the following: When...
|
by: Ellen Manning |
last post by:
Using A2K. In my table I have the field "Grant" which can have a
value or be null. I have a query that counts the number of records
and has a Where clause on the Grant field. The query won't...
|
by: Susie Swint |
last post by:
I have the following IIf statement which worked in Access 95 but will
not work in Access 2002. The error message I get is that the expression
is typed incorrectly, or is too complex to be...
|
by: Matt |
last post by:
Hi all, Thank you for taking the time.
I have a database with 45 tables on it. 44 tables are linked to a main
table through a one to one relationship.
My question is, is there no way i can...
|
by: Mike Bridge |
last post by:
I am using MS Access 2003, and I typed in a query in SQL view which was working fine. Now when I open it, it gives me
the error "Join expression not supported". Apparently, Access "fixed" it for...
|
by: Russ |
last post by:
I tried the following:
>>> x = complex(4)
>>> y = x
>>> y *= 2
>>> print x, y
(4+0j) (8+0j)
But when I tried the same thing with my own class in place of
"complex" above, I found that both...
|
by: wayniac |
last post by:
I am having a problem when I try and remove several fields from the lookup. I have many fields, and the error I am getting is "Expression is too complex", is there anyway of going around this or...
|
by: cori25 |
last post by:
Paycode': IIf(="01","Meeting",IIf(="02","Training",IIf(="04","Special Project",IIf(="05","QC",IIf(="06","MDU",IIf(="07","UG",IIf(="08","2nd Man",IIf(="09","Sr Tech Other",IIf(="10-1","Loan Out to...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
| |