old asp web app: access to SQL express


i have older asp web application (not .net)  connects access database , reads tables.  .mdb file resides on web server, along asp page.  access db going away, , tables have been re-created in sql express.  need figure out how connect , read tables either existing non dot.net asp application, or new php application.

i have read post

faq: how connect sql express "downlevel clients"(access 2003, vs 2003, vb 6, etc(basically not using .net 2.0 or new sql native client))

some more fundamental questions are:
1)  can upload the sql express mdf file iis server, , connect stand-alone file (like access mdb file)?  *** note: sql express not installed on server, standalone mdf file uploaded)
1)a)  if yes, additional code need?  unsuccessful in using following connection string
set conntemp=server.createobject("adodb.connection")
connectionstring="data source=.\sqlexpress;integrated security=true;user instance=true;attachdbfilename=sonnys_inventory.mdf"
conntemp.open connectionstring

1)b) if no - need install sql express on iis server.  upload mdf file server , "attach" through sql management program , follow directions in post mentioned above?

thanks help.


1) no.

1b) can either attach , use server attached database instance, or create user instance (which new features of sql server express)

another way use sql server compact edition has inprocess database engine , not need install anything. engine loaded upon first request. supports functionality of sql server express, though limited in way.

see sql server compact pages on ms site more information.

jens k. suessmeyer.

---
http://www.sqlserver2005.de
---


SQL Server  >  SQL Server Express



Comments

Popular posts from this blog

Conditional formatting a graph vertical axis in SSRS 2012 charts

Register with Power BI failed

SQL server replication error Cannot find the dbo or user defined function........