1

Topic: Prompt by mistake "Statement (s) could not be prepared."

Here such request

SELECT *
FROM OPENROWSET (' SQLOLEDB ', ' Driver = {Microsoft dBase Driver (*.dbf)} ;Trusted_Connection=yes;sourcetype=DBF;defaultdir=D: \WORK\DB_DBF ';
' SELECT * FROM ADD7.pdf ')

At performance gives:
The message 8180, level 16, state 1, line 1
Statement (s) could not be prepared.
The message 208, level 16, state 1, line 1
Invalid object name ADD7.pdf '.
File available.
If other error delivers MSDASQL:
The AN OLE DB provider "MSDASQL" for linked server "(null)" reported an error. The provider did not give any information about the error.

2

Re: Prompt by mistake "Statement (s) could not be prepared."

Al0011;
It is direct with pdf  smile

3

Re: Prompt by mistake "Statement (s) could not be prepared."

TaPaK;
Well when in Server Management Studio you set through Task an envelope from pdf in sql such line quite works.
And in request for some reason here so.

4

Re: Prompt by mistake "Statement (s) could not be prepared."

Al0011;
Can all the same dbf?

5

Re: Prompt by mistake "Statement (s) could not be prepared."

TaPaK;
Yes dbf)

6

Re: Prompt by mistake "Statement (s) could not be prepared."

Al0011;
Well and write correctly

7

Re: Prompt by mistake "Statement (s) could not be prepared."

Corrected file name;
But an error all the same the same.

8

Re: Prompt by mistake "Statement (s) could not be prepared."

Al0011 wrote:

TaPaK;
Well when in Server Management Studio you set through Task an envelope from pdf in sql such line quite works.
And in request for some reason here so.

Save the packet created by a wizard yes look, what there the provider

9

Re: Prompt by mistake "Statement (s) could not be prepared."

Al0011 wrote:

corrected file name;
But an error all the same the same.

You it is direct up to the end an error read????
Error it

wrote:

Invalid object name ADD7.pdf '.

10

Re: Prompt by mistake "Statement (s) could not be prepared."

Yasha123 wrote:

it is passed...
Save the packet created by a wizard yes look, what there the provider

Oh, and how it to make?
[img=http://forum.ixbt.com/lamer.gif]

11

Re: Prompt by mistake "Statement (s) could not be prepared."

TaPaK wrote:

it is passed...
You it is direct up to the end an error read????
Error it
it is passed...

Well so there normal dbf, I in request an error made it.

12

Re: Prompt by mistake "Statement (s) could not be prepared."

Al0011;
Then probably an error any more the same?

13

Re: Prompt by mistake "Statement (s) could not be prepared."

Al0011 wrote:

oh and how it to make?
[img=http://forum.ixbt.com/lamer.gif]