SYNCHRONISING XDA MINI S WITH PC USING VISTA
Jan 23, 2008
I have a problem synching my xda mini s with my pc using vista. A previous thread was unhelpfully closed by Ilya as being off topic; well it isn't on topic anywhere else. At least not according to microsoft's own search engine. Ilya, why not try giving a helpful answer instead of 'not my problem'? My xda will not synch using vista; XP and ActivSync has been perfect. I've tried installing mobile device centre version 6.1 but I suspect vista isn't compatible with Windows mobile version 5.1. Should it be? If not, is there a patch or is upgrading to vista going to cost another couple of hundred pounds to get a compatible mobile device? If so, I'm off to a different operating system. Perhaps, like many others, back to XP and let Microsoft continue to dither around and experiment on others.
View 1 Replies
ADVERTISEMENT
Dec 17, 2002
Hello all,
I'd like to write an app in either C# or VB which can capture certain events on a SQL Server. Just like profiler, it would listen to the SQL Server constantly and would probably run in the system tray.
Could you point me in the right direction? How does profiler achieve this, are there any existing ActiveX controls for this or does the .NET framework include something suitable.
Thanks
Tom
View 1 Replies
View Related
Dec 2, 2005
I have a table with a few million records and I need to search andreturn rows where a varchar(1000) field has the value "Showed"SQL will not allow me to add an index for a field of this length.Is it possible to create some kind of index for only the value "Showed"Or is there some other faster way to search for this value?thanks,Paul
View 8 Replies
View Related
Sep 28, 2005
Hi, i have created a mini form to test out easy steps and my sql
connection but something is wrong with my connection i think...
I am running windows XP Pro SP 2. i have Microsoft VisStudio .NET 2003
fully installed and now im installing SQL Server 2000 Developrs
Edition. I just cimpleted the installaion and picked some settings:
Local Computer Installation, Create new Instance since this is the
first time i use it, Server and Client Tools, and chose a Local rather
the Domain option aferwards. (i have used this version before but had
to format the comp so now reinstalling everything).
My problem is this, i basically started the server and it on online. i
went to the "enterprise manager" and in the "Microsoft SQL Servers
-> SQWL Server Group -> (Local)(Windows NT)-> Databases, i
created a new database called tables and added a single table just to
begin testing to see if at least its functional. i was able to do this
so far.
Now i started my .NET, and wrote a tiny program to see if the
connection to the SQL database would open, but it didnt. It always
failed. i am programming an ASP.NET WebApplication. I cant open the
connection to my database. i dont know why. (The tiny piece of code i
wrote is at the bottom in case you know c#). There is a note also
under the code for the ones who will read through its simlicity
any help or walk through would be appreciated. thank u...
Sam
CODE:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Configuration;
namespace WebTest1
{
/// <summary>
/// Summary description for WebForm1.
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
string connection = ConfigurationSettings.AppSettings["ConnectionString"];
protected System.Web.UI.WebControls.TextBox TextBox1;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.TextBox TextBox2;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.TextBox TextBox3;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.Label Label5;
protected System.Web.UI.WebControls.Label outputBox;
protected System.Web.UI.WebControls.Label Label3;
private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void Button1_Click(object sender, System.EventArgs e)
{
outputBox.Text = "Button has been clicked";
SqlConnection conn = new SqlConnection(connection);
outputBox.Text += "----------------Creating sql Connection";
try
{
conn.Open();
outputBox.Text += "---------------opening the Connection";
}
catch(Exception p)
{
outputBox.Text += "--------------failed to open Connection";
Console.WriteLine(p.ToString());
}
outputBox.Text += "-------------Success Connection and Login to Server!";
}
}
}
NOTE: i always get this output :
Button has been clicked----------------Creating sql
Connection--------------failed to open Connection-------------Success
Connection and Login to Server!
it skips the try block's print line which means it didnt work......
string connection =
ConfigurationSettings.AppSettings["ConnectionString"]; this one i
updated in my Web.config and included application setting line that
loox like this
<add key="ConnectionString" value="Data Source=127.0.0.1; Initial Catalog=login; User Id=sa; password=pass" />
View 2 Replies
View Related
Sep 9, 2007
I use my Pocket PC XDA O2 mini for 2 years already and I don't have any problems when I sync it with my previous laptop which has Window XP operation system.
A few months ago, I bought a new laptop with Window Vista operation system, I could not sync my O2 mini with my PC. Then, I download Windows Mobile Device Center but my computer still could not recognize my O2 mini. My O2 mini has window mobile 2003 Second Edition Version 4.21.1088 operation system. Please let me know if you have any advices.
Thanks.
View 1 Replies
View Related
Nov 19, 2001
Hello,
I've installed development server and created the databases, and restore the ddatabase from backups of production server, There the users in the databases which are not in sysxlogins in master, Please guide me how I can synchronise the logins? Can I bcp out sysxlogins from development and then bcp in in development server? Is there any way there even groups in the database and do I have to corncern about any other tables in master db
Thanks in Advance
Alpa
View 3 Replies
View Related
Apr 28, 2008
Hey folks,
I'm looking to gather ideas on this before I start the project; so what better way to start than to ask here? ;)
The situation is this: we are in the process of replacing a large data driven application with a new one. Before turning the old'un off (that's not for a minimum of 6 months), we need to migrate data between the two entirely different schemas, and I've been tasked with writing the interfaces.
Now, here comes the kicker; they don't just want a "straight-forward data conversion", they want to run a period where they can still update both databases and any changes in the old one are to be pushed into the new db.
Because the schemas are not the same, I believe replication is out of the question so I was looking for advice as to what possibilies I have ahead of me to achieve this.
I fear I may not have expained this well enough; so as always if there are holes in the detail let me know and I'll do my best to fill them in :)
Old db = SQL Server 2000
New db = 2005
Thanks,
George
View 13 Replies
View Related
Dec 25, 2005
HiWe have an internal ms access database which we need to synchronise with ourwebsite with sql server 2005 backend which is hosted on a public host. Myquestion is; is there a way to keep the two databases synchronised using thetechnologies built in sql server 2005 and/or access? We also have thepossibility of an in-house sql server 2000. Can this be used in anyway tohelp, perhaps by moving data from in house access to in house sql server2000 and then synching sql server 2000 and remote sql server 2005?ThanksRegards
View 1 Replies
View Related
Jun 27, 2007
Hello guys,
I'm stumped. Is there a way to get a compact edition client (running on a standard PC) to automatically sync. (using merge replication) with a server on a schedule?
I can quite happily pull up SQL Managerment Studio and sync. on the client, but I want to have something running in the background basically doing this for me (again, on the client). I know I can do it in code, but we've not yet received our Visual Studio package, so for the moment, I want something already written to do it for me.
Surely this must be possible?
Thanks in advance!
View 8 Replies
View Related
Oct 4, 2001
Hi, can anyone point me in the right direction of how to sync an in-house SQL Server 7 with a remote SQL server 7.
We are a development house. We build website using SQL server 7 databases then move them up to an entirely different SQL server 7 database in a remote location.
Now, please don't laugh, currently we export all the data from the development server into a csv and import it back into the live server. As you can imagine, it's clunky, time consuming and unreliable.
Is there a way to automatically sync the two? I tried desperately to find any information but even the MicroSoft MCSE training manual on SQL doesn't say how to do this.
Any help would be greatly appreciated.
Thanks in advance.
Chris
View 1 Replies
View Related
Dec 28, 2005
HiIs there a way to synchronise/replicate an access db with sql server 2000db, short of writing the code oneself?ThanksRegards
View 1 Replies
View Related
Nov 17, 2006
Hi
I have a production system running sql 2000 server 32 bit
Now i am planning to move to SQL server 2005 64 bit setup .
I need to have a set up of both SQL 2000 and sql 2005 in parallel for some time until it is sure that the sytem can completly move .
The problem is how do i synchronize the data in the two servers when they are operating parallely.....
Please advice.
Thanks in advance......
View 1 Replies
View Related
Feb 8, 2007
HI ,
I Created one database named login.sdf in sql Ce ,i created one table login having two fields (username and password).it is working well.I trying to synchronise these with SQL2000 using Active sync.it is not working ..And one more things ,i tried to connect the default pocket PC 2002 emulator with Active sync.it is also not working.can anybody give some solution for these problem
Thanks in Advance
Regards
Ihsan
View 8 Replies
View Related
Nov 7, 2007
I have purchased a seperate computer to "learn and play" which has Vista OS on it. What is the best/or most practical way to setup a sql db on this computer for me to play with and learn sql? I realize some of you think this may be simple but I don't have the opportunity to "dig" in the sandbox at work so I have to do this on my own. Thanks for your help.
View 1 Replies
View Related
Dec 21, 2006
I am trying to develop using SQL Server Compact Edition on Vista 64-bit and when I try to load the .DLL files for x86 I get 'BadImageFormatException'. Looking at the documentation, I do not see where SQL Server Compact Edition supports Vista 64-bit, is this true? If it is true, when will it support 64-bit?
Luke Mauldin
View 4 Replies
View Related
Jun 9, 2007
I'm having problems getting SQL Express running with Vista. It says remote connection may not be enabled when launching a program in the IDE. The application interfaces with a SQL database that was previously working in XP.
I have installed:
VS2005 Standard
SQL Express
VS Vista upgrade
VS2005 SP1
SQL SP2
Thanks.
View 2 Replies
View Related
Apr 16, 2007
Hello, I have installed Vista Windows recently in my computer. And when using an application that connects a SQL Server2000 who is in the same dominion, gives the following error me:
[DBNETLIB][ConnectionOpen(Connect()).]
The connectivity between both pc's is correct.
View 1 Replies
View Related
Dec 20, 2007
I have Vista and Office 2007 installed. It comes with the SQL Configuration tool. I was told by someone at Microsoft that I can't install SQL 2005 server on Vista. I have an application called Goldmine that I want to run under Vista, using SQL.
Should I install SQL 2005 express? Can that work under Vista?
Can I use what comes with office 2007? What else will I need to download? Management Studio?
Thanks a ton,
Ken
View 13 Replies
View Related
May 15, 2008
I just added all users as Db_owner :) Now I am gettimg this error:
The EXECUTE permission was denied on the object 'GetCountryByISO', database 'zikbay', schema 'dbo'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'GetCountryByISO', database 'zikbay', schema 'dbo'.
View 3 Replies
View Related
Feb 9, 2007
Hi
I'm trying to use Express to query the Vista Search engine using a linked server as follows:-
sp_addlinkedserver @server = 'myLinkedSvr', @provider = 'Search.CollatorDSO.1', @datasrc = 'SYSTEMINDEX', @srvproduct = '', @provstr='Application=Windows'
go
SELECT FileName FROM OPENQUERY("myLinkedSvr", 'SELECT Filename FROM SYSTEMINDEX')
go
but this returns
Server: Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Search.CollatorDSO.1" for linked server "myLinkedSvr" reported an error. Command was not prepared.
Server: Msg 7350, Level 16, State 1, Line 1
Cannot get the column information from OLE DB provider "Search.CollatorDSO.1" for linked server "myLinkedSvr".
OLE DB provider "Search.CollatorDSO.1" for linked server "myLinkedSvr" returned message "Command was not prepared.".
It's obviously "almost" working because it complains if I query a column that does not exist.
Any ideas?
tia
Niall
View 2 Replies
View Related
Aug 4, 2007
Hi
I have 2 computers
DESKTOP : runs WinXP and SQL Server 2005
NOTEBOOK : runs Windows Vista and SQL Server 2005
when i try to connect to DESKTOP from NOTEBOOK i get this error
TITLE: Connect to Server
------------------------------
Cannot connect to DESKTOP.
------------------------------
ADDITIONAL INFORMATION:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
can anyone help me to fix it?!
View 3 Replies
View Related
Nov 7, 2007
Experts... im completely stuck. My laptop was stolen, my replacement arrives with vista on it. Get my SQL Stuff on it and when I try executing a select statement on one of the sql servers I get the error; An error occurred while executing batch. Error message is: Internal connection fatal error. and it simply disconnects. I cant run any queries! Please help.
"Impossible is Nothing"
View 6 Replies
View Related
Jan 13, 2008
Hello,
Can i install SQL7 on Windows Vista Home Premium Edition?
Appreciate any help.
Thanks,
Ed
View 1 Replies
View Related
Jun 1, 2007
Hi,
I am having a vb6 application with sql server 2005 database. It works fine on windows xp. But when i install the application on windows vista I am getting Adodc error "login failed for user sa". Still the forms are populated with data from the database. But the event handlers dosent seem to work after i get this error. Does someone know what caused that adodc error. I have disabled User account control for the vista installation.
Vinith
View 4 Replies
View Related
Aug 31, 2007
Hello,
I recently got me a new laptop with Vista preinstalled. All good and well, but when I try to install a program vital for my profession, I get an error (OS not supported for this program). In the install I can configure what components to install, one of them is MSDN 2000. My question is, will SQL Server Express take over what MSDN can't on Vista (and thus running the program needing the MSDN 2000), or will windows XP be the new OS on my brand new laptop in the future. Love Vista, hate the compatibility.
View 1 Replies
View Related
Dec 8, 2006
We€™re calling ADOX::Table::Keys::Append to make a primary key for a table using the SQLOLEDB provider. We€™re passing an ADOX::Key with Name set to a custom name, Type set to ADOX::adKeyPrimary, and a single column added. For the Append call, the 2nd parameter is ADOX::adKeyPrimary, the third is a vtMissing (VT_ERROR with DISP_E_PARAMNOTFOUND), the last two are empty BSTR€™s.
On XP, this works well (msadox.dll file version 2.81.1117.0). On Vista, this fails with an invalid parameter error (msadox.dll version 6.0.6000.16386).
Has the interface changed in some way, is this functionality not supported, or is it broken?
View 1 Replies
View Related
Nov 20, 2007
Hi, Mike, et al,
First of all, I am a self taught programmer, and a Sql Neophyte, and know just enough to get confused (or in trouble). I have a TabletPC app that uses SqlExpress, installing as 'Click Once'. Works great on XP, but my app comes to a screeching halt on Vista, because of the permissions/contact network administrator issue. I read Mike's post (dated a year ago, Oct 06) about using SSMSE to create a new Login with sysadmin rights for the current user. Long story short, completed it successfully, but it didn't work.
I have been browsing posts here on the subject, but I am confused. Does my Vista user need to install SP2? Will that fix the problem? I am sorry, but some of the posts on this subject are over my head.
Could I prevail on one of the moderators to point me in the right direction, or to explain in v-e-r-y b-a-s-i-c terms what I need to do to help my Vista users access my SqlExpress DB?
Many thanks!
Steve
View 11 Replies
View Related
Aug 7, 2006
Has anyone managed to get SQL server 2005 standard edition working on Vista?
If I install from CD I get an error message
Error Message:
sql server setup could not connect to the database service for server confiurgration.The error was[Microsoft][SQL Native Client]Shared Memory Provider:No process is on the other end of pipe.
I have then tried installing SP1 (which i understand is meant to fix some of the vista issues), but then when I then try to re-install from the CD it says the version on my PC is more up-to-date and doesnt install.
All I have in Programs - SQL server 2005 - Are the Configuration tools, not the Management studio etc.
View 4 Replies
View Related
Mar 3, 2007
I had sql express and microsoft express accounting working fine on xp. When I updated to vista and reinstalled sqlexpress with sp1 and management express sp1, I can not get the server to register. Any command I click gives error message "this type of initializer <module> threw and exception". Also when I tried to install accounting from office 2007 cd, will not install giving same message. Ihave uninstalled and reinstalled sql express w sp1 several times with no success. I can find no reference to this error message anywhere. Anybody got an idea where I can do to get this to work properly? Thanks in advance.
View 3 Replies
View Related
Aug 14, 2007
Hello,
I am trying to install SQL Server Enterprise 2005 on Windows Vista Enterprise.
The installation has finished "successfully", but when I am trying to open the MS SQL manager, I see that the manager has not installed.
How can I fix it?
Thanks, Idan.
View 4 Replies
View Related
Jun 9, 2007
Goodday
If I go to Http://localhost/reports I get this error
I have followed the tutorial but still get the error as below. If i go to http:// localhost I get the iis7 wecome page , without a problem.
Sorry I,m a bit new at this , I see in the error message that I must type something in a command line window.
Is this the black blackground box with C:windowssystem32>_ already typed in . Must I type this just after and press entre %systemroot%system32inetsrvAPPCMD.EXE migrate config "Default Web Site/Reports"
Server Error in Application "Default Web Site/Reports"
HTTP Error 500.0 - Internal Server Error
Description: This application is running in an application pool that uses the Integrated .NET mode. This is the preferred mode for running ASP.NET applications on the current and future version of IIS.
In this mode, the application should not specify ASP.NET handler mappings in the <system.web>/<httpHandlers> configuration section. Instead, it should use the <system.webServer>/<handlers> configuration section to configure ASP.NET handler mappings. You have the following options:
1) Migrate the application to work with the Integrated .NET mode (PREFERRED).You can migrate the application configuration, including the contents of the <httpHandlers> configuration section, by using the following from a command line window (the window must be running as Administrator):
%systemroot%system32inetsrvAPPCMD.EXE migrate config "Default Web Site/Reports"
After you migrate your application, it will run in both Classic and Integrated .NET modes, as well as on downlevel platforms.
View 13 Replies
View Related
Apr 11, 2006
Are there any plans to support SQL Mobile running on Windows Vista? I have an application that runs SQL Mobile on Tablet PC's. I would like to support Vista the same way.
Thanks,
Joe
View 3 Replies
View Related
