| Author |
 Topic  |
|
|
DougR
Starting Member
6 Posts |
 Posted - 08 April 2001 : 03:13:47
|
I am currently testing Snitz on one of my servers (NT4 SP5, Access 97).
I am trying to install some mods that use mod_dbsetup.asp. When I click update, I receive -2147217900 | [Microsoft][ODBC Microsoft Access 97 Driver] errors. (Doesn't matter which mod I try to install, still receive said error)
I read some posts and took the advice given: installed MDAC 2.6. This didn't fix it.
Next thing was to change my strConnString. Since I am using an Access 97 DB, my line in config.asp reads:
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:\testdb\test.mdb" '## MS Access 97
I commented out this line (as advised to others), and used the Access 2000 line instead:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\testdb\test.mdb;" '## MS Access 2000
When I use the 2000 line, I receive the following error right off the bat when forum is accessed:
ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.
/test/mod_dbsetup.asp, line 13
When Access 97 ConnString is used, my forum is completely fine, except when I try and update the DB to install a mod.
What am I doing wrong? I really hope it is not something painfully obvious.
Thanks in advance,
Doug
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 08 April 2001 : 03:19:01
|
MDAC 2.6 does not include the MSJet drivers, you must download them separately.
you can get them here: http://www.microsoft.com/data
Look for this: Microsoft Jet 4.0 SP3 Now Available for Download |
 |
|
|
DougR
Starting Member
6 Posts |
Posted - 08 April 2001 : 11:02:35
|
Thanks for the fast response!
I installed Jet 4.0 SP3, but receive the following error:
CONFIGDRIVER: Unable to configure ODBC driver Microsoft Excel Driver (*.xls): Could not load the setup or translator library.
I opened the ODBC control panel and I do find the Excel driver (3.51.1029.00) under the Drivers tab.
These are probably all "newbie" questions, as I have no knowledge in the database world.
I did do a search for this on MS Knowledge Base, Article ID: Q260558 - my registry keys are fine, and I d/l'ed Component Checker, ran an analysis, and everything is fine.
Confused. 
|
|
|
|
DougR
Starting Member
6 Posts |
Posted - 08 April 2001 : 11:05:28
|
quote:
These are probably all "newbie" questions, as I have no knowledge in the database world.
I did do a search for this....
I searched for resolution to the error I received...... not my lack of knowledge. 
LOL. Should have rearranged those lines before posting.
|
|
|
|
DougR
Starting Member
6 Posts |
Posted - 08 April 2001 : 19:46:46
|
Oh, boy! The resolution was SOOOO basic, I'm embarrassed.
All I had to do was restart my server. 
I wish the Jet 4.0 install just told me to restart the server, instead of giving me that error message. Then again, if one is meddling with components such as this, the assumption of "Installer should know what to do next" is understandable.
<reminding self to KISS>
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 08 April 2001 : 19:48:52
|
Yep, when all else fails, try rebooting...  |
|
|
| |
Topic |
|
Topic Locked
