Kevin6's Q&A profile
SQL Server SQLMobile 2005 IIS 5.1 problems
Hi, I've installed SQL Server 2005 mobile server tools. Then using the synchronization wizar, i set up a virtual directory on my iis 5.1 (running windows xp). To test the installation i’ve opened an IE windows, then http://localhost/sqlceremote/sqlcesa30.dll. I get always the same message: "interal server error". Then i look into the event log and found an IIS WARNING entry saying (in spanish) "El servidor no pudo cargar la aplicacion '/LM/W3SVC/1/root/sqlceremote'. Error 'Interfaz no compatible '. -> incompatible interace I can’t find the way to make this work. Any help It may be important to say that i have installed an SQL 2005 express edition instance that is not a default instance becouse i also have an MSDE on t ...Show All
Visual C# In C#, how should I use a VB ocx that is dependent on a win32 dll ?
Hi, I am trying to use a VB ocx control in C#. Internally the ocx control makes use of a C++ dll. I have done the following 1. Registered the ocx 2. Included the component in VS .Net IDE tool bar. But when I try to drag and drop the control I am getting an error "Failed to import the ActiveX control. Please ensure it is registered properly." I am using .Net Visual Studio 2005 Looks like there is some problem in creating the wrapper for the ocx. After drag and drop, under Project->References the wrapper is not available. It simply shows the wrapper's name with a warning icon ( i.e.., the icon used to indicate that the reference is not available or not built). When ActiveX is dependent on another dll should we do something di ...Show All
.NET Development How to load assembly from config file
Hi, we have to define COM/.Net references in come configurable file in Windows Forms application (class library). For .Net Web application we can add something like this in web.config file to define a referance: <configuration> <system.web> <compilation> <assemblies> <add assembly="System.Data, Version=1.0.2411.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> </assemblies> </compilation> </system.web> </configuration> But for windows this element is missing. Is there any way thru which we can load assemblies from any configuration file or any updatable file. Regards Sid we cant use Assembly.Load. as that will requir ...Show All
SQL Server SQL Express and SQL 2005 developer edition on same machine
Hello, I am wanting to setup both SQL Express and SQL 2005 developer edition with visual studio 2005 professional on the same machine and want to make SQL dev edition the default local accont to where I can set the sql connection to server=localhost. Is there a way to do this Thanks So, I then should proably install SQL 2005 dev as default instance, then go ahead with the visual studio 2005 pro with SQL express installation after, correct Also, I am seeing this in the IIS ASP.net configuration settings connection string data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true. I am assuming that sql express is the default server. ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Error when trying to install XNA Build
After I downloaded the XNA Build March 2006 CTP, I was brought to a page that showed me how to setup Microsoft Visual Studio 2005 Premier Partner Edition. I successfully installed Microsoft Windows Installer 3.1, Miscrosoft XML 6.0, and Microsof .NET Framework 2.0. After I did that I downloaded Vs_Setup.msi. I double clicked it and there was no visual activity on my computer. About a minute later a message came up that said, "Error 1311.Source File not found : C:\Documents and Settings\(My Name)\My Documents\_1519_RTL_x86_enu_VSCC_Help_Collection.cab. Verify that the file exists and that you can access it. The file did not exist and I could not access it. I have retried installing many times but the same thing happens. Help apprecia ...Show All
Visual Studio Printing Crystal report with Modified Page Setup
I have an ASP.net (VS 2003) application, within the application I have a report which to be printed in dot-matrix printer with size 9.27in * 5.00in. I defined a new form with same size mentioned and I renamed it as A4 Half then I used that form size in Crystal report for visual studio to fix the form size. Report output is working fine in the development machine (Windows XP Professional), but while deploying that report in the deployment server (windows 2003 server) it’s coming in a full page size although same form size and printer already defined on that server. Please update me if any body faced same problem before or have a solution for that. Thanks Ahmed ...Show All
Visual Studio Team System Can't find any tables for databinding?
Hi, I tried to add an Excel spread sheet as a data source for my webtest. I have created an excelsheet with highlighting the table and defined the name. Also, in the webtest editor, I have selected the Provider, Entered the path of the file, set the values to the extended properties. When I tried to perform the last step(mentioned below), I can't find any tables associated with it. "Choose the tables you would like to include for data binding then click Ok. " FYI: I have referred this link for this http://blogs.msdn.com/slumley/archive/2006/02/08/adding-different-types-of-data-sources-to-a-web-test.aspx Kindly suggest where I would have messed up. Thanks - Vijay. I experience ...Show All
SQL Server Lookup Task Datatype issue
Hello: I'm attempting to use the lookup task and i'm running into an issue about incompatible datatypes. The table that i'm referencing in the lookup has a field named DateCreated, and it's DataType is DateTime. But when I hook it up to the Lookup Task, the lookup task thinks it's a DB_Timestamp, so i get an incompatible data type error. What can i do Duane: Thanks for your reply. My problem is not with the dataflow, but with the Lookup Task misinterpreting the Data Type of one of the columns in my lookup table. Instead of being DateTime as the column is set to, the the Lookup task thinks the column is a DB_Timestamp. ...Show All
Smart Device Development windows mobile browser
I am trying to BROWSE using my pocket PC to upload a vopice file to a website. The current browser does not have this option, but I was told to try a different browser called "Netfront.com". It allows me to do this which is great, but I was wondering if there is a version of windows mobile that allows this Feel free to contact me either email or cell phone at 412-913-8684. Also looking to find someone that can make a software for my handheld that is in "DSS" format, not the typical "WAV". This forum is smart device development related. Since your question is not related to smart device development, it's off topic here. If you’re having a hardware issue, please contact hardw ...Show All
SQL Server Computed columns and constant
Hi, I have a small problem with my database. I've got following situation: I have a computed column, which value is base on currency rate: rent * rate. Users have to have possibility to change currency rate easily (maybe another table or constant). Is there any way to create formula, which would compute value properly, via constant or something like this Or the easiest workaround would be load data into dataset (I'm building asp.net application - database will be very small - couple of hundreds of records) and make calculations programmatically Przemek hi, computed columns can only be based on constants, variables, functions and columns of the same table, and the last one exclude your Users hav ...Show All
Visual Studio 2008 (Pre-release) WCF equivalent to MapPath?
Is there a WCF equivalent to MapPath I have some specific files that will be in the directory where the service is running. My question stems from the fact that MapPath bacially is called from a static HttpContext. I understand that this isn't a problem if the service is hosted in IIS but will there be an HttpContext for all hosting environments What would be the safest way to get the "root" directory of a WCF service Thank you. Kevin Burton HttpContext .Current.Server.MapPath There is an HttpContext only when webhosted in aspnetCompatibilityMode, see http://msdn2.microsoft.com/en-us/library/aa702682.aspx for details. I don't think there is an equivalent for other hosting environments. ...Show All
SQL Server Insert av value in a sql-server database
Hello: I have a code that save information from a textbox to a access-database...And it work exactly the way I want.... Now I want to change the database to a sql-server-database....but I dont know what to change in the code I have... The code for the access-database is: <% @(a) Page Language="VB" %> <% @(a) import Namespace="System.Data" %> <% @(a) import Namespace="System.Data.Oledb" %> <script runat="server"> sub submit(obj as object, e as eventargs) Dim MinConnectionString as string = _ "Provider=Microsoft.Jet.Oledb.4.0;" & _ "Data Source=MinDatabas.mdb" Dim strSQL As String = "INSERT INTO tabell1(namn) VALUES( @(a)Namn)" Dim Conn As New OledbConnection(MinConnectionString) Dim Command As Ne ...Show All
Windows Forms STA and threadpool problem
Hello, I have a Windows Form project which i tried to merge with a console project that uses Thread pool. After i did that i got a messege saying: "WaitAll for multiple handles on a STA thread is not supported." OMG someone please help me! this is an emergency beucase i must use the ThreadPool. anyone has an idea Can you provide any more information How did you merge a WinForm and console app What COM objects are you using What is the logic like in the TP code The error sounds like you are trying to access a COM object that is running in an STA and you block. In this case a deadlock situation would occur if no one other than the COM object releases the handles being wai ...Show All
SQL Server selecting debugger
hi, while trying out one function which needs to connect to the database,i got this error: An unhandled win32 exception occurred in name.vshost.exe[1668]. it prompted me to select a debugger.what does this error mean hi jens, this error occurred right after i solved the problem which i posted under the thread "remote connection" what i did was i simply created a text box and a button where when i press the button, my application will connect to the database in my friend's pc and store whatever is written inside the text box the error was displayed right after i pressed the button. what could be the cause of this error the thing is,i was able to manually open his database table and ins ...Show All
Software Development for Windows Vista Get an extended exception information
Hello, I want to get an extended exception information, like Application Name, Fault Module Name (the dll if exists). How can I do that Thanks. ...Show All
