Google Answers Logo
View Question
 
Q: Vb.net Crystal Reports ( No Answer,   3 Comments )
Question  
Subject: Vb.net Crystal Reports
Category: Computers > Programming
Asked by: briansigma-ga
List Price: $15.00
Posted: 30 May 2004 19:55 PDT
Expires: 29 Jun 2004 19:55 PDT
Question ID: 354090
I've created a VB.net form with the Crytsal Report Viewer. My report
(and all data) connects using a system DSN using Oracle 8.1.77 ODBC
driver for Oracle 8i db. My reports run fine, but I want to shield the
user from having to enter the password when it opens the ODBC
connection. I'm having trouble getting the username/password to embed
so they can just click on the vb.next exe and run the viewer in my
form. I need a good sample that uses the same ODBC driver and passed
all the authentication information. I'm new at CR for VB.net - Thanks
Answer  
There is no answer at this time.

Comments  
Subject: Re: Vb.net Crystal Reports
From: justincave-ga on 03 Jun 2004 02:25 PDT
 
The easiest way to do this is probably to embed the password in the
DSN.  You can't do this through the DSN configuration screen (Oracle
discourages storing passwords in DSN's because they are stored in
plain text), but you can modify the registry to add the password. 
Under the key HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<<your DSN
name>>, you can modify the "Password" string value to be the password
(you can create this value if it doesn't already exist).
Subject: Re: Vb.net Crystal Reports
From: briansigma-ga on 03 Jun 2004 06:46 PDT
 
That is not practical in this situation (150 desktops), I need to send
the VB.net exe with the emmbedded credentials for the ODBC driver that
is a System DSN allready used to support an app that connects to
Oracle 8i. Using Crystal reports for Visual Studio.net, I can drag the
CrytsalViewer control onto my simple form, but have not been able to
locate the properties to set the credentials. The report by itself
using Crystal ver 8.5 or 10, connects to the Oracle DB via the same
system DSN, and requires the password to pass via ODBC to Oracle. I
was hoping somebody out there has done this using VB.net and Crystal
for .net
Subject: Re: Vb.net Crystal Reports
From: packiya-ga on 15 Jun 2004 04:06 PDT
 
Hi
As told above...By JustinCave..

Use this key HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<DSN
name>And then you can modify the "Password" string value to be the password. 

For doing that.. Instead of manually doing it in the VB.Net Exe which
you are installing in 150 desktops.. U can access the registry in the
startup screen and write the above Key Value Pair to the Registry.

If you need more info on How to write to registry pls get back..

Regards
Packiyanath

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy