Crystal Reports v8 with SQL 2005
I'm having a really frustrating problem when my already created crystal reports (v8) establish connections to an SQL 2005 database stored on a mapped network drive. I don't believe the mapped network drive is the problem as it works fine with an Access database.
Current code is as follows:
Set oApp = New CRAXDRT.Application
Set oReport = oApp.OpenReport(sReportPath & "\" & getReportFile(ARGUMENT)) 'this just retrieves a report's filename from an already established database connection
oReport.Database.Tables(i).location = "H:\database.mdf"
'oReport.Database.Tables(i).Name = LCase(oReport.Database.Tables(i).Name)
I'm using the SQL database in this way because the software has been designed to do it that way. Previously it connected in exactly the same way but to an Access (*.mdb) file. When I try and do this... it works fine. Are there compatibility issues between crystal reports v8 and SQL2005??? Perhaps there's another way of doing it? I can't find anything about it...
I get "file integrity" errors and "file not found" errors when the "TestConnectivity" method is invoked. I know the tables exist and that the "case" of the table names match.
Hope someone can help... Any ideas?