| Author |
|
Snowgasm
Newbie
Joined: 18 October 2007
Location: Netherlands
Online Status: Offline
Posts: 2
|
| Posted: 18 October 2007 at 5:57am | IP Logged
|
|
|
I have just installed the ASP.NET 4.0 version of Mailbee
Webmail.
I tried using a mdb (access) database, as I used to run in
the old ASP version of the package. First of all the pacage I
received did not include a database, so I tried using an
empty database (created from Access) and tried using the
old database from the ASP package.
Both did not work. I receive the following ASP error while
creating the databases:
Server Error in '/' Application.
Syntaxisfout (operator ontbreekt) in query-expressie xtype
= 'U' and OBJECTPROPERTY(o.id, N'IsMSShipped')!=1.
Description: An unhandled exception occurred during the
execution of the current web request. Please review the
stack trace for more information about the error and where
it originated in the code.
Exception Details: System.Data.OleDb.OleDbException:
Syntaxisfout (operator ontbreekt) in query-expressie xtype
= 'U' and OBJECTPROPERTY(o.id, N'IsMSShipped')!=1.
Source Error:
An unhandled exception was generated during the
execution of the current web request. Information
regarding the origin and location of the exception can be
identified using the exception stack trace below.
Stack Trace:
[OleDbException (0x80040e14): Syntaxisfout (operator
ontbreekt) in query-expressie xtype = 'U' and
OBJECTPROPERTY(o.id, N'IsMSShipped')!=1.]
System.Data.OleDb.OleDbCommand.ExecuteCommandText
ForSingleResult(tagDBPARAMS dbParams, Object&
executeResult) +267
System.Data.OleDb.OleDbCommand.ExecuteCommandText
(Object& executeResult) +192
System.Data.OleDb.OleDbCommand.ExecuteCommand(Co
mmandBehavior behavior, Object& executeResult) +48
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(
CommandBehavior behavior, String method) +106
System.Data.OleDb.OleDbCommand.ExecuteReader(Comma
ndBehavior behavior) +111
System.Data.OleDb.OleDbCommand.System.Data.IDbComm
and.ExecuteReader() +6
WebMailPro.DbManager.SelectTablesNames() +100
[WebMailDatabaseException: Syntaxisfout (operator
ontbreekt) in query-expressie xtype = 'U' and
OBJECTPROPERTY(o.id, N'IsMSShipped')!=1.]
WebMailPro.DbManager.SelectTablesNames() +288
WebMailPro.MailAdm.mailadm_database_settings.create_ta
bles_Click(Object sender, EventArgs e) +391
System.Web.UI.WebControls.Button.OnClick(E ventArgs e)
+105
System.Web.UI.WebControls.Button.RaisePostBackEvent(Stri
ng eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBac
kEventHandler.RaisePostBackEvent(String eventArgument)
+7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHan
dler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollecti
on postData) +33
System.Web.UI.Page.ProcessRequestMain(Bool ean
includeStagesBeforeAsyncPoint, Boolean
includeStagesAfterAsyncPoint) +5102
I use ASP.NET 2.0 btw.
After that I tried using my MySQL server. Everything
worked out fine. I can find and login to the database and
create the necessary tables.
I then created a new user. Again, no problem shows. But
when I try to login I get the folowing error:
"Value was either too large or too small for a signed byte."
|
| Back to Top |
|
| |
Snowgasm
Newbie
Joined: 18 October 2007
Location: Netherlands
Online Status: Offline
Posts: 2
|
| Posted: 18 October 2007 at 6:01am | IP Logged
|
|
|
BTW:
The sentece:
Syntaxisfout (operator ontbreekt) in query-expressie xtype =
'U' and OBJECTPROPERTY(o.id, N'IsMSShipped')!=1.]
Is in Dutch and would look like this when translated:
Syntax error (operator missing) in query-expression xtype =
'U' and OBJECTPROPERTY(o.id, N'IsMSShipped')!=1.]
|
| Back to Top |
|
| |
Andrew
AfterLogic Support
Joined: 28 April 2006
Location: United States
Online Status: Offline
Posts: 1189
|
| Posted: 18 October 2007 at 8:11am | IP Logged
|
|
|
We've replied you via e-mail.
Best regards,
Andrew
|
| Back to Top |
|
| |
MailBee.NET Objects 
MailBee.NET Queue 
MailBee Objects 
WebMail Pro PHP 
AfterLogic Aurora 
MailSuite Pro for Linux 
Unified Messaging Solution 
Search
Register
Login
Topic: ASP.NET database trouble
Privacy policy |
Refund policy