August 4, 2011 at 12:09 pm
Hi I have an application that was designed to run on a pocket pc to collect scanner data and write the data to a table on our server.
The server has multiple databases, and the application wants to write the data to the wrong database.
I have supplied the appropriate credentials for the application.
I have inherited this server and pocket PC. I thought I had removed all references to a previous server frome the PocketPC, but now I am wondering if the previous developer set up a connection in the Pocket PC that directs all connections directly to the old server.
I would appreciate any feedback
August 4, 2011 at 12:43 pm
Sounds like you have missed something in your code that is connecting to a server. There is no way anybody can offer much help based on the limited amount of information provided. If it is using a machine DSN that could be the problem. There are so many things I can guess about. I suspect there is a connection string somewhere in your code that is still the old one.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply