Search results

Trying to post a link, but this forum is not allowing me to :(

Hello Rx, thanks for your continued help. We're in a situation that we can't touch a thing on the DB servers, so linked servers & things can't be done. Anyway, I've resolved the issue by using runas & was able to the other domain & got things done. Thanks again for your continued help.

Update - I tried with SQL Server local account (sa) & it worked!! So its confirmed that the issue is NOT with connect string, but, when the domain changes, how to change the UID & PWD accordingly to get authenticated using Trusted_Connection. Please guide. Thanks Edit - The driver was "SQL...

Thank you for your reply. I've Googled & Googled & googled and googled a lot & found this is one website which was greatly convincing that there're some good experts for DSN/DSN less/VBA/Excel & hence registered to find a solution. So, my point is that, this forum has superb code examples, but...

156 views & no solution?? C'mon guys, please, there has to be some solution & someone should've done this before. Pls help!

Hello All I'm developing a small app in MS Excel (using VBA ofcourse) that needs to establish connection with SQL Server & run a code that is input. It turned out quite a challenge for me that I frankly never expected. The Excel will reside on our local laptops that is in, say DOMAIN1 where we...