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