[HELP] - Is is possible to access MsAccess database from an html page? - GoFuckYourself.com

Blackrose · 12-05-2002, 07:53 PM

Now lets see how this board is helpful ... =)

I have this problem in my thesis. I was thinking if it is possible to read, write, delete records in a MS Access database from an html page ... think it is possible ?

Please direct me to a page that contains such info.

Thanks

bawdy · 12-05-2002, 07:56 PM

yeah u need to learn asp

http://hotwired.lycos.com/webmonkey/programming/asp/

Blackrose · 12-05-2002, 09:51 PM

thanks ... any more peeps want to lend a hand ?

lEricPl · 12-05-2002, 10:22 PM

Here is a simple way to display data from an Access DB using a 'DataReader' in VB.NET for an ASP.NET page.

PS -- Regular ASP is thing of the past.

As for updating/deleting and such, buy a good book. 'ASP.NET Unleashed' is great.

=====================
Imports System.Data.OleDb 'Note: First you need to import the System.Data.OleDb Class.

'Note: Then set the variables and complete the conn.
Dim strConn As String = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\data\data1.mdb;"
Dim strSQL As String = "Select * From table1"
Dim Conn As New OleDbConnection(strConn)
Dim Cmd As New OleDbCommand(strSQL, Conn)
Conn.Open()

'Note: Then you can Bind to a Repeater, DataGrid, or any other control.

Repeater1.DataSource = Cmd.ExecuteReader(System.Data.CommandBehavior.Clos eConnection)
Repeater1.DataBind()
=====================

I use Visual Studio.NET, but check in to ASP.NET Web Matrix -- It's a free tool by Microsoft to build ASP.NET Web Pages in C# or VB.NET.

Also, check out SQL Server -- much better than Access.

psyko514 · 12-05-2002, 10:24 PM

forget asp and access
move on to php and sql

lEricPl · 12-05-2002, 10:28 PM

Why go with PHP when you can build web pages with:

C++
C#
COBOL
EIFFEL
Jscript
Python
VisualBasic.NET

...And Many More.

ASP.NET and XML Web Services are the MOST powerful things to hit the Internet -- ever.

Trust me. Wait and see.

The power once only seen in Desktop Applications is now right in an ASP.NET web page.

psyko514 · 12-05-2002, 10:35 PM

all hail microsoft!

FATPad · 12-05-2002, 10:38 PM

Quote:

Originally posted by lEricPl
Why go with PHP when you can build web pages with:

C++
C#
COBOL
EIFFEL
Jscript
Python
VisualBasic.NET

...And Many More.

ASP.NET and XML Web Services are the MOST powerful things to hit the Internet -- ever.

Trust me. Wait and see.

The power once only seen in Desktop Applications is now right in an ASP.NET web page.

There a sample page anywhere of an ASP.NET page that showcases all this power?

psyko514 · 12-05-2002, 10:44 PM

and why would i need to harness the power of desktop applications into a webpage?
so i can make an online word processor? forget php/sql, i can do that with java.
or perhaps an online graphics program? or an online web browser, where someone can open up IE, visit my webpage, and then surf the web thru my webpage.

the possibilities are endless!

lEricPl · 12-05-2002, 10:58 PM

Sorry guys -- I'm not going to argue the differences of Java, PHP and .NET.

Java is very solid, and PHP is a tight scripting language.

I do use PHP on a regular basis, and we have some very hardcore Java programmers over at SitePass.

If you just want to simply display/edit/delete simple data, I would use PHP.

If I wanted to build a solid Web Application, I personally would use ASP.NET.

FiReC · 12-05-2002, 11:00 PM

cold fusion is also an option!

lEricPl · 12-05-2002, 11:05 PM

I never really got in to Cold Fusion that much -- but if it does the trick, cool

Can't forget about Perl now can we?

Rory · 12-05-2002, 11:22 PM

Quote:

Originally posted by lEricPl
I never really got in to Cold Fusion that much -- but if it does the trick, cool

Can't forget about Perl now can we?

Show me something that I cant build in php that I would wanna do on the web. Your blowing smoke out of your butt , php owns you and your a newB Hax0r. Seriously though , you seem to be blabbering and saying nothing other than naming a few coding languages. If it needs to be done, it can be done with php, if you wanna make pointless video game snippets use flash, at least everyone can play it.

