 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Security / December 2005No data in Sql server 2005
Hi everybody, Happy Holidays to all. I developed a windows application that connects to Sql server 2000, using windows authentication and it works, able to retrive and other data process. But when I used it on Sql Server 2005 Express, it was unable to retrive data. What is wrong with it? How can I fixed this? Connecting String at 2000: "integrated security=SSPI;data source=localhost;persist security info=False;initial catalog=Genesis;" Connection String at 2005: "integrated security=SSPI;data source=RITS-DENNIS\SQLEXPRESS;persist security info=False;initial catalog=Genesis;" "user id=guest;password=guest123;data source=RITS-DENNIS\SQLEXPRESS;persist security info=False;initial catalog=Genesis;" Thanks in Advanced. den2005  SignatureMCP Year 2005, Philippines Hi, would you give some more insight !? is it run on Windows Authentication !? is their Guest User has access for DB / server !? what is error message ? :-) Regards SignatureAndy Davis Activecrypt Team -------------------------------------------- SQL Server Encryption Software http://www.activecrypt.com > Hi everybody, > Happy Holidays to all. I developed a windows application that connects to [quoted text clipped - 21 lines] > > den2005 Thanks Andy for replying. The connection is ok. Able to connect and open the SqlConnection but no data is retrive, but teher is data on it. I used windows authentication in sql 2000 and try this in sql 2005. Dennis SignatureMCP Year 2005, Philippines > Hi, > would you give some more insight !? [quoted text clipped - 30 lines] > > > > den2005 Hi, have you created a new database ! or attached it !? :-) Regards SignatureAndy Davis Activecrypt Team -------------------------------------------- SQL Server Encryption Software http://www.activecrypt.com > Thanks Andy for replying. > [quoted text clipped - 38 lines] > > > > > > den2005 Please don't post independently in separate newsgroups. You can add multiple newsgroups to the header and then all the answers appear as one. See my reply in the other newsgroup. SignatureAndrew J. Kelly SQL MVP > Hi everybody, > Happy Holidays to all. I developed a windows application that connects [quoted text clipped - 26 lines] > > den2005 Sorry for that, don't know how to do that. dennis SignatureMCP Year 2005, Philippines > Please don't post independently in separate newsgroups. You can add > multiple newsgroups to the header and then all the answers appear as one. [quoted text clipped - 30 lines] > > > > den2005 You simply include the other newsgroups in the "NewsGroups" (addressed to part of the header) section and it will be posted to all of them at once, including replies. If you have Outlook Express you can simply click on the "Newsgroups" icon to the left of the textbox and select as many as you need. SignatureAndrew J. Kelly SQL MVP > Sorry for that, don't know how to do that. > [quoted text clipped - 36 lines] >> > >> > den2005 In the headers of den2005's messages it says that the Newsreader is "Microsoft CDO for Windows 2000", so it seems to not be Outlook Express. I think it is probably an online Newsreader. > If you have Outlook Express you can simply click on the "Newsgroups" icon > to the left of the textbox and select as many as you need. Hi Andrew and Sam, I am using the Microsof Online Newsgroup to post topics and not using Outlook. den2005 SignatureMCP Year 2005, Philippines > In the headers of den2005's messages it says that the Newsreader is > "Microsoft CDO for Windows 2000", so it seems to not be Outlook Express. I > think it is probably an online Newsreader. > > > If you have Outlook Express you can simply click on the "Newsgroups" icon > > to the left of the textbox and select as many as you need. Hi Den The Web based newsgroups such as http://www.microsoft.com/technet/community/newsgroups/server/sql.mspx do not allow you to post in multiple groups. You should choose the most appropriate group and post there. Before posting it is also worth checking for similar posts made in the past, e.g. search google (which would cover multiple groups) or using the search facility in the online groups. John > Hi Andrew and Sam, > I am using the Microsof Online Newsgroup to post topics and not using [quoted text clipped - 10 lines] >> > icon >> > to the left of the textbox and select as many as you need. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.