Error: 429

[lcarocha]

Hi, I have a problem with Error 429, I read a locked thread about the same problem (http://forums.pcwintech.com/index.php/topic,1098.msg4691.html#msg4691) tried some of the tools suggested but I still cant get SPF to work.
Could please help with the issue at hand since I really love this program (I have been using it for some time at my small business).

Thanks

[Shane]

The program uses ADO (By Microsoft) to read the router database.
The problem is on your system ADO is messed up for some reason.

I take it you tried the MDAC repair tool on my toolbox page?

Shane

[lcarocha]

Yup.. used it, rebooted but no go.   

[Shane]

What version of windows are you on?

Shane

[lcarocha]

Win 7 x64 on a D-Link DIR-655. SPF latest version.

[Shane]

I was wondering why the other forum thread was locked, forgot I have it set to auto lock after 30 days of no replies lol.

Anyways on this one
http://forums.pcwintech.com/index.php/topic,1098.msg4690.html#msg4690

I was telling him about the size differences. Can you check yours as well?

Should be easy for us to find the right files to download and replace off the net.

Shane

[lcarocha]

As a matter of fact I went through every step mentioned in the locked thread before opening this one and all the file sizes of the ADO matched the ones you had (according to the other thread). I D/L the M$ tool to repair the ADOs (even though the tool is not designed for Win7) and Im still getting the error

[Shane]

What does my MDAC test tool on my toolbox show?

Shane

[lcarocha]

Ill get back to you with that info as soon as I get home. Thanks

[lcarocha]

Sorry I did get back to you yesterday, we had a massive power failure in the block and I didnt have electricity until 20:32 today.
Anyway, here is the result

Starting Test.
Date: 06-Apr-10 Time: 23:09:15
''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Connecting To Test.mdb using DAO...
--Successful
Opening Table...
--Successful
Closing connection to the database.
--Successful
''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Connecting To Test.mdb using ADO...
ERROR!: 91 - Object variable or With block variable not set
''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Done, Test Complete.
'''''''''''''''''''''''''''''''''''''''''''''''''''''''

[Shane]

What a pain this can be some times.
I have an idea though. I use to have the program use DAO, some people had that corrupt. I moved to ADO. Same thing. The funny thing is I haven't had anyone who had both messed up at the same time.

So the question is, how do I keep this from happening? I have an idea 

I can make a new version of Simple Port Forwarding that can use both ADO and DAO. As the program tries to connect to the database with ADO and it detects an error then it will DAO instead. If it still gets a 2nd error then it will tell the user. But this way the program will try both first, thus saving my users and me a lot of unneeded headache.

What are your thoughts?

Shane

[lcarocha]

Sounds just about right.
Eventhough I have VERY basic networking knowledge and dont have a clue on what the ADO and DAO files do it is clear that if you can make it work with either of them then why not go for it? its like taking and alternate route to the supermarket, they will be different but in the end they will get you where you want to go

[Shane]

I am actually working on it now, lots of work to do to have it do both. I should have something in a few hours. Want to test it for me when I am done? since ADO is broke on your system you would be a great test for it.

Shane

[Shane]

Ok all done. Just need it tested by you before I release it.

Download the zip file. Extract the new spf.exe, then replace the old spf.exe with this one. Give it a try and see if the database will load for you now.

Let me know as soon as you can so I can release it if it works. 

Shane

[attachments over 25 days old deleted by admin]

[lcarocha]

You are the best. The new .exe works ok. I have access to my router and everything seems to be in working order. Ill be trying some stuff (port forwarding etc ) and Ill let you know