I am having a site running asp pages.
My databases is mysql.

My big problem is that I have not found any freeware asp script for web site statistics to fully support mysql database.

All of asp scripts for web statistics, comes with an access database. Only a few come with an microsoft sql.
None of them with mysql.

I tried a lot to make some changes and tried to convert such access databases with converters, by hand etc but with no luck.

So the best solution for me is to find a good asp script that comes with mysql database. I would simply transfer the tables to my mysql database and it would instantly run, with no incompatibilities.

A good script to give me some details, not just a simple hit counter if this is possible.

I would be grateful if you could help me telling what to do, where there is such script, or even sending me such asp-mysql pack.

Thanks in advance

Anyone to help me?

Hi Karib,

Usually, using Google for these kind of queries should do the trick. If you have already search and found nothing, there may not be that much around. MySQL is used in combination with PHP much more than ASP so that may explain the limited availability of these kind of scripts.

Do you have any specific problems with the scripts you are translating? If you have a script that does what you want, changing it so it works with MySQL shouldn't be too hard.

Can you please not post these reminder messages? It clutters up the forum and people's mailboxes. If people have the answer, you'll usually get an answer. If they don't have the answer, an additional post with "Anyone to help me?" (which was already clear from the first post) is not really going to help.
Sometimes it may take a while before you get an answer, but that's usually a time zone issue. I was asleep when you posted your first and your second message......

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

I am sorry for the additional posting.

I have searched google, hotscripts.com etc so much.
It's a pity, asp scripts has not much support for mysql.
Access databases are not really professional as they do not support many users.
Ms sql on the other hand, has limited support from most hosting companies, and has to be purchased.

But like I said, it shouldn't be too bard to convert an existing script to work with MySQL.

Do you have a particular script and functionality in mind?

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thanks for your response.

I am dissapointed in mysql support from asp language and programmers.
Believe me I tried a lot to do my task with the existing asp-access scripts.

I used the statcountx asp script. It is well Known, I was very pleased from them, it had all I wanted. It had access database. I had all my site to mysql except from these statistics. Someday, the site was slow down. Me and other people searched to find out what the problem was the access. As my site had more traffic, access was too bad, slowing everything down. From the momment I removed the access db and statistics (that's the point), no such problems ever occured.

Now I am looking to metasun.com .
They seem to do fine work, access db and ms sql once again, they told that the new version will support mysql(Thanks God). But I wait for this version over 5 months!
I sent email to them, the cannot tell a date. So, I have not any point to believe it will be out soon. Maybe at the end of 2004!

I think only few people have made the search I made about asp+mysql+web statistics.

I 've seen and tested so many scripts from so many sites. (aspobjects.com, aspin.com, hotscripts.com, google etc)
No luck.
So I gave up.

I need an asp script with native mysql support.
Or someone with experience that already has converted succesfully(where is such person?) one of these scripts.

This situation make me wonder why do I had developed all my site to asp instead of php.

That's all.

Thank you.

I forgot to say how many days I tried to cope with the error these asp-access scripts gave me during this process of upgrading them to run smoothly with myslq.
Just to do absolutely nothing in the end.

Ha, yes, the right tool for the right job, right ;)

But seriously, ASP can do what PHP can do. IMO, this is not really the problem of ASP, but of Access. Access is not designed to handle lots and lots of users. Depending in the type of application, it will slow down considerably after 20 to 25 users. SQL Server is much better in these scenario's

What I don't get is why converting the script should be so hard. The ADO layer in ASP abstract most of the database access anyway, so executing a SELECT or UPDATE statement is roughly the same for all databases. Would you like to give it a try, or do you want a ready-made script?

Were you ever able to fix this problem: http://p2p.wrox.com/topic.asp?TOPIC_ID=11232 ?

Cheers,

Imar



---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

What a pity. It shouldn't be that difficult, I would say. Like I said, would you like to give it another try, or are you looking for a finished product now? What kind of errors did you get?

Were you ever able to fix this problem: http://p2p.wrox.com/topic.asp?TOPIC_ID=11232 ?


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thanks for your response.

I want a ready-made script. After having spent so much time trying to make things work, now I don't give even a second to do it again.
But I need it.
My hosting company runs webalizer stats. But it gives us the statistics only on weekly basis! This is bad for me. When I had this access stats, it was not only on daily basis, it was realtime!



As far as this problem: http://p2p.wrox.com/topic.asp?TOPIC_ID=11232
I stucked because the message was always visble.
When the recordset was empty, it appears. (so it works)
When not, it appears to (but why?).
I made it many times with no success.



If i had a ready-made asp script-mysql, it would be the best thing


Thanks in advance