Hi all
Below is my code
all I need is to fetch the name ofthe table and display it in the browser.
The code below doesn't give any error, but when I execute my asp page the page freezed and doesn't give any result
I don't know what's the problem
It will be great if any one help me to getout of my problem.
<!--#include file="adovbs.inc"-->
<%
' LISTS ALL TABLES AND COLUMN NAMES
Dim objADOXDatabase
Set objADOXDatabase = Server.CreateObject("ADOX.Catalog"
objADOXDatabase.ActiveConnection "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:/inetpub/test/test.mdb"
Dim objTable, objColumn
For Each objTable in objADOXDatabase.Tables
If objTable.Type = "TABLE" then
Response.Write objTable.Name & "<br>"
For Each objColumn in objTable.Columns
Response.Write " " & objColumn.Name & "<br>"
Next
Response.Write "<p>"
End If
Next
Set objADOXDatabase = Nothing
%>
Thanks
Balachandar Thank You
sbind77
Below is my code
all I need is to fetch the name ofthe table and display it in the browser.
The code below doesn't give any error, but when I execute my asp page the page freezed and doesn't give any result
I don't know what's the problem
It will be great if any one help me to getout of my problem.
<!--#include file="adovbs.inc"-->
<%
' LISTS ALL TABLES AND COLUMN NAMES
Dim objADOXDatabase
Set objADOXDatabase = Server.CreateObject("ADOX.Catalog"
objADOXDatabase.ActiveConnection "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:/inetpub/test/test.mdb"
Dim objTable, objColumn
For Each objTable in objADOXDatabase.Tables
If objTable.Type = "TABLE" then
Response.Write objTable.Name & "<br>"
For Each objColumn in objTable.Columns
Response.Write " " & objColumn.Name & "<br>"
Next
Response.Write "<p>"
End If
Next
Set objADOXDatabase = Nothing
%>
Thanks
Balachandar Thank You
sbind77