Author |
Topic |
|
Jeepers Ron
New Member
USA
95 Posts |
Posted - 22 November 2002 : 18:07:16
|
Spell Checker for Snitz 3.4.01
pop_spellcheck.asp I'm having a problem getting the correct connection string.
I've got my Forum in: Root:\myhost\Forum I have both my forum.mdb and dictionary2000.mdb in: Root:\myhost\cgi-bin I'm using this connecting string in my pop_spellcheck.asp
spellConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/test/dictionary2000.mdb")
I also tried: ("/test/dictionary2000.mdb") ("Root:/myhost/cgi-bin/dictionary2000.mdb") ("/Forum/dictionary2000.mdb") ("/dictionary2000.mdb")
And many other ways putting that database in others places, but still unable to get it to work, can anyone help?
The closest I get is the spell check window will come up with my message in it, but the misspelled words are not checked. |
Jeeper from Michigan
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 22 November 2002 : 22:20:12
|
If your dictionary database and snitz database are in the same place try using the exact same connection string as the snitz database uses with the actual database name referring to dictionary2000.mdb
Just what kind of server is this on anyway?
@tomic |
SportsBettingAcumen.com |
|
|
Jeepers Ron
New Member
USA
95 Posts |
Posted - 23 November 2002 : 13:00:33
|
The feature of my server are:
Active Server Page (ASP) support Database MS ACCESS ODBC Unlimited PERL v5 Personal CGI ditectory HTTP streaming audio/video Java applets, Chockwave, Flash support
I hope that answers the server question.
This is that part I've been changing to over and over to every combination I can think of. NOTE: Just for this posting I changed the Server address in the below string with "My server"
' spellConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\web\My-server\cgi-bin\dictionary2000.mdb.mdb" '## MS Access 2000
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\web\My-server\cgi-bin\dictionary2000.mdb.mdb" '## MS Access 2000
' spellConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/test/dictionary2000.mdb")
Here is the other part of the pop_spellcheck.asp I've been playing around with.
set SpellConn = Server.CreateObject("adodb.connection") SpellConn.open spellConnStr set rs = my_Conn.execute(sql) ' set rs = SpellConn.execute(sql) while not rs.eof w = rs(0) dic(w) = "" rs.movenext wend ' SpellConn.close ' set SpellConn = nothing set rs = nothing
Thanks for looking into this for me. |
Jeeper from Michigan
|
|
|
Jeepers Ron
New Member
USA
95 Posts |
Posted - 24 November 2002 : 11:06:35
|
Okay, I've moved the dictionary2000.mdb into my cgi-bin dictory, that is also where my Forum's Database is located. The pop_spellcheck.asp will loadup the Spellcheck window with no errors, but it wont hi-light the misspelled words.
Is there another file I should be looking at other then the pop_spellcheck.asp one?
Could it be something wrong with the Hilite funtion?
Oops, forgot to update. This mod is fully functional in my forum now. |
Jeeper from Michigan
|
Edited by - Jeepers Ron on 09 January 2003 15:05:06 |
|
|
hmmm
Starting Member
35 Posts |
Posted - 08 January 2003 : 23:00:42
|
Is there a way to include the dictionary db in a MySQL db. I am using a host that limits you to a single MySQL db and has no access db support. Maybe have its own table in the SQL db and make it look there?
Any ideas would be much appreciated! |
|
|
Hasheba
New Member
USA
97 Posts |
Posted - 08 January 2003 : 23:27:41
|
I think I read something in the Installation guide when I was setting my Spell Checker up.. It was like you have to have dictionary2000.mdb set as read-only. I think that's what I read.. Maybe that's your problem.
I'm just throwing Ideas out here.. I really don't know, but you could try it! |
-Jeff http://www.leo-land.net |
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 09 January 2003 : 09:00:59
|
quote: Originally posted by Jeepers Ron
The feature of my server are:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\web\My-server\cgi-bin\dictionary2000.mdb.mdb" '## MS Access 2000
You have .mdb twice |
The UK MkIVs Forum |
|
|
|
Topic |
|