Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 2nd, 2004, 11:19 AM
Registered User
 
Join Date: Nov 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default JET database Engine and Access

I try to connect from my ASP page to an access database which is on a server on network.
My code is hereQ
  set cn=server.CreateObject("ADODB.connection")
  set rs=server.CreateObject("ADODB.recordset")
  cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=//Info/db_pepdym/pepdym.mdb"

  rs.Open "SELECT * FROM tblCalls", cn, 1, 1
  If not rs.EOF then
    rs.movefirst
    Do while not rs.EOF
  Response.Write "<b>" & rs("Id") & "</b>" &" "
  Response.Write "<b>" & rs("Title") & "</b>" & "<br>"
   rs.movenext
  Loop
  end if
  cn.Close
  But it doesnt work. I think the The problem is that the database is on the network. What can i do?

 
Old November 2nd, 2004, 07:04 PM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 303
Thanks: 0
Thanked 0 Times in 0 Posts
Default

why don't you create a DSN on you server?
 
Old November 3rd, 2004, 03:52 AM
Registered User
 
Join Date: Nov 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

i tried before to use a DSN but the problem remain. As i Know teh netive OLEDB provider is better.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft JET Database Database Engine (0x80040E09 cannielynn0312 Classic ASP Professional 2 December 17th, 2007 02:50 AM
Microsoft JET Database Engine (0x80040E09) u813222 Classic ASP Professional 12 April 3rd, 2007 01:27 PM
JET Database Engine Error amit_palrecha Classic ASP Databases 7 February 8th, 2007 03:50 AM
Microsoft JET Database Engine (0x80040E07) gwalker_ne8 Classic ASP Databases 2 November 11th, 2006 09:32 AM
NEW: Microsoft JET Database Engine error'80040e14' rishinicolai Classic ASP Databases 4 December 13th, 2005 05:58 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.