i'm trying create windows service connects development database (ms access 2003 *.mdb), i'm running connection errors. access db contains linked tables sql server db , have credentials create new linked tables (idk if enough connect sql server db). i've made several other winform applications connect via oledb connection , continue work.
now, i've tried oledb connection in windows service no avail , i've tried multiple drivers odbc connection. i've tried changing serviceinstaller account type between user , localsystem , target cpu poops , giggles (been burned before on one). ultimately, think scope of windows service screws odbc connections, think require direct connection sql server db.
is there method may have missed allow me continue using ms access database , subsequently oledb connection have in existing applications?
Comments
Post a Comment