Database Search
TechHome
 |
- !!NEWSFLASH!!
- 1437 or 3437 Extender Load Error
- 3132 error when using DAO
- 521 Attribute string too long
- Access SQL Update
- An SQL Tutorial
- Automated ODBC Data Source creation
- Calling a MS SQL Server 2000 Stored Procedure
- Change database then Update then count rows
- Compact an Access Database
- COMPACT_DB and Password MDB Files
- Continue a SQL Query after a Warning Message from Driver
- Create a System DSN for a TXT File Problem
- Create an SQL DSN with User name and Password
- DSN Connection Strings
- Execute an Oracle stored procedure
- Explanation of ODBC Usage
- Get Installed Driver Information
- Get Parameters from a Stored Procedure
- How Does qBindCol Work
- How to Do a Simple Sql Query
- Invalid Cursor State Error
- MDAC Invalid Object
- Microsoft SQL Server ODBC driver Info
- More on How ODBC Works
- ODBC and Services
- ODBC and SQL
- ODBC DSN Maker
- ODBC DSN Port Configuration
- ODBC Extender with WebBatch problems
- ODBC on 64 bit System
- ODBC SQLDescribeCol Example
- ODBC WHERE Syntax Blank Data
- Pervasive SQL Syntax Error
- Problem Adding System DSN for SQL Server
- Problem Using qConfigData with the Oracle ODBC Driver
- qConnect Crashes with Exit Code -1073741571
- qExecDirect and SQL Questions
- QExecDirect Second handle issue with SQL Server Drivers
- qFetch with Empty Cell
- qFetch with qBindCol and qGetData
- qGetData 50 columns limit
- qLastCode to Check these SQL Return Codes
- Read Information from Lotus Notes
- Retrieving data after a SQL JOIN
- Return Codes in ODBC Extender
- s0022 error from SQL Server Driver
- Specify SQL Server Password in qConfigData
- SQL Server SELECT SUM Statement
- SQL SUCCESS WITH INFO
- Syntax for Insert Into Access
- Updating ODBC.INI File over the Network
- Using WildCards in an ODBC SQL Statement
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: 2001:01:09:15:42:24
Last Updated: 2001:01:09:15:42:24