I'm using an application called Star Projects (I didn't write) and trying to pull a simple Vendor_Name from a Pervasive/Btrieve database into a MS SQL 2000 stored procedure. The report I modified had all the fields I needed including the Vendor Code field which should join to the APVEND table in the Pervaisve database. I added the lines I needed, and was able to create/update the stored procedure. I also tested a simple query, and it found the correct information.
But when I select the location in the report to MS SQL Server, I get a General SQL server error message. If I set the location to ODBC-Report Manager (Star Projects specific), I get "Server is not yet open". I know just enough of everything to be lost. A suggstion was made to use OPENQUERY instead of four componete path (linke server.data source..table), but I'm not sure where the join comes using that syntax. Any help or suggestions would be appreciated.
Start Free Trial
