blopez's Q&A profile

• SQL Server How to register remote server? Authentication method is grayed out!

  In SQL Server management Studio. I was trying to add remote server, so it would show up in registered servers. The authentication method is grayed out!   T he only option to connect to the server is by clicking connect button. It remebers the old settings. I t  also shows me all server databases , even I have selected my database in options... Could you send a screen shot of the authentication dialog to my email address when it is in the state that you descibe Also, please provide step by step explanation how it gets into this state (please also send this as a reply to this posting). Example: 1. Start SQL Serv ...Show All

• Visual Studio Express Editions Beta 1 SQL Server express refuses to uninstall

  A while back I uninstalled VB 2005 Express, but didn't uninstall the SQL Server that came with it.  Now, when I try to follow the explicit instructions for uninstalling beta 1 of VB 2005 Express, I get an error message stating I "need to install VB first", and then it quits.  I no longer have the beta 1 VB express setup files, so I'm kind of stuck.  Can anyone tell me how to remove the beta 1 SQL Server parts so I can proceed with installing beta 2 Hi John, VB Express (or lack thereof) should not stop you from uninstalling SQL Express. Just skip over the step that calls for VB Express u ...Show All

• .NET Development Creating Reports in pdf format

  I need to create reports in pdf format for which i require "fdfacx_net.dll" can anybody suggest me as to where can i download this dll from(i heve learned that this is a free dll provided by Adobe Systsems) Thanks and Regards Rohit Hi, fdfacx_net.dll is part of the Acrobat FDF Toolkit . But As I can remember, you must have a full version of Acrobat (not the reader) to use this. Here's a tutorial on how to do this. How To Generate PDF Files Dynamically .       cheers, Paul June A. Domag ...Show All

• Visual Studio Trouble connected to VSS 6.0 Database.... 2 lines of code?

  Hello everyone. This is my first post here but I have certainly done my research. First, I'm using .Net 2003 and connecting to a VSS 6.0 database. I've included the com object and added the using statement in my header. I have a simply button on a form for testing. When pushed I try the following code: but I error out on the DB.Open line. I've made sure my location user and password are all correct IVSSDatabase DB = new VSSDatabaseClass(); DB.Open(@"z:\srcsafe.ini","user","password"); I get "invalid access code". What does this mean I can’t see anything w ...Show All

• SQL Server General Question

  I have a general question about transactions and commands that are replicated in a Transactional replication. My screen shot says: A total of 5 transaction(s) with 85 command(s) were delivered. I know what a transaction is, but what is a command I am assuming a transaction is begintrans committrans, correct Hi, example BEGIN TRANSACTION UPDATE SOMETable SET SomeColumn = 'SomeValue' Where SomeotherColumn ='SomeCondition' UPDATE SOMETable SET SomeColumn = 'SomeValue' Where SomeotherColumn ='SomeCondition' COMMIT 1 Transaction(scope) 2 Updates / Commands HTH, jens Suessmeyer. --- http ...Show All

• SQL Server Unable to Uninstall SQL server 2005 Express

  When I try to un install SQL Server Express (VS 2005 Beta 2), which is not functional, I get an error message: The SQL Server System Configuration Checker cannot be executed due to WMI Configuration on the machine MACHINE_NAME Error:2147746132 (0x80040154). I ran the Windows Install Cleanup tool but that didn't help. SQL Server 2005 Express is still listed in the list of Applications in the Add/Remove dialog. I tried the uninstall for SQL Server 2005 CTP and had the same error message. What can I do about this I assume this is long since resolved, so I'm marking it as fixed to clean up our records. If you still need help here, pl ...Show All

• .NET Development What is appropriate for this?

  Hello, I currently need to make a "list" of paths to a file. What is appropriate for this kind of a list a database or something else Thank You very much    Keehun Nam I think you may find a datatable convenient, like someone mentioned. I'm unsure if the path object is serializable, if it is not then this will not be an option for you. Consider the following: using System.Data; DataTable pathLookupTable = new DataTable(); pathTable.Columns.Add("PathName", typeof(string)); pathTable.Columns.Add("PathObject", typeof(Path)); This gives you a generic datatable object that is capable of storing path objects by name.&nbs ...Show All

