Author |
Topic |
|
lordfirestripe
Starting Member
7 Posts |
Posted - 19 April 2001 : 17:40:54
|
My host says they have a Acess 2000 database, but a MS Sql server. i tried to configure it to work for that, but i got this error...
|
|
lordfirestripe
Starting Member
7 Posts |
Posted - 19 April 2001 : 17:41:51
|
sorry, accidentally hit post button... this error
Microsoft JET Database Engine error '80004005'
Not a valid file name.
/trifearious/forum/inc_top.asp, line 42
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 19 April 2001 : 17:45:48
|
can you post your strConnString from your config.asp file?
|
|
|
lordfirestripe
Starting Member
7 Posts |
Posted - 19 April 2001 : 17:51:06
|
i'll give you one better and post the whole section up to the end of the access strings.
'################################################################################# '## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql) '################################################################################# strDBType = "sqlserver" 'strDBType = "access" 'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines! 'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ= home.domaindlx.com\trifearious\database\snitz_forums_2000.mdb" '## MS Access 97 'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & home.domaindlx.com\trifearious("/database/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=http://home.domaindlx.com\trifearious\database\snitz_forums_2000.mdb;" '## MS Access 2000
Edited by - lordfirestripe on 19 April 2001 17:57:08 |
|
|
lordfirestripe
Starting Member
7 Posts |
Posted - 19 April 2001 : 17:53:24
|
ohh.. sorry. it looks rather wierd on my 1024 X768 screen, it is laid out normal, the wierd look is due to word wrap.
i am using the underlined line.
Edited by - lordfirestripe on 19 April 2001 17:55:37 |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 19 April 2001 : 18:08:45
|
You can't use a url to access your database. Your database and forum files are on the same computer, so you can't use a url.
I'm not sure of the connection for domaindlx, but I'm sure someone will correct me if I'm wrong. Try this:strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/trifearious/database/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path And don't worry about it not showing up correctly, I can decipher it not matter how jumbled up you post it.
|
|
|
lordfirestripe
Starting Member
7 Posts |
Posted - 19 April 2001 : 18:28:48
|
well.... the forum let me in, but the screen was black with black letters.... I CANNOT SEE WHERE TO LOG IN please help with this.
all i could see was a smiley, a folder, a non-loading picture, and if i move my mouse over a part of the screen, it showed there was a link there.
Edited by - lordfirestripe on 19 April 2001 18:30:36 |
|
|
lordfirestripe
Starting Member
7 Posts |
Posted - 19 April 2001 : 18:38:45
|
i was able to see some text by dragging and highlighting, but... it still has no sign in box, and i get errors on member page and some other pages.
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
|
lordfirestripe
Starting Member
7 Posts |
Posted - 20 April 2001 : 13:27:59
|
Yeah, i later found that i had to log directly into the admin_home.asp to see the box, as soon as i logged in and set the first option screen(link at top of list for admin options) the forum went to the colors it is here.. from there i customized it. so somehow setting something in the first options area fixed my problem. Thanks for all your help
-lordfirestripe
|
|
|
|
Topic |
|