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: General / Current Version (Old)
 When I go to memberpage 2 I get this error:
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

marcovanl
Starting Member

2 Posts

Posted - 05 June 2001 :  10:49:11  Show Profile
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'LIMIT'.

/forum/members.asp, line 125

please help


Davio
Development Team Member

Jamaica
12217 Posts

Posted - 05 June 2001 :  12:36:15  Show Profile
That error occurs when you have selected "MySql" as the database type you are using in your config.asp file, but you are actually using "SQL Server". Go into your config.asp file and make the appropriate changes. This is what it is supposed to have near the top of the config.asp file:

strDBType = "sqlserver"
'strDBType = "access"
'strDBType = "mysql"



Edited by - Davio on 05 June 2001 12:37:10
Go to Top of Page

marcovanl
Starting Member

2 Posts

Posted - 06 June 2001 :  07:58:40  Show Profile
quote:

That error occurs when you have selected "MySql" as the database type you are using in your config.asp file, but you are actually using "SQL Server". Go into your config.asp file and make the appropriate changes. This is what it is supposed to have near the top of the config.asp file:

strDBType = "sqlserver"
'strDBType = "access"
'strDBType = "mysql"



Edited by - Davio on 05 June 2001 12:37:10



thanks now it works
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 0.24 seconds. Powered By: Snitz Forums 2000 Version 3.4.07