intermittent openquery error "..The OLE DB provider MSDASQL indicates that the object has

Help,

I am running a pass through query to oracle from SQL server 2000 as
follows;

select * from openquery(nbsp, 'select * from FND_FLEX_VALUES')

I have run this query through both DTS and the query analyzer and get
the foloowing error;

Server: Msg 7357, Level 16, State 2, Line 3
Could not process object 'select * from FND_FLEX_VALUES'. The OLE DB
provider 'MSDASQL' indicates that the object has no columns.
OLE DB error trace [Non-interface error: OLE DB provider unable to
process object, since the object has no columnsProviderName='MSDASQL',
Query=select * from FND_FLEX_VALUES'].

The really strange thing is, I'll get this error the first time I
execute the query but if I execute it immeadiatley after it will run
fine.

Any help would be most appreciated!

Cheers"Kevin" <kevin.morrell@.nbs.nhs.uk> wrote in message
news:3fff8324.0409150032.783cfd99@.posting.google.c om...
> Help,
> I am running a pass through query to oracle from SQL server 2000 as
> follows;
> select * from openquery(nbsp, 'select * from FND_FLEX_VALUES')
> I have run this query through both DTS and the query analyzer and get
> the foloowing error;
> Server: Msg 7357, Level 16, State 2, Line 3
> Could not process object 'select * from FND_FLEX_VALUES'. The OLE DB
> provider 'MSDASQL' indicates that the object has no columns.
> OLE DB error trace [Non-interface error: OLE DB provider unable to
> process object, since the object has no columnsProviderName='MSDASQL',
> Query=select * from FND_FLEX_VALUES'].
> The really strange thing is, I'll get this error the first time I
> execute the query but if I execute it immeadiatley after it will run
> fine.
> Any help would be most appreciated!
> Cheers

There are a couple of KB articles for error 7357, but they only relate to
situations where the query doesn't return a result set, which doesn't seem
to be the case with your query:

http://support.microsoft.com/defaul...8&Product=sql2k
http://support.microsoft.com/defaul...9&Product=sql2k

Is there some reason why you're using the ODBC OLE DB provider instead of
the Oracle one (MSDAORA)? You might want to try the Oracle one to see if
that makes a difference, and upgrading MDAC to the latest version might also
be worth a try.

Simon

Interactive Debugging of Stored Procedure

In VS 2005 with SQL Server Express: How do I debug a stored procedure that is called from a object datasource control while the asp.net code is running?

Thanks

You may need to PRINT debugging information in the stored procedure, or use SQL Profiler to capture a trace when executing the stored procedure.

intellisense for QA?

VB.NET (actually VS.NET) has a feature called Intellisense that will display
methods/properties for an object once you type a dot. For example:
Object1.
At that point, you may see a list similar to:
- Compare
- GetType
- Parse
- ToString
which you can choose. No memorization required. Is there a plug-in or
something for QA that will do the above? For example, I might join two
tables:
select us.column1, mm.column1
from dbo.summary us JOIN
dbo.message mm
ON us.
When I type us., I'd like to see all the fields in that table. Any
suggestions?
Thanks,
Brett> Is there a plug-in or
> something for QA that will do the above?
No. And the feature was dropped from the next version because T-SQL isn't
written and organized in a way that suits intellisense, the way a more
structured programming language is. If you type SELECT you might expect a
drop-down to appear with all of the built-in aggregate functions,
user-defined functions and every single column in all views and tables in
the entire database. The kind of metadata retrieval required for this just
didn't make sense...

> When I type us., I'd like to see all the fields in that table. Any
> suggestions?
Check out some of the other tools written for writing/modifying T-SQL,
though I've never heard of one that accomplishes this. The tools that ship
with SQL Server won't have this feature for a while (if ever)...|||There is no plug in for QA. This feature has also been dropped, currently,
from SQL 2005. I would look for a third party tool for running queries to
solve this problem.
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
"Brett" wrote:

> VB.NET (actually VS.NET) has a feature called Intellisense that will displ
ay
> methods/properties for an object once you type a dot. For example:
> Object1.
> At that point, you may see a list similar to:
> - Compare
> - GetType
> - Parse
> - ToString
> which you can choose. No memorization required. Is there a plug-in or
> something for QA that will do the above? For example, I might join two
> tables:
> select us.column1, mm.column1
> from dbo.summary us JOIN
> dbo.message mm
> ON us.
> When I type us., I'd like to see all the fields in that table. Any
> suggestions?
> Thanks,
> Brett
>
>|||Brett wrote:
> VB.NET (actually VS.NET) has a feature called Intellisense that will
> display methods/properties for an object once you type a dot. For
> example:
> Object1.
> At that point, you may see a list similar to:
> - Compare
> - GetType
> - Parse
> - ToString
> which you can choose. No memorization required. Is there a plug-in
> or something for QA that will do the above? For example, I might
> join two tables:
> select us.column1, mm.column1
> from dbo.summary us JOIN
> dbo.message mm
> ON us.
> When I type us., I'd like to see all the fields in that table. Any
> suggestions?
> Thanks,
> Brett
Take a look at SQL IDE from Imceda. We offer autocomplete on objects.
14-day trial from web site.
David Gugick
Imceda Software
www.imceda.com|||Have a look at ApexSQL Edit (http://www.apexsql.com/). I bought this
some time ago and it's a pretty good product. Their support is very good
and you get free upgrades for ever, major and minor versions.
Regards,
William D. Bartholomew
http://blog.bartholomew.id.au
*** Sent via Developersdex http://www.examnotes.net ***|||We've added T-SQL Intellisense-like word-completion support for Visual
Studio 2003/2005 and the SQL Server 2005 Management Studio to our PromptSQL
product. So you can now have auto-completion for TSQL in those environments
and of course Query Analyzer.
SELECT * FROM Em[Ctrl-Space] displays a popup with all tables starting with
Em
SELECT * FROM Employees AS e JOIN [Ctrl-Space] shows a popup with all tables
related to the employees table (via primary/foreign keys)
SELECT * FROM Employees AS E JOIN Orders o on [Ctrl-Space] shows a popup
with possible joins based on primary/foreign keys on the tables in the FROM.
Press "." after a table name to get the columns in the table. It has proper
support for SQL Server 2005, which of course means prefixing table names
with schema names as appropriate.
Online demos and registration-free download: http://www.promptsql.com/
PromptSQL is written in C# and uses hooks to monitor Query Analyzer and the
other supported environments. You carry on using these standard tools.
Regards,
PromptSQL Team.
Brett wrote:
> VB.NET (actually VS.NET) has a feature called Intellisense that will
> display
> methods/properties for an object once you type a dot. For example:
> Object1.
> At that point, you may see a list similar to:
> - Compare
> - GetType
> - Parse
> - ToString
> which you can choose. No memorization required. Is there a plug-in or
> something for QA that will do the above? For example, I might join two
> tables:
> select us.column1, mm.column1
> from dbo.summary us JOIN
> dbo.message mm
> ON us.
> When I type us., I'd like to see all the fields in that table. Any
> suggestions?
> Thanks,
> Brett|||your product is way - however this is not the correct forum for these
types of post. Please post this in microsoft.public.sqlserver.tools.
Truly a fabulous product though.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Damian Mehers" <feedback at promptsql.com> wrote in message
news:O9hBnr1mFHA.3608@.TK2MSFTNGP15.phx.gbl...
> We've added T-SQL Intellisense-like word-completion support for Visual
> Studio 2003/2005 and the SQL Server 2005 Management Studio to our
PromptSQL
> product. So you can now have auto-completion for TSQL in those
environments
> and of course Query Analyzer.
> SELECT * FROM Em[Ctrl-Space] displays a popup with all tables starting
with
> Em
> SELECT * FROM Employees AS e JOIN [Ctrl-Space] shows a popup with all
tables
> related to the employees table (via primary/foreign keys)
> SELECT * FROM Employees AS E JOIN Orders o on [Ctrl-Space] shows a popup
> with possible joins based on primary/foreign keys on the tables in the
FROM.
> Press "." after a table name to get the columns in the table. It has
proper
> support for SQL Server 2005, which of course means prefixing table names
> with schema names as appropriate.
> Online demos and registration-free download: http://www.promptsql.com/
> PromptSQL is written in C# and uses hooks to monitor Query Analyzer and
the
> other supported environments. You carry on using these standard tools.
> Regards,
> PromptSQL Team.
>
>
> Brett wrote:
>