| Author |
 Topic  |
|
|
CrEeP
Starting Member
6 Posts |
 Posted - 18 February 2001 : 15:41:24
|
ok when i use access2000 line in the config i set it up and i get this error, what do i need to do to fix it?
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/snitz_forum/config.asp, line 55
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\WebDocs\megaforum.com\snitz_forum\snitz_forum2000.mdb;" ## MS Access 2000
-------------------------------------------------------------------------------------------------------------------------^
and also whic way is it better or faster to run the forum?
"sqlserver" "access" "mysql"?
which is the fastest and most relyable?
thanks for all of the help!
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 18 February 2001 : 15:47:50
|
quote:
ok when i use access2000 line in the config i set it up and i get this error, what do i need to do to fix it?
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/snitz_forum/config.asp, line 55
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\WebDocs\megaforum.com\snitz_forum\snitz_forum2000.mdb;" ## MS Access 2000
-------------------------------------------------------------------------------------------------------------------------^
and also whic way is it better or faster to run the forum?
"sqlserver" "access" "mysql"?
which is the fastest and most relyable?
thanks for all of the help!
"sqlserver" "access" "mysql"
They are the database types your using, access if your using access, mysql if your using mysql, and sqlserver if your using SQL.
Make sure that is specified for the right database, in your case "access" would be right.
----
Da_Stimulator
Snitz Forums Dev Team Member
http://stimmy.cfm-resources.com/forum - my testing forums. |
 |
|
|
CrEeP
Starting Member
6 Posts |
Posted - 18 February 2001 : 16:08:17
|
ok so what do i need to do to make the error not happen? when i use the database as access i get an error.
here is the error it says after i go to setup.asp
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/snitz_forum/config.asp, line 55
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\WebDocs\megaforum.com\cgi-bin\snitz_forums_2000.mdb;" ##
-----------------------------------------------------------------------------------------------------------------------^
so i take it the line 55 where is says "Access 2000 using virtual path" somthing needs to be done but what? i dont under stand
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 18 February 2001 : 16:09:50
|
It looks like you removed a ' too many. There should be one in front of the ## and after the "
....mdb;" '## MS Access 2000
Pierre |
|
|
|
CrEeP
Starting Member
6 Posts |
Posted - 18 February 2001 : 16:20:53
|
lol it had to be something simlpe lol. well i appreaite all the help you all gave to me to help me figure out what was wrong.
thanks much
have a good day you 2!!! Da_Stimulator, and gor
|
|
|
|
CrEeP
Starting Member
6 Posts |
Posted - 18 February 2001 : 16:25:11
|
hmmm looks like i spoke to soon, and sorry for all of the trouble. but i got anuther error its when i go to the forum it says this.
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/snitz_forum/inc_functions.asp, line 644
well i checked it and that line is blank, is there something i need to add or what?
sorry to be such a pain!
but thanks for all of the help!
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 18 February 2001 : 16:54:10
|
do a search for: Operation must use an updateable query
You'll find a lot of topics on that error.
The Search link is on the top right of this page. |
|
|
| |
Topic |
|
Topic Locked
