Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
VB Databases Basics Beginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Databases Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old November 14th, 2006, 09:04 AM
Authorized User
 
Join Date: Oct 2004
Location: Nottingham, , United Kingdom.
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to VBM2
Default Crystal Reports v8 with SQL 2005

Hi all.

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)
    oReport.Database.Tables(i).TestConnectivity

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?

Cheers,

VBM2

Kind regards,

Craig
__________________
Kind regards,

Craig


Similar Threads
Thread Thread Starter Forum Replies Last Post
Crystal Reports & VS 2005 inkrajesh ASP.NET 2.0 Professional 0 March 5th, 2007 07:27 AM
Dynamic Links in Crystal Reports (VS.Net 2005) harini311 Crystal Reports 0 September 9th, 2006 10:44 PM
Sql 2005 Reports abdul_owiusa Reporting Services 0 June 25th, 2006 12:03 PM
Crystal reports (v8.5) returning blank fields rainman_matthew Crystal Reports 0 December 6th, 2005 11:55 AM
SQL in Crystal Reports Roopedog Crystal Reports 1 August 9th, 2005 07:18 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.