I have made one website in which there are some crystal reports (SAP), the website is made in visual studio 2010 (4.0 frame work) and using SAP crystal reports. I have made the reports and it works fine when i view them from IDE (visual studio), but i want
to make it live, so i tested the reports on IIS (on my machine), everything was working fine but in crystal reports i got this error::
Failed to open the connection. Details: [Database Vendor Code: 18456 ] Failed to open the connection. Details: [Database Vendor Code: 4060 ] Failed to open the connection. rptPOEntry {727AA589-A2A9-439D-BD8E-F100EDE04AC4}.rpt Details: [Database Vendor Code: 18456 ]
I googled many solutions but none was successful, i tried the following solutions
Do the following steps:
1. Open the report in the CR XI designer.
2. Select Database -> Set Datasource Location.
3. Set Datasource Location window will appear and in the replace with section connect to the database and replace these tables with the tables in the current datasource by clicking the update button.
4. After updating close the Set Datasource Location window.
5. Go to 'Database menu' and Click 'Verify Database' and click on ’OK’.
6. Preview the report and the save the report.
But this was not helpful for me... I want to deploy it anyhow on the server. please let me know what all things i need to configure on the server and please also let me know how to resolve the error which occurred on my machine.. (IIS)
when you say you want to make it "live", would you please advise in details whether you make it live on your own server or on a remote shared host? If you have your own server, do you have full control over the server? If you do, would you please try to login
to your server and try to access the database via the SSMS tool? If you can, you just have to use exactly the same details on your website web.config. Please remember that your site may work fine on your local PC, but it can fail on the server if the details
of the database is incorrect.
If you are on a shared host, you need to contact your host provider to obtain the correct connection string details.
In conclusion, the problem is NOT with your crystal report, but on your connection string details. If you can figure this out, your report will work. If you need any assistance with Crystal Report 2010 hosting, you can contact
asphostcentral.com
Please mark this response as an "answer" if it helps you. Thanks heaps and good luck!
what i meant is we have our server (own) and want to make it live on that server.. but before trying to upload the same on the server i tried to deploy the same website on my local machine on (IIS) but the result was same (ERROR).
where KRUNAL-PC\SQLEXPRESS is my local machines SQL server and following its userid and password and the name of the database "PurchaseOrder"
now this connection string should atleast work on my local machine on (IIS) but it didn't moreover other transaction pages are working fine but only there is problem with crystal reports please suggest for the same . I am really stucked up..
would you be able to connect to your database server via SSMS tool? If you cant, you have a serious problem here and you may need to uninstall your SQL Server database located on the server.
The most basic thing to do here is to make sure you can login to your database server. Once this is achieved, you can work out the connection to your own database on the database server.
If you need an assistance, you can contact
asphostcentral.com for SQL, ASP.NET and Crystal Report hosting. Thanks heaps!
The website is made by me and the coding, designing and DB part is done by myself only. I can have very much access to all parts of Database, coding everything .
And the website is hosted on my local machine where SQL server DB, Coding everything is present.. But still i m getting the error.
Please suggest i would be really thankfull to you ..
krunalpancha...
Member
10 Points
26 Posts
SAP crystal report problem in vs 2010
Oct 27, 2011 08:00 AM|LINK
Hello everyone,
<div class="pre-action-link" id="premain0" width="100%"></div>I have made one website in which there are some crystal reports (SAP), the website is made in visual studio 2010 (4.0 frame work) and using SAP crystal reports. I have made the reports and it works fine when i view them from IDE (visual studio), but i want to make it live, so i tested the reports on IIS (on my machine), everything was working fine but in crystal reports i got this error::
Failed to open the connection. Details: [Database Vendor Code: 18456 ] Failed to open the connection. Details: [Database Vendor Code: 4060 ] Failed to open the connection. rptPOEntry {727AA589-A2A9-439D-BD8E-F100EDE04AC4}.rpt Details: [Database Vendor Code: 18456 ]I googled many solutions but none was successful, i tried the following solutions
Do the following steps:
1. Open the report in the CR XI designer.
2. Select Database -> Set Datasource Location.
3. Set Datasource Location window will appear and in the replace with section connect to the database and replace these tables with the tables in the current datasource by clicking the update button.
4. After updating close the Set Datasource Location window.
5. Go to 'Database menu' and Click 'Verify Database' and click on ’OK’.
6. Preview the report and the save the report.
But this was not helpful for me... I want to deploy it anyhow on the server. please let me know what all things i need to configure on the server and please also let me know how to resolve the error which occurred on my machine.. (IIS)
Please help me out ...
Thanks in advance,
Regards,
Krunal Panchal
Crystal sap asp.net reports
necro_mancer
Star
8073 Points
1587 Posts
Re: SAP crystal report problem in vs 2010
Oct 27, 2011 11:28 AM|LINK
hi krunal,
when you say you want to make it "live", would you please advise in details whether you make it live on your own server or on a remote shared host? If you have your own server, do you have full control over the server? If you do, would you please try to login to your server and try to access the database via the SSMS tool? If you can, you just have to use exactly the same details on your website web.config. Please remember that your site may work fine on your local PC, but it can fail on the server if the details of the database is incorrect.
If you are on a shared host, you need to contact your host provider to obtain the correct connection string details.
In conclusion, the problem is NOT with your crystal report, but on your connection string details. If you can figure this out, your report will work. If you need any assistance with Crystal Report 2010 hosting, you can contact asphostcentral.com
Please mark this response as an "answer" if it helps you. Thanks heaps and good luck!
:)
Professional SQL 2008 R2 Service
krunalpancha...
Member
10 Points
26 Posts
Re: SAP crystal report problem in vs 2010
Oct 29, 2011 05:02 AM|LINK
Hi,
what i meant is we have our server (own) and want to make it live on that server.. but before trying to upload the same on the server i tried to deploy the same website on my local machine on (IIS) but the result was same (ERROR).
what i added in my connection string is :
<appSettings>
<add key="CnnStr" value="server=KRUNAL-PC\SQLEXPRESS; uid=sa; pwd=sasasasa; database=PurchaseOrder; Connection Timeout=999999900;"/>
</appsettings>
where KRUNAL-PC\SQLEXPRESS is my local machines SQL server and following its userid and password and the name of the database "PurchaseOrder"
now this connection string should atleast work on my local machine on (IIS) but it didn't moreover other transaction pages are working fine but only there is problem with crystal reports please suggest for the same . I am really stucked up..
Thanks in advance,
Regards,
Krunal Panchal
necro_mancer
Star
8073 Points
1587 Posts
Re: SAP crystal report problem in vs 2010
Oct 31, 2011 04:18 AM|LINK
ok,
would you be able to connect to your database server via SSMS tool? If you cant, you have a serious problem here and you may need to uninstall your SQL Server database located on the server.
The most basic thing to do here is to make sure you can login to your database server. Once this is achieved, you can work out the connection to your own database on the database server.
If you need an assistance, you can contact asphostcentral.com for SQL, ASP.NET and Crystal Report hosting. Thanks heaps!
Professional SQL 2008 R2 Service
krunalpancha...
Member
10 Points
26 Posts
Re: SAP crystal report problem in vs 2010
Oct 31, 2011 06:17 AM|LINK
Hi,
The website is made by me and the coding, designing and DB part is done by myself only. I can have very much access to all parts of Database, coding everything .
And the website is hosted on my local machine where SQL server DB, Coding everything is present.. But still i m getting the error.
Please suggest i would be really thankfull to you ..
Thanks in advance,
Regards,
Krunal panchal
Crystal asp.net reports