|
|
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 |
|
There is no answer at this time. |
|
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 |
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 Home - Answers FAQ - Terms of Service - Privacy Policy |