Quote:
quote:Originally posted by liping_chen911
I would like to import data that stored in the MSDE into SQL 2000. I was not able to make an ODBC connection for MSDE. Any ideas? Thanks in advance!
|
If you are importing to sql server from msde, you can use the enterprise manager which comes with sql server. You have to add the msde server into the manager right click sql server group and select add server. (this will only work from the machine msde is installed on) , then add your sql server the same way. You should then be able to import/ export between dbs.
note: msde only seems to allow access from the local user account. it seems to ignore the sa username / pword. if your trying to use odbc from another pc, this would probably stop you.