Database

FirstPrevNext

Re: UNC required ??? Jon Hulatt17-Dec-04 3:50 Jon Hulatt 17-Dec-04 3:50  It's almost certainly a permissions problem. IIS runs as an anonymous user, which probably won't have access to your share. Try enabled NTLM (Integrated Windows Authentication) on your webserver, and then logging into your web application like that. IIS will then use your credentials, and it'll probably work. using System.Beer; Re: UNC required ??? Colin Angus Mackay17-Dec-04 4:11 Colin Angus Mackay 17-Dec-04 4:11  Jon Hulatt wrote: IIS runs as an anonymous user, which probably won't have access to your share. IIS runs as a special user, not anonymous. The user name is different depending on the version of windows being used. In IIS you can set which user will be used when the end user is logged on as anonymous. This user can be configured as a domain user, by default it is a machine user. Do you want to know more? WDevs.com - Member's Software Directories, Blogs, FTP, Mail and Forums MSDE Inquiry Member 150205616-Dec-04 21:49 Member 1502056 16-Dec-04 21:49  Is Microsoft SQL Desktop Engine comes along with the distribution of VS.net 2002? I really do not know how to identify such. After installing VS.net 2002, I do not get any SQL shortcut or executable for me to access it. Or I have to download it from Microsoft's Site? And another thing, in case I got MSDE or Microsoft SQL server express 2005, is it possible to package it with local based application using it as its database? Just MSAccess where you do not need to install access to a local computer for your program to run? Thank you in advance for your helps. I just have to know Re: MSDE Inquiry Colin Angus Mackay17-Dec-04 2:20 Colin Angus Mackay 17-Dec-04 2:20  aarontlu wrote: Is Microsoft SQL Desktop Engine comes along with the distribution of VS.net 2002? I really do not know how to identify such. After installing VS.net 2002, I do not get any SQL shortcut or executable for me to access it. Or I have to download it from Microsoft's Site? I found a message in my Visual Studio install that reads: Visual Studio .NET 2003 does not include Microsoft SQL Server Desktop Engine (MSDE). To download MSDE, go to http://go.microsoft.com/fwlink/?linkid=13962[^]. So, yes you have to download it. aarontlu wrote: is it possible to package it with local based application using it as its database? Yes. There should be some instructions that come with it. If not, there there are a few articles about it[^]. Does this help? Do you want to know more? WDevs.com - Member's Software Directories, Blogs, FTP, Mail and Forums Re: MSDE Inquiry Member 150205617-Dec-04 13:29 Member 1502056 17-Dec-04 13:29  aarontlu wrote: is it possible to package it with local based application using it as its database? collin wrote: Yes. There should be some instructions that come with it. If not, there there are a few articles about it[^]. Thank you very much, these things save me a lot of time. And I'm planning ahead for future project. About local use of the SQL Desktop Engine, I have 2 questions.. 1. Is it the same if I use Sql Server express 2005? 2. Will it act like access where I do not need to install the Sql Server Express 2005 on the computer that I'm installing my program on? Your help are fully appreciated I just have to know Re: MSDE Inquiry Colin Angus Mackay17-Dec-04 13:32 Colin Angus Mackay 17-Dec-04 13:32  For both your follow up questions I have no idea. I've not had much time to look into the new features of SQL Server 2005 or the licensing/deployment model that it will use. Do you want to know more? WDevs.com - Member's Software Directories, Blogs, FTP, Mail and Forums Re: MSDE Inquiry Rob Graham24-Dec-04 6:08 Rob Graham 24-Dec-04 6:08  1. No. SQL server exress 2005 is a newer version of SQL server (Yukon - not yet released) than the MSDE distributed with VS. Net 2003 (SQL 2000). Most SQL 2000 functions should work the same on Yukon (It is backwards compatible), but there is no gaurantee at this point since it is not released. 2. No it will not work like Access, you will need to install the server if it is not already present, and attach or create your database to the server. Why would anyone waste time arguing with an accountant about anything? Their sole function is to record what happenned, and any higher aspirations are mere delusions of grandeur. On the ladder of productive contributions they are the little rubber pads at the bottom that keep the thing from sliding out from under you. - Roger Wright ListView Control RogerDodge16-Dec-04 21:41 RogerDodge 16-Dec-04 21:41  I'm new to .NET and C# coming from VisualFox background. I'm having a tough time with this control, namely determining which row has been selected. I have four columns, three of which are visible, the fourth contains an id which becomes the parameter to a Stored Procedure which then populates a DataGrid. e.g. private void listView2_SelectedIndexChanged(object sender, System.EventArgs e) { cmdSelectZoneCosts.Parameters["@zoneid"].Value=this.listView2.SelectedItems[0].SubItems[3].Text; dsZoneCosts.Clear(); daZoneCosts.Fill(dsZoneCosts, "ZoneCosts"); } For some reason, the code is executed TWICE(?) the first time the .SelectItems.Count = 0 which crashes the line. If I "trap" for that i.e. if (this.listView2.SelectedItems.Count !=0) { cmdSelectZoneCosts.Parameters["@zoneid"].Value=this.listView2.SelectedItems[0].SubItems[3].Text; dsZoneCosts.Clear(); daZoneCosts.Fill(dsZoneCosts, "ZoneCosts"); } It works this way, but why is it running the code twice ?? Can anyone point me in the right direction to a sample walkthrough of a simple form which will display records from a database, Add, Edit, Delete functions. Roger SQL Syntax Error Suresh Prasad16-Dec-04 19:48 Suresh Prasad 16-Dec-04 19:48  Can any one help me with the following SQL statement. I am getting a syntax error. I am trying to update fields in a access database. Thanks strSQL = "UPDATE tblSetup SET" strSQL = strSQL & "tblSetup.Company_Name = '" & txtName & "'," strSQL = strSQL & "WHERE tblSetup.Company_ID = '" & txtID & "'" Re: SQL Syntax Error Colin Angus Mackay17-Dec-04 2:24 Colin Angus Mackay 17-Dec-04 2:24  There are no spaces between SET and tblSetup. Also there is a spurious comma just before the WHERE. Finally, your SQL is highly susceptable to SQL Injection Attack. You may wish to read up on what SQL Injection attacks are, and how to prevent them.[^] Does this help? Do you want to know more? WDevs.com - Member's Software Directories, Blogs, FTP, Mail and Forums Re: SQL Syntax Error Suresh Prasad17-Dec-04 4:06 Suresh Prasad 17-Dec-04 4:06  Thanks. I will try it out. Datagrid update Yulianto.16-Dec-04 16:15 Yulianto. 16-Dec-04 16:15  I`m new to ADO.NET, can we update a table from the datagrid? Thanks <italic>Work hard and a bit of luck is the key to success. You don`t need to be genius, to be rich. Re: Datagrid update Veera Raghavendra16-Dec-04 17:20 Veera Raghavendra 16-Dec-04 17:20  You can update the database from the datagrid it is possible in web.ui.datagrid.u must use the templates of datagrid properties e.veera raghavendra Generating wrapper code for SQL Server Stored Procedure Fraas16-Dec-04 15:32 Fraas 16-Dec-04 15:32  How Can I Generating wrapper code for SQL Server Stored Procedure ?? If You will Go To The Following link you will see an example for Generating wrapper code for Oracle Database .. And Also the author say there is built in tool for Generating wrapper code for SQL Server http://www.codeproject.com/vb/net/OracleSPWrapper.asp my question .. where is this tools ??? and thanks with my regarding Fraas &quot;Artificial&quot; Server&quot; -beginner question Anonymous16-Dec-04 13:49 Anonymous 16-Dec-04 13:49  I want to practice my SQL on Excel spreadsheets. When I have a project open in VS2003.NET and open the 'Server Explorer' window, it tells me (as it should) that there are no SQL Servers to connect to. When I was learning SQL in school we would connect to the Oracle 9 Database on the Network. Now I want to continue practicing SQL/C#, but have no network/database or internet connectivity. Is there a way I can add an add an "SQL Server" to this path when in fact the "Server" is located on the same laptop. Please forgive my ignorance on the subject. I'm in no way pretending to know what I'm talking about but very much want to learn... thanks for your time.... Server Object - Where to find the Dll ? Vector715-Dec-04 22:37 Vector7 15-Dec-04 22:37  Hello, I want to use the command Server.MapPath and need the Server object. Where I can found it for reference ? Re: Server Object - Where to find the Dll ? Heath Stewart15-Dec-04 23:17 Heath Stewart 15-Dec-04 23:17  The Server property is an intrinsic object accessible from within ASP.NET. You cannot simply use Server.MapPath (which is actually HttpServerUtility.MapPath) because 1) it's an instance method and you cannot instantiate the HttpServerUtility class yourself, and 2) it only works with a given virtual path because it needs to map a virtual path to a physical path. This is specific to both the virtual host and the virtual directory. Even on two different virtual hosts, a virtual directory will map differently to the same physical directory. For future reference, if you have a question about what assembly a class (not object, which is an instance of a class) is defined in, you can view the bottom of the class documentation topic in the .NET Framework SDK that states what namespace and in what assembly the class (or any Type) is defined. This posting is provided "AS IS" with no warranties, and confers no rights. Software Design Engineer Developer Division Sustained Engineering Microsoft [My Articles] [My Blog] Re: Server Object - Where to find the Dll ? Vector716-Dec-04 1:45 Vector7 16-Dec-04 1:45  Hello, thx for response. Yes I am working on an ASP.NET project and need the MapPath Method. But if I cannot instantiate it, i have no possibilities accessing it ? Re: Server Object - Where to find the Dll ? Colin Angus Mackay16-Dec-04 2:34 Colin Angus Mackay 16-Dec-04 2:34  Vector7 wrote: Yes I am working on an ASP.NET project and need the MapPath Method. But if I cannot instantiate it, i have no possibilities accessing it ? Did you read what Heath said? You cannot instantiate it. It is created by the framework for you. In your page class there is a property called Server[^] which exposes a pre-existing instance of the class which you can use. Do you want to know more? WDevs.com - Member's Software Directories, Blogs, FTP, Mail and Forums Re: Server Object - Where to find the Dll ? Vector716-Dec-04 3:58 Vector7 16-Dec-04 3:58  I have read it, but still not the correct hint. This is what I've looked for : HttpContext.Current.Server.MapPath Because I didn't found the Server object, I thought I need an explicit IIS dll. But now I found this in the web by chance ( all other places show System.MapPath instead the right ASP.NET Version ). Re: Server Object - Where to find the Dll ? Heath Stewart16-Dec-04 5:26 Heath Stewart 16-Dec-04 5:26  You can also access the Server property from the Page class (or rather the instance of the Page for your code, if you're running within a .aspx for example). Excuse me for wondering why you're trying to access the Server property when you posted in the ADO/ADO.NET forum. Next time please use the appropriate forum, i.e. the ASP.NET forum. This posting is provided "AS IS" with no warranties, and confers no rights. Software Design Engineer Developer Division Sustained Engineering Microsoft [My Articles] [My Blog] Re: Server Object - Where to find the Dll ? Vector716-Dec-04 23:41 Vector7 16-Dec-04 23:41  Excuse me for wondering why you're trying to access the Server property when you posted in the ADO/ADO.NET forum. Next time please use the appropriate forum, i.e. the ASP.NET forum. Because I am developing a DB Application, where I need this in the connectionstring. Re: Server Object - Where to find the Dll ? Heath Stewart17-Dec-04 1:00 Heath Stewart 17-Dec-04 1:00  It's still a question about ASP.NET. If you had a question about how to do a particular operation in C# you'd ask in the C# forum. The context of the application isn't as important as the context of the question. We don't know what you're writing, but if you ask in the right forum you'll get a more appropriate response. This posting is provided "AS IS" with no warranties, and confers no rights. Software Design Engineer Developer Division Sustained Engineering Microsoft [My Articles] [My Blog] How to databound listbox with three table relational structure? Origon15-Dec-04 22:31 Origon 15-Dec-04 22:31  Hi, I have a little problem with data bounding a listbox, it works just fine when I bound the listbox to a “parent -> child” structure but when I want to bound it to the following structure I just can’t get it to work. product (table) - prod_id (PK) - prod_name category (table) - cat_id (PK) - cat_name product_category_relation (table) - prod_id (PK) - cat_id (PK) product (one to many) -> product_category_relation <- (one-to-many) category I want to get the category names into a listbox when a product is chosen through data bounding, any help in the right direction is much appreciated, thanks in advance. Reporting Service : custom parameter Member 150632215-Dec-04 5:42 Member 1506322 15-Dec-04 5:42  I have just recently created a few reports for this web app we are working on. Upon constructing the reports and connecting them to some stored procedures i noticed that the parameters passed to the report only allow a single selection for a specific parameter.. for example if you have an employee parameter it only allows a single selection which sucks if you want the user to be able to pick a few employees. i was wondering if anyone had information on creating or modifying the current reporting Service Api that renders reports so that one could create custom parameter selection tools. here is an example of what im looking for. http://dspace.dial.pipex.com/town/drive/xxg48/CustomParameters.html any information would be great!

Last Visit: 31-Dec-99 18:00     Last Update: 11-Jun-24 7:08 Refresh ᐊ Prev1...2169217021712172217321742175217621772178 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.