I'm currently developing a tablet application which uses SQL Mobile 2005.
I added the reference to the System.Data.SqlServerCe DLL and copied all the necessary DLLs of the SQL Mobile SDK (from the Program FilesMicrosoft SQL Sevrver 2005 Mobile EditionDeviceMobilev3.0 ablet directory) to my output directory.
But when my code hits the first SQL Mobile related line:
SqlCeEngine dbEngine = new SqlCeEngine();
I get an BadImageFormatException. This happens both on the Tablet and my development machine. I already reinstalled the SQL Mobile 2005 Device SDK, both nothing changed after that.
Any ideas why this fails? Is it a bug in the System.Data.SqlServerCe DLL or the SDK?
First off, please allow me to extend my thanks to those of you who've helped me with the one or two questions I've had over the last month with regards to SQL Server Express. We more or less successfully rolled out a new version of our software migrated to SQL Server Express to our client today and they were very happy with it.
There is one perplexing problem though. There were about 20-odd installations on Sony VAIO's which all went relatively seamlessly. One of the users, however, has a couple of Panasonic ToughBook CF-19s with Windows XP Tablet PC 2005 Edition with SP2 installed. His are the *only* machines which our solution is not working on.
By way of description, the system is a revamp of a Microsoft Access legacy platform and in order to simplify the conversion, I opted to use ODBCDirect as well as Jet in different parts of the program; not ideal but I had no choice really. So the program accesses the server in two ways. It either uses an ODBC DSN created using the relevant settings through Control Panel or it uses an ODBC-linked Access file linked to the server. These connections both work fine on all the Sony VAIO's and the program is able to start.
On the ToughBooks (we've tried it on two with the same result), I'm sure that the ODBC connection is working fine, as the "Test Data Source" button executes favourably and says that the test succeeded. This is further confirmed during startup of our app which automatically attempts to login to the server and displays the success of that.
My suspicion, therefore, is that it is failing when it attempts to open the ODBC-linked database (I can't be 100% sure since the client is not going to be happy about me installing debuggers on their pretty machine), but all evidence suggests this is the case. Does anyone have an idea if there is something in Tablet PC Edition which could be causing this failure, since it has all worked fine on XP Professional installations on different laptops and desktops.
Hi~! i use my computer to create a project for my UMPC(with Tablet PC system). i want to use SQL server compact 3.1 and VB2005 to finish the work.. i need to upload some data from UMPC to SERVER. How can i do? The UMPC can not connect to PC by ActiveSync. so how can i move the data?
have SQL Server 2005 std edition SP1 installed on Windows 2003 Std edition .Configured Transactional (single Publisher and no clustered environment.) Replication past two months working fine, Now 1.Distrib.exe application err is coming.
Due to which my job is failing (Distributor to Subscriber). Iam attaching thw file. Thanks Sandeep
Hey, don't know if it's the right place for this question but i hope you help me. I made an application with VS 2005 that connecting to sql server file db.mdf Now i want this application work on another user computer, and of course i don't want to install vs 2005 there. I did install .net framework, but what i need to do to make the database work? do i have to install sql server on his computer? or is there something more simple? I know that if i was using access file than i need to install nothing else. please help! thanx. max
ALTER procedure [dbo].[AHD_EmpID_GET] as begin declare @User varchar declare @empid varchardeclare @Pword varchar select E.EmpID as Code, E.Empcode as Description from AHD_glb_Employees E inner join AHD_users U on E.empid=U.empid --where E.Empid=@empid end i have tried this but it is not getting a unique value........... can u help me pls??
I've got an application that needs to:1. Look on the user's machine and locate a file2. Pull that file over to DTS3. Allow DTS to insert this file into a table I'm sure this can be done....anyone got any article on how to do it? Thanks!
I have created a Visual Basic application the connects to my SQL database. The appliction lets a user click on a button, data is retrieved from the database and then formatted in Excel. Everything works fine on my machine (this is probably because i have both VB and SQL installed on my machine) I have created a .exe and deployed the application on some users desktops. The problem is that when they click on a button - nothing happens. I dont even get any error messages! Everything else appears to be fine. I have tested the DSNs and they appear to be fine too. Does anyone know why this would happen ??
hI, EVERY ONE. 1)IF I EXECUTE QUERY FROM QUERY ANAL , QUERY & STORE PROC RUN VERY FINE , BUT SAME REPORT IF I DO FROM FRONT END(i.e from web application tool) THEN IT TAKE VERY LONG TIME.WHAT COULD BE THE REASON ?
2) IF I REBOOT MACHINE - SQL SERVER. THEN FROM FRONT END if I RUN ANY REPORT THEN IT WORK FAST BUT NOT same AS OF QUERY ANALY .I DON'T UNDERSTAND THIS . PLEASE ANY ONE HAS COME ACORSS THIS PROBLEM & HAVE ANY SUGGECTION PLEASE REPLY ME
Whenever a user logs on to SQL-Server there´s a message in the application log of windows NT like "Login succeeded for user 'Domainusername'. Connection: Trusted." Since we have lots of users. The application log fills up twice a day. Is there any way to prevent SQL-Server from doing this ? (I know that there are settings in the event-viewer which clear events whenever space is needed).
i hv developed an application in vb.net, database is in server and more than 50 PCs i have installed my application. Is this the correct procedure, or else i hv to install it on the server and get the shortcut file in all the PCs.because if suppose i want to send a new patch file that time iam going to uninstall my application in all the PCs and installing it again. It takes time.
if i install this in server and create shortcut on every client pc, then how should i management variables value while coding. Please do let me know. thanks for your help
I'm not sure if this is the right section for the question, but here goes...
I have an application that needs to be run in network client mode. This app is supposed to connect to a SQL 2005 db hosted on a server. As I procede through the installation process I get a prompt when i populate the serverdb information.
'The listener port was responsice, but did not return a primary port number for <servername>. Please verify that <servername> is a valid and running database before proceeding.
A little background is in order:
Host:
Server 2003 Standard
SQL Server 2005
Installed instance of said db
Client:
Windows XP Pro sp2
Network config:
We have a domain with about 125 workstationslaptops. Windows firewall is turned off using a group policy (makes it easier to push apps out to clients). For giggles I made exceptions to the 'turned off' firewall policies for the needed ports etc. This was done on both the host server and the client.
is it possible to call a SQL job from an ASP.NET application? if so, how? I'm using VS.net2003 and am programming in C#I've been searching for a while, but haven't found anything. It doesn't help that one of my keywords when searching is "job(s)."
i created a asp.net application using sql server. it retrieve data from a sql server and shows it in the form. it uses textbox control to show it. i wanna update it or add a new item in database. i wrote the code for it under update and add buttons. when i click on the update button after changing a data in textbox, the page is getting refreshed nad comign back to initial state without getting updated. but when i change the textbox1.text with a string in the code, its getting updated with string without any problem. even same problem for addition too, am using a dataadapeter and dataset for this. when i assign a string to the datset columns, its getting updated well but wheni assign it with textbox.text.tostring, nothing is happenig to database. can anyone help me in this issue, why the data was not sent to the datbase and the page is getting refreshed.. plz need help.. its urgent
-- If the parameter and current value dont match, an error -- Is raised which i will need to deal with in my app.
--Error message so (without entering anything for the returned error so far is --Msg 102, Level 15, State 1, Procedure UpdateFile, Line 19 --Incorrect syntax near '@Filename'.
Hai All , Iam having the one Application in DotNet2005.But iam using the two database(SqlServer2005).If user's login the application it will check credentials in first database, if he is not having the login credentials it will cheek the second Database. How can I handle in the configuration file?. How can I change the connection string depending upon the Database in my application for database operation (like insert and update).Any one kindly provide the solution.Thanks and regards,sureshK
Dear All,Finally I completed my project. Thanks all you helped me to do it.Now I have the biggest problem. In my application the Data grid is filled with Data from SQL server table which has large number of records. When I run my queries in SS Management Studio it runs very fast. To fill data to datagrid it takes lots of time. How can I reduce this time. How can I increase the performance of my Application.Thanks,Janaka
Imports System.Data.SqlClientImports System.DataImports Microsoft.SqlServerPartial Class _Default Inherits System.Web.UI.Page Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click End Sub Protected Sub TextBox3_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox3.TextChanged End Sub Protected Sub SqlDataSource1_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles SqlDataSource1.Selecting End Sub Protected Sub Save_Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Save_Button1.Click Dim conn As New SqlConnection() conn.ConnectionString = Data Source=REDSTONE;Persist Security Info=True;User ID=******;Password=******;Unicode=True End SubEnd Class
End of statement expected. C:Documents and SettingskasireddyMy DocumentsVisual Studio 2005WebSitesBankCustomerInfo.aspx.vb 'System.Data' is a namespace and cannot be used as an expression. C:Documents and SettingskasireddyMy DocumentsVisual Studio 2005WebSitesBankCustomerInfo.aspx.vb C:Documents and SettingskasireddyMy DocumentsVisual Studio 2005WebSitesBankCustomerInfo.aspx.vb
Hi, I am using ASP.Net 2005 with C# language and SQL SERVER 2005... I am developing an web based application and have to deploy it on server. I need to prevent my site from the SQL Injection and have to use some algorithms. What is the best technique or method (Algorithm) in .Net ? Give some measures to prevent from Hackers.
I am geeting following error while trying to acquire db connection. I use sql server ce2.0 with vs2005 Failed to find or load the registered .Net Framework Data Provider
I have problem in calling the SP from ASP.NET application @DefApp nvarchar(255)= '' ,@DefBusFunction nvarchar(255)= '' ,@DefImpact nvarchar(255) = '',AS Begin declare @sql nvarchar(4000)declare @whereClause nvarchar(4000)DECLARE @return_value intdeclare @sqlWhere nvarchar(4000) select @sql = 'SELECT DefApp, DefBusFunction, DefImpact FROM Def LEFT JOIN ZFunction ON (def.DefApp = ZFunction.App) AND (Def.DefBusFunction = ZFunction.BusFunction)' if @DefImpact <> '' Set @whereClause = ' where DefImpact ' SET @whereClause = @whereClause + ' = ''' + @DefImpact + '''' set @sqlWhere=@sql + @WhereClauseEXEC @sqlWhereEnd and i am calling this SP from my ASP.net application to fill the SSRS report. I have written code in ASP.NET like: sqlCmd = new SqlCommand("subbusample", conn); sqlCmd.CommandType = CommandType.StoredProcedure;sqlCmd.Parameters.Add(new SqlParameter("@DefImpact", SqlDbType.NVarChar, 255, txtValue3.Text.ToString())); sqlCmd.Parameters.Add(new SqlParameter("@DefBusFunction", SqlDbType.NVarChar, 255, txtValue1.Text.ToString())); sqlCmd.Parameters.Add(new SqlParameter("@DefApp", SqlDbType.NVarChar, 255, txtValue2.Text.ToString())); RptViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; RptViewer.ServerReport.ReportServerUrl = new System.Uri("http://servername/ReportServer");RptViewer.ShowParameterPrompts = false; RptViewer.ServerReport.ReportPath = "/folder name/Subbu_Sample";
when i execute it, i am not able to fill the report with data.
Can anyone point me to a good tutorial or give me a run down on using Sql Application roles from my asp.net application. Books Online only give a run down on how to set it up - not how to implement or use it from my code. MSDN no help. Google - same thing.
Is there a way to connect to a sql db and read the databases and write them to a webpage? Then is there a way to view the tables in a selected database on a webpage?
I'm trying to make a web based enterprise manager.
Hi, please i have a problem, i can't execute my asp.net application with IIS 5.0? i have a message indicating that MYSERVERASPNET can't connect, and that arrive when trying connect to the database under SQL Server 2000. you have to know that my application work very well with webserver of WebMatrix. Web Matrix Project : version 0.6 .Net Framework 1.1 Thank you.
I regularly get the message : application log is full. I cleared event viewer's log file but it didn't help. What is this message about? Thanks in advance,
I have completed a windows db app. I have saved the db files in the application/bin/ folder. The connectionstring that i am using is
Code:
sql Server =(local);Data Source=.SQLEXPRESS;DataBase=;Integrated Security=SSPI
say i wanted to install this app on my home computer, does not have sql express or anything installed. Now i want to use the application and it must read/write data from the sql db that was saved in the application/bin/ folder. what is the connectionstring then ?
can anyone please help ? what im trying to say is that the application must work independent from any SQL manager/express etc.
For my application, I need to consult a database located on a server on the local network. The application is located on my pc. I use the connection string Code:
When I compile my project as a windows application, this works fine. But when I compile as a web application in ASP.NET and try the same connection, it won't connect. How can this be solved?
Here the environment is application in 3 layers. So the user in his client machine, access the application in an application server that sends the request to my sql server database server. My problem is: when I run sp_who from Query Analyzer, I see the host name that is pre-defined inside code application. But, actually, I need to know the user who is requesting the transactio so I can know right the person who is slowing my database performance.... Do you know, any function, procedure or anything else that I can use in the application code in order to provide the user or the host name from the client machine????? I hope some answers...