| Author |
Create database - How come this code doesn't work?
|
|
| michaaal 2004-07-01, 3:55 pm |
| 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...
%>
| |
| Aaron [SQL Server MVP] 2004-07-01, 3:55 pm |
| What on earth does "doesn't work" mean?
--
http://www.aspfaq.com/
(Reverse address to reply.)
"michaaal" <res0gyio@verizon.net> wrote in message
news:O#ZpRn4XEHA.3944@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...
> %>
>
>
| |
| Evertjan. 2004-07-01, 3:55 pm |
| 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)
| |
| michaaal 2004-07-02, 3:55 pm |
| > 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?
| |
|
|
| Bob Barrows [MVP] 2004-07-02, 3:55 pm |
| michaaal wrote:
>
> 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"
|
|
|
|