Solved

Crystal Reports Problem

Posted on 1998-11-19

Visual Basic Classic

1 solution

219 Views

Last Modified: 2010-05-03

Hello I'm using the Report Designer for Crystal Reports 6.0. The problem that I'm having is that when I go to open the report it is saying ODBC login failure. When I created the report I put in a valid Username and Password assuming it would use these durin execution, but it does not seem to be using these and I can't find where to set them.

Comment

Question by:clsmaster

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

2 Comments

LVL 1

Accepted Solution

by:kponder

kponder earned 300 total points

ID: 14457101998-11-19

Assuming you are using VB & Sql Server try the following:

crwReports.Connect = "DSN = server;UID = username;PWD =password;DSQ = databasename"

Of course, change server,username,password, and databasename to match your system

Expert Comment

by:sridharp

ID: 14457111998-11-19

If you are using SQL server or client then first log onto the sql server or client and then you will not get any problem. Do write this and mail me back please

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Textbox ActiveX Control That Limits Input to Numbers

Article by: Martin

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …

MS Access VBA - converting linked tables to local tables

Article by: Don

Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…

Using Automation to Control Outlook from Access

Video by: TechMommy

Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

Creating and Using an Access Class Module

Video by: TechMommy

Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…