473,372 Members | 1,302 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

Create database - How come this code doesn't work?

I am trying to run this code on a Windows 2003 Server.
I have ASP enabled. Any idea why it doesn't work?
<%
newDB = "new.mdb"
newDB = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & newDB

Set cat = CreateObject("ADOX.Catalog")
cat.Create newDB
Set conn = CreateObject("ADODB.Connection")
conn.Open newDB

' create tables, etc...
%>
Jul 19 '05 #1
5 1534
What on earth does "doesn't work" mean?

--
http://www.aspfaq.com/
(Reverse address to reply.)


"michaaal" <re******@verizon.net> wrote in message
news:O#**************@tk2msftngp13.phx.gbl...
I am trying to run this code on a Windows 2003 Server.
I have ASP enabled. Any idea why it doesn't work?
<%
newDB = "new.mdb"
newDB = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & newDB

Set cat = CreateObject("ADOX.Catalog")
cat.Create newDB
Set conn = CreateObject("ADODB.Connection")
conn.Open newDB

' create tables, etc...
%>

Jul 19 '05 #2
Aaron [SQL Server MVP] wrote on 01 jul 2004 in
microsoft.public.inetserver.asp.general:
What on earth does "doesn't work" mean?


Well, Aaron,
after a long day of remembering the years
that I did work more than fulltime,
I can understand that people say that of me.

OT ;-}
--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)
Jul 19 '05 #3
> What on earth does "doesn't work" mean?

Aaron, sorry for not getting specific.

I am trying to use this code to dynamically create an MS Access database
on my Win2003 web server. I get something to the effect of "page cannot
be displayed".

Could you try the code on your server possibly? Or tell me a better way to
dynamically create a MS Access database?
Jul 19 '05 #4
> on my Win2003 web server. I get something to the effect of "page cannot
be displayed".


Now, find out the real error.
http://www.aspfaq.com/2109
http://www.aspfaq.com/2476

--
http://www.aspfaq.com/
(Reverse address to reply.)
Jul 19 '05 #5
michaaal wrote:
What on earth does "doesn't work" mean?


Aaron, sorry for not getting specific.

I am trying to use this code to dynamically create an MS Access
database on my Win2003 web server. I get something to the effect of
"page cannot be displayed".

Could you try the code on your server possibly? Or tell me a better
way to dynamically create a MS Access database?


We need to see the real error message
(http://www.aspfaq.com/show.asp?id=2109), although I can practically
guarantee that it's a permissions issue.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Frank Wilson | last post by:
Tom, It sounds to me like ASP, not ASP.NET is handling the request for WebForm1.aspx. This is most likely an IIS config issue that may have been caused by order of installation or...
2
by: Markus Prediger | last post by:
Hi NG, I have an asp.net project that uses an vb6 com object for some database-manipulation (I cannot rewrite it in .net, sorry, its not my decision). I want it to be instanciated seperately...
5
by: darjonase | last post by:
Alright, so I am creating an entire database in code since I have no idea how to bundle a created database in an install of my application. I know how to create the database and the tables in...
14
by: mistral | last post by:
Need php script to create mySQL database programmatically; since hosting configuration may not allow create database from script, script also need eliminate/rewrite all restrictions in appropriate...
27
by: max | last post by:
Hello, I am a newbye, and I'm trying to write a simple application. I have five tables with three columns; all tables are identical; I need to change some data in the first table and let VB...
16
by: Mich | last post by:
Hi, i'm building an web application for anonymous users. They can take a look in the website, nothing more. In order to perform other actions, the anonymous user must be logged. So i create an...
15
by: lxyone | last post by:
Using a flat file containing table names, fields, values whats the best way of creating html pages? I want control over the html pages ie 1. layout 2. what data to show 3. what controls to...
3
by: Mark A | last post by:
At first glance it seems like a good idea to use the new RESTRICTIVE option when creating a database to remove public access otherwise granted by default. Then one could grant the required access...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.