| Author |
 Topic  |
|
|
AGrasso
Starting Member
USA
19 Posts |
 Posted - 05 July 2001 : 12:44:53
|
I am not sure if this has been answered already ... Since I'm new at this .. I could use your help.
I get this message when running Setup.asp
ADODB.Connection error '800a0e7a'
ADO could not find the specified provider.
/forums/inc_top.asp, line 42
|
|
|
AGrasso
Starting Member
USA
19 Posts |
Posted - 05 July 2001 : 12:54:04
|
This is the config.asp file info ..
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/fpdb/snitz_forums_2000.mdb;") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\forum.snitz.com\snitz_forum.mdb;" '## MS Access 2000
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=SQL_USER;pwd=PASSWORD;database=DATABASE_NAME" '## MS SQL Server 7
'strConnString = "driver=MySQL;server=SERVER_NAME;uid=MYSQL_USER;pwd=PARRWORD;database=DATABASE_NAME" '## MySQL
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
|
 |
|
|
mafifi
Junior Member
USA
308 Posts |
Posted - 05 July 2001 : 15:36:32
|
The config information looks OK. Did you actually create a folder called fpdb as stated in your config information? Are you hosting with Brinkster?
Thanks,
Mo |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 06 July 2001 : 00:23:38
|
If you're on an older server, maybe the Jet 4.0 drivers aren't installed. If it's your server, go to msdn.microsoft.com/data and download the newest MDAC. Note that v2.6 requires a separate download for the Jet drivers, refer to the instructions on the site.
Alternatively, you can use the DRIVER={Microsoft Access Driver (*.mdb)} connection string which uses the ODBC driver for MS Access. That driver should be present on any MS server.
======
Doug G
====== |
|
|
|
AGrasso
Starting Member
USA
19 Posts |
Posted - 06 July 2001 : 07:56:07
|
quote:
The config information looks OK. Did you actually create a folder called fpdb as stated in your config information? Are you hosting with Brinkster?
Thanks,
Mo
Yes, I tried to follow these instructions to the "T"
|
|
|
|
mafifi
Junior Member
USA
308 Posts |
Posted - 06 July 2001 : 09:15:00
|
Doug G,
MDAC 2.6 is fine for experienced users, for all other users MDAC 2.5 is very suffecient.
AGrasso,
quote:
Yes, I tried to follow these instructions to the "T"
By saying "yes, " above, I take it that you are hosting with Brinkster. Here is the code for Brinkster:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("\your_user_name\db\snitz_forum.mdb") & ";" & _
"Persist Security Info=False"
make sure to put your DB in the directory named db assigned to you by Brinkster.
Thanks,
Mo
Edited by - mafifi on 06 July 2001 09:16:07 |
|
|
|
AGrasso
Starting Member
USA
19 Posts |
Posted - 06 July 2001 : 09:48:07
|
quote:
Doug G,
MDAC 2.6 is fine for experienced users, for all other users MDAC 2.5 is very suffecient.
AGrasso,
quote:
Yes, I tried to follow these instructions to the "T"
By saying "yes, " above, I take it that you are hosting with Brinkster. Here is the code for Brinkster:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("\your_user_name\db\snitz_forum.mdb") & ";" & _
"Persist Security Info=False"
make sure to put your DB in the directory named db assigned to you by Brinkster.
Thanks,
Mo
Edited by - mafifi on 06 July 2001 09:16:07
My apologies for not making my reply clear... NO I do not use Brinker as a host. I have an Intranet running on IIS Windows NT.
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 06 July 2001 : 10:37:21
|
quote:
MDAC 2.6 is fine for experienced users, for all other users MDAC 2.5 is very suffecient.
Well, this may not be strictly true, particularly if you have SQL 2000 servers in the mix, or SQL 7 at the newest SP. Some design tools don't work against the latest SQL until you update. There are, as usual, a lot of changes between 2.5 and 2.6, and I recommend using the latest version.
======
Doug G
====== |
|
|
| |
Topic |
|
Topic Locked
