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: I’m getting a few MSSQL error codes A d d - P o s tAdd P o s t
Author
Message << Prev Info | Next Info >>
mskislan
New User
New User


Joined: January/11/2010
Online Status: Offline
Info: 4
Added: January/11/2010 at 5:38pm | IP Logged Quote mskislan
Hi all

I have some trouble having the ASPbanner running smoothly. Database set up (MSSQL2005 on Win2003) and files copied and modified (permission set) on the webserver (Win2003). Changed password on aspbanneruser from temp to a new one, in both the database and in the config file.
I can log in, add users, upload files, create zones, etc, but when I click Banners I get this message:
Microsoft OLE DB Provider for SQL Server error '80040e14'

Incorrect syntax near '='.

/aspbanner/banners.asp, line 306

And when I click Manage banners one an individual user, I get this error:
Microsoft OLE DB Provider for SQL Server error '80040e14'

Incorrect syntax near '='.

/aspbanner/manage_banners.asp, line 255

I have obviously done something wrong somewhere, but I cant figure it out. Any suggestions?

Thanks
Morten
Back to Top View mskislan's Profile Search for other info by mskislan
 
mskislan
New User
New User


Joined: January/11/2010
Online Status: Offline
Info: 4
Added: January/13/2010 at 4:16am | IP Logged Quote mskislan
Im just going to add some information to my own post.
I still havent found a solution to these SQL errors. My installed version of ASPbanner is the latest paid version of the single website version.
The webserver (Win2003 std, 32 bit) runs on the same network as the SQL server (MSSQL 2005/Win2003 std, 32 bit).
Ive tried to switch from the aspbanneruser to the sa user, but with same outcome. When nearly giving up, I removed both the database and all files/folders and started over again from scratch. Double checking the instructions, I made sure the installation and configuration was done correctly. After launching it again I got the same errors
Clicking on Managing banners on a user, gives me this:
Banners For xxxx xxxx, Inc
(1 Banner Found)   
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '='.
/aspbanner/manage_banners.asp, line 255

If I click on the Banners button, I get this:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '='.
/aspbanner/banners.asp, line 306

I havent change an code in the banners.asp file

Before I added the first user and assigned a banner to the advertiser, no errors was displayed on these two pages.

I hope someone can give me some suggestions on how to solve this.

Thanks
Morten
Back to Top View mskislan's Profile Search for other info by mskislan
 
mskislan
New User
New User


Joined: January/11/2010
Online Status: Offline
Info: 4
Added: January/13/2010 at 4:46am | IP Logged Quote mskislan
Would it have anything to do with the servers regional settings? -Decimal symbol, time format, etc? The servers have English language, but regional settings are set to Norwegian. Ive tried to change it to English (United States) on both the webserver and the SQL server, but didnt see any changes right away (caching, or something at the SQL server preventing this to kick in?).
I cant leave it on English for a longer time, because other applications and web sites get all messed up with these settings.

Morten
Back to Top View mskislan's Profile Search for other info by mskislan
 
mskislan
New User
New User


Joined: January/11/2010
Online Status: Offline
Info: 4
Added: January/13/2010 at 7:15am | IP Logged Quote mskislan
Whoa!
I found it! It had something to do with how it stored/displayed dates. I used some code found here on the forum and updated config_inc.asp
Now everything works like a charm
Back to Top View mskislan's Profile Search for other info by mskislan
 
cwilliams
Admin Group
Admin Group
Avatar
CJWSoft Web Software Developer

Joined: April/06/2004
Online Status: Offline
Info: 1729
Added: January/13/2010 at 8:46am | IP Logged Quote cwilliams

sorry you had to post to yourself..

I was away for a day and although I had my new DROID with me thinking I could watch out for people needing help... well, I apparently wasn't getting emails regarding forum posts..

glad you found the solution.. this comes up once in a while when dealing with internationl server/sql etc etc  once it's done it's done and it will work ok



__________________
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 source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspprotect.com, www.powerasp.com,www.aspclassifieds.com,www.aspphotogallery.com,www.codewanker.com