• Visual Studio Express Editions Can't bind to SQL Server Express Data Source

  Hi everyone, I am experimenting with Visual Basic 2005 Express Edition and SQL Server 2005 Express. I have a local copy of SQL Server running, and have created a sample database on it. The SQL Server service is running, and accepting connections. I can connect to it using ODBC and the Native Client libraries. However, when I go to bind the SQL Server database as a data source, it is not available. My only options are to bind to an Access (.mdb) file or a SQL Server Database file (.mdf). There is no option for me to bind to the database without having access to the db file itself. I know I've gotten this to work before, but the relevant opti ...Show All

• Windows Forms Problem with vertical scrollbar in virtual mode

  I encountered a very disturbing error. First the initial situation: The application displays data in a datagridgrid. The amount of this data can vary from 40 to 14000 datasets depending on the users selections. The data itself has to be processed in very specific manners so that I have to use the virtual mode. The height of the rows depends on the data in the row. So there are different heights in the datagrid. The problem: The display of the data in the datagrid is entirely correct and runs indeed very smoothly. As soon as the amount of rows in the datagrid changes from somewhat under 40 to over 3000 the vertical scrollbar of the datagrid g ...Show All

• .NET Development How to access primary key value

  I have a simple access DB, first field is ID and is autonumber, its also the primary key. Then I have a simple routine to insert new record, something like. Dim sql as string = "INSERT INTO table (name,address,phone) VALUES ('bob','windermere avenue','456225')" Dim conn as oledbconnection = new oledbconnection(connectionstring) Dim cmd as oledbcommand = new oledbcommand(sql,conn) cmd.executenonquery Obvously this will insert new record and access will assign an ID, my question is how do I get this ID Thanks I found this link that may help you: http://www.c-sharpcorner.com/Code/2002/Nov/AutoNumber.asp ...Show All

• Visual Studio Team System TFS (again)

  Ive finally managed to install TFS (after 4 odd weeks). However, now the only user who can use it is the one who it was installed under. Ive gone into security and set up other users to have permissions to access the server, but whenever any other user tries to connect to the server a browser style logon dialog box appears and no user/password is accepted. Please help Michael Michael, This probably has something to do with your server configuration. Could you help to answer a few questions 1. was this a single-server or dual-server 2. was the server on a domain or a workgroup 3. was the install account do ...Show All

• SQL Server VS2005 Team Suit + SQL Server 2005 Enterprise ???

  Hi all, I'm newer. I want to install Visual Studio 2005 Team Suit and SQL Server 2005 Enterprise,but Visaul Studio 2005 Team Suit contains SQL Server 2005 Express. How can I do this Thank you. Simply uncheck SQL Server 2005 Express in the Visual Studio 2005 Team Suite installation and install SQL Server 2005 Enterprise afterwards. ...Show All

• Windows Forms Serialization between different apps

  i want the data that i save from application1 to be used from application2 as far as i know serialization is the way to go and it worked excellently saving and loading inside the first application, but now i cant load the data into a second program. this is the saving code: ===============================================       If SaveFileDialog.ShowDialog() = Di ...Show All

• .NET Development All about StrongNameIdentityPermission & Assembly signing

  Hi All I'm using v1.1   I’m about to create a Strong Name with public/private key from sn tool and I’ll sign this to my Executable and DLLs   I wanted to secure a method such that only the assembly which I’ve signed with my key can call the method. I’m decorating my method with StrongNameIdentityPermission.   So on implementing this I’ve some queries   1.   what is the difference b/w the public keys generated by sn -p and sn -tp 'coz the key generated by sn -tp command is failed when I used with StrongNameIdentityPermission attribute. and it is working for the key generated by ...Show All

• Smart Device Development i am still facing problems

  please help me. i want to play a .wav file added to my solution's resources (file name is "start.wav" ). i used the following code-- private void button1_Click(object sender, EventArgs e) { System.IO.Stream mystream = Properties.Resources.start; OpenNETCF.Media.SoundPlayer myplayer = new OpenNETCF.Media.SoundPlayer(); myplayer.Stream = mystream; myplayer.Play(); } but error messase i get is " Cannot implicitly convert type 'byte[]' to 'System.IO.Stream" . is there any method to play a resource sound file. please help I can guess that "start" variable is a byte array, and you are trying to assign a ...Show All