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 How-To
Password Reminder
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
VB How-To Ask your "How do I do this with VB?" questions in this forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB How-To 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
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old August 6th, 2004, 04:09 AM
Registered User
Join Date: Aug 2004
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Crystal Report & VB6 & SQL Server

i have a vb6 program load few crystal reports that get data from SQL Server through ODBC...
most of them can load data successfully and printed out...
but 1 of them is using 2 tables and it is fail to load the datas...
it get error...
(Logon failed.
Details:28000:[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user "LOS")
Set Report13 = objCrystal.OpenReport(App.Path & "\Report13.rpt")
CRViewer91.ReportSource = Report13

what is the problem of this??? because only this report call 2 tables and cannot be loaded.

Reply With Quote
  #2 (permalink)  
Old February 1st, 2005, 07:05 PM
Registered User
Join Date: Feb 2005
Location: Valencia, Carabobo, Venezuela.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to witchfynder

Try designing the report based on a view. Try to put all the required fields in the view then put them into the report and coll it from vb

Reply With Quote
  #3 (permalink)  
Old June 5th, 2013, 01:58 AM
Registered User
Points: 6, Level: 1
Points: 6, Level: 1 Points: 6, Level: 1 Points: 6, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Jun 2013
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Red face Crystal Report (8.5) is not working on win7/windows 2008 64 bit system

Hi Dear,

i m also facing the same problem. If you can help me out with the following issue,I will appreciate.

Crystal Report (8.5) is not working on win7/windows 2008 64 bit system

My application is a vb application and I am using Crystal report 8.5. It is working fine on 32 bit system and 64 bit system of Windows 2003 server. When I run the same application either on win7 64 bit or on 2008 64 bit, report does not open.
I am using vb script to access the database.
Part of the code written in the VB script file is as follows:
Dim objrsRecordSet 'As RecordSet
Dim strSQL 'As String

'**** Open Database Connection using the parameters passed from the main program
Set dbConnection = CreateObject("ADODB.Connection")
dbConnection.ConnectionString = "Provider=SQLOLEDB;Server=" & mstrServer & ";uid=" & mstrUserName _
& ";pwd=" & mstrPassword & ";Database=" & mstrDatabase & ";"

dbConnection.CommandTimeout = 200

dbConnection.Properties("Enable Fastload").Value = True

Basically we have two visual basic projects developed in VB 6.0 language: let’s say
1. Diapp (we consume the report.dll in this application, in order to generating the reports)
2. Adacrystalapp (which is used for making the report.dll)

Diapp application generating the reports on windows-XP(32 bit machines) without any problems but when I run the same application on 64 bit machines(win7/Vista…etc) report is not generating.
If I run the both applications (Diapp, Adacrystalapp) in debug mode then reports are generating on 64 bit machines (win7/vista) also without any problems.

Please help me out with this issue, i will appreciate for your response.
Reply With Quote

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 Report & .NET Eagle Crystal Reports 0 June 22nd, 2005 09:15 PM
Crystal Report & Java ritesh12 Crystal Reports 0 May 25th, 2005 04:17 PM
Linux & KDE & C++ & QT & MYSQL & Kdevelop Munnnki Linux 0 January 2nd, 2005 05:41 PM
SQL Stored Procedure & VB6 acdsky VB Databases Basics 1 September 29th, 2004 10:01 AM
Setting Crystal Report Server & Database maheshkumar Crystal Reports 1 June 29th, 2004 12:12 AM

All times are GMT -4. The time now is 05:33 PM.

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