c# - published reports don't work - Database logon failed Error -

-

i developing simple web app has 3 reports created on vs 2013, reason reports run fine developer mode, when publish website give me "database logon failed" error. causing this? vs installed on same server publishing reports. have created local admin user same info odbc connection logon user iis authentication, still no luck.

below code:

public partial class openwoswebform : system.web.ui.page     {         connectioninfo epakconnectioninfo = new connectioninfo();          protected void setconnectioninfo()         {              epakconnectioninfo.servername = configurationmanager.appsettings["epak_server_name"];             epakconnectioninfo.userid = configurationmanager.appsettings["epak_user_name"];             epakconnectioninfo.password = configurationmanager.appsettings["epak_password"];         }          private void page_init(object sender, eventargs e)         {              reportdocument report = new reportdocument();             report.load("c:\\delray beach\\delray beach\\reports\\openwosreport.rpt");             setconnectioninfo();             tablelogoninfo crtablelogoninfo = new tablelogoninfo();              foreach (crystaldecisions.crystalreports.engine.table crtable in report.database.tables)             {                 crtablelogoninfo = crtable.logoninfo;                 crtablelogoninfo.connectioninfo = epakconnectioninfo;                 crtable.applylogoninfo(crtablelogoninfo);             }             foreach (reportdocument subreport in report.subreports)             {                 foreach (crystaldecisions.crystalreports.engine.table crtable in subreport.database.tables)                 {                     crtablelogoninfo = crtable.logoninfo;                     crtablelogoninfo.connectioninfo = epakconnectioninfo;                     crtable.applylogoninfo(crtablelogoninfo);                 }             }              openwosviewer.reportsource = report;              openwosviewer.toolpanelview = crystaldecisions.web.toolpanelviewtype.none;         }     }

thanks

besides "database logon failed", "unable connect: incorrect log on parameters"?

if so, try this: https://stackoverflow.com/a/24578304/2248943

and try these:

  1. kill asp.net proccess (w3wp.exe or aspnet.exe) (it restart) .
  2. if using xsd file, check it's location path in rpt, try "set location" again; if not work, try remove tables , include them ok (this hard-working).

i faced problem many times , each case solved 1 of these actions.


Comments

Post a Comment

Popular posts from this blog

javascript - gulp-nodemon - nodejs restart after file change - Error: listen EADDRINUSE events.js:85 -

-
i'm running nodejs 0.12.3 - gulp 3.10.8 , gulp-nodemon 2.0.3. gulpfile.js : gulp.task('serve', ['build'], function() { gulp.start('fb-flo'); nodemon({ script: paths.server, env: { 'node_env': 'development' }, // env: { 'node_env': 'production' }, execmap: { 'js': 'node_modules/babel/bin/babel-node --stage 1' //es7 cote server }, delay: '0ms', watch: ['src/shared/', 'src/server/'], ignore: ['src/shared/components'], tasks: function (changedfiles) { var tasks = []; changedfiles.foreach(function (file) { if (path.extname(file) === '.jsx' && !~tasks.indexof('bundlejs')) tasks.push('bundlejs'); if (path.extname(file) === '.less' && !~tasks.indexof('compileless')) tasks.push('compileless'); }); return tasks; } ...
Read more

Fatal Python error: Py_Initialize: unable to load the file system codec. ImportError: No module named 'encodings' -

-
i trying make simple python program opening list of webpages user manually download reports site. don't have previous experience preparing exe files.. , i'm in learning process python coding. of done on windows 7 x64 this python code: #!c:/python34/python.exe -u splinter import * import time import os import csv #---------------------------------- raporty = [] open('../raporty.csv', newline='') csvfile: contents = csv.reader(csvfile, delimiter=' ', quotechar='|') row in contents: r = ', '.join(row) r = r.replace(',','') raporty.append(r) #--not implemented yet zmienne = [] open('../zmienne.csv', newline='') csvfile: contents = csv.reader(csvfile, delimiter=' ', quotechar='|') row in contents: r = ', '.join(row) r = r.replace(',','') zmienne.append(r) print("start") browser = browser(...
Read more

javascript - oscilloscope of speaker input stops rendering after a few seconds -

-
the following script reads audio user's microphone , renders oscilloscope on html canvas. the source taken example of mozilla developer network: visualizations web audio api and here fiddle: http://jsfiddle.net/b7j8pktp/ mozgetusermedia (note: code has no fork mechanism different browsers: works firefox) it works fine few seconds , stops rendering. whereas works totally stable: http://mdn.github.io/voice-change-o-matic/ the problem can reduced following code. microphone activation icon (next the address bar in firefox) disappears after 5 seconds: navigator.mozgetusermedia({audio: true}, function() {}, function() {} ); ( http://jsfiddle.net/b7j8pktp/2/ ) this known bug in firefox. take stream getusermedia call , hook window so: navigator.mozgetusermedia({audio: true}, function(stream) { window.stream = stream; // rest of code }, function err() { // handle error }); hopefully can fixed soon. problem we're f...
Read more