Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_database_setup thread: Connection.Properties, FolderProperties


Message #1 by "Stavros Nicolakopulos" <rezebric@h...> on Fri, 2 Mar 2001 12:10:55 +0200

------=_NextPart_001_0003_01C0A311.D515A170

Content-Type: text/plain; charset="iso-8859-7"

Content-Transfer-Encoding: quoted-printable



I create a connection to an Access database located in my computer (C:\Da

tastores\*.mdb). When I display the Connection's Properties, the Property

("Server Name") is not avalaible. I'm working on Windows 2000 pro with II

S 5

installed.



The other problem is the follow :

-------------------------------------------------------------------------

-----------------

<% Option Explicit %>

<HTML>

<HEAD>

<TITLE>Record Object</TITLE>

</HEAD>

<BODY>

<%

Dim objNodeRecord, objNodeField

Set objNodeRecord =3D3D Server.CreateObject("ADODB.Record")

objNodeRecord.Open  " ", "URL=3D3Dhttp://www.wrox.com/"

Response.Write "<H2>Properties of the folder:</H2>"

Response.Write "<TABLE BORDER=3D3D'1'>"

  For Each objNodeField In objNodeRecord.Fields

   Response.Write "<TR>" & "<TD>" & objNodeField.Name & "</TD>" & _

      "<TD>" & objNodeField.Value & "</TD>" & "</TR>"

  Next

Response.Write "</TABLE>"

objNodeRecord.Close

Set objNodeRecord =3D3D Nothing

%>

</BODY>

</HTML>

-------------------------------------------------------------------------

--------------------

When I open the above *.asp file I get a

.

.

.

.

HTTP 500.100 - Internal Server Error - ASP error

Internet Information Services







Technical Information (for support personnel)





Error Type:

Microsoft OLE DB Provider for Internet Publishing (0x80004005)

Unspecified error

/UpgradesDB/record.asp, line 10



Browser Type:

Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) =3D20



Page:GET /UpgradesDB/record.asp =3D20

.<br clear=3Dall><hr>Get Your Private, Free E-mail from MSN Hotmail at <a

 href=3D"http://www.hotmail.com">http://www.hotmail.com</a>.<br></p>





  Return to Index