brianmultilanguage's Q&A profile
SQL Server Large Sample Database required for testing
We are creating a search engine in MS SQL using FullText etc. we need to run some tests against a database that is near to realistic data. We have been able to generate a database of thousands of usernames, first names etc. but we can't figure out where to obtain a database full of data that contains product descriptions, product titles etc. Does anyone have any idea where we could obtain (or even buy if need be) a large database (over 10,000 records) of sample data that we could run test queries against, so that we can optimise the queries, provide execution time estimates etc. We have downloaded the adventureworks sample database, but there are not nearly enough records in it. Any help would be much appreciated. ...Show All
SQL Server cannot connect with JDBC to express 2005
Hi all, I try to connect with a java application to a freshly download SQL server express 2005, but I cannot anything I do. If I try with the following string "10.0.0.82:1433;databaseName=flavio;user=f.palumbo;" I get this message : java.sql.SQLException: Impossibile eseguire l'accesso per l'utente 'f.palumbo'. L'utente non e associato a una connessione SQL Server trusted. If I try with this string "localhost:1433/flavio" I get this message : com.microsoft.sqlserver.jdbc.SQLServerException: Il numero di porta 1433/flavio non e valido. So I'm getting crazy to find out a solution ... can somebody help me Thanks a lot Flavio The first error says that f.palumbo user ...Show All
Visual Studio 2008 (Pre-release) Intellisense problem
Hi! I installed Visual Studio to a clean installation of Windows Vista RC2. After installing Linq Preview, I have the known problem of intellisense completion. If I write: ArrayList list = new and then press space bar, intellisense doesn't give me suggestions. Same problem with the override keyword. I usually solved this problem by resetting the environment and by using the uninstall c# ide support script. The problem is that now, if I execute the script, I receive this error: Uninstall LINQ Enabled C# IDE Support was unsuccessful. Some files that need to be restored are currently in use. Is there any workaround I have VB installed and the smart tags functionalities work well. Thanks ...Show All
Visual Studio 2008 (Pre-release) Orcas svcutil Suport?
Hey! I found out that I can download Microsoft Pre-release Visual Studio Code Name "Orcas" today from : http://www.microsoft.com/downloads/details.aspx FamilyID=69055927-458B-4129-9047-FCC4FACAE96C&displaylang=en#filelisthttp://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1129583&SiteID=1&mode=1 Will this suport paramters on the svcutil when adding a WCF service inside Visual Studio. I need two parameters that are not suported in Visual Studio 2005(with orcas suplement): /a = asynchronous methods /r = Shared types ex svcutil /o:proxy.cs /a /r:SharedTypes.dll http: //localhost:8000 The /a and /r switch has always been there in svcutil.exe tool that comes with the .Net Framework 3.0 re ...Show All
Visual Studio Express Editions Console Application
I am building a console application which runs in the background. Can you catch a key press or a key down or a key up in console application like in a window application That's not what I really want. I have a loop : Module aaaa Sub Main() While a <> "Stop" End while End Main End Module This Loop doesn't stop looping until the user press the ESC key on the keyboard. If he press the ESC key a is set to "STOP" and the loop ends. ...Show All
.NET Development {"Object must implement IConvertible."}
I keep getting this even though I have defined everything that has been suggested in all the forums :-( - HELP! I used this fine in VS 2003 - can anyone tell me the replacement in VS 2005. I have a public function that is called at various times that I need to execute a Stored Procedure. I get an error at the =>DBExecuteQuerySP = cmd.ExecuteReader(CommandType.StoredProcedure) It tells me to check my 'inner exception' - and that shows the subject line as error: {"Object must implement IConvertible."} My FUNCTION: 'Executes a SELECT Stored Procedure and returns a SqlDataReader containing the results Public Shared Function DBExecuteQuerySP( ByVal cmd As SqlCommand) As SqlDataReader Dim co ...Show All
Visual Studio Team System Files appearing as empty folders and TF10187
We have imported a few test projects from Visual SourceSafe into TFS Version Control. The VSS Converter was not used, but we rather added the latest revisions of the files into TFS by hand. On one workstation the whole solution works fine - deleting everything and then using Open from Source Control has no problems. On another workstation, however, couple of files in the solution (and its web application project in particular) are written into the file system as directories. In practice, this means that for example "d:\tfs\x\web\WebService\X.Xx\XmlExport.asmx.cs" is not a file, but an empty directory. If I then delete the directory and use Get Specific Version w/ Force to reget the file from TFS, it does appear normally (as a ...Show All
Visual Studio Express Editions unexpected error
hi I've installed office 2003 and VB displays me a warning: There are updated custom wrapers available for the fallowing referenced components: Excel, Microsoft.office.core, VBide when I replace auto-generated wrapers with these custom wrapers then VB dosen't recognize this type of code: Dim oExcel As New Excel.Application what should I do Reference the 11.0 Excel Library and then make a local reference like this: Dim XL As Microsoft . Office . Interop .Excel . Application ...Show All
Smart Device Development IrDA DataReceived Event Never Triggers
I have seen similar queries in other threads, but none of the solutions proposed seem to help me. I send data to a device, and if I manually initiate a Read, the expected response is there. The DataReceived event is not triggered though, and the BytesToRead property equals zero. The code is pasted below. If you can show my error, I will be very grateful! static class IrPort { private static SerialPort m_IrDA; private static byte[] m_buf; private static void DataReceived(object sender, SerialDataReceivedEventArgs e) { MessageBox.Show("DataReceived"); return; } public static void Close() { int NumBytes = m_IrDA.BytesToRead; int FirstByte = m_IrDA.ReadByte(); // This always shows BytesToRead = 0, but also the correct first b ...Show All
SQL Server Windows and Forms Authentication issues
I have a user who is trying to access the SQL 2005 server with 2 seperate accounts(using Windows Authentication). With one account he can connect just fine, but with the seccond he recieves a logon fail error. The only difference that we can tell is that the first account uses a password for our kerberos domain, and the second (that fails) uses a longer pass phrase (which does use spaces as characters). My intuition tells me that shouldn't matter, but I've been wrong before. Can anyone confirm this, or correct me if I'm wrong This is using ASP.NET 2005 for the front end. The exact Exception details are: "System.Data.SqlClient.SqlException: Login failed for user 'domain\user " The stack tra ...Show All
SQL Server Notification Services "IDeliveryProtocol"
Using the "BOL" I got a example of how to create a new Delivery Protocol. The link for the page in the BOL is ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/ntsrvpg9mref/html/T_Microsoft_SqlServer_NotificationServices_IDeliveryProtocol.htm Every thing goes ok, but by the time I run the instance I get the following error: Event Type: Error Event Source: NotificationServices Event Category: None Event ID: 6008 Date: 23-10-2006 Time: 12:17:59 User: N/A Computer: LAMBRETA Description: Description: An instance of the delivery protocol could not be created. EventParameters: Instance Name: FlightNmoInstance Protocol Name: MyStoredProcProtocol Protocol Assembly Name: C:\Program Files\Microsoft SQL Server\90\Samp ...Show All
.NET Development I want to protect my database from use out of my application
hi I am working in vb.net application, I almost finesh, the problem is : the application depend on MS access (.mdb )database file, the data is the most important in my aplication... so when I deploy the application on the user computer, any one can copy or access the data from the database and use it out of the application.....please tel me how can I prevent that Mimo: Can you please elaborate your problem From what i understand you only want the users to access the data through the application and not use the .MDB file directly or make copies of the file. You can do that by securing the access database outside your application. http://support.microsoft.com/kb/289885 Hope it helps, ...Show All
Visual Studio Express Editions Can some one tell me how to find the default icon please.
Hello. Can some one tell tell me how to show the default icon in a ListView box please Av only bean learning programming about 3 or 4 weeks now, and am stuck on the this. Am making a cleaning program, the files and the path show in the Listview box, but I want the default icon to show as well. Your help will be very much apresiated. Hears wishing every one a merry Christmas and a happy new Year, and may 2007 be a good year for you all. Thank you I got a feeling it will take me some time, but I will eventually let ya know wether or not i get it to work in my code. There is one thing in partucular that am stuck on, if ya don't mind me asking! in my ListView box i c ...Show All
Windows Forms CellValueChanged() event inside the KeyDown() event
Hello All Is it possible to fire CellValueChanged() event inside the KeyDown() event of the DataGridView control. I tried this way but failed Private Sub dgvAlphaNumeric_KeyDown( ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles dgvAlphaNumeric.KeyDown dgvAlphaNumeric_CellValueChanged(sender, CType(CType(e, EventArgs), DataGridViewCellEventArgs)) End Sub Is there any support other than this Thanks in Advance PRash ...Show All
Visual Studio 2008 (Pre-release) Error: Mapping not found in workspace
I just start a new model from a simple database and receive this error when I try manipulate some data: The mapping for Entity Container 'ADONextLib.ADONext' was not found in Workspace. The samples from the CTP is working properly. There is a connectionstring in a .config file called "ADONextLib.ADONext" In order to better answer your question it would help if you could share with us your .csdl file and the code where you setup and try to use the context. In general what this message is saying is that the system was unable to find some of the metadata it needs in order to be able to interact with your database. - Danny ...Show All
