I am using MSDE right now for a new database, that eventually will need to use the full blown sql server. One limit of the MSDE is it doesn't support linked servers... I am having trouble using OPENROWSET and OPENDATASOURCE, does anyone know if it is because I am using MSDE and not SQL Server?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MSDE and OPENROWSET
- Thread starter Niv3k
- Start date
tlbroadbent
MIS
Linked Servers are possible in MSDE. What problems do you encounter with OpenRowset and OpenDataSource? Can you post teh SQL code and error messages, if any. Terry L. Broadbent - DBA
SQL Server Page:
If you want to get the best answer for your question read faq183-874.
SQL Server Page:
If you want to get the best answer for your question read faq183-874.
- Thread starter
- #3
Well, that's very odd. I re-ran the same SQL code as yesterday to see exactly what the error said, and it works! I was trying to connect to an Access database, and it was giving me a Jet error, something about an unfriendly provider, but it seems to want to work now. Yay!
Thanks anyway, Terry.
Kevin
Thanks anyway, Terry.
Kevin
- Status
Similar threads
- Locked
- Question
- Locked
- Question