DotNetInvoice Forums

hi,

i purchased the applicaiton two weeks ago. When we installed and run on our server it gives error that we could not debug. I think it may have to do something with specifying database name. We could not find the refeerence to the database name that is specified in system. However, there is a not on instruction about choosing database name. Are we missing any files? please advise

regards,

Hiren

Note: This is a copy of the email sent directly from support.

Hiren,

 
If you continue to have the error you described, please email it to support and we'll see if we can assist with the debugging.

It's possible that the error is related to the SQL setup, so let's make sure that is correct first.  In the install.sql script, there are not currently any places that you need to replace your server name as mentioned in the setup documentation.  If you review page 6 in the setup documentation, it describes how to configured the web.config file to point at the database you have installed.  This may be the missing step in your installation at this point.

--
DotNetInvoice Support
support@dotnetinvoice.com

 

Hiren,

You can name your Database anything you want to. However, I would suggest naming it somethig that will let you remember what application is using it.

[ For example: if I were to install another application such as Community server I would lean toward naming my database something to the effect of  Commserv.]  

After you have created your database in MSSQL this will be the name that you will use in your Web.Config file.You can locate your DB on the same machine or on another dedicated Database machine as long as the name of the DB is correct and the path/address to the DB is correct.

Cheers

EJ

hi

 we did run sql script etc. it runs fine locally. However, it does not work online on web server. It does not debug there, just says server application in error!

 Live URL http://www.webdatadesign.com.au/clientlogin

Hiren,

If I am not mistaken I cannot see anything on that URL but  "Website Design"

Can you access the database on the Local Network? Can you access it via Example: 10.10.111.xxx\SQL2005 then DB name?

If you can do this then you have a firewall issue. Open 1433 and 1434 Also don't run this application as a folder under IIS run it under as a Virtual Directory as an Application and give it it's own app pool.

1. Create application Pool  if it is Server 2008 set the application default to Classic NOT integrated.

2. Create Virtual Directory as an application make sure that NETWORK SERVICE has FULL Permissions.

  test your ports at this URL for 1433 and 1434

http://www.t1shopper.com/tools/port-scanner/   NOTE: Your firewall can be open and have the application not responding and it will give you a closed port response so make sure things are set correctly.

3. Is the SQL Browser running?

4. Do you have the SQL Surface Config set correctly to accept incomming TCP connections?

Give this a try see what you get?

Joe

Hi Hiren,

The error you are receiving looks like DotNetInvoice might be installed in the same directory with other applications or it's not using it's own web.config file.  The line that is giving the error - <add directoryName="cscode"/> - is not part of the standard DotNetInvoice installation so that may be the issue. You could use the web.config file from your download of DotNetInvoice and then update to the correct database connection string.

You may also want to try Joe's suggestions to make sure you have proper access.

Please reply to this post or email support@dotnetinvoice.com if you continue to have problems.