Deploying ADP on IIS problem

  • Thread starter Thread starter Rac
  • Start date Start date
R

Rac

Hi,
I'm trying to make the web application on IIS by using mdb file.
I've set up the environment as described in documents found on the internet,
but when I open the page, I get the error 'An error occured trying to use
"TABLE_NAME". Check too see that the object exists'.
It seems that the page finds the connection to database, but it doesn't find
the table.

Page settings
ConnectionString: ...DataSource=http://servername/MyApp/database.mdb
UseRemoteProvider=True

If the mdbpath is set to C:\folder\database.mdb and UseRemoteProvider=False,
I can get the data, but only on the machine where the IIS is installed.

I'v tried to use DataSource=\\servername\MyApp\database.mdb but it doesn't
work.

Can anybody tell me what have I to set to reach the database on IIS by using
ADP?

thanks
 
a mdb is not an ADP.
and if your using an ADP then go striaght to the SQL server using

var WEBSQL = Server.CreateObject("ADODB.Connection");
WEBSQL.Open( "Driver={SQL Server};Server=DNS or
IP;Database=dbname;UID=SQLuserID;PWD=SQLPSWD");
 
Better to ask in the Access news group.

Rac said:
Sorry, I mean DAP (Data Access Pages), not ADP Project.
These are the html pages built with Access 2000 used for returning data from
database to which has direct access the http server.

Procedures for deploying this kind of pages is described at
http://www.msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k
2/html/deploydap.asp,
http://support.microsoft.com/default.aspx?kbid=291783,
but this doesn't work in my environment.
 
Back
Top