« Previous Next »

• 06-08-2009, 12:13 AM

  aloysiusjegan Joined on 06-08-2009, 4:11 AM Posts 1

  Not able to access sql linked tables from ASP page with IIS server Reply Contact I have a MS Access database with both native tables and 2 linked tables  to a local sql server (via odbc drivers) . Under MS access everything works well, i can add, delete, edit records in all tables (both native and sql linked tables)  I also have an ASP application (iis 6.0) installed and configured on the same PC and i can browse all the native MS Access tables but not the 2 sql server linked tables.  I tried to configure the ODBC connection with both sql autentication and trusted connection but nothing change, i can browse via I.E. the native MS Access tables but not the linked one's.....  I think it has something to do with the connection string.....  "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Request.ServerVariables("APPL_PHYSICAL_PATH") & "mdb-database\Agenzia.mdb"   Any help?   Thanks.

  Tags: SQL link tablesIIS server

• 06-08-2009, 9:36 AM

  In reply to

  tomkmvp Joined on 03-20-2003, 6:27 AM Central NJ Posts 6,189	Re: Not able to access sql linked tables from ASP page with IIS server Reply Contact It's hard to help since you didn't tell us exactly what "not works" means.  Your solution can likely be fouind at http://www.aspfaq.com/ ... Tom Kaminski IIS MVP http://mvp.support.microsoft.com/ http://blogs.iis.net/tomkmvp/ http://www.linkedin.com/pub/8/690/408 http://www.bluesrepublic.org/