473,763 Members | 1,794 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

.NET vb db access for crystal report

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.
Jul 21 '05 #1
6 1449
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.
Jul 21 '05 #2
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.
Jul 21 '05 #3
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.publi c.dotnet.framew ork.adonet,micr osoft.public.do tnet.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
Jul 21 '05 #4
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.publi c.dotnet.framew ork.adonet,micr osoft.public.do tnet.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
Jul 21 '05 #5

Great. I'll follow through. Thanks very much for your help!

Helen
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 21 '05 #6

Great. I'll follow through. Thanks very much for your help!

Helen
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 21 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
2523
by: Raghuraman | last post by:
Hai I have a designed Crystal report .rpt file which has 4 access tables .. After designing the report i put a parameter field which filteres the desired records quite naturally. Every thing works fine in the crystal report design time as well as in the preview asking parameters .. But if i call it thru my VB form it works nice after removing the parameteres.
3
6915
by: Gheaci Maschl | last post by:
Hi all! I would like to have your opinion about my problem and my proposal how to solve it: Ingredients: - BTriev database - Crystal Reports - maybe MS Access - Liinos6 (small ERP software)
3
3645
by: trustme1 | last post by:
I am wanting to be able to write reports against an ms-access database that is part of another package. I only want to report from the database. What I need is a package that will allow me to create the reports and then be able to distribute a run-time version. The client may not have Office so the package must run standalone. It could get to the Access database through an ODBC driver. Does anyone know what packages available?
10
17548
by: Joriz | last post by:
Obviously im new with ms access..so my basic question is how do i run crystal reports in my ADP. I also pass parameters to cyrstal reports. Please help! thanks in advance
4
11425
by: Rich Moser | last post by:
My organization is in the midst of making a reporting tool decision. On the table are Crystal and the reporting functionality in Access. - Report distribution is not a factor - it's all local - Training time is a factor since we have to create a boatload of reports in a short time - The ability for users to modify report formats and data content is required - Cost is a factor - no one wants to spend too much money
1
3408
by: webmaster | last post by:
I have a password protected Access Database (.MDB) file. I also have a Crystal Report with database fields connected to table in this database. I want to display the Crystal Report Preview Form using CRViewer. How to supply the password of the database, so that CRViewer is able to open the table at run-time?
3
11013
by: route_coder | last post by:
I am using access database to create a crystal report in VB.NET Everything works fine when I run on my machine. But when I am deploying it other windows machines. It is asking for database server name and logon information. The problem which I understood from this is that the path is hardcoded in the crystal report and the database is in my bin folder. when I run my app on other machines it is looking for the database in that folder and...
16
6534
by: JoeW | last post by:
I'm utilizing a database that I created within MS Access within a program I've created in VB.NET. I am using the VB front end to navigate the information, but want to be able to print a report, that I've also created within MS Access. I've attempted using the Access.Application instance, but I get errors when it tries to load the database. Just wondering if anyone has any experience with this, and what I should do. Thanks for any...
0
1879
by: amiga500 | last post by:
Hello, I am developing a crystal report called Expense Report (I am not an expert Crystal Report designer) if someone could help me in this problem I would be greatly appreciate it. The report would be as follows: Description Sun Mon
0
2339
by: Mark Gold | last post by:
Hi! We have a VB application using Crystal Reports 6 that has worked successfully on hundreds of systems for over 10 years. Now, on one network, the application and access database does not close. It seems to hang on the command. When we open the application an peruse the screens without opening up a report (using crystal reports), the application and access db closes fine. But as soon as we run a report and then close the report and...
0
9383
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9992
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9819
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8821
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5268
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5405
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3916
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3519
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2790
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.