Statement(s) could not be prepared

Question

0.00/5 (No votes)

See more:

Hi,
i connect to myDatabase (sql server).

CDatabase m_database;
bool p=m_database.Open(_T("myDatabase "),0,0,_T("ODBC;UID=user1"),1);

myDatabase created in Sql Server 2008 :

server type: Database Enginge<br />
server name: my-pc\SQLEXPRESS<br />
authentication: Windiws Authentication <br />
user name: my-pc\user1

CRecordset m_recordset(&m_database);
m_recordset.Open (CRecordset :: snapshot, _T("select * from myTable"), CRecordset::readOnly);

error:
Invalid object Name 'myTable'. Statement(s) could not be prepared

how do i resolve this problem?

Posted 27-Mar-14 9:47am

Zon-cpp

Add a Solution

Comments

CHill60 27-Mar-14 15:59pm

Check the value of p ... is it True? If not then your .Open command is wrong.
If p is True then do you have a table on your database called "myTable"?

Zon-cpp 27-Mar-14 16:08pm

hello,
yes, p is true and myTable is created.

CHill60 27-Mar-14 16:10pm

Are those spaces in CRecordset :: snaphot really there in your code - doesn't look right to me

Zon-cpp 27-Mar-14 16:13pm

without those spaces, too, i have "Statement ..." error.

CHill60 27-Mar-14 16:16pm

Can you try m_recordset.Open (CRecordset::readOnly, _T("select * from myTable")); - don't worry ::snapshot is the default anyway

CHill60 27-Mar-14 16:19pm

Sorry - that is just wrong. Ignore my last post. :headslap:

Richard MacCutchan 28-Mar-14 5:18am

Use the SQL Management Studio to verify the spelling of your table name.

Zon-cpp 5-Apr-14 6:29am

hi, the spelling is correct but i found what is my problem :
2 services in sql server configuration was stopping (sql server explorer and sql server browser). i run them and solved my problem.
thank you

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Zon-cpp · Accepted Answer · 2014-04-05T00:31:00

Solution 1

services of sql server should be running. (sql server explorer and sql server browser. manage them in sql server configuration manager.

Posted 5-Apr-14 0:31am

Zon-cpp