Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_web_howto thread: ODBC connection to access mdb in readonly


Message #1 by "Rob v. Osnabrugge" <osnabrr@h...> on Mon, 14 Oct 2002 14:44:02
Dear ASP

how can I make my existing odbc connection to an Access database on the 
web-server such that the connection is set to "readonly"

Many thanks,
Rob
Message #2 by "TomMallard" <mallard@s...> on Mon, 14 Oct 2002 07:48:57 -0700
Open the ODBC mgr and click options...brings up the read-only box.

tom mallard
seattle

-----Original Message-----
From: Rob v. Osnabrugge [mailto:osnabrr@h...]
Sent: Monday, October 14, 2002 2:44 PM
To: ASP Web HowTo
Subject: [asp_web_howto] ODBC connection to access mdb in readonly


Dear ASP

how can I make my existing odbc connection to an Access database on the
web-server such that the connection is set to "readonly"

Many thanks,
Rob

---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


Message #3 by "Rob v. Osnabrugge" <osnabrr@h...> on Tue, 15 Oct 2002 20:13:18
Tom,

I did not mean via control panel, but by means of the connection string in 
an ASP page

Rob
> Open the ODBC mgr and click options...brings up the read-only box.

tom mallard
seattle

-----Original Message-----
From: Rob v. Osnabrugge [mailto:osnabrr@h...]
Sent: Monday, October 14, 2002 2:44 PM
To: ASP Web HowTo
Subject: [asp_web_howto] ODBC connection to access mdb in readonly


Dear ASP

how can I make my existing odbc connection to an Access database on the
web-server such that the connection is set to "readonly"

Many thanks,
Rob

---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


Message #4 by "TomMallard" <mallard@s...> on Tue, 15 Oct 2002 20:32:16 -0700
Add "ReadOnly=1;" to the connection string...here's an example of most of
the attributes you can set.

[ODBC]
DRIVER=Microsoft Access Driver (*.mdb)
UID=admin
UserCommitSync=Yes
Threads=3
SafeTransactions=0
ReadOnly=1
PageTimeout=5
MaxScanRows=8
MaxBufferSize=2048
FIL=MS Access
Exclusive=0
DriverId=25
DefaultDir=C:\Inetpub\root\data\kitesport.com
DBQ=C:\Inetpub\root\data\kitesport.com\ksp.mdb


tom

-----Original Message-----
From: Rob v. Osnabrugge [mailto:osnabrr@h...]
Sent: Tuesday, October 15, 2002 8:13 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: ODBC connection to access mdb in readonly


Tom,

I did not mean via control panel, but by means of the connection string in
an ASP page

Rob
> Open the ODBC mgr and click options...brings up the read-only box.

tom mallard
seattle

-----Original Message-----
From: Rob v. Osnabrugge [mailto:osnabrr@h...]
Sent: Monday, October 14, 2002 2:44 PM
To: ASP Web HowTo
Subject: [asp_web_howto] ODBC connection to access mdb in readonly


Dear ASP

how can I make my existing odbc connection to an Access database on the
web-server such that the connection is set to "readonly"

Many thanks,
Rob

---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20



---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20



  Return to Index