Right- but when you build the ODBC DSN - the screen after you enter the username/password asks for a Default Database - this needs to point to the correct database.
Robert -----Original Message----- From: Mikal Anderson [mailto:[email protected]] Sent: Tuesday, February 22, 2011 2:43 PM To: [email protected] Subject: Re: Witango-Talk: Invalid object name The ODBC data source name is the same but the server name is different. On 2/22/2011 11:36, Robert Shubert wrote: > In the ODBC setup, are you changing the database? > > Robert > > -----Original Message----- > From: Mikal Anderson [mailto:[email protected]] > Sent: Tuesday, February 22, 2011 2:02 PM > To: [email protected] > Subject: Witango-Talk: Invalid object name > > Hello List -- > > We're moving our Witango installation from one server to another and for > some reason the new installation is now demanding that the table owner > (tableOwner.tableName) be prepended to each dB action. Here's the error: > > An error occurred while processing your request: > File: fctChecks.taf > Position: get_dLocDef > Class: DBMS > Main Error Number: 208 > > [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name > > 'LocDef'. > 42S02 > > I solved this once several years ago--it's probably ridiculously > simple--but cannot remember the solution. The ODBC setup is the same. > The dB permissions check. What am I missing? > > > > > > ---------------------------------------- > > To unsubscribe from this list, please send an email to [email protected] > with "unsubscribe witango-talk" in the body. > > > > ---------------------------------------- > > To unsubscribe from this list, please send an email to [email protected] > with "unsubscribe witango-talk" in the body. > > > -- Mikal Anderson www.LakeOMedia.com "What has your website done for you lately?" This message, including any attachments, is confidential and intended solely for the person(s) or organization to whom it is addressed. If an NDA has been signed by the parties, this communication is governed by the stipulations contained within that NDA. If you are not the intended recipient, or have received this message by mistake, please notify Mikal Anderson, the original sender, and delete this message from your system. Any unauthorised use, forwarding, or other dissemination of this message, in whole or in part, is strictly prohibited. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
