HELP HELP HELP

[ralphtg]

i have a crystal report that will not run after switching servers. here is the sql trace log. if anyone can help please do. i don't know very much about the whole procces.
ralph


this is the trace log...

Credit Reason R 3ac-398 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 024D1828
UWORD 6 <SQL_DRIVER_NAME>
PTR 0x024D1AE8 [ 14] "PVXODBC"
SWORD 510
SWORD * 0x0012D610 (14)

Credit Reason R 3ac-398 ENTER SQLAllocHandle
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 024D1828
SQLHANDLE * 01DDA7AC

Credit Reason R 3ac-398 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 024D1828
SQLHANDLE * 0x01DDA7AC ( 0x024d23e8)

Credit Reason R 3ac-398 ENTER SQLExecDirect
HSTMT 024D23E8
UCHAR * 0x01DBEBA0 [ -3] "SELECT CodeList."code", CodeList."desc" FROM "\\wilson\public\Defect\defect.CodeList" CodeList WHERE CodeList."code" = '13'\ 0"
SDWORD -3

Credit Reason R 3ac-398 EXIT SQLExecDirect with return code -1 (SQL_ERROR)
HSTMT 024D23E8
UCHAR * 0x01DBEBA0 [ -3] "SELECT CodeList."code", CodeList."desc" FROM "\\wilson\public\Defect\defect.CodeList" CodeList WHERE CodeList."code" = '13'\ 0"
SDWORD -3

DIAG [S000] Canada][PVX ODBC Driver][FILEIO]Table is not accesible (12)

Credit Reason R 3ac-398 ENTER SQLErrorW
HENV 024D16A0
HDBC 024D1828
HSTMT 024D23E8
WCHAR * 0x0012D840 (NYI)
SDWORD * 0x0012D97C
WCHAR * 0x0012D440
SWORD 242
SWORD * 0x0012D978

Credit Reason R 3ac-398 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 024D16A0
HDBC 024D1828
HSTMT 024D23E8
WCHAR * 0x0012D840 (NYI)
SDWORD * 0x0012D97C (12)
WCHAR * 0x0012D440 [ 54] "Canada][PVX ODBC Driver][FI"
SWORD 242
SWORD * 0x0012D978 (54)

Credit Reason R 3ac-398 ENTER SQLFreeHandle
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 024D23E8

Credit Reason R 3ac-398 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 024D23E8




this is the sql query and formula....


query
------

SELECT
ARO_InvHistoryDetail."InvoiceNumber", ARO_InvHistoryDetail."SOCommentCode", ARO_InvHistoryDetail."SOCommentCodeDescLine1", ARO_InvHistoryDetail."SOCommentCodeDescLine2",
ARN_InvHistoryHeader."InvoiceType", ARN_InvHistoryHeader."InvoiceDate", ARN_InvHistoryHeader."CustomerNumber"
FROM
"ARO_InvHistoryDetail" ARO_InvHistoryDetail,
"ARN_InvHistoryHeader" ARN_InvHistoryHeader
WHERE
ARO_InvHistoryDetail."InvoiceNumber" = ARN_InvHistoryHeader."InvoiceNumber" AND
ARO_InvHistoryDetail."HeaderSeqNumber" = ARN_InvHistoryHeader."HeaderSeqNumber" AND
ARN_InvHistoryHeader."InvoiceType" = 'C' AND
ARO_InvHistoryDetail."SOCommentCode" = '/C' AND
ARN_InvHistoryHeader."CustomerNumber" <> '0095440' AND
ARN_InvHistoryHeader."InvoiceDate" >= ? AND
ARN_InvHistoryHeader."InvoiceDate" <= ?
------------------------------------------------------------------


formula
-------

{ARN_InvHistoryHeader.InvoiceType} = "C" and
{@problem} in ["40", "39", "38", "37", "36", "35", "34", "33", "24", "23", "22", "21", "20", "19", "18", "17", "16", "15", "14", "13", "08", "07", "06", "05"] and
{ARN_InvHistoryHeader.CustomerNumber} <> "0095440" and
{ARN_InvHistoryHeader.InvoiceDate} in Date (2003, 11, 02) to Date (2003, 11, 29) and
{ARO_InvHistoryDetail.SOCommentCode} = "/C"

 

[synapsevampire]

The problem is probably connectivity related.

Can you elaborate on what switching servers means?

Did you switch the Database server? How are these reports executed, from a software application? Is that the server? Which version of Crystal?

You may just have to repoint the report to the proper data source. You can try just changing the ODBC on the machine that's running the report first, if that fails, open the report in Crystal and use Database->Set Location to point at the proper data source.

You'll probably have to do some discovery about the environment if the above doesn't resolve.

I'm guessing that you're a dba who got saddled with this since you used the SQL Server trace facility. As a professional you should appreciate the need to pass along environment information when requesting assistance.

-k

 

[ralphtg]

ok some background it is crystal reports 7.0. the report is pulling info out of a MAS90 database ver 3.41. but it also tries to call on a access table.
i did not write this and have little knowledge of it. we had it running on a server that crashed. i installed a new server and copied the info from the other server.

the thing i forgot to tell you is the error displayed when the report won't run is
"odbc error: canada] [pvx odbc driver][fileIO] table is not accesible"
i hit ok and this is second message
"error detected by database dll"

if you need any more info let me know.
ralph

 

[synapsevampire]

It sounds like the ODBC on the machine from which your running it is wrong, try changing it.

-k

 

[ralphtg]

i tried changing it once but i just copied the odbc data sources from the last machine. do i just delete what i have and use the drivers i have or should i get a new set of drivers. not really sure about all of it, do i need any specific drivers the last machine was winnt 4.0 server the new one is a win2000 pro. does any of that matter. thanks for your help.
ralph