pimpshost · 12-06-2002, 02:59 AM

Quote:

Show me something that I can't build in php that I would wanna do on the web. Your blowing smoke out of your butt , php owns you and your a newB Hax0r. Seriously though , you seem to be blabbering and saying nothing other than naming a few coding languages. If it needs to be done, it can be done with php, if you wanna make pointless video game snippets use flash, at least everyone can play it.

Blackrose was a customer of mine, but left because of Myle's fuck ups. It sucked for Blackrose to go, but I can say, he knows what he is doing. If he is asking a question, you should answer it. Maybe next time you have a question, he'll have something for you. Based on my experiences, he got a server, pushed bandwidth and it grew quickly. That means, he know what he is doing. He is definately not a newbie.

If you are growing your traffic, good for you, but you might as well answer the question if you know whats up. It seems there is always someone on GFY that has the answer. There is also always someone on GFY who dosen't have the answer, just a bunch of bullshit to throw out.

Here is my answer: Blackrose, if you want info on NT stuff, go to www.brainbuzz.com, they are a company located in the south and it seems their main focus is NT. They had a lot of MS developers and a huge knowlede DB. You will probably get any answers you need there very quick.

If you get the chance, hit me up on ICQ. See you in Vegas, hopefully.

Blackrose · 12-06-2002, 04:41 AM

Thanks Jason =)

It actually sucked a lot leaving you guys ... I have to agree you gave me some awesome service there especially with Andre ... but i just cant take the fuckups caused by Myles ...

We could surely do business again in the near future ... and if time permits ... yes, ill see you in vegas =)

Now, on my question ... the reason i need to know how is that im planning to use html in my baby thesis instead of using VB ... sure i know how to read/write from and mdb thru VB proggie ... but i want more interaction ... so i thought of using html ... ive also read somewhere that flash can access a mdb database ... but i wouldnt bother with flash ... just some simple html would do ... if possible =)

Rory · 12-06-2002, 12:03 PM

Quote:

Originally posted by pimpshost

Blackrose was a customer of mine, but left because of Myle's fuck ups. It sucked for Blackrose to go, but I can say, he knows what he is doing. If he is asking a question, you should answer it. Maybe next time you have a question, he'll have something for you. Based on my experiences, he got a server, pushed bandwidth and it grew quickly. That means, he know what he is doing. He is definately not a newbie.

If you are growing your traffic, good for you, but you might as well answer the question if you know whats up. It seems there is always someone on GFY that has the answer. There is also always someone on GFY who dosen't have the answer, just a bunch of bullshit to throw out.

Here is my answer: Blackrose, if you want info on NT stuff, go to www.brainbuzz.com, they are a company located in the south and it seems their main focus is NT. They had a lot of MS developers and a huge knowlede DB. You will probably get any answers you need there very quick.

If you get the chance, hit me up on ICQ. See you in Vegas, hopefully.

Your a fuckiong retard , I was replying to that Eric dude, look at the quote on my reply.

Blackrose , html cannot talk to a database, use asp, php, ssi, etc. You can write html and use the include to pull your database info out. php.net man , great new langauge that allows html to be dynamic - its amazing.

Rory

12-05-2002, 07:53 PM	#1
Blackrose Confirmed User Join Date: Aug 2001 Location: Carnal City Posts: 344	[HELP] - Is is possible to access MsAccess database from an html page? Now lets see how this board is helpful ... =) I have this problem in my thesis. I was thinking if it is possible to read, write, delete records in a MS Access database from an html page ... think it is possible ? Please direct me to a page that contains such info. Thanks __________________ The die is cast... The dice are rolled... You look like shit... I feel like gold -- Uh, me?

12-05-2002, 09:51 PM	#3
Blackrose Confirmed User Join Date: Aug 2001 Location: Carnal City Posts: 344	thanks ... any more peeps want to lend a hand ? __________________ The die is cast... The dice are rolled... You look like shit... I feel like gold -- Uh, me?

12-05-2002, 10:28 PM	#6
lEricPl Confirmed User Join Date: Dec 2002 Location: FL Posts: 1,062	Why go with PHP when you can build web pages with: C++ C# COBOL EIFFEL Jscript Python VisualBasic.NET ...And Many More. ASP.NET and XML Web Services are the MOST powerful things to hit the Internet -- ever. Trust me. Wait and see. The power once only seen in Desktop Applications is now right in an ASP.NET web page. Last edited by lEricPl; 12-05-2002 at 10:34 PM..

