bordavide's Q&A profile

• SQL Server SQL 2005 Enterprise June CTP Installation Error

  Tried to install several times (on Win2003 Ent. SP1) but I always get the following error: Failure adding user NT AUTHORITY\NETWORK SERVICE to local group SQLServer2005MSSQLServerADHelperUser (1388) The user varies (sometimes NT AUTHORITY\SYSTEM) and so does the local group (sometimes SQLServer2005SQLBrowserUser). Any tips Regards Roger I have tried to install SQLDEV ,But got the same error mesage. ...Show All

• SQL Server Compare 2 IDs in Conditional Split

  If I have 2 input fields to my conditional split, how can I do a compare based on if they are alike.  Example, I have 2 IDs, I want to see if the IDs match for a  PK/FK relationship, if they match, then output those rows to the conditional's output stream.  Do I literally do this or is this not right for the expression   Is there a like statement I should be using instead [IDName] == [IDName] Basically I have 2 OLE DB s ...Show All

• SQL Server How do I load the Sample SSIS Components?

  Especially interested in the CodePageConvert. Installing the .msi just creates a project folder in my Visual Studio directory. I'm unclear how to get from this point to being able to choose this component from my Toolbox items in SSIS. There was a readme file that talked about gacutil.exe and .snk files that was a above my head. Can anyone dumb it down for me Marjorie, Firstly, you need to compile the ...Show All

• .NET Development XSD Tool to generate ArrayList instead of arrays

  I was generally pleased with the enhancements to the XSD tool (partial classes, properties) but dissapointed that it still won't generated member containers with ArrayList instead of Array. I've done this manually in the past but it can be painful with a large complex schema.  Is there some tool or technique to generate or convert serializeable code that uses ArrayLists instead of Arrays This is a very pop ...Show All

• Visual Basic VB scripts and upgrading Oracle question

  If anyone can provide any assistance it would be greatly appreciated. We have old VB 3,4,5 scripts that run on many clients that run Windows. We are going to be upgrading the database version that they connect to, from Oracle 7 to Oracle 9,10. What would we need to change from a VB script perspective Do we need to modify the actual scripts or just change the driver they are using for the database connection Thanks for your help. ...Show All

• .NET Development Jscript runns out of order

  Below is code that is executed when a page loads to 'refresh' a tree menu <script type="text/javascript"> function syncNode(id) { //debugger; parent.frames("menu").Location.Reload(true); parent.frames("menu").TreeView1.CollapseAll(); parent.frames("menu").TreeView1.SelectNodeById(id); parent.frames("menu").TreeView1.Render(); return true; } </script> However, it seems the lines the deal with the object "TreeV ...Show All

• .NET Development Blocked SMTP send in Net.Mail

  I've found this problem mentioned in another thread but not addressed as it was off the main problem. My application appears to send mail OK but none of it leaves the machine until the app is exited. Is some kind of flush required I'm using VB 2005 express. Downloaded yesterday. Dim  s mtpSend As New SmtpClient Dim mmNew As New MailMessage( New MailAddress( "y@X.net" ), New MailAddress( "j@X.net" )) mmNew.IsBodyHtml = ...Show All

• Visual Studio Team System Can anyboby provide a script for custom Web-test plug-in to clean up a database after test recording and also after test has run

  Can anyboby provide a script for custom Web-test plug-in to clean up a database after test recording and also after test has run and start with fresh database I have a form in which there is a data grid on it.During recording i add some values in that field so as a result those values get added in the data grid and i got a string saying that record has been saved.When i ran this test those values were already in the data base so the test pass ...Show All

• Visual Basic Uploading A File To A Server (Via FTP)

  Hi, I'm trying to upload a file to a server (I'm using FSP Host for my webspace, which offers full FTP support) and I get this error : System.Net.WebException was unhandled   Message="The remote server returned an error: (550) File unavailable (e.g., file not found, no access)."   This is my code: My .Computer.Network.UploadFile( "C:\Luke.cou" , ftp://one.fsphost.com/CryingOnionTest/Luke.cou , "CryingOnionTest" , "< ...Show All

• Windows Forms ConnectionString Encryption/Decryption

  Hello, Appologies if this is posted in the appropriate area.  I have a ASP.NET web application problem involving the data encryption and decryption assembly(DLL) used on the connection string value that is set in the webconfig file. The problem occurs in&nbs ...Show All

• .NET Development How to use wse2.0 + vs.net2005 beta2(C#) ?

  I create a webservice using wse2.0 and vs.net2003(C#) secussefully. But when I create that by using wse2.0 and vs.net2005 beta2(c#), I can't find the "reference.cs" file in the folder "Web References"  which appear in vs.net 2003. Who can help me to find the differences between vs.net 2005 beta2 and vs.net2003 at using wse2.0 ======================================================== The codes are as follow:  string Username ...Show All

• SQL Server Transaction log keeps growing

  I have set the dboption 'trunc. log on chkpt.' to true; yet the transaction log keeps on growing. sp_dboption pubs_db does show 'trunc. log on chkpt.' to be set. I tried DBCC SHRINKFILE ( pubs_db_log , 100 ) and for a while, the pubs_db_log.ldf was about 100M and then it grew to 10GB. I have a process running that is inserting more than 15K rows per hour and I would like to keep the transaction log from growing. How do I control the tx log g ...Show All

• .NET Development Error while trying to open Access Database File

  Hi all, This may appear very basic question, but I cannot figure out why I get an error at MyConn.Open() line while I try to open the db file from VB.Net. The path is perfectly provided from OpenFileDialog when the file is slected. The code is as below, Dim OpenDBPath As New OpenFileDialog() Dim MyConn As New OleDb.OleDbConnection() MyConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;UserID=Admin;Password=mypass;Da ...Show All

• .NET Development Enforce Constraints and Integrity in DataSet

  Good day, In Beta 2 we have a DataSet with 3 related tables and a number of other constraints. The DataSet was generated from a SQL Express database by the Add Data Source wizard. The DataSet editor shows that the constraints and relationships from the Database design were picked up correctly by the wizard. We are instantiating and using this DataSet manually (i.e. no form wizards or form binding). The DataSet itself does not ...Show All

• Software Development for Windows Vista Error in Createprocessasuser()

  Hello,   I am creating a service application in which I am calling a new .exe file when ever I start the service. but beore that I am facing problem in creating a process. I have used CreateProcessAsUser() but it is throwing an error     "Error creating process: 1314" is the error can anyone helpme out with this below is my code....     TCHAR        ...Show All