I am on the verge of pulling my hair off on this one. I've got web reports built on Crystal XI and they work absolutely fine on my Windows XP machine. I now transfer the web application to my Windows 2003 Enterprise Production Server and the web application
is still running fine except all my reports keep giving the following error:
Failed to open the connection. Details: [Database Vendor Code: 17 ]
Failed to open the connection. C:\WINDOWS\TEMP\{ADB8090C-40ED-499D-88E3-915E23B0C5C3}.rpt Details: [Database Vendor Code: 17 ]
I have the latest service packs for crystal & windows. The Business Objects website doesn't talk about this error.
I resolved the issue finally. Something which is pretty wierd.
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.
Now, I did this plenty of times already before I posted this question here. The only thing I did not do is send the report back to my programmers and ask them to re-compile the application and send the DLL again.
<div>Would you please help me ? I'm get a look at business object web site to solve the CRXI (Logon information denied Database vendor 17).</div> <div>[Windowx XP / VS 2003 / c#]</div>
Failed to open the connection. Details: [Database Vendor Code: 17 ] Failed to open the connection. C:\WINNT\TEMP\{A658127A-373F-48D4-9480-F56C432BCC49}.rpt Details: [Database Vendor Code: 17 ]
Yes, I re-compiled my app, but I note something strange. Every time I open the report at CRXI and take a look at Change DataSource menu, the information there is not updated. So I change it again and verify DB and save.
netfreak9
Member
110 Points
23 Posts
Crystal: Failed to open Connection
Jun 08, 2006 08:34 AM|LINK
Hi,
I am on the verge of pulling my hair off on this one. I've got web reports built on Crystal XI and they work absolutely fine on my Windows XP machine. I now transfer the web application to my Windows 2003 Enterprise Production Server and the web application is still running fine except all my reports keep giving the following error:
Failed to open the connection. Details: [Database Vendor Code: 17 ]
Failed to open the connection. C:\WINDOWS\TEMP\{ADB8090C-40ED-499D-88E3-915E23B0C5C3}.rpt Details: [Database Vendor Code: 17 ]
I have the latest service packs for crystal & windows. The Business Objects website doesn't talk about this error.
Thanks,
Irfan.
jportelas
Contributor
2718 Points
591 Posts
Re: Crystal: Failed to open Connection
Jun 09, 2006 12:24 PM|LINK
netfreak9
Member
110 Points
23 Posts
Re: Crystal: Failed to open Connection
Jun 10, 2006 04:47 AM|LINK
Hi jportelas,
I am using SQL Server 2000 and when I run the reports in Crystal, they run fine. I am unable to understand what is the cause of this problem.
Please help.
Thanks,
Irfan.
netfreak9
Member
110 Points
23 Posts
Re: Crystal: Failed to open Connection
Jul 12, 2006 03:01 PM|LINK
I resolved the issue finally. Something which is pretty wierd.
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.
Now, I did this plenty of times already before I posted this question here. The only thing I did not do is send the report back to my programmers and ask them to re-compile the application and send the DLL again.
Woooff ... what a pain.
Anyways, thanks for all the replies.
Irfan.
garyvw
Member
2 Points
3 Posts
Re: Crystal: Failed to open Connection
Jul 31, 2007 05:48 PM|LINK
Thank you! I've been fighting this problem for a while now and that did the trick!
mstr_freak
Member
2 Points
1 Post
Re: Crystal: Failed to open Connection
Sep 07, 2007 03:47 AM|LINK
Irfan
Thanks a lot for this post...coz it helped me with my problem.
alexandre.pi...
Member
8 Points
10 Posts
Re: Crystal: Failed to open Connection
Jan 23, 2008 11:35 AM|LINK
Failed to open the connection. Details: [Database Vendor Code: 17 ] Failed to open the connection. C:\WINNT\TEMP\{A658127A-373F-48D4-9480-F56C432BCC49}.rpt Details: [Database Vendor Code: 17 ]
<
add key ="rptCon" value="C:/Inetpub/wwwroot/CERIntraneMyConnectionString = System.Configuration.ConfigurationSettings.AppSettings.GetValues("rptCon") ;
ReportDocument oReport=
new ReportDocument();oReport.FileName=MyConnectionString[0];
// oReport.Load(MyConnectionString[0]);
TableLogOnInfo logOnInfo =
new TableLogOnInfo();logOnInfo.ConnectionInfo <script></script>.AllowCustomConnection=
true;logOnInfo.ConnectionInfo.IntegratedSecurity =
false;logOnInfo = oReport.Database.Tables["CERWEB"].LogOnInfo;
ConnectionInfo connectionInfo =
new ConnectionInfo ();connectionInfo = logOnInfo.ConnectionInfo;
//make connection to DataBase
//pass as argument the JobNo ID
string i;i= HttpContext.Current.Request.QueryString.Get(0);
DataSet ds =
new DataSet();business bus =
new business();ds = bus.GetRecord(i);
connectionInfo.DatabaseName = "CER";
connectionInfo.ServerName = "serverr";
connectionInfo.Password = "xxx";
connectionInfo.UserID = "sa";
oReport.Database.Tables ["CERWEB"].ApplyLogOnInfo(logOnInfo);
// connectionInfo.DatabaseName = "CERWEB";
// connectionInfo.ServerName = "w2hz7q6x02";
// connectionInfo.Password = "intranetlocal";
// connectionInfo.UserID = "welcome1";
// oReport.Database.Tables ["CERWEB"].ApplyLogOnInfo(logOnInfo);
<script></script>oReport.SetDataSource(ds.Tables[0]);
//pass the query as parameterCrystalReportViewer1.DisplayGroupTree=
false;CrystalReportViewer1.ReportSource=oReport;
CrystalReportViewer1.RefreshReport();
I've tried to open the CRXI in the windows 2000 server and update the datasource location, verify database, but the errors remains.
<script></script>netfreak9
Member
110 Points
23 Posts
Re: Crystal: Failed to open Connection
Jan 23, 2008 08:35 PM|LINK
Hi alexandre, Did you re-compile your application after the "Verify Database" thingy? If not, try that.
Thanks,
Irfan.
alexandre.pi...
Member
8 Points
10 Posts
Re: Crystal: Failed to open Connection
Jan 24, 2008 11:28 AM|LINK
Yes, I re-compiled my app, but I note something strange. Every time I open the report at CRXI and take a look at Change DataSource menu, the information there is not updated. So I change it again and verify DB and save.
But the error remains.
jportelas
Contributor
2718 Points
591 Posts
Re: Crystal: Failed to open Connection
Jan 24, 2008 01:15 PM|LINK
Do you have any sub-reports in the crystal report?
Are you working in VS 2005 or 2003?