12-05-2002, 11:00 PM	#11
FiReC Confirmed User Industry Role: Join Date: Jan 2002 Location: Land o Nubiles Posts: 2,350	cold fusion is also an option! __________________ www.nubilefilms.com \| www.nubiles.net \| www.anilos.com \| tubescript.nubiles.net \| icq4162727

12-06-2002, 04:41 AM	#15
Blackrose Confirmed User Join Date: Aug 2001 Location: Carnal City Posts: 344	Thanks Jason =) It actually sucked a lot leaving you guys ... I have to agree you gave me some awesome service there especially with Andre ... but i just cant take the fuckups caused by Myles ... We could surely do business again in the near future ... and if time permits ... yes, ill see you in vegas =) Now, on my question ... the reason i need to know how is that im planning to use html in my baby thesis instead of using VB ... sure i know how to read/write from and mdb thru VB proggie ... but i want more interaction ... so i thought of using html ... ive also read somewhere that flash can access a mdb database ... but i wouldnt bother with flash ... just some simple html would do ... if possible =) __________________ The die is cast... The dice are rolled... You look like shit... I feel like gold -- Uh, me?

12-05-2002, 07:56 PM	#2
bawdy Confirmed User Join Date: Feb 2002 Posts: 1,424	yeah u need to learn asp http://hotwired.lycos.com/webmonkey/programming/asp/

12-05-2002, 10:22 PM	#4
lEricPl Confirmed User Join Date: Dec 2002 Location: FL Posts: 1,062	Here is a simple way to display data from an Access DB using a 'DataReader' in VB.NET for an ASP.NET page. PS -- Regular ASP is thing of the past. As for updating/deleting and such, buy a good book. 'ASP.NET Unleashed' is great. ===================== Imports System.Data.OleDb 'Note: First you need to import the System.Data.OleDb Class. 'Note: Then set the variables and complete the conn. Dim strConn As String = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\data\data1.mdb;" Dim strSQL As String = "Select * From table1" Dim Conn As New OleDbConnection(strConn) Dim Cmd As New OleDbCommand(strSQL, Conn) Conn.Open() 'Note: Then you can Bind to a Repeater, DataGrid, or any other control. Repeater1.DataSource = Cmd.ExecuteReader(System.Data.CommandBehavior.Clos eConnection) Repeater1.DataBind() ===================== I use Visual Studio.NET, but check in to ASP.NET Web Matrix -- It's a free tool by Microsoft to build ASP.NET Web Pages in C# or VB.NET. Also, check out SQL Server -- much better than Access.

12-05-2002, 10:24 PM	#5
psyko514 See sig. Join Epic Cash. Join Date: Oct 2002 Location: Montreal, Quebec. ICQ: 214702014 Posts: 22,366	forget asp and access move on to php and sql

12-05-2002, 10:35 PM	#7
psyko514 See sig. Join Epic Cash. Join Date: Oct 2002 Location: Montreal, Quebec. ICQ: 214702014 Posts: 22,366	all hail microsoft!

12-05-2002, 10:44 PM	#9
psyko514 See sig. Join Epic Cash. Join Date: Oct 2002 Location: Montreal, Quebec. ICQ: 214702014 Posts: 22,366	and why would i need to harness the power of desktop applications into a webpage? so i can make an online word processor? forget php/sql, i can do that with java. or perhaps an online graphics program? or an online web browser, where someone can open up IE, visit my webpage, and then surf the web thru my webpage. the possibilities are endless!

12-05-2002, 10:58 PM	#10
lEricPl Confirmed User Join Date: Dec 2002 Location: FL Posts: 1,062	Sorry guys -- I'm not going to argue the differences of Java, PHP and .NET. Java is very solid, and PHP is a tight scripting language. I do use PHP on a regular basis, and we have some very hardcore Java programmers over at SitePass. If you just want to simply display/edit/delete simple data, I would use PHP. If I wanted to build a solid Web Application, I personally would use ASP.NET.

12-05-2002, 11:05 PM	#12
lEricPl Confirmed User Join Date: Dec 2002 Location: FL Posts: 1,062	I never really got in to Cold Fusion that much -- but if it does the trick, cool Can't forget about Perl now can we?