When I run the program and choose Datasource Type as Database/Spreadsheet, when I select the appropriate Access file I receive the following message.
SQL Error State:HY000, Native Error Code:3F, ODBC Error: [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key
'Temporary (volatile) Jet DSN for process 0x974 Thread 0xcd8 DBC 0x79cdb3c Jet'
and then after clicking OK I get the same error again. Then after clicking OK to that I can continue to the Datasource table screen.
I can complete the project and build. However, things do not work as planned. You can visit the output at www.acerail.net/project/www.acerail.net/project/
Whenever I try to View, Edit, Sort, or even go to a linked table's page using Internet Explorer I am taken to a "Page Cannot Be Found".
Sometimes after the page cannot be found if I refresh I get an error like -
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '[CustomerID]= and [CustomerID]='.
from include/Customers_dbconnection.asp
strConnection = "Proivder=MSDataShape; DRIVER={Microsoft Access Driver
(*.mdb)};DQB=E:\websites\ACERAILNET\wwwroot\database\voucher.mdb;UID=;PWD="
In the ASP pages that I have written that can read, write, and edit the SAME database I have used the following connection
objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath ("..\_database\voucher.mdb") & ";"
Thank you in advance,
Brian
