| Author |
 Topic  |
|
|
ZeroTolerance
Starting Member
23 Posts |
 Posted - 05 July 2001 : 03:01:03
|
I just got this forum and I am getting this error. I tried hundreds of combinations on how to correct it with no luck please help!
Microsoft VBScript compilation error '800a0409'
Unterminated string constant
/Forums/config.asp, line 55
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="/tools/snitz_forum.mdb"
--------------------------------------------------------------------------------------^
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 05 July 2001 : 03:17:22
|
quote:
I just got this forum and I am getting this error. I tried hundreds of combinations on how to correct it with no luck please help!
Microsoft VBScript compilation error '800a0409'
Unterminated string constant
/Forums/config.asp, line 55
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="/tools/snitz_forum.mdb"
--------------------------------------------------------------------------------------^
change as below:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/tools/snitz_forum.mdb")
'## MS Access 2000 using virtual path
gauravbhabu
There is only one miracle...That is LIFE!
Edited by - GauravBhabu on 05 July 2001 03:18:27 |
 |
|
|
ZeroTolerance
Starting Member
23 Posts |
Posted - 05 July 2001 : 03:38:35
|
I am not using the virtual path one because when I do it gives me nothing, not even an error just a blank page. I am wodering why I am still getting this message please I just want to get the forum up and running hehe!
Error Message:
Microsoft VBScript compilation error '800a0409'
Unterminated string constant
/Forums/config.asp, line 55
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="/tools/snitz_forums_2000.mdb" '## MS Access 2000
---------------------------------------------------------------------------------------------------------------^
|
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 05 July 2001 : 06:30:24
|
quote:
I am not using the virtual path one because when I do it gives me nothing, not even an error just a blank page. I am wodering why I am still getting this message please I just want to get the forum up and running hehe!
Error Message:
Microsoft VBScript compilation error '800a0409'
Unterminated string constant
/Forums/config.asp, line 55
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="/tools/snitz_forums_2000.mdb" '## MS Access 2000
---------------------------------------------------------------------------------------------------------------^
here, may be you are missing > ; < at the end. try also with the full path.
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="/tools/snitz_forums_2000.mdb;" '## MS Access 2000
gauravbhabu
There is only one miracle...That is LIFE!
Edited by - GauravBhabu on 05 July 2001 06:34:40 |
|
|
|
ZeroTolerance
Starting Member
23 Posts |
Posted - 05 July 2001 : 12:14:18
|
After I added the ; I get this error message now.
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/Forums/config.asp, line 55
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="/tools/snitz_forums_2000.mdb;" '## MS Access 2000
-------------------------------------------------------------------------------------------^
|
|
|
|
davemaxwell
Access 2000 Support Moderator
USA
3020 Posts |
Posted - 05 July 2001 : 12:30:08
|
The problem is the quotation marks. Try changing it to this:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=""/tools/snitz_forums_2000.mdb"""
Dave Maxwell
--------------
Proud to be a "World Class" Knucklehead |
|
|
|
ZeroTolerance
Starting Member
23 Posts |
Posted - 05 July 2001 : 12:37:48
|
Ok I changed to that and now I get a blank white page. That is all. I hate to be a burden but this is driving me nuts and I self taught myself HTML hehe
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 06 July 2001 : 00:20:00
|
quote:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="/tools/snitz_forum.mdb"
Problem one is the quote after Source= it needs to be removed.
Problem two is you are trying to reference your database by a URL instead of a physical path. Look at the examples in config.asp with Server.MapPath(), or download the whereami tool from the Snitz forum home and use the correct physical path to your database.
When you enter a physical path it will look like
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\wwwroot\myweb\tools\snitz_forum.mdb"
======
Doug G
====== |
|
|
|
marsh
Starting Member
7 Posts |
Posted - 06 July 2001 : 22:39:12
|
So you cant have your database thing run off a webserver? It's gonna be the physical thing on your hard drive?
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 06 July 2001 : 23:08:22
|
Yes, you must specify a physical path.
You can use the Server.MapPath("url_to_mdb") function to automatically determine the physical path from a url. There are examples in config.asp (use a real url btw)
======
Doug G
====== |
|
|
|
ZeroTolerance
Starting Member
23 Posts |
Posted - 09 July 2001 : 23:49:57
|
OK I tried everything and here is my response I get when trying to run config.asp from my website:
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/Forums/config.asp, line 54
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= & Server.MapPath("http://www.mydomain.com/Forums/tools/snitz_forums_2000.mdb")" '## MS Access 2000 using virtual path
---------------------------------------------------------------------------------^
Edited by - ZeroTolerance on 09 July 2001 23:50:36 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 10 July 2001 : 01:07:05
|
As was said before, you can't use a URL to point to your database.
Do this, go here http://forum.snitz.com/archive/default.asp?catid=11&cattitle=Forum+Setup+Tools and download the "Where Am I?" tool. Extract the file to where your database is and go to the file using your browser. It will tell you the physical location to your database.
Then you will use the following connection string:strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=PATH TO DATABASE;" '## MS Access 2000 replacing the text "PATH TO DATABASE" with the path you got from the where am I? script.
- David |
|
|
|
ZeroTolerance
Starting Member
23 Posts |
Posted - 10 July 2001 : 01:23:04
|
OK I am gonna try this now will post results thanks for all your help, I really want to get this working. Once again thanks an I never wanted to be a burden.
|
|
|
|
ZeroTolerance
Starting Member
23 Posts |
Posted - 10 July 2001 : 02:02:00
|
OK got everything going now getting this error.
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/Forums/inc_functions.asp, line 644
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 10 July 2001 : 02:07:51
|
That's a permissions problem with your database file and the folder it is in. It needs Read/Write permissions for the anonymous user account.
You can do a search here on the forum for "Operation must use an updateable query.". You will find quite a few answers to that error.
- David |
|
|
| |
Topic |
|
Topic Locked
