troubleshooting Question

ODBC connection problem on Terminal Server, windows server 2003 sp2

Avatar of mikewilson55
mikewilson55 asked on
Microsoft SQL Server 2005Microsoft Server OSInstallation
7 Comments1 Solution768 ViewsLast Modified:
I have a application.  I make odbc connection to database through code.  I am connecting to sqexpress database.  It works perfectly on all desktops and even a server running windows server 2003.  They're IT guy wants it loaded on his termnal server to allow remote users access to new program.  Creating the odbc connection through wizard works perfectly and "test connection" is successful.  However, when i start program, the code that works perfectly everywhere else fails.  The error is "provider cannot be found".  MDAC appears to be loaded and ran componentchecker 2.0 utility from microsoft which found it (2.8 sp2) and didn't indicate any problem.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros