Active InfoActive Info  Display List of Info MembersMemberlist  Search The InfoSearch  HelpHelp
  RegisterRegister  LoginLogin
ASPBanner Unlimited Version 8.0
 CJWSoft Support Info : ASPBanner Unlimited Version 8.0
Subject Info: Error :0x80040E14 A d d - P o s tAdd P o s t
Author
Message << Prev Info | Next Info >>
knishimoto
New User
New User


Joined: March/25/2008
Location: United States
Online Status: Offline
Info: 1
Added: March/25/2008 at 3:54pm | IP Logged Quote knishimoto

Hi Support,

Yesterday one of our programmer tried to create a new zone in ASPBanner version 8.1. Below is a copy of the error code he got. Then that afternoon I tested the ASBanner to see if I could recreate the error our programmer got. Instead I got a different error. The error is also below. If you wish to test the program on our site please use the following URL and login and password below. After testing the program please reply with your solution to everyone listed in this email.

 

Sincerely,

Kevin Nishimoto

Network Administrator

Golf Reservations Hawaii

 

Error 1:

*Error Type:

Microsoft OLE DB Provider for SQL Server (0x80040E14)

Incorrect syntax near '#'.

/advertiser/aspbanner/appinfo_inc.asp, line 148

Error 2:

Microsoft OLE DB Provider for SQL Server error '80040e14'

Line 1: Incorrect syntax near '#'.

/advertiser/aspbanner/appinfo_inc.asp, line 121

 
Back to Top View knishimoto's Profile Search for other info by knishimoto Visit knishimoto's Homepage
 
cwilliams
Admin Group
Admin Group
Avatar
CJWSoft Web Software Developer

Joined: April/06/2004
Online Status: Offline
Info: 1769
Added: March/25/2008 at 6:41pm | IP Logged Quote cwilliams

Hi,

the database type value in the config file is invalid.

"MSSQL" is not a valid value… it should just be   "SQL"  there

I am not sure how you got that there... maybe I mistyped something in some older directions.. not sure.. anyway I imagine that should clear up the issue... notice how when you log in the top right says your using an access database.. the system does not think you are using sql those it is using sql statements compatible with access.. thus the errors...

Also, next time you have username/password/site info please PM it seperately.
Not a good idea showing to the public...



__________________
Best Regards, Christopher Williams www.CJWSoft.com
Back to Top View cwilliams's Profile Search for other info by cwilliams Visit cwilliams's Homepage
 

If you wish to make a comment to this info you must first login
If you are not already registered you must first register

  A d d - P o s tAdd P o s t
Printable version Printable version

Info Jump
You cannot add new info in this area
You cannot add to info in this area
You cannot delete your info in this area
You cannot edit your info in this area
You cannot create polls in this area
You cannot vote in polls in this area

Active Server Pages ASP a directory of ASP tutorials applications scripts components and articles for the novice to professional developer. CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspprotect.com, www.powerasp.com,www.aspclassifieds.com,www.aspphotogallery.com,www.codewanker.com