Fieldman
|
Posted: 02/05/2004, 11:00 AM |
|
i imported spreadsheet to sql 2000
when running reports and query CCS will not validate this query.
error invalid object name 'tablename'.
if i run the same query on query analyzer it works.
other tables work i created manually but none of the imports work.
|
|
|
Edd
Posts: 547
|
Posted: 02/05/2004, 1:18 PM |
|
Check your permissions for CCS's web access account.
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
peterr
Posts: 5971
|
Posted: 02/05/2004, 2:39 PM |
|
BTW, do you have a table named "tablename" in your database?
Let us know, and if so we will run some tests to see if this may be causing the problem.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
peterr
Posts: 5971
|
Posted: 02/05/2004, 2:43 PM |
|
Hmm, I see a similar problem discussed here, and not related to CCS: http://www.sqlmag.com/forums/messageview.cfm?catid=3&threadid=7107
Possibly you could also provide your SQL/Query , so that we could analyze if there is a potential problem there.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
Fieldman
|
Posted: 02/05/2004, 6:50 PM |
|
i found the problem
when imported the file in DTS i used NT login not sql
also were some problems with datatype and column...
wht does CCS use "type" in the column for? after sloving problem with NT login and some data type i still was unable to run query, error pointed to the column name "type" when i renamed it everything works ok
|
|
|