| Author |
 Topic  |
|
|
muddywellies
Junior Member
United Kingdom
156 Posts |
 Posted - 04 March 2007 : 04:47:57
|
I downloaded the 5-in-1 Expansion Pack for my V3.4.06 forum.
The one sheet instruction looked clear. As a precaution I downloaded my existing forum Config.asp file and printed it. I then opened the integration mod (#1) and printed its Config.asp file.
Laid side-by-side it was very easy to identify the connection string mentioned in the instruction sheet. (I had never seen one before & didn't know what they I was supposed to be looking). Just for the record the connection string begins "strConnString".
I made the necessary changes which identified the location of the forum on my PC. The line of code was double-checked.
Next, I checked my forum would allow code. I then uploaded the dbs file. Back in my forum I picked Mod Setup selected it and followed the on-screen instructions. At this point I could still access my forum OK. So I uploaded all the remaining files for the mod seperately. I then pointed to my forum and received the following message on my Firfox browser.
"Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/snitz/inc_header.asp, line 112"
Now, where have I gone wrong here?
Fortunately, nothing is lost because I can still reload my original config file. But I can't see where my error lies. Particularly since the error appears on one of the uploaded files which do not require any changes. Can someone help? |
I've got green fingers, but I'm all thumbs using a keyboard! |
|
|
Panhandler
Average Member
USA
783 Posts |
Posted - 04 March 2007 : 09:50:58
|
I would look at the config.asp file again.
"BeyondCompare" is an excellent tool for comparing files.
It will let you open two files and compare them in two side-by-side windows - line for line.
Differences will be highlighted and shown at the bottom of the page.
This method is accurate and fast.
To get the feel of how it works, make up a simple text file.
Copy it - make a change to the copied file.
Then use BeyondCompare to compare the two files.
Once you understand the basics (they're fairly intuitive) try looking at your old config.asp file compared to the one that you modified.
Also, check the inc_header.asp file about line #4
It should say: Mods: 1) Site Integration
If it states any other mod names, then you've grabbed the inc_header.asp file from the wrong folder.
Free trial down load:
http://www.scootersoftware.com/
|
"5-in-1 Snitz Common Expansion Pack" - five popular mods packaged for easy install
". . .on a mote of dust, suspended in a sunbeam. . ."
HarborClassifieds
Support Snitz Forums
|
 |
|
|
muddywellies
Junior Member
United Kingdom
156 Posts |
Posted - 04 March 2007 : 14:07:50
|
I've checked the header file as suggested and line 4 is as it should be.
Just downloaded trial of BeyondCompare. Will get back with post on that later. |
I've got green fingers, but I'm all thumbs using a keyboard! |
|
|
|
Panhandler
Average Member
USA
783 Posts |
|
|
muddywellies
Junior Member
United Kingdom
156 Posts |
Posted - 05 March 2007 : 11:36:16
|
OK. I am using Beyond Compare and used it to compare both the integration config file and the original one which works fine.
Aside from the code which is obviously part of the MOD which I would not begin to know about, the only other difference was an apostrophe missing viz:
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
Corrected both files to match and reloaded the integration Mod and the error message now reads
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/snitz/inc_header.asp, line 112
Now, the only line I corrected in my integration mod in the config.asp file was line 53 below and it matches the original working file exactly.
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Websites\localuser\winsford\private\snitz_forums_2000.mdb" '## MS Access 2000
|
I've got green fingers, but I'm all thumbs using a keyboard! |
|
|
|
muddywellies
Junior Member
United Kingdom
156 Posts |
Posted - 05 March 2007 : 12:12:37
|
Addendum to previous post.
I've added or omitted an apostrophe in lines 47-49 where:
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
AND/OR
with the connection string which locates the forum on my PC
and lost the whole Forum. Through a mix-up with using the BeyondCompare files I have very effectively matched the good, working original config.asp file to the non-working integration mod config.asp file.
It took nearly three months to build my site and in the course of 48 hrs trying to add this Integration Mod which has never worked for me and now my forum has vanished into the ether.
|
I've got green fingers, but I'm all thumbs using a keyboard! |
|
|
|
MaD2ko0l
Senior Member
United Kingdom
1053 Posts |
Posted - 05 March 2007 : 12:29:52
|
quote:
Originally posted by muddywellies
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Websites\localuser\winsford\private\snitz_forums_2000.mdb" '## MS Access 2000
i think u need to remove the ' at the beggining of this line so it should read
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Websites\localuser\winsford\private\snitz_forums_2000.mdb" '## MS Access 2000 |
© 1999-2010 MaD2ko0l |
|
|
|
muddywellies
Junior Member
United Kingdom
156 Posts |
Posted - 05 March 2007 : 14:15:41
|
Removed apostrophe just now and the error message reads the same.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/snitz/inc_header.asp, line 112 |
I've got green fingers, but I'm all thumbs using a keyboard! |
Edited by - muddywellies on 05 March 2007 14:16:12 |
|
|
|
Panhandler
Average Member
USA
783 Posts |
Posted - 05 March 2007 : 21:49:23
|
You can unzip a fresh version of Snitz (download it if you didn't keep it on your computer).
Extract the config.asp file from it.
Just like you did when you first installed the forum, make the two changes to config.asp:
1) database type (remove the apostrophe)
and
2) connection string for your database
That should put you back to square one with the config.asp file.
|
"5-in-1 Snitz Common Expansion Pack" - five popular mods packaged for easy install
". . .on a mote of dust, suspended in a sunbeam. . ."
HarborClassifieds
Support Snitz Forums
|
|
|
|
muddywellies
Junior Member
United Kingdom
156 Posts |
Posted - 06 March 2007 : 03:16:41
|
Thank you panhandler. I have retrieved my forum from the ether. I'm retiring somewhat 'battered and bruised' after my experience of (not)installing the Integration Mod on an otherwise Mod-free site during the past few days. Certainly after reading through my original post I can not comprehend where things went astray and the other Mod files remain on the server.
If anyone had a trouble-free time with the Integration Mod installation on v3.4.06 who is also not ASP code-savvy I would appreciate their comments as I would like to get the Mod installed with a view to having Adsense on my forums.
|
I've got green fingers, but I'm all thumbs using a keyboard! |
|
|
|
muddywellies
Junior Member
United Kingdom
156 Posts |
Posted - 06 March 2007 : 03:49:50
|
Eureka!! Added the Integration Mod. Problem was an apostrophe. The apostrophe, I learned, tells the browser NOT to read that particular line.
My own mistake, was that I was adding and removing the apostrophe from the line at the left side of the page which, was NOT the beginning of the line of code but in the middle of it because the complete code to which it applied was over TWO lines. My fault entirely. Apologies to everyone especially 'Panhandler' who posted on my behalf. I have been suitably humbled believe me.
Now, moving on, I can see the integration Mod is installed and of course the site is visible, working and looking no different. I shall now head off towards the search box and look up about Adsense. |
I've got green fingers, but I'm all thumbs using a keyboard! |
|
|
|
Panhandler
Average Member
USA
783 Posts |
|
| |
Topic |
|
Topic Locked
