| Author |
 Topic  |
|
|
joeman1
Starting Member
USA
8 Posts |
 Posted - 07 July 2001 : 13:18:09
|
For some reason I keep getting this error when trying to login using ADMIN. This is for the first time install when trying to run setup.asp
..
ADODB.Connection error '800a0e7a'
ADO could not find the specified provider.
/forum/setup_login.asp, line 58
I have set up the config file to the best of my ability. Here is what it looks like.
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/cgi-bin/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
Here is the actual path in explorer. Though this might help.
I:\Inetpub\OperationsWebSite\cgi-bin\snitz_forums_2000.mdb
Please help
Thanks
Joe
|
|
|
mafifi
Junior Member
USA
308 Posts |
Posted - 07 July 2001 : 13:41:24
|
Can you provide more information. NT or Unix?
Who is your ISP?
Thanks,
Mo
Edited by - mafifi on 07 July 2001 13:43:15 |
 |
|
|
joeman1
Starting Member
USA
8 Posts |
Posted - 07 July 2001 : 13:42:04
|
This is NT IIS 4
|
|
|
|
mafifi
Junior Member
USA
308 Posts |
|
|
joeman1
Starting Member
USA
8 Posts |
Posted - 07 July 2001 : 13:56:10
|
Please forgive me.. The instructions
Download this file and place it where you intend to place your files then run the file (http://www.yourdomain.com/forum/whereami.asp) and post the results for me to look at.
I dont understand.. Please explaine. I went to that site and did not see anything to download.
Thnaks
Joe
|
|
|
|
joeman1
Starting Member
USA
8 Posts |
Posted - 07 July 2001 : 13:58:42
|
Also, I am not useing an ISP. This is a forum for an intranet site. So it in not public.
Thanks
Joe
|
|
|
|
mafifi
Junior Member
USA
308 Posts |
|
|
joeman1
Starting Member
USA
8 Posts |
Posted - 07 July 2001 : 14:18:12
|
ok.. here are the results
I:\Inetpub\OperationsWebSite\newforum\whereami.asp
BUT
the MDB file is actually here
I:\Inetpub\OperationsWebSite\cgi-bin\snitz_forums_2000.mdb
???
Thnaks
Joe
|
|
|
|
mafifi
Junior Member
USA
308 Posts |
Posted - 07 July 2001 : 14:22:54
|
Try this:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=I:\Inetpub\OperationsWebSite\cgi-bin\snitz_forums_2000.mdb;"
Thanks,
Mo |
|
|
|
joeman1
Starting Member
USA
8 Posts |
Posted - 07 July 2001 : 14:25:57
|
Ok.. cut and pasted that into the config.asp and it still gave this error
ADODB.Connection error '800a0e7a'
ADO could not find the specified provider.
/newforum/setup_login.asp, line 58
after I logged in..
Joe
|
|
|
|
mafifi
Junior Member
USA
308 Posts |
Posted - 07 July 2001 : 14:29:21
|
Next Step. Create DSN and let's call it forums and then use the following line
strConnString = "forums"
Sounds like the OLEDB driver is not installed on your server.
Thanks,
Mo
Edited by - mafifi on 07 July 2001 14:31:09 |
|
|
|
joeman1
Starting Member
USA
8 Posts |
Posted - 07 July 2001 : 14:39:59
|
Ok I made a system and user DSN ODBC driver and now the page just sits there. Does nothing. Also, is there a way I can install that OLEDB on my server?
Thanks
Joe
Edited by - joeman1 on 07 July 2001 14:41:20 |
|
|
|
mafifi
Junior Member
USA
308 Posts |
Posted - 07 July 2001 : 14:57:23
|
Yes. Go to Microsoft's Site and search for MDAC. The latest version is 2.6, but my advise is to download and install 2.5 since it comes with all the drivers. Then you have to go back to your code and change it back to
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=I:\Inetpub\OperationsWebSite\cgi-bin\snitz_forums_2000.mdb;"
Let me know how it works.
Here you go.
http://www.microsoft.com/data/download_25SP2.htm
Thanks,
Mo
Edited by - mafifi on 07 July 2001 15:02:37 |
|
|
|
joeman1
Starting Member
USA
8 Posts |
Posted - 07 July 2001 : 15:27:50
|
You are the MAN.. That is what the problem was.. Sorry for the oversight on my end, and a BIG THANKS for the help...
Joe
|
|
|
|
mafifi
Junior Member
USA
308 Posts |
Posted - 07 July 2001 : 15:53:52
|
No Problem. Enjoy it.
Thanks,
Mo |
|
|
| |
Topic |
|
Topic Locked
