Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > problem with creating a database in win xp

Reply
Thread Tools

problem with creating a database in win xp

 
 
zeev
Guest
Posts: n/a
 
      07-21-2003
hallo
i have to do a code in ASP that including this code:

set c=server.createobject("adodb.connection")
c.open "dsn=MyDSN;"
c.execute "create table first_tables(Name char, Tel char)"

and i am geting that error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E09)
[Microsoft][ODBC Text Driver] Cannot modify the design of
table 'first_tables'. It is in a read-only database.
/1.asp, line 4

what can i do?
thanks
zeev j
 
Reply With Quote
 
 
 
 
Tammy B.
Guest
Posts: n/a
 
      07-21-2003
if it access database then right click on database on uncheck read only

"zeev" <(E-Mail Removed)> wrote in message
news:052001c34f64$b83b3e00$(E-Mail Removed)...
> hallo
> i have to do a code in ASP that including this code:
>
> set c=server.createobject("adodb.connection")
> c.open "dsn=MyDSN;"
> c.execute "create table first_tables(Name char, Tel char)"
>
> and i am geting that error:
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E09)
> [Microsoft][ODBC Text Driver] Cannot modify the design of
> table 'first_tables'. It is in a read-only database.
> /1.asp, line 4
>
> what can i do?
> thanks
> zeev j



 
Reply With Quote
 
 
 
 
Tom B
Guest
Posts: n/a
 
      07-21-2003
Try using a dsn-less connection.
http://www.connectionstrings.com
http://www.able-consulting.com/ADO_Conn.htm

I've not used MS Access in a while, but you may have to use ADOX to create
tables.


"zeev" <(E-Mail Removed)> wrote in message
news:052001c34f64$b83b3e00$(E-Mail Removed)...
> hallo
> i have to do a code in ASP that including this code:
>
> set c=server.createobject("adodb.connection")
> c.open "dsn=MyDSN;"
> c.execute "create table first_tables(Name char, Tel char)"
>
> and i am geting that error:
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E09)
> [Microsoft][ODBC Text Driver] Cannot modify the design of
> table 'first_tables'. It is in a read-only database.
> /1.asp, line 4
>
> what can i do?
> thanks
> zeev j



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Database Database Database scott93727@gmail.com Computer Information 0 09-27-2012 02:43 AM
DataBase DataBase DataBase DataBase scott93727@gmail.com Computer Information 0 09-26-2012 09:40 AM
Applet to run on Win 98, Win ME, Win XP, Win Vista & Win 7 ?? Krist Java 6 05-06-2010 11:53 PM
Surfcontrol - problem with mixed win/non-win devices noname Cisco 1 07-27-2004 09:50 AM
Problem in creating dynamic form...also, is it possible to add the fields from JAVASCRIPT directly to the database using JSP?... Jagdeesh Java 2 09-28-2003 03:10 PM



Advertisments