| Groups | Blog | Home |
dotnet ado.net : DDL via ExecuteNonQuery()
-1. I'm using SQL Server 2000 and this has been happening since I installed VS2005 (which also installed SQL Server 2005). I'm starting to think it has to do with pemissions. Maybe SQL Server 2005 messed up with SQL Server 2000's permissions? I don't believe it's possible, but I cannot think of any other alternative. The thing is that this is not happening when I execute the same DDL (i.e. CREATE Table...) in the Enterprise Manager or the Query Analyzer. It only happenes via ADO.NET. Any ideas? Thanks! Paul
Are you using the same credentials for both? What about the initial catalog?
-- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP INETA Speaker www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ Visit www.hitchhikerguides.net to get more information on my latest book: Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ----------------------------------------------------------------------------------------------------------------------- [quoted text, click to view] <timexsinclair2068@hotmail.com> wrote in message news:1180472833.023726.264710@q75g2000hsh.googlegroups.com... > I'm trying to run an ExecuteNonQuery("CREATE TABLE...") and I get a > -1. I'm using SQL Server 2000 and this has been happening since I > installed VS2005 (which also installed SQL Server 2005). > > I'm starting to think it has to do with pemissions. Maybe SQL Server > 2005 messed up with SQL Server 2000's permissions? I don't believe > it's possible, but I cannot think of any other alternative. > > The thing is that this is not happening when I execute the same DDL > (i.e. CREATE Table...) in the Enterprise Manager or the Query > Analyzer. It only happenes via ADO.NET. > > Any ideas? > > Thanks! > Paul >
Thanks for your help Bill.
Yes. I am using "SQL Server and Windows" authentication for both. The funny thing is I can execute DML queries, but not DDL. On May 29, 4:38 pm, "William \(Bill\) Vaughn" [quoted text, click to view] <billvaRemoveT...@betav.com> wrote: > Are you using the same credentials for both? What about the initial catalog? > > -- > ____________________________________ > William (Bill) Vaughn > Author, Mentor, Consultant > Microsoft MVP > INETA Speakerwww.betav.com/blog/billvawww.betav.com > Please reply only to the newsgroup so that others can benefit. > This posting is provided "AS IS" with no warranties, and confers no rights. > __________________________________ > Visitwww.hitchhikerguides.netto get more information on my latest book: > Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) > and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) > ----------------------------------------------------------------------------------------------------------------------- > > <timexsinclair2...@hotmail.com> wrote in message > > news:1180472833.023726.264710@q75g2000hsh.googlegroups.com... > > > I'm trying to run an ExecuteNonQuery("CREATE TABLE...") and I get a > > -1. I'm using SQL Server 2000 and this has been happening since I > > installed VS2005 (which also installed SQL Server 2005). > > > I'm starting to think it has to do with pemissions. Maybe SQL Server > > 2005 messed up with SQL Server 2000's permissions? I don't believe > > it's possible, but I cannot think of any other alternative. > > > The thing is that this is not happening when I execute the same DDL > > (i.e. CREATE Table...) in the Enterprise Manager or the Query > > Analyzer. It only happenes via ADO.NET. > > > Any ideas? > > > Thanks! > > Paul
Sure sounds like a rights issue to me. OS? Vista requires different user
rights. Dig into SSMS and see what rights are assigned to the account being used from ADO.NET. Turn on the profiler to see what credentials are being passed. -- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP INETA Speaker www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ Visit www.hitchhikerguides.net to get more information on my latest book: Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ----------------------------------------------------------------------------------------------------------------------- [quoted text, click to view] <timexsinclair2068@hotmail.com> wrote in message news:1180475072.402206.123650@o5g2000hsb.googlegroups.com... > Thanks for your help Bill. > > Yes. I am using "SQL Server and Windows" authentication for both. The > funny thing is I can execute DML queries, but not DDL. > > > > On May 29, 4:38 pm, "William \(Bill\) Vaughn" > <billvaRemoveT...@betav.com> wrote: >> Are you using the same credentials for both? What about the initial >> catalog? >> >> -- >> ____________________________________ >> William (Bill) Vaughn >> Author, Mentor, Consultant >> Microsoft MVP >> INETA Speakerwww.betav.com/blog/billvawww.betav.com >> Please reply only to the newsgroup so that others can benefit. >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> __________________________________ >> Visitwww.hitchhikerguides.netto get more information on my latest book: >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) >> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) >> ----------------------------------------------------------------------------------------------------------------------- >> >> <timexsinclair2...@hotmail.com> wrote in message >> >> news:1180472833.023726.264710@q75g2000hsh.googlegroups.com... >> >> > I'm trying to run an ExecuteNonQuery("CREATE TABLE...") and I get a >> > -1. I'm using SQL Server 2000 and this has been happening since I >> > installed VS2005 (which also installed SQL Server 2005). >> >> > I'm starting to think it has to do with pemissions. Maybe SQL Server >> > 2005 messed up with SQL Server 2000's permissions? I don't believe >> > it's possible, but I cannot think of any other alternative. >> >> > The thing is that this is not happening when I execute the same DDL >> > (i.e. CREATE Table...) in the Enterprise Manager or the Query >> > Analyzer. It only happenes via ADO.NET. >> >> > Any ideas? >> >> > Thanks! >> > Paul > >
I'm using XP Pro SP2.
The account being used from ADO.NET is the same one I use from the Enterprise Manager (SQL Server 2000 doesn't use SSMS). So, in theory, it shouldn't be a credentials problem. I guess? On May 29, 4:51 pm, "William \(Bill\) Vaughn" [quoted text, click to view] <billvaRemoveT...@betav.com> wrote: > Sure sounds like a rights issue to me. OS? Vista requires different user > rights. > Dig into SSMS and see what rights are assigned to the account being used > from ADO.NET. > Turn on the profiler to see what credentials are being passed. > -- > ____________________________________ > William (Bill) Vaughn > Author, Mentor, Consultant > Microsoft MVP > INETA Speakerwww.betav.com/blog/billvawww.betav.com > Please reply only to the newsgroup so that others can benefit. > This posting is provided "AS IS" with no warranties, and confers no rights. > __________________________________ > Visitwww.hitchhikerguides.netto get more information on my latest book: > Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) > and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) > ----------------------------------------------------------------------------------------------------------------------- > > <timexsinclair2...@hotmail.com> wrote in message > > news:1180475072.402206.123650@o5g2000hsb.googlegroups.com... > > > Thanks for your help Bill. > > > Yes. I am using "SQL Server and Windows" authentication for both. The > > funny thing is I can execute DML queries, but not DDL. > > > On May 29, 4:38 pm, "William \(Bill\) Vaughn" > > <billvaRemoveT...@betav.com> wrote: > >> Are you using the same credentials for both? What about the initial > >> catalog? > > >> -- > >> ____________________________________ > >> William (Bill) Vaughn > >> Author, Mentor, Consultant > >> Microsoft MVP > >> INETA Speakerwww.betav.com/blog/billvawww.betav.com > >> Please reply only to the newsgroup so that others can benefit. > >> This posting is provided "AS IS" with no warranties, and confers no > >> rights. > >> __________________________________ > >> Visitwww.hitchhikerguides.nettoget more information on my latest book: > >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) > >> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) > >> ----------------------------------------------------------------------------------------------------------------------- > > >> <timexsinclair2...@hotmail.com> wrote in message > > >>news:1180472833.023726.264710@q75g2000hsh.googlegroups.com... > > >> > I'm trying to run an ExecuteNonQuery("CREATE TABLE...") and I get a > >> > -1. I'm using SQL Server 2000 and this has been happening since I > >> > installed VS2005 (which also installed SQL Server 2005). > > >> > I'm starting to think it has to do with pemissions. Maybe SQL Server > >> > 2005 messed up with SQL Server 2000's permissions? I don't believe > >> > it's possible, but I cannot think of any other alternative. > > >> > The thing is that this is not happening when I execute the same DDL > >> > (i.e. CREATE Table...) in the Enterprise Manager or the Query > >> > Analyzer. It only happenes via ADO.NET. > > >> > Any ideas? > > >> > Thanks! > >> > Paul
Thanks Patrice.
I found out what the problem was. ExecuteNonQuery is returning -1 if a DDL succeeds but also -1 if there's a rollback -no exception raised, so no message. Then I had no way to discern if it succeeded or it rolled-back. I'm now not relying on returned values, but on exceptions raised. Thank you all for your replies! [quoted text, click to view] On May 30, 11:17 am, "Patrice" <http://www.chez.com/scribe/> wrote: > Don't you have an error message to show us (or does your app hides them ?= )=2E > > -- > Patrice > > <timexsinclair2...@hotmail.com> a =E9crit dans le message de news: > 1180472833.023726.264...@q75g2000hsh.googlegroups.com... > > > I'm trying to run an ExecuteNonQuery("CREATE TABLE...") and I get a > > -1. I'm using SQL Server 2000 and this has been happening since I > > installed VS2005 (which also installed SQL Server 2005). > > > I'm starting to think it has to do with pemissions. Maybe SQL Server > > 2005 messed up with SQL Server 2000's permissions? I don't believe > > it's possible, but I cannot think of any other alternative. > > > The thing is that this is not happening when I execute the same DDL > > (i.e. CREATE Table...) in the Enterprise Manager or the Query > > Analyzer. It only happenes via ADO.NET. > > > Any ideas? > > > Thanks! > > Paul
Don't you have an error message to show us (or does your app hides them ?).
-- Patrice <timexsinclair2068@hotmail.com> a écrit dans le message de news: 1180472833.023726.264710@q75g2000hsh.googlegroups.com... [quoted text, click to view] > I'm trying to run an ExecuteNonQuery("CREATE TABLE...") and I get a > -1. I'm using SQL Server 2000 and this has been happening since I > installed VS2005 (which also installed SQL Server 2005). > > I'm starting to think it has to do with pemissions. Maybe SQL Server > 2005 messed up with SQL Server 2000's permissions? I don't believe > it's possible, but I cannot think of any other alternative. > > The thing is that this is not happening when I execute the same DDL > (i.e. CREATE Table...) in the Enterprise Manager or the Query > Analyzer. It only happenes via ADO.NET. > > Any ideas? > > Thanks! > Paul >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
| home · blog · groups | Questions? Comments? Contact the dn |