VB Error on method "openconnection"

[marnieg]

I have a project that is an adp connected to sql server 2008. Most users have the adp file on their local machine which then connects to the database on the server using windows authentication. The client then wanted to put the adp file on a terminal server to allow access from outside the office. When the user tries to access it from the terminal server side they get an error. See the attached image of the error. Could the problem be with ODBC connection from the terminal server?

 

[llkhoutx]

.Post your connection string, it's probably wrong. Error message might indicate that your front end data is corrupted or exceed 2G is size.

 

[marnieg]

I know the connection string is correct because I can access the database from other PCs. The only difference is that this adp file sits on the Terminal server that users are accessing. How does Terminal Server using Windows Authentication differ from desktop?

I will check the file size on the terminal server. On the desktop version it's only 15 mb.

 

[boblarson]

Post the connection string anyway. It may need to be adjusted for where you are using it. Don't assume anything when it comes to troubleshooting.