ASP Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsProgrammingASP Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old April 11th, 2003, 08:48 AM
kaverao kaverao is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2003
Location: Mangalore
Posts: 11 kaverao User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Angry Crystal report : 'Failed to open a rowset' problem

Hi All,
I am using the crystal reports in my vb.net Client-server desktop application with the OLEDB(ADO) type of connectivity to SQLServer 2000(Establishing Database connection in report-design time providing ServerName,DatabaseName,login,password).
But, throughout my application, I am using a DSN to establish the connection with database server.
The problem is, when I deploy the software in the client's place with a different Server name, it shows the Login form when I call a crystal report. Eventhough, i provide the correct Servername, database name, login and password, it fails to display the report with the following message pop-up "Failed to open a row set".

Can anybody please suggest me a way to fully AVOID THE LOGIN PROMPT SCREEN at all times.

Reply With Quote
  #2  
Old April 15th, 2003, 02:26 AM
cfortuna cfortuna is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2003
Location: Saudi Arabia
Posts: 8 cfortuna User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
report : 'Failed to open a rowset' problem

Sir,

You have to review / check all the fields in your crystalreport file, see to it that all FIELDS you use should be the same as the one in your database. After that click the "verify database" to update you C.R. File. Message will appear "database updated".
Everytime you update the tables that you use in your crystal report you should always "click" update database in your CR file otherwise all the updates in your table will not be reflected in your C.R.
I always encouter that problem when I'm in hurry. Try it and everything will be ok.

;-) Clifford:

Reply With Quote
  #3  
Old April 15th, 2003, 02:55 AM
kaverao kaverao is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2003
Location: Mangalore
Posts: 11 kaverao User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Override SECURITY ASPECTS in Crystal reports

Hi Cfortuna,
Thank you for the reply. I hope i have not chnaged any fields of database tables after design of CRs. But, anyway, I will try it out.
I will follow your method and report the progress to you.

My intention is to SUPPRESS ALL SECURITY ASPECTS at the report level (after design). It should be displayed without asking for login/passwords, irrespective of the deployed environment .
Can you please sugeest me if you know any any method.

Thanks again,
-Venk

Reply With Quote
  #4  
Old April 15th, 2003, 03:05 AM
cfortuna cfortuna is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2003
Location: Saudi Arabia
Posts: 8 cfortuna User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Sir,

Does it mean that everytime you run the report in vb it ask for userid and password? Is this your question of security aspects? We'll when i'm using DSN connection yes i do have the same scenario. But now i'm using OLEDB SQL Server connection in which all the userid and password is already embedded to the program.
Did I understand your question correctly?

:-) Clifford

Reply With Quote
  #5  
Old April 15th, 2003, 03:17 AM
kaverao kaverao is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2003
Location: Mangalore
Posts: 11 kaverao User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Yes Sir, Exactly!.
U have got my problem correctly.
Using OLEDB(ADO) connection, we can embed the LogOnInfo during CR design. But, When I install the s/w in client's place, and preview a CR, it shows the login screen again just because the SERVER NAME is changed inspite of Database, Login & password are same. It's not permitted to change the servername of the client's LAN. This exactly is my problem.
I'll greatful if u suggest a solution.
ThanX
-venk

Reply With Quote
  #6  
Old April 15th, 2003, 09:30 AM
crazytrain81 crazytrain81 is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2002
Posts: 232 crazytrain81 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 16
If you're connecting to SQL you should use the SqlClient object rather than OleDbSql. You can still embed the logon information.

Have you tried hard coding your connection string? Hard code it and see if it avoids the login prompt.

Reply With Quote
  #7  
Old April 15th, 2003, 10:42 AM
kaverao kaverao is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2003
Location: Mangalore
Posts: 11 kaverao User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
yeah!. I'm connecting to SQL2000. Where exactly can i get this 'SqlClient' object ?.
I can't hardcode it all the times bcoz, the SERVER NAME changes as i install at client's LAN. I guess, the alternative would be -storing the servername/logoninfo somewhere in the client's database itself. And binding it just before calling the report.
what's u'r openion ?.
ThanX a lot for the reply.
-Venk

Reply With Quote
  #8  
Old April 16th, 2003, 12:35 AM
cfortuna cfortuna is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2003
Location: Saudi Arabia
Posts: 8 cfortuna User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Crystal report : 'Failed to open a rowset' problem

Sir,

sqlclient should be a available in vb .net upon declaring the namspace above it.
"imports system.data.sqlclient "
I've got you a sample.

Regarding your LAN servername you have 2 options, it's either you save it on the registry of each client's pc or put in on your web.config - "APPLICATION SETTINGS" you can define it there. Upon loading of your report you read it ....

Private Sub logon()
Dim Loginfo As New TableLogOnInfo()
Loginfo = nfm1.Database.Tables("testtable").LogOnInfo
Dim stConnection As New ConnectionInfo()
stConnection = Loginfo.ConnectionInfo
stConnection.DatabaseName = "test"
stConnection.ServerName = "test123"
stConnection.UserID = "testme"
stConnection.Password = "testme"
nfm1.Database.Tables("testtable").ApplyLogOnInfo(Loginfo)
end Sub

On your web.config file.
<appSettings>
<!-- User application and configured property settings go here.-->
<!-- Example: <add key="settingName" value="settingValue"/> -->
</appSettings>

check the other sites on how to use the web.config.

Hope this will help..
Best Regards
:-) CFortuna

Reply With Quote
  #9  
Old April 16th, 2003, 12:54 AM
kaverao kaverao is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2003
Location: Mangalore
Posts: 11 kaverao User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
ThanX

Hi,
ThanQ very much for all help & sample codes.
i'll try it out soon.
regards,
-Venk

Reply With Quote
  #10  
Old April 18th, 2003, 02:12 AM
kaverao kaverao is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2003
Location: Mangalore
Posts: 11 kaverao User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
using DSN

Hi,
i've solved it using a DSN for connectivity. If i set the 'trusted connection' property in CR, it allows any NT user (with SQL user permission) without asking login/password.
ThanX for all help....
-venk

Reply With Quote
  #11  
Old April 19th, 2003, 12:34 AM
cfortuna cfortuna is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2003
Location: Saudi Arabia
Posts: 8 cfortuna User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
you're right.... Enjoy!


Reply With Quote
  #12  
Old April 19th, 2003, 01:09 AM
kaverao kaverao is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2003
Location: Mangalore
Posts: 11 kaverao User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Smile thanX

ThanX Clifford.
Let's meet next time... may i mail u?
bye
venk

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsProgrammingASP Development > Crystal report : 'Failed to open a rowset' problem


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.

© 2003-2018 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap