Has anyone tried this before? Have a DSN connection to an access database on a Windows server, while your forum files are on a Unix host with ChiliASP? I contacted ChiliASP developers and they said that's the only way to use an Access database on a Unix host. They said it should work.
Unfortunately, I have some problems with the rs.absolutepage and the rs.pagecount. It seems to be closing the record set whenever you access these 2 methods. This results in only the topic being shown on the topic.asp page. The replies don't show up.
I have heard this works, but I don't have any direct experience with doing it.
Does the ODBC driver to the Access database come as part of Chilisoft? I'm asking because I'm trying to set up ODBC to/from PostgreSQL and I need to get a unix odbc manager as well as the odbc driver.
I don't think the chilliAsp data drivers support those two methods, so you would need to fool the forum into thinking your db was a mysql db
What exactly do you mean, fool the forum into thinking the DB is MySQL Huw? MySQL handles paging differently and I don't think Access would like to do it that way .
Anyway I noticed that you guys never use client side cursors with paging. Maybe I'll try that and see how it works.
Topic Locked
Posted - 09 August 2002 : 01:51:25
.
Nathan Bales