Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB Databases Basics
Password Reminder
Register
| FAQ | Members List | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 09:27 AM.


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