Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Nasty Upgrade Problem?? Please help.		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

JBelthoff
Starting Member

USA
17 Posts
Posted - 12 January 2005 :  00:00:37  Show Profile  Visit JBelthoff's Homepage  Send JBelthoff an AOL message  Send JBelthoff an ICQ Message
Hi all,

I just upgraded from 3_4_03 3_4_05 and I am having some difficulty.

I get this message:



Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near 'LIMIT'.

/default.asp, line 795


The forum is located here to see:
http://photographyforums.johnbelthoff.com

Could someone give me some clues please?

Thanks,

JB
Dodge, Duck, Dip, Dive & Dodge
If a man can dodge a wrench, he can dodge a ball!
JB - IPG - HS

JBelthoff
Starting Member

USA
17 Posts
Posted - 12 January 2005 :  00:36:34  Show Profile  Visit JBelthoff's Homepage  Send JBelthoff an AOL message  Send JBelthoff an ICQ Message
Never Mind I fixed it.

I shure does help to have it selected to SQLServer and not MySQL

Thanks,

JB
Dodge, Duck, Dip, Dive & Dodge
If a man can dodge a wrench, he can dodge a ball!
JB - IPG - HS
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 12 January 2005 :  05:21:37  Show Profile  Send ruirib a Yahoo! Message
Yes, SQL Server and MySQL do not support the same SQL syntax...

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 1.3 seconds. Powered By: Snitz Forums 2000 Version 3.4.07