Wrox Home  
Search P2P Archive for: Go

  Return to Index  

aspx_professional thread: Unable to add SQL tables with VS.NET


Message #1 by planeswalk@h... on Thu, 11 Jul 2002 03:25:27
Hi, Ryan!

First of all, many thanks for replying fast!

I have already checked and rechecked on the server that all necessary 
permissions for my username is correct. The problem is that I can add a 
table using MS Access 2000 but not with VS.NET. I was also thinking that 
this could be a permissions issue as I can create tables perfectly on 
another SQL DB with another login name, but how come I can add tables with 
Access? 

Regards,

Marlon


> Maybe your login does not have rights to create tables?

-Ryan A. Rinaldi
Nascent Systems
www.nascentsys.com
rrinaldi@n...
p: 630 775 0166
f: 630 775 0167
 

-----Original Message-----
From: planeswalk@h... [mailto:planeswalk@h...] 
Sent: Thursday, July 11, 2002 3:25 AM
To: ASPX_Professional
Subject: [aspx_professional] Unable to add SQL tables with VS.NET


Hi!

I am having some trouble when I try to add a table to my SQL container 
using VS.NET.  I created a connection to the SQL server using Server 
Explorer in VS.NET, and it's able to connect to the server and open the 
DB.  I'm supposed to be able to right-click on the Tables folder under
the 
server, and an option to "Add a Table" is supposed to pop up in the 
context menu.  It doesn't.  Also, I am able to add tables to that DB
using 
MS Access 2000.  Lastly, when I connect to a different SQL Server I was 
also able to add tables this way.

I am desperately running low on ideas... any suggestions?


Many thanks!

Marlon
---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to



  Return to Index