Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name when i copy the db
- From: agesone@xxxxxxxxx
- Date: 16 Jul 2006 12:47:28 -0700
Hi, I had 1 database in sql, i have made a new database and then used
the import/export tool. I have the 2nd db made now with tables copied
from the 1st database.
So when i make the conn to the 2nd dbase through adobc and asp, after i
have added the column 'ACTIVE' to the new database (2nd) and the
original database (1st)
from the 1st database after the copy, and when i try to connect from
the asp page, it says:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
and this happens when i try to connect to the new database with any new
column name i've made in the tables. The user permissions are the exact
same for both of the dbases now, and i'm curious on if there was
something i missed. If i make new columns in the 1st dbase, asp
connects fine, but it just doesnt see it in the new db's tables.. could
it be something with a different path where the db was created? the
original db i had copied from, was saved in the c drive, and the new
copied db w/ columns, is in the d drive. I'm just stuck.. i don't know
what i need to do. heres the code, please help:
DSNCONN_1="DSN=OLDDBASE;USERID=DBASEUSER;PASSWORD=123;"
'connection to original dbase (in c drive)
DSNCONN_2="DSN=NEWDBASE;USERID=DBASEUSER;PASSWORD=123;"
'connection to the originals copied dbase (in d drive)
SET RS = SERVER.CREATEOBJECT("ADODB.RECORDSET")
RS.OPEN "SELECT * FROM TOPICS WHERE ACTIVE='1', DSNCONN_1
/\ /\ /\ I have tested and this code above does work fine and shows the
correct results because it's connecting to the original database, i
have made this column in the original database, the same time as i did
in the new database which i copied over, when i change the dsn
connection to the new database ('DSNCONN_2'), which should read this db
the same exact way since it was copied and they both now include the
'ACTIVE' table, it shows this error:
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?
.
- Follow-Ups:
- Prev by Date: Re: Encrypting Data in SQL 2000
- Next by Date: Re: Application sending email
- Previous by thread: SQL 2005 and SSL
- Next by thread: Re: Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name when i copy the db
- Index(es):
Relevant Pages
|
