Re: Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name when i copy the db

agesone@xxxxxxxxx wrote:
<snip>
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'ACTIVE'.


Both of these databases have this column in the same exact table, why
isn't this working though..By the way, any columns that weren't added
to the copied database, and that were there from the copy, the asp
pages work fine on, just the new columns i've added to both db's, its
not working. I already checked the individual column security, and the
user settings are the same as the originals dbase columns security
settings, Please help?

Is it possible that the new database is case-sensitive and the original one is not?

Dump out the table definitions from each and compare them.


.

Relevant Pages

  • Multiple databases
    ... I have 10 databases that have the exact same layout (employee time). ...
    (microsoft.public.access.modulesdaovba)
  • 50 concurrent web users on asp.net 2.0 accessing Oracle database
    ... the worse case scenerio has 50 external users ... are on the otherside of the DMZ) at the exact same second. ... The backend databases are oracle 9i and 10g. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Problem in Replication
    ... >same versions but i am getting error like Version mismatch .. ... - the exact platform ... you would need to check the compatible parameter of ... both databases and/or sys.props$. ...
    (comp.databases.oracle.server)
  • Initially merging two databases
    ... setup the initial snapshot between two databases, that are the exact same ...
    (microsoft.public.sqlserver.replication)