|
 |
aspx_beginners thread: Can't add SQL tables usgin VS.NET
Message #1 by planeswalk@h... on Thu, 11 Jul 2002 03:18:40
|
|
Hi, all!
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
Message #2 by "Norman Beresford" <n.beresford@a...> on Thu, 11 Jul 2002 09:50:52 +0100
|
|
Hi Marlon
Have you checked that you have the correct permissions on the MS SQL Server
machine? It's quite possible that you don't have permisson to create
tables.
Norman
Message #3 by "Naveen Avatapally" <naveen_av@h...> on Thu, 11 Jul 2002 10:18:58 -0400
|
|
Hi Marlon,
Please let me know if you are able to solve the problem, because I had the
same problem and I was under the impression that we can't add SQL tables
from server explorer in VS.NET.
Thanks,
Naveen.
>From: planeswalk@h...
>Reply-To: "aspx_beginners" <aspx_beginners@p...>
>To: "aspx_beginners" <aspx_beginners@p...>
>Subject: [aspx_beginners] Can't add SQL tables usgin VS.NET
>Date: Thu, 11 Jul 2002 03:18:40
>
>Hi, all!
>
>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
------------------------------------------------------------
Naveen Avatapally
Graduate Student in Electrical/Computer Eng. Dept
Graduate Research Assistant in McTrans Center
1111 SW 16TH AVE # 99
Gainesville FL 32601 USA
Phone(R):(352)377-9295
http://www.avatapally.com
------------------------------------------------------------
_________________________________________________________________
Join the world?s largest e-mail service with MSN Hotmail.
http://www.hotmail.com
Message #4 by "Allan Williams" <allan@a...> on Thu, 11 Jul 2002 10:33:52 -0400
|
|
Naveen, Marlon,
If you have enterprise you can add tables to sql server, if you have
permissions for the database to add tables.
I have professional edition and therefore cannot add tables to sql
server, but I can add tables to the msde on my local machine.
Hope this helps
-->Allan Williams
-----Original Message-----
From: Naveen Avatapally [mailto:naveen_av@h...]
Sent: Thursday, July 11, 2002 9:19 AM
To: aspx_beginners
Subject: [aspx_beginners] Re: Can't add SQL tables usgin VS.NET
Hi Marlon,
Please let me know if you are able to solve the problem, because I had
the
same problem and I was under the impression that we can't add SQL tables
from server explorer in VS.NET.
Thanks,
Naveen.
>From: planeswalk@h...
>Reply-To: "aspx_beginners" <aspx_beginners@p...>
>To: "aspx_beginners" <aspx_beginners@p...>
>Subject: [aspx_beginners] Can't add SQL tables usgin VS.NET
>Date: Thu, 11 Jul 2002 03:18:40
>
>Hi, all!
>
>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
------------------------------------------------------------
Naveen Avatapally
Graduate Student in Electrical/Computer Eng. Dept
Graduate Research Assistant in McTrans Center
1111 SW 16TH AVE # 99
Gainesville FL 32601 USA
Phone(R):(352)377-9295
http://www.avatapally.com
------------------------------------------------------------
_________________________________________________________________
Join the world's largest e-mail service with MSN Hotmail.
http://www.hotmail.com
Message #5 by "Naveen Avatapally" <naveen_av@h...> on Thu, 11 Jul 2002 10:49:18 -0400
|
|
Thanks Allan,
Naveen.
>From: "Allan Williams" <allan@a...>
>Reply-To: "aspx_beginners" <aspx_beginners@p...>
>To: "aspx_beginners" <aspx_beginners@p...>
>Subject: [aspx_beginners] Re: Can't add SQL tables usgin VS.NET
>Date: Thu, 11 Jul 2002 10:33:52 -0400
>
>Naveen, Marlon,
> If you have enterprise you can add tables to sql server, if you have
>permissions for the database to add tables.
>
> I have professional edition and therefore cannot add tables to sql
>server, but I can add tables to the msde on my local machine.
>
>Hope this helps
>
>-->Allan Williams
>
>
>-----Original Message-----
>From: Naveen Avatapally [mailto:naveen_av@h...]
>Sent: Thursday, July 11, 2002 9:19 AM
>To: aspx_beginners
>Subject: [aspx_beginners] Re: Can't add SQL tables usgin VS.NET
>
>Hi Marlon,
>Please let me know if you are able to solve the problem, because I had
>the
>same problem and I was under the impression that we can't add SQL tables
>
>from server explorer in VS.NET.
>
>Thanks,
>Naveen.
>
> >From: planeswalk@h...
> >Reply-To: "aspx_beginners" <aspx_beginners@p...>
> >To: "aspx_beginners" <aspx_beginners@p...>
> >Subject: [aspx_beginners] Can't add SQL tables usgin VS.NET
> >Date: Thu, 11 Jul 2002 03:18:40
> >
> >Hi, all!
> >
> >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
>
>
>
>
>------------------------------------------------------------
>Naveen Avatapally
>Graduate Student in Electrical/Computer Eng. Dept
>Graduate Research Assistant in McTrans Center
>1111 SW 16TH AVE # 99
>Gainesville FL 32601 USA
>Phone(R):(352)377-9295
>http://www.avatapally.com
>------------------------------------------------------------
>
>
>_________________________________________________________________
>Join the world's largest e-mail service with MSN Hotmail.
>http://www.hotmail.com
>
>
>
>
>
>
------------------------------------------------------------
Naveen Avatapally
Graduate Student in Electrical/Computer Eng. Dept
Graduate Research Assistant in McTrans Center
1111 SW 16TH AVE # 99
Gainesville FL 32601 USA
Phone(R):(352)377-9295
http://www.avatapally.com
------------------------------------------------------------
_________________________________________________________________
Join the world?s largest e-mail service with MSN Hotmail.
http://www.hotmail.com
Message #6 by planeswalk@h... on Fri, 12 Jul 2002 12:28:47
|
|
Hi, guys!
First of all, thanks for answering my post!
I have been ableto upload my SQL database using Query Analyzer, and not by
Enterprise Manager as I originally wanted to do. Correct me if I'm wrong
but, I am assuming that since I am only using SQL desktop edition and not
standard edition, that it could be a factor? Are client components not
enough to add tables?
Again, many thanks for your valuable time and answers!
Regards,
Marlon
> Naveen, Marlon,
If you have enterprise you can add tables to sql server, if you have
permissions for the database to add tables.
I have professional edition and therefore cannot add tables to sql
server, but I can add tables to the msde on my local machine.
Hope this helps
-->Allan Williams
-----Original Message-----
From: Naveen Avatapally [mailto:naveen_av@h...]
Sent: Thursday, July 11, 2002 9:19 AM
To: aspx_beginners
Subject: [aspx_beginners] Re: Can't add SQL tables usgin VS.NET
Hi Marlon,
Please let me know if you are able to solve the problem, because I had
the
same problem and I was under the impression that we can't add SQL tables
from server explorer in VS.NET.
Thanks,
Naveen.
>From: planeswalk@h...
>Reply-To: "aspx_beginners" <aspx_beginners@p...>
>To: "aspx_beginners" <aspx_beginners@p...>
>Subject: [aspx_beginners] Can't add SQL tables usgin VS.NET
>Date: Thu, 11 Jul 2002 03:18:40
>
>Hi, all!
>
>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
------------------------------------------------------------
Naveen Avatapally
Graduate Student in Electrical/Computer Eng. Dept
Graduate Research Assistant in McTrans Center
1111 SW 16TH AVE # 99
Gainesville FL 32601 USA
Phone(R):(352)377-9295
http://www.avatapally.com
------------------------------------------------------------
_________________________________________________________________
Join the world's largest e-mail service with MSN Hotmail.
http://www.hotmail.com
|
|
|
View Cart
