Author |
Topic |
|
Beaudoin
New Member
Canada
75 Posts |
Posted - 01 February 2005 : 10:20:13
|
I'm getting this error:
Microsoft OLE DB Provider for SQL Server error '80040e07'
Syntax error converting the varchar value '0, 0' to a column of data type int.
/Army/forum/forum/admin_policy.asp, line 62
Can anyone tell me how to fix this problem?
I'm using an SQLserver database. |
Jason Beaudoin Army Web Designer Canadian Army
|
Edited by - Beaudoin on 01 February 2005 11:59:33 |
|
Beaudoin
New Member
Canada
75 Posts |
Posted - 01 February 2005 : 14:03:08
|
Nevermind everyone... I had to revert to our Access database. |
Jason Beaudoin Army Web Designer Canadian Army
|
|
|
hawkdrean
New Member
73 Posts |
Posted - 29 March 2005 : 02:49:21
|
I'm getting this error went I try to make a custom Policy
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/admin_policy.asp, line 62
This is what on line 62: my_conn.execute(strsql),,adCmdText + adExecuteNoRecords
Can anyone help me with this?
Thanks |
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 29 March 2005 : 04:08:48
|
Hawkdrean,
That normally means that it can not find a table/field in your database. Did you run the dbs file via the admin area? You need to follow all the steps when installing mods.
|
Cheers, David Greening |
|
|
hawkdrean
New Member
73 Posts |
Posted - 29 March 2005 : 04:34:06
|
Yes I ran the datebase file went I first installed the forum and all the tables/fields are showing up. I ever run Check Installation and I still get the error |
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 29 March 2005 : 04:48:56
|
Where abouts are you running this, as everytime I go to your homepage, I get: HTTP/1.1 New Session Failed
The admin_policy.asp file I have, at line 62, I have:Response.Write " <p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strHeaderFontSize & """>Configuration Posted!</font></p>" & vbNewLine & _ So what changes have you made changes to the original admin_policy.asp file. Re-download it from OneWayMule's site and re-upload the admin_policy.asp as there seems to be something wrong with your copy. It is the best advice I could give you, to start with an un-edited version of the mod.
|
Cheers, David Greening |
|
|
hawkdrean
New Member
73 Posts |
Posted - 29 March 2005 : 05:15:23
|
I went and download the Policy.asp from here http://www.snitzbitz.com/mods/details.asp?Version=All&mid=134 And ran the database file and then uploaded the Policy.asp to overwrite the one in my forum folder. Then I try again to make my own policy and it worked. I think the one I had was bad and it was causing the error. |
|
|
|
Topic |
|