| Author |
 Topic  |
|
sumo
Junior Member
USA
121 Posts |
|
|
Aznknight
Senior Member
USA
1373 Posts |
 Posted - 13 April 2001 : 14:43:48
|
I understand your situation now. However, I cannot reproduce this error on my test machine running 2000AS and sql server 7 or on my live site running sql 2000.
Can you guys do a response.write on the main strSQL on classifieds_details.asp?
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
 |
|
|
cyberd
Starting Member
Australia
34 Posts |
Posted - 13 April 2001 : 22:19:00
|
quote:
I understand your situation now. However, I cannot reproduce this error on my test machine running 2000AS and sql server 7 or on my live site running sql 2000.
Can you guys do a response.write on the main strSQL on classifieds_details.asp?
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource
I have tried placing it in a few places, but getting nothing. Can you suggest somewhere.
I was adding <% Response.Write(strSQL) %>
|
|
|
|
seven
Senior Member
USA
1037 Posts |
Posted - 14 April 2001 : 01:05:54
|
The DB setup does not work with access?
|
|
|
|
sumo
Junior Member
USA
121 Posts |
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 14 April 2001 : 06:31:03
|
quote:
The DB setup does not work with access?
Try using the access 2000 connection string. It's okay even if you're using the acces 97 db.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
cyberd
Starting Member
Australia
34 Posts |
Posted - 18 April 2001 : 05:36:46
|
Where/how did you instert the string SUMO, just want to check if mine looks the same.
I guess you've had no luck yet?
|
|
|
|
ctsolutions
New Member
Germany
69 Posts |
Posted - 18 April 2001 : 07:46:05
|
"I understand your situation now. However, I cannot reproduce this error on my test machine running 2000AS and sql server 7 or on my live site running sql 2000."
@Aznknight
I'm running also Win2k 2000 Adv.Server with SQL 2000 and I have the same problem as cyberd.
=============
Contact Person:
Microsoft VBScript compilation - Fehler '800a03ea'
Syntax error
/iisHelp/common/500-100.asp, line 122
on error go to 0
---------^
Microsoft OLE DB Provider for ODBC Drivers- Fehler '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.
/musicfox/inc_functions.asp, line 1553
====================
Datenträger
Contact Ad Content
Location: Hessen
Contact:
Microsoft VBScript compilation - Fehler '800a03ea'
Syntax error
/iisHelp/common/500-100.asp, line 122
on error go to 0
---------^
Microsoft OLE DB Provider for ODBC Drivers- Fehler '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.
/musicfox/inc_functions.asp, line 1553
===========
Microsoft VBScript compilation - Fehler '800a03ea'
Syntax error
/iisHelp/common/500-100.asp, line 122
on error go to 0
---------^
Microsoft OLE DB Provider for ODBC Drivers- Fehler '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.
/musicfox/pop_profile.asp, line 129
Snitz Forum 2000 Test Site = Access 2000 =
http://itc.dynip.com/itcenter
Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser.
|
|
|
|
ctsolutions
New Member
Germany
69 Posts |
Posted - 18 April 2001 : 07:58:05
|
@All with this problem !!!
================
Syntax error
/iisHelp/common/500-100.asp, line 122
on error go to 0
---------^
Microsoft OLE DB Provider for ODBC Drivers- Fehler '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.
=====================
There ist a Database Connection Sring problem.
When you use a DNS Connection like:
strConnString = "DSN=musicfox"
you have problem.
when you change the Connection of:
strConnString = "Provider=SQLOLEDB;Data Source=(Local);Initial Catalog=musicfox;User ID=sa;Password=a##m" '## MS SQL Server 2000
BINGO !!! Fine-Work
Regards,
ctsolutions
Snitz Forum 2000 Test Site = Access 2000 =
http://itc.dynip.com/itcenter
Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser.
|
|
|
|
cyberd
Starting Member
Australia
34 Posts |
Posted - 19 April 2001 : 08:19:15
|
quote:
@All with this problem !!!
================
Syntax error
/iisHelp/common/500-100.asp, line 122
on error go to 0
---------^
Microsoft OLE DB Provider for ODBC Drivers- Fehler '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.
=====================
There ist a Database Connection Sring problem.
When you use a DNS Connection like:
strConnString = "DSN=musicfox"
you have problem.
when you change the Connection of:
strConnString = "Provider=SQLOLEDB;Data Source=(Local);Initial Catalog=musicfox;User ID=sa;Password=a##m" '## MS SQL Server 2000
BINGO !!! Fine-Work
Regards,
ctsolutions
Snitz Forum 2000 Test Site = Access 2000 =
http://itc.dynip.com/itcenter
Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser.
Egat - It works a charm - On SQL 7 as well.
Thanks CT
|
|
|
|
Huntress
New Member
USA
96 Posts |
Posted - 22 April 2001 : 18:31:48
|
When will you release the version that includes editing and deleting of ads?
And here's a suggestion: Let the user decide when the ad will expire 
I've downloaded and installed, I like it alot. But I can't make it public until we can edit or delete ads.
One bug I found:
When editing categories in which the name is more than one word, only the first word is populated in the text box. If saved without typing it back, then the category name is changed.
Thanks!
Diana |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 22 April 2001 : 18:43:51
|
Actually I have been thinking of discontinuing updates of this mod and focus on my other mods. Due to time constraints as well as the low interest in this mod.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
Huntress
New Member
USA
96 Posts |
Posted - 22 April 2001 : 19:01:11
|
PLEASE!!!!!  |
|
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
Posted - 22 April 2001 : 20:57:05
|
I would also like to see the ability to edit or delete ads.
Its a pain to have to download the database, and then upload the changes because of a few phony ads in poor taste.
So throw my vote of interest in the pile.
http://www.dunzellsden.com/forum/ |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
|
|
Topic |
|
Topic Locked
