Posted by othellomy on 03/14/07 12:10

On Mar 14, 4:56 pm, othell...@yahoo.com wrote:
> On Mar 13, 11:14 pm, "The Man" <LeJon7...@gmail.com> wrote:
>
> > Someone at my job who was a IT Professional before me wrote a SQL
> > statement. That statement or file is working with a program that we
> > use called Papervision and the purpose of that SQL is to assign data
> > to a table. I need help on how to locate this SQL file. I know it is
> > running because it is working with the program papervision but it is
> > not working correctly. Is there any easy way to locate SQL files off
> > the server we are using?
>
> What is papervision? Are you familiar with this product? Maybe the sql
> is located somewhere within this app.

I got some idea from your other post regarding asking for 'SQL Help'.
It seems that your app scans invoices and puts them into sql server
and when you tried to import new data (to match and merge) it failed
with an ODBC error. Your best bet is the product support help. Also,
the server might have some tables that store your invoices (scanned)
with all the information. You might want to find out from QA under
database-tables and view the data itself and might want to get to the
data itself using Enterprise Manager!

[Back to original message]