> 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?
I've had no problems with SQL Server 6.5 or 7 on Win2K. This may sound
silly, but have you made sure that your ODBC datasource lists the database
name? If it doesn't, your datasource will often point to the "master"
database.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
