WinBatch Tech Support Home

Database Search

If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.

TechHome

ODBC
plus

Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.

Keywords: 	 MDAC Invalid Object .

Question:

The program I made works fine on NT 4.0, Windows 2000, I have tested NT 4.0 with MDAC 2.1 as well as 2.5 writing to a SQL 7.0.

I am trying publish this app on an NT 4.0 Terminal Citrix server. I have put MDAC 2.5 on this server and I get an error while trying to execute a SQL Insert statement. I get 'Invalid Object' and then the name of table. I have changed the table name to something different and like I said it works fine every where else .. just not running off this server.

any ideas from the SQL gurus out there?

Reply #1

Have you tried using a fully qualified table name? Like:

databasename.dbowner.tablename

Or, are you sure you are connected to the correct DB? Maybe exec another SQL statement, before the one that errors, that connects you to the correct DB. Like: USE databasename

MORE...

Executing the 'USE' before did the trick. Strange though how it worked everywhere else .. Thanks a lot!



Article ID:   W14427
Filename:   MDAC Invalid Object .txt
File Created: 2017:07:28:13:58:32
Last Updated: 2001:01:09:15:42:24