ODBC SQL Server Driver error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

ODBC SQL Server Driver error

Author

Topic

shajimanjeri
Posting Yak Master

179 Posts

Posted - 2007-03-13 : 05:05:31

Hi,
When Iam browsing my website, It showing an error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'tbl_Users'. (this is the table name)

Why this error is comming
Please help me!

Shaji

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2007-03-13 : 05:53:09

This error message means that the table 'tbl_Users' doesn't exist in the database you are connected to. Maybe you are connected to the wrong database...?

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"

shajimanjeri
Posting Yak Master

179 Posts

Posted - 2007-03-29 : 01:01:55

But I am sure there is a table with name 'tbl_Users'. I think this error may be related to some database user permissions?

Still showing the same error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'tbl_Users' (this is my table name).

Please help me!

With regards
Shai

quote:
Originally posted by Lumbago

This error message means that the table 'tbl_Users' doesn't exist in the database you are connected to. Maybe you are connected to the wrong database...?

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-29 : 01:07:06

Open QA. Type "sp_help" and execute that statement.
Do you see the table "tbl_Users"?

Peter Larsson
Helsingborg, Sweden

shajimanjeri
Posting Yak Master

179 Posts

Posted - 2007-03-29 : 01:17:10

Thanks Mr.Peter Larsson,

I tried this. then I can see the table 'tbl_Users'.
Table name : tbl_Users
Owner : dbo
Object_Type : user table

Now what to do?

With regards
Shaji

quote:
Originally posted by Peso

Open QA. Type "sp_help" and execute that statement.
Do you see the table "tbl_Users"?

Peter Larsson
Helsingborg, Sweden

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-29 : 02:00:32

What happens when you execute the statement "SELECT * FROM tbl_Users" in QA?
If you do get values, how are you logged in as with QA? Are you using the SA account?
Which account do your website use?

Peter Larsson
Helsingborg, Sweden

shajimanjeri
Posting Yak Master

179 Posts

Posted - 2007-03-29 : 02:33:16

I can select, insert etc from the QA.
I am using windows authetication method. there is no SA account.

"Which account do your website use?" what does it mean please?

see I just created one ODBC with name 'rpla', and trying to connect trough asp.
My connection query is
dim con,Rs,u,p
set con = server.createobject("ADODB.Connection")
con.open "rpla"

Shaji

quote:
Originally posted by Peso

What happens when you execute the statement "SELECT * FROM tbl_Users" in QA?
If you do get values, how are you logged in as with QA? Are you using the SA account?
Which account do your website use?

Peter Larsson
Helsingborg, Sweden

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-29 : 02:36:25

I mean, how do you CONNECTIONSTRING look like in your web application?
All users authenticate as IUSR_<MACHINENAME> if you allow that in IIS. This user must also have access to the database, UNLESS you specify another account to use in the connectionstring in the web application.

Peter Larsson
Helsingborg, Sweden

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2007-03-29 : 03:00:11

Are you sure that the database you are connecting to in your connection-string is the same as the one you are connecting to when using query analyzer?

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"

shajimanjeri
Posting Yak Master

179 Posts

Posted - 2007-03-29 : 03:29:33

Thanks Peter Larsson,

yes, I checked the authetication, Username is 'IUSR_TT-02CF38240C77'.
Now how to check whether thsis user have the permission to access the database?

I just tested this table 'tbl_Users' in another database with another DSN name (another ODBC connection)and browsed, its working fine.

Please help me!

Shaji.

quote:
Originally posted by Peso

I mean, how do you CONNECTIONSTRING look like in your web application?
All users authenticate as IUSR_<MACHINENAME> if you allow that in IIS. This user must also have access to the database, UNLESS you specify another account to use in the connectionstring in the web application.

Peter Larsson
Helsingborg, Sweden

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2007-03-29 : 03:39:11

If the user didn't have access to the database you would get a different error message: "SQL Server does not exist or access is denied"

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-29 : 04:07:26

I can't help you until you post the connectionstring.
Until then all I can help you with are guesses.

1) Add the account IUSR_TT-02CF38240C77 as data_reader to the database.

or

2) Create a new user named WebUser or similar, and use that account in your connectionstring.

Peter Larsson
Helsingborg, Sweden

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources