Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Poll Mod, setup problem		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

roseda
Starting Member

8 Posts
Posted - 18 December 2004 :  22:35:55  Show Profile
After I install Poll Mod, v 2.0.7 as per the red me file.
I get an error from the when I select Poll Configuration in the Admin Options. The error is:

Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'FORUM_POLLS'. Make sure it exists and that its name is spelled correctly.

/ASPForum/admin_poll.asp, line 152

Any ideas on what would cause this?

Thank you in advance for any assistance.
Yours,
Dale Rose

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 19 December 2004 :  01:20:19  Show Profile
Did you run the Mod Setup to install the database tables?
Did it run without any errors?
Are you using the Access 2000 connection string in your config.asp file? If not, you need to use it.
Support Snitz Forums
Go to Top of Page

roseda
Starting Member

8 Posts
Posted - 19 December 2004 :  22:15:16  Show Profile
It seemed to upgrade fine. The only red areas where the last two indicated that the table alread existed.
Here is a pic:



I ran the uninstall and ran the install again and got the same results.

I am running an Access database with a connectionless DSN.

Thanks for the assistance.
Yours,
Dale Rose
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 19 December 2004 :  22:18:15  Show Profile
Try using an Access 2000 connection string instead. That should solve the problem. I am guessing the DSN connection is using Access 97 drivers which cause this problem.
Support Snitz Forums
Go to Top of Page

roseda
Starting Member

8 Posts
Posted - 20 December 2004 :  13:29:03  Show Profile
Do I request this done via my webhosting service or do I make changes in a file?

Appreciate the assistance.
Yours,
Dale Rose
Go to Top of Page

PeeWee.Inc
Senior Member

United Kingdom
1893 Posts
Posted - 20 December 2004 :  14:00:24  Show Profile  Visit PeeWee.Inc's Homepage
Make the change to config.asp
De Priofundus Calmo Ad Te Damine
Go to Top of Page

roseda
Starting Member

8 Posts
Posted - 20 December 2004 :  16:38:06  Show Profile
What do I need to add to my current connection string?
Current string is:
strConnString = "DSNname" '## DSN

Appreciate the assistance.
Yours,
Dale Rose
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 20 December 2004 :  17:46:24  Show Profile
This is the connection string you need to use:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 2000
Just enter in the location of your database. Use the whereami.asp page to help you find the location of your database, if you are not sure. Or ask your host.
Support Snitz Forums
Go to Top of Page

roseda
Starting Member

8 Posts
Posted - 20 December 2004 :  20:57:01  Show Profile
I was able to determine the server path with whereami and then make the DSN connection string.
Works fine now.

Thanks for the assistance.
Yours,
Dale Rose
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.31 seconds. Powered By: Snitz Forums 2000 Version 3.4.07