|
 |
asp_databases thread: RE: Database path Connection chapter 15 - sample
code
Message #1 by "raind ray" <raind@m...> on Thu, 25 Jul 2002 16:59:29
|
|
> I do not understand what you mean by Tools/ Internet Options/ Advanced/
Unitck 'Dispaly Friendly HTTP errors'. Could you explain more or tell me
by using an example? Thank You..Ray reply
Tools/ Internet Options/ Advanced/ Untick 'Display Friendly HTTP errors'
Thanks
Sam
-----Original Message-----
From: raind ray [mailto:raind@m...]
Sent: 24 July 2002 18:20
To: ASP Databases
Subject: [asp_databases] Database path Connection chapter 15 - sample
code
Hello there,
I need you guys help as the following code. I found and error of "HTTP 500-
Internal server error" . am not sure about the path used. I am using
subcribe server and therefore can you tell me what should i put in order
to connect to the database.
my database name is donorcard.mdb
my site address is http://203.123.246.17/project/ (for example)
i have to upload all my files to the subsribed server.
<!-- METADATA TYPE="typelib"
FILE="C:\Program Files\Common Files\System\ado\msado15.dll" -->
** What should I write on the above path instead of the default C:\prog...
in the book ****
<%
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open = "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=E:\datastore\donorcard.mdb"
**** As well the datasource path, the default was shown on
above and I do not know what for the path should I write in my case? ***
Message #2 by "Kim Iwan Hansen" <kimiwan@k...> on Fri, 26 Jul 2002 18:16:33 +0200
|
|
Make sure you include the typelib correctly:
http://www.asp101.com/articles/john/typelibs/default.asp
-Kim
> -----Original Message-----
> From: raind ray [mailto:raind@m...]
> Sent: 26. juli 2002 15:30
> To: ASP Databases
> Subject: [asp_databases] RE: Database path Connection chapter 15 -
> sample code
>
>
> Dear sam,
> Thank you for your kindly reply. Yes, the browser showing the error more
> details this time. It would be :
>
> Active Server Pages error 'ASP 0224'
>
> Cannot load TypeLib
>
> /project/Clssfd.asp, line 1
>
> Cannot load Type Library specified in the METADATA tag.
>
> When I click on the submit button, it should go to AddUser.asp page and
> adding the record to the database. The code as below:
> File name: AddUser.asp
> -----------------------
> <!--#include file="Clssfd.asp"-->
> <%
> Dim rsUsers
> Set rsUsers = Server.CreateObject("ADODB.Recordset")
> rsUsers.Open "Member", objConn, adOpenForwardOnly,
> adLockOptimistic, adCmdTable
> .......
>
> Filename: Clssfd.asp
> --------------------
> <!-- METADATA TYPE="typelib"
> FILE="project/msado15.dll" -->
>
> <%
> Dim objConn
> Set objConn = Server.CreateObject("ADODB.Connection")
> objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
> "Data Source= project/donarcard.mdb"
>
> If Session("blnValidUser") = True and Session("MemberID") = "" Then
> Dim rsMemberIDCheck
> set rsMemberIDCheck = Server.CreateObject
> ("ADODB.Recordset")
> Dim strSQL
> ......
>
> Cheers mate!
>
> /Ray
>
>
>
> > I suppose he means go into internet explorer tools menu option inside
> there will be a button called internet option clisk advanced then click
> advanced u will get a check boxes where uncheck
> display friendly http errors
>
> hope this helps
> sid
>
> -----Original Message-----
> From: raind ray [mailto:raind@m...]
> Sent: Thursday, July 25, 2002 12:59 PM
> To: ASP Databases
> Subject: [asp_databases] RE: Database path Connection chapter 15 -
> sample code
>
>
>
>
> > I do not understand what you mean by Tools/ Internet Options/
> Advanced/
> Unitck 'Dispaly Friendly HTTP errors'. Could you explain more or tell me
>
> by using an example? Thank You..Ray reply
>
> Tools/ Internet Options/ Advanced/ Untick 'Display Friendly HTTP errors'
>
> Thanks
> Sam
>
> -----Original Message-----
> From: raind ray [mailto:raind@m...]
> Sent: 24 July 2002 18:20
> To: ASP Databases
> Subject: [asp_databases] Database path Connection chapter 15 - sample
> code
>
>
> Hello there,
>
> I need you guys help as the following code. I found and error of "HTTP
> 500-
> Internal server error" . am not sure about the path used. I am using
> subcribe server and therefore can you tell me what should i put in order
>
> to connect to the database.
>
> my database name is donorcard.mdb
> my site address is http://203.123.246.17/project/ (for example)
> i have to upload all my files to the subsribed server.
>
>
>
>
>
> <!-- METADATA TYPE=3D"typelib"
> FILE=3D"C:\Program Files\Common Files\System\ado\msado15.dll" -->
>
> ** What should I write on the above path instead of the default
> C:\prog...
> in the book ****
>
> <%
> Dim objConn
> Set objConn =3D Server.CreateObject("ADODB.Connection")
> objConn.Open =3D "Provider=3DMicrosoft.Jet.OLEDB.4.0; " & _
> "Data Source=3DE:\datastore\donorcard.mdb"
> **** As well the datasource path, the default was shown on
>
> above and I do not know what for the path should I write in my case? ***
>
Message #3 by "raind ray" <raind@m...> on Fri, 26 Jul 2002 15:29:40
|
|
Dear sam,
Thank you for your kindly reply. Yes, the browser showing the error more
details this time. It would be :
Active Server Pages error 'ASP 0224'
Cannot load TypeLib
/project/Clssfd.asp, line 1
Cannot load Type Library specified in the METADATA tag.
When I click on the submit button, it should go to AddUser.asp page and
adding the record to the database. The code as below:
File name: AddUser.asp
-----------------------
<!--#include file="Clssfd.asp"-->
<%
Dim rsUsers
Set rsUsers = Server.CreateObject("ADODB.Recordset")
rsUsers.Open "Member", objConn, adOpenForwardOnly,
adLockOptimistic, adCmdTable
.......
Filename: Clssfd.asp
--------------------
<!-- METADATA TYPE="typelib"
FILE="project/msado15.dll" -->
<%
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source= project/donarcard.mdb"
If Session("blnValidUser") = True and Session("MemberID") = "" Then
Dim rsMemberIDCheck
set rsMemberIDCheck = Server.CreateObject
("ADODB.Recordset")
Dim strSQL
......
Cheers mate!
/Ray
> I suppose he means go into internet explorer tools menu option inside
there will be a button called internet option clisk advanced then click
advanced u will get a check boxes where uncheck
display friendly http errors
hope this helps
sid
-----Original Message-----
From: raind ray [mailto:raind@m...]
Sent: Thursday, July 25, 2002 12:59 PM
To: ASP Databases
Subject: [asp_databases] RE: Database path Connection chapter 15 -
sample code
> I do not understand what you mean by Tools/ Internet Options/
Advanced/
Unitck 'Dispaly Friendly HTTP errors'. Could you explain more or tell me
by using an example? Thank You..Ray reply
Tools/ Internet Options/ Advanced/ Untick 'Display Friendly HTTP errors'
Thanks
Sam
-----Original Message-----
From: raind ray [mailto:raind@m...]
Sent: 24 July 2002 18:20
To: ASP Databases
Subject: [asp_databases] Database path Connection chapter 15 - sample
code
Hello there,
I need you guys help as the following code. I found and error of "HTTP
500-
Internal server error" . am not sure about the path used. I am using
subcribe server and therefore can you tell me what should i put in order
to connect to the database.
my database name is donorcard.mdb
my site address is http://203.123.246.17/project/ (for example)
i have to upload all my files to the subsribed server.
<!-- METADATA TYPE=3D"typelib"
FILE=3D"C:\Program Files\Common Files\System\ado\msado15.dll" -->
** What should I write on the above path instead of the default
C:\prog...
in the book ****
<%
Dim objConn
Set objConn =3D Server.CreateObject("ADODB.Connection")
objConn.Open =3D "Provider=3DMicrosoft.Jet.OLEDB.4.0; " & _
"Data Source=3DE:\datastore\donorcard.mdb"
**** As well the datasource path, the default was shown on
above and I do not know what for the path should I write in my case? ***
Message #4 by "Roy, Siddarth S" <sroy@b...> on Thu, 25 Jul 2002 11:59:19 -0400
|
|
I suppose he means go into internet explorer tools menu option inside
there will be a button called internet option clisk advanced then click
advanced u will get a check boxes where uncheck
display friendly http errors
hope this helps
sid
-----Original Message-----
From: raind ray [mailto:raind@m...]
Sent: Thursday, July 25, 2002 12:59 PM
To: ASP Databases
Subject: [asp_databases] RE: Database path Connection chapter 15 -
sample code
> I do not understand what you mean by Tools/ Internet Options/
Advanced/
Unitck 'Dispaly Friendly HTTP errors'. Could you explain more or tell me
by using an example? Thank You..Ray reply
Tools/ Internet Options/ Advanced/ Untick 'Display Friendly HTTP errors'
Thanks
Sam
-----Original Message-----
From: raind ray [mailto:raind@m...]
Sent: 24 July 2002 18:20
To: ASP Databases
Subject: [asp_databases] Database path Connection chapter 15 - sample
code
Hello there,
I need you guys help as the following code. I found and error of "HTTP
500-
Internal server error" . am not sure about the path used. I am using
subcribe server and therefore can you tell me what should i put in order
to connect to the database.
my database name is donorcard.mdb
my site address is http://203.123.246.17/project/ (for example)
i have to upload all my files to the subsribed server.
<!-- METADATA TYPE=3D"typelib"
FILE=3D"C:\Program Files\Common Files\System\ado\msado15.dll" -->
** What should I write on the above path instead of the default
C:\prog...
in the book ****
<%
Dim objConn
Set objConn =3D Server.CreateObject("ADODB.Connection")
objConn.Open =3D "Provider=3DMicrosoft.Jet.OLEDB.4.0; " & _
"Data Source=3DE:\datastore\donorcard.mdb"
**** As well the datasource path, the default was shown on
above and I do not know what for the path should I write in my case? ***
Message #5 by Sam Clohesy <sam@e...> on Wed, 24 Jul 2002 17:16:55 +0100
|
|
Tools/ Internet Options/ Advanced/ Untick 'Display Friendly HTTP errors'
Thanks
Sam
-----Original Message-----
From: raind ray [mailto:raind@m...]
Sent: 24 July 2002 18:20
To: ASP Databases
Subject: [asp_databases] Database path Connection chapter 15 - sample
code
Hello there,
I need you guys help as the following code. I found and error of "HTTP 500-
Internal server error" . am not sure about the path used. I am using
subcribe server and therefore can you tell me what should i put in order
to connect to the database.
my database name is donorcard.mdb
my site address is http://203.123.246.17/project/ (for example)
i have to upload all my files to the subsribed server.
<!-- METADATA TYPE="typelib"
FILE="C:\Program Files\Common Files\System\ado\msado15.dll" -->
** What should I write on the above path instead of the default C:\prog...
in the book ****
<%
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open = "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=E:\datastore\donorcard.mdb"
**** As well the datasource path, the default was shown on
above and I do not know what for the path should I write in my case? ***
Message #6 by "raind ray" <raind@m...> on Wed, 24 Jul 2002 17:19:56
|
|
Hello there,
I need you guys help as the following code. I found and error of "HTTP 500-
Internal server error" . am not sure about the path used. I am using
subcribe server and therefore can you tell me what should i put in order
to connect to the database.
my database name is donorcard.mdb
my site address is http://203.123.246.17/project/ (for example)
i have to upload all my files to the subsribed server.
<!-- METADATA TYPE="typelib"
FILE="C:\Program Files\Common Files\System\ado\msado15.dll" -->
** What should I write on the above path instead of the default C:\prog...
in the book ****
<%
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open = "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=E:\datastore\donorcard.mdb"
**** As well the datasource path, the default was shown on
above and I do not know what for the path should I write in my case? ***
|
|
|
View Cart
