Developer forum

Forum » Development » SQL2005 / .NET 2.0 C# Dynamicweb

SQL2005 / .NET 2.0 C# Dynamicweb

E-mail notifications

Reply
Posted on 01/06/2007 13:37:33

Hello everyone,




I've been strugling with this problem for a couple of days now, and the support team asked me to ask the developer team inhere, so that is what i'm gonna do.


 


First up i've downloaded the following files from downloads/software




SQL 2005 dump: DefaultEmptyDataSQL.zip (5-29-2007)

Application/Admin: Application.zip (5-29-2007)

Solution/Project: CSharpClassicNet20.zip (3-26-2007)



When im done with the setup on IIS, replacing rights etc etc.



I load up:

localhost/admin





and i get error


Invalid column name 'True'




After looking it over with some different tools.



The problem seems to be that the application tries todo a True/False statement towards a Bit field in the database which only allows 0/1. I've triede changing the database to MsAccesss and the application works and it also works if i change to an old SQL solution we have running so eigther way it seems that application vs. the SQL dump just doesent work?




Would it be possible for you to release a complete package as an SQL2005.bak + a solution in c# that works together?



Cheers




Jais E.




jed@dkis.dk




 




 


Replies

 
Posted on 01/06/2007 13:51:05
Reply

Could you post the complete exception. Maybe a link to a screen dump?

 
Posted on 01/06/2007 14:35:12
Reply

http://www.jaiz.dk/DWerror.html   - From localhost/Admin


http://www.jaiz.dk/DWerror2.html - From localhost



 


Additional information:


DWerror2.html


Is also a bit suspesious as i dont have a folder thats called projects under C:\


 


My real line to the path is:


C:\Udvikling\Forbrugsforeningen\Application\Default.aspx.cs


 


and not:



CustomModules.Default1.Page_Load(Object sender, EventArgs e) in C:\Projects\csharpcm.net.dynamicsystems.dk\Application\Default.aspx.cs:34




But this is a "problem" i have seen before with errors in dynamicweb and havent had any effect on the solution/project itself in anyway.



 
Posted on 08/06/2007 13:42:50
Reply
MKR wrote:



How do you switch between access and MSSQL database? Through the controlpanel in dynamicweb or directly in the Globalsettings.aspx file?




If you change database directly in the Globalsettings file, the key for SQL server should be: 'ms_sqlserver'




The only way i have been able to reproduce this error, is by writing something else than 'ms_access' and 'ms_sqlserver'. This causes dynamicweb to connect to MSSQL server with access sql strings.


 


The SQL server I used is restored from the following file: DefaultEmptyDataSQL.zip




-Martin












Globalsettings.aspx is the file where i change betwin the servers. I dont use dynamicweb for that :)


 


also i  double checked the Globalsettings file no error's in it


 






//Jaiz







 

You must be logged in to post in the forum