.NET vb db access for crystal report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I'm using
VB .NET (Visual Studio 2002
Crystal Reports 9 (soon to upgrade to 10, just want 9 to work first
Win 200

When I run the crystal report independently, I can access the Oracle 7.3.4 database, no problem. db name PDTT, uid and pwd

But, when I run it via the vb .net app, it is only reading the memory of the data in the report, and therefore when I try to run a parameter, it fails. It calls me to insert server name, it defaults to the db name and uid and calls for a pwd. Why is this happening? What am I doing wrong

I call the report from form1 which initializes the RD component , and the CR Viewer on form2 calls the PDTTtest.rpt
When I click refresh in debug mode, I'm asked for the server name, etc

I can visually see the db tables listed in VStudio .net. Is this a networking issue? The server resides elsewhere, maybe a domain/router/security prob? Yet, if so, why can I connect using the report alone

I'd really appreciate your help. I've put this request out in a few places, am not getting feedback, need to move forward asap!!

(a) I need to be able to run the report in the app, and
(b) I want to set it up so the user isn't prompted to log in each time.
 
After trying everything for days on end, thought ok let's revisit the odbc oracle7 system dsn setup, checked the "Enable Asynchronous Support", and am now reading the report data through vb .net!!! Who would have guessed? So now, just one outstanding question

is it possible to set up the app so the user is not prompted for login info each time

Thanks in advance.
 
Hi Helen,

This is or a Crystal Report question or an Oracle question.

The two newsgroups where you have probably the most success are

microsoft.public.dotnet.framework.adonet,microsoft.public.dotnet.languages.v
b

I put that express in one line so you can crosspost it.

Because you need probably a more specialist from each of those groups,
however both that I know will avoid either one of the questions (also I know
one who is probably answer it in the language vb group)..

I hope you get your results

Cor
 
Back
Top