|
Site Sponsored By: SQLDSC - SQL Server Desired State Configuration
|
|
|
Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.
|
- Advertisement - |
Maintaining Data Connections
Posted - 2004-05-17 : 12:12:13
I am a IS Coordinator for the state and have found myself now a DB admin..
..when a year ago I couldnt even SPELL "D-B". Anyway I am running a database in SQL 2000 that is accessed by the folks I support via a web piece. Some fo the operations access the database and open an instance of word for a mwege from the database. All of this was working quite smoothly until I upgraded all my users to Office 2003.
Now, when one of these apps needing to open a word merge doc is used, the user has to rediscover the datasource. The database is password protected, so, when asked, I tell SQL to allow saving passwords and make the data connection. But after the word doc is completed and closed the data connection is lost and this will have to be done again....and again...and again...I have looked over MS technology database but cant find anything there, and was hoping some of you SQL guru's could hook me up.Once again, forgive my ignorance and/or lack of correct terminology. Feel free to email me with any suggestions and any input would be greatly appreciated!
Thanks!Herculeric
could take a crack at this one?...Throw an SQL virgin a bone will ya?
