ASP and MS Access

[accessman2]

Hi,

I am new on ASP. I have a simple question.

I know that ASP can connect SQL Server.

But, can ASP connect to MS Access?

Please let me know, thanks.

 

[selenau837]

Hi,

I am new on ASP. I have a simple question.

I know that ASP can connect SQL Server.

But, can ASP connect to MS Access?

Please let me know, thanks.

I know that ASP.Net can. I did it last night in class.

 

[dan-cat]

Should get you started:

http://mavweb.net/asp-samples/database-connection-strings.asp

PS: If you're just starting asp I would recommend you skip straight to asp.net. www.asp.net

 

[selenau837]

Should get you started:

http://mavweb.net/asp-samples/database-connection-strings.asp

PS: If you're just starting asp I would recommend you skip straight to asp.net. www.asp.net

Yes, you can also down load for free the Microsoft Web Developer 2005 for free from MSN. It supports ASP.Net.

 

[accessman2]

I have another question,

Is it same, ASP VS ASP.Net?

 

[selenau837]

I have another question,

Is it same, ASP VS ASP.Net?

Similar, but ASP.Net requires the .net frame work. That is the main difference. However, I have never used ASP. I have started on ASP.net instead. That is what I am taking currently in school.

 

[webster]

Yes you can, its the same concept. just a different provider
i.e see connectionstrings.com for the syntax

Use OLEdb.

ASP.NET requires .NET 1.x/2.x framework yes and the
syntax is slightly different. You can use VB.NET
or C# codes with .NET.

Hope this helps.

John

 

[daceyj]

sample code to connect to Access Database with ASP

here is some sample code of how to connect to an access database with asp.
It also shows how to bind the data you have returned from the connection to a datagrid,
Hope this is ok for you

Sub GetAuthors_Click(Sender As Object, E As EventArgs)
Dim DS As DataSet
Dim MyConnection As ADOConnection
Dim MyCommand As ADODataSetCommand
Dim SelectCommand As String = "SELECT * FROM Authors"
MyConnection = New ADOConnection("dsn=pub2")
MyCommand = New ADODataSetCommand(SelectCommand, MyConnection)
DS = new DataSet()
MyCommand.FillDataSet(DS, "Authors")
MyDataGrid.DataSource=DS.Tables("Authors").DefaultView
MyDataGrid.DataBind()
End Sub