Linking to access tables -
07-08-2004
, 01:03 PM
Hi again.
Had some success yesterday pulling data from a Access mdb that was located in
a folder in the WWWRoot folder. I then wanted to see if I could have a front
end mdb somewhere on the network and link the tables to the web mdb but because
it is on the other side of the DMZ this would not work so it looks like I shall
have to go the way of using DSN. As a newbie this is causing some problems, i'm
getting this error message on the website,
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
/data.asp, line 8
I checked the code for data.asp and it points to another ASP file,
testdata.asp which looks fine but it refers to an htm file,
Connection_odbc_conn_dsn.htm, which I cannot locate anywhere. Can any pass me
any advice on what is wrong and how I can resolve this ?
Thanks in advance,
Mitch.... |