In your enterprise manager go to the user management menu and make sure the
users have permissions to see those tables. Also, make sure all your
authentications (NT,or sql sever) match up (on your sql server, database,
and odbc datasource). I have had this happen when switching servers, or
restoring from a backup onto a new server. Somehow these parameters don't
get saved.
HTH
Matt
-----Original Message-----
From: andrew kopelman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 1:57 PM
To: CF-Talk
Subject: win 2000/sql with cf 4.5 PROBLEMS
After upgrading to Windows 2000, I get this interesting situation with SQL
Server (or ODBC): any table that i create, isn't 'seen'. I get the error:
Invalid object name 'onetable'. ('Onetable' being the single table I
created.) If I query one of this same sqlserver database system tables, like
sysusers, it runs the query without complaint. Therefore, my 'application'
is connecting with the database, the databases native tables are seen, any
new tables are not.
Any ideas? Anybody else having other troubles with SQL on Windows 2000?
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
