I have a WM6 phone which got an Exchange server setting for my email. When I connected the device by USB, the activesync will show "Synchronization could not completed. Try again later. Support Code 80072f7d". When I search the result from this forum. The answer is not related to mobile phone issues.
Will anyone able to help?
Thanks, ppdog
hi,
i am developing one location based mobile application in c#(.net compact framework).i m using ActiveSync to connect to device emulator.i m getting confused that would i be needing to connect device using ActiveSync everytime even after deploying it onto actual device?or i need to use GPRS connection? or i need to connect using both? and whats the code fro checking GPRS connection status? i m using merge replication fr synchronization. please guide me as soon as possible..
thanks and regards,
dhruvi
I have the following problems:
- in Active Sync 4.5 there is no DMA connection available
- when selecting a DataSource in VS2005 I do not have SQL SERVER Compact Edition in the list
While testing this problem out, I found it has something to do with this update SSCE31VSTOOLS-ENU and SSCE31VSTOOLS-DEU. Both updates do not run. Instead I get a message that necessary files are missing or do not have the right version for updating.
How could I solve this problem? What is the right order to install this beasty patch?
Best greetings from Germany.
hallo could anyone tell me how do i connect to the internet through activesync ? thx
View 1 Replies View RelatedI want to synchronize my database on Pocket PC / The Emulator that use WM5 and SQLCE3, but the synchronize is doesn't use IIS as the bridge, but i want to use ActiveSync as the synchronizer bridge. The rule like this.
1. Have database on Pocket PC.
2. Have application on Desktop PC.
3. When device or emulater placed on cradle, then the database automaticaly synchronized with database server on desktop pc.
Why I want to use ActiveSync as synchronizer.
1. I have the Pocket PC cradle. So my device can synchronized using ActiveSync.
2. I have internet connection on Desktop PC. So why i must pay more for GPRS if i only need to synchronize my device with my desktop pc.
Thanks.
Hello. Is there any possibility to connect and proceed merge replication between SQL Mobile and SQL Server 2000 SP4 using ActiveSync? I need to deal with this situation:
- mobile application is working using self .sdf database but from time to time it connects to SQL Server and do some synchronization (synch or asynch, really doesn't matter). But, when there is no network connection (broken, suspended, wifi broken etc.) I have to create an option - Pocket PC will land into cradle and I have to synch all changes made in SDF and SQL Server using ActiveSync (or something like that - via USB).
So my question is : is there any simple mechanism to do this? Or I have to write some Active Sync manager which will be dealing with my replication? (pretty hard to do). Awaiting answer - Maciej Wysocki.
PS. I am using Windows CE 3.0 but I can setup Windows Mobile 5.0 too, I am just wondering if there is any chance to make this type of synch. working.
In VS2005 RTM using
View 15 Replies View RelatedI have tried using the SqlClient class to connect to the database, but I haven't had much success. Here is my setup:
Desktop/Workstation has Windows XP, ActiveSync, .NET Framework 2.0, and SQL Server 2005.
The production Workstation will have 2000; so I do want to ensure SQL Server 2000 compatibility with my solution.
Handheld device is an Intermec 751g with docking station, hooked to PC host using USB connector cable and ActiveSync, Windows CE 4.2, .NET Compact Framework 2.0 with SP1 and latest patch.
Development tools consist of Visual Studio 2005 and C# .NET language.
Note that when I attempt to ping my desktop from the handheld command prompt I get "transmit failed, error code 11010".
Also, I am able to access the Internet from my handheld device.
My error is encountered when I execute this fill code:
int returnValue = this.Adapter.Fill(dataTable);
Please note that all of my code is generated by the VS 2005 IDE at this juncture, as I am simply trying to get the plumbing to work.
Here is the error that I encounter:
System.Data.SqlClient.SqlException was unhandled
Message="SqlException"
Class=20
LineNumber=0
Number=6
Procedure="ConnectionOpen (Connect())."
Server="09Q-GHAZEL2\SQL2K5"
Source=".Net SqlClient Data Provider"
State=0
StackTrace:
at System.Data.SqlClient.SqlConnection.OnError()
at System.Data.SqlClient.SqlInternalConnection.OnError()
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Connect()
at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin()
at System.Data.SqlClient.SqlInternalConnection..ctor()
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.QuietOpen()
at System.Data.Common.DbDataAdapter.FillInternal()
at System.Data.Common.DbDataAdapter.Fill()
at System.Data.Common.DbDataAdapter.Fill()
at DeviceApplication1.AdventureWorksDataSetTableAdapters.ContactTableAdapter.Fill()
at DeviceApplication1.Form1.Form1_Load()
at System.Windows.Forms.Form.OnLoad()
at System.Windows.Forms.Form._SetVisibleNotify()
at System.Windows.Forms.Control.set_Visible()
at System.Windows.Forms.Application.Run()
at DeviceApplication1.Program.Main()
Thanks again for your insight. Sincerely, -Dotnetfellow dotnetfellow@yahoo.com
I have a report that gets sends out through a subscription and sometimes the report has multiple pages and all those pages appear within one email.Is it possible to set the subscription in such a way that an email is sent per page when the subscription executes.
View 2 Replies View RelatedUnder IIS SMTP I can set bounced email redirect etc. how to do that with dbmail, the idea is I can get the list of bounced emails somewhere so I can create a report.
Any idea?
thanks
need help
split list of email add comma for evry email
i have tabe "tblLogin" and in this table i have field emall
like this
emall
-----------------------------------------
aaa@hhhh.mm
nnn@hhhh.mm
mmm@hhhh.mm
need to do ilke this
Code Snippet
@list_email = (SELECT emall FROM tblLogin)
--------------------------i get this
-----------------------@list_email=aaa@hhhh.mm ; nnn@hhhh.mm ; mmm@hhhh.mm
@recipients = @list_email
Code Snippet
IF EXISTS( SELECT * FROM [db_all].[dbo].[taliB] )
BEGIN
DECLARE @xml NVARCHAR(MAX)DECLARE @body NVARCHAR(MAX)
SET @xml =CAST(( SELECT
FirstName AS 'td','',
LastName AS 'td','' ,
Date_born AS 'td','' ,
Age AS 'td','' ,
BirthdayToday AS 'td','' ,
BirthdayThisWeek AS 'td'
FROM [Bakra_all].[dbo].[taliB] ORDER BY LastName FOR XML PATH('tr'), ELEMENTS ) AS NVARCHAR(MAX))
SET @body ='<html><H1 align=center>aaaaaaaaaaaaaaaaaaaaaa</H1><body ><table border = 1 align=center dir=rtl>
<tr>
<td>name</td>
<td>fname</td>
<td>date</td>
<td>age</td>
<td>aaaaaaaaa</td>
<td>bbbbbbbbbbbbbbb</td>
</tr>'
SET @body = @body + @xml +'</table></body></html>'
EXEC msdb.dbo.sp_send_dbmail
@recipients =N'rrr@iec.co.il',
@copy_recipients='rrrrr@iec.co.il',
@body = @body,
@body_format ='HTML',
@subject ='ggggggggggggggggggggg',
@profile_name ='ilan'
END
ELSE
print 'no email today'
Hello ALL
what I want to achieve is to load a text file that has email addreses from disk and using the email addresses in the text file look it up against the email addresses in the database table then once matched delete all the users in the table whose email address were in the text file.
I also want to update some users using a different text file.
Please help me with the best way to do this
Thanks in advance
Hi there,
I'm new here and fairly new to .NET and C# too.
I've received a couple of complains about a website I've been working on the
past year or so: http://www.ipcamerademos.com/
I can open and browse the website fine, in both MS Internet Explorer and
Firefox. But some people are getting some error opening up the website (home
page):
Server
Error in '/' Application.
Here is the problem, i'm sure there is quite a bit on google but i'm
not sure what to search for. I want to know how to connect to a
sql server from my home machine using the localhost for testing asp.net
files out. At work the machines will connect fine using
localhost. The server we connect to is in another location.
If someone could get me started on what to search for i would
appreciate it.
Hi All,
I'm trying to run a copy of Enterprise Manager at home. I have a small wireless network and would like to install it on either one machine (stand-alone) or run it on my network.
The machine it is installed on is running Windows 2000 and the remote machine is running Windows XP Home <<< not sure if SQL Server will run on this.
I tried installing it previously as stand-alone on the Win2K machine, but kept getting a "Server not found or access denied" message whenever I tried to register or connect.
Any ideas on how best to set it up at home would be greatly appreciated.
Thanks,
Tim
Hi all:
How to install a sql server 2005 in a computer with windows Xp Home Edition?
Thanks
I got google on the other tab but I am home with my Norton firewall and SQL Server 2005 and sqlwb.exe just tried to make an internet connection. wtf?
View 4 Replies View RelatedHow can I practice the use of SQL server without changing mygirlfriends laptop to XP Pro (which anyway I dont have)?Using (unfortunately) Windows XP Home not Pro, Visual Studio 2005.Trying to learn SQL server with asp, javascript, vbsrcipt and HTML-new to this.Headbutted the wall for a few hours trying to install SQL Serverproperly. The long and short is no IIS with Win XP Home so doesnt seemto work properly. I did manage to connect to Northwinds and publs DBso can use them to learn but I need to be able to ceate own database.Ie 3 tables.For the moment I have created a table in Northwind which I will try tofill with datafrom a notepad file I have...Dan
View 2 Replies View RelatedI just got Visual Studio 6 Enterprise which includes SQL Server7. However, when I try to install SQL7 (Standard Edition ?) onWindows XP Home it only installs the client components and notthe server component. The install routine claims this is becauseof the version of Windows I am using.Now I know that IIS isn't supposed to be installable on WindowsXP Home but it is with a fairly straight forward hack, so what Iwas wondering was is there a way to get SQL7 Standard installedon Windows XP Home (maybe with a similar sort of hack)?Failing that (and assuming the SQL7 in VS6EE is "Standard") doesSQL7 Desktop work on Windows XP Home? If so where can I get it(haven't seen one so far on eBay)?Regards PLST
View 1 Replies View RelatedHello there!I am trying to install MS SQL 2000 Server on Windows XP Home edition.I found in Microsoft that the above installation is possible.But when i run the installation, i am getting a black screen that iscloses after a second. Nothing else happens.Any ideas how to troubleshoot this?Thank you
View 4 Replies View RelatedWhe installation have to start service sql : impossible to start service (WIN XP HOME)
View 4 Replies View RelatedUsing System Role Assignment I grant a domain user account "System Administrator" & "System User" within Reporting Services.
Then I connect via IE7 to Report Server with the domain account that has been granted the above rights. The page comes up but the "Contents" and "Properties" tabs are missing. This user can use "Site Settings" and perform admin though.
If I assign the users domain account to the local Administrator group on the Win 2003 Server, then when they reconnect to Reporting Services the missing tabs appear.
We are a development shop, need some of our qa testers and developers to have admin rights within Reporting Services but don't want to grant them local Administrator rights on the server. This could also be an issue upon deployment at customer sites.
So how to get round this. I have been trying ACL's on the Reporting Services directorys, ASP.Net security etc but with no success.
PS: Everything was sweet before SP2
Hi,
I have SQL Server 2005 Express and XP Home sp/2. There's just me, the one computer, (i.e. one user and no nowork), but I am connected to broadband Internet. I have the SQL Server installed with its defaults, so it and its various parts are all Network Services (except VSS which is a Local System service). I've read, and read, but still do not really understand it all. Can someone please just tell me: is this the safest set of services I could use?
I also use Aqua freeware to import my data to the SQL Server, and Aqua requires connection via the TCP/IP port and for the Browser to be on. How vulnerable am I doing this?
Thanks in advance,
jessj
Hi there,
Could you please fill me in on some possible reasons and solutions as to why the report server home page appears blank?
Thanks!
Hi,
I have an sql express server which contains a single database. Three users access this database using a C# application I have writen. I use Integrated Security for these three users.
The problem is that one of my users wishes to use my application from home.
What are my options in letting this user use my application from home?
Thanks for your help,
Barry.
Hi,
We're creating an installer package for SQL Express 2005 and I'm using the built-in setup project in VS 2005 to create my MSI.
Everything appears to be working well, excpet that on Windows XP Home the SQL Express package is exiting with an error code 70002. I've googled for several days now and simply can't find any help on the 70002 exit code. Can anyone help ?
The command line arguments (I've split them onto seperate lines for clarity) we're passing to "sqlexpr32.exe" are : -
/qn
INSTANCENAME=OurInstance
SAPWD="OurPassword"
ADDLOCAL=SQL_Engine,SQL_Data_Files,Client_Components,Connectivity
SQLBROWSERAUTOSTART=1
SQLACCOUNT="NT AUTHORITYSYSTEM"
SQLBROWSERACCOUNT="NT AUTHORITYSYSTEM"
AGTACCOUNT="NT AUTHORITYSYSTEM"
ASACCOUNT="NT AUTHORITYSYSTEM"
RSACCOUNT="NT AUTHORITYSYSTEM"
SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0
SQLAUTOSTART=1
I have installed SQL Express with the following command line parameter--
"SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 SAPWD="$DB_PWD$" INSTANCENAME="$INSTANCE_NAME$" ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_Replication SQLACCOUNT="NT AUTHORITY" SQLBROWSERACCOUNT="NT AUTHORITY" SQLBROWSERAUTOSTART=1"
The operating system is XP Home..
Now the problem is when I open up Management studio from another m/c I can't find the Instance installed in the XP Home MC. I deally in the management studio should displays the instances like this...
[Mechine Name][Instance name]
but in this case it is showing only
[Mechine Name] in the Management studio's brows server list in a different MC.
So I am not being able to connect to that MC. I have checked that the remote connection is checked on with Surface area config. manager.
Same command line is working for Windows 2000. Any help please......
When I type my 'http://ServerName/rmMyManager/Pages/Folder.aspx' I can see only Home and NOT Properties. I can see all the folders below that I have .
Just two days back I have changed permission to allow only me for deploying and have all those settings. Please guide me accordingly.
Hello All,
I just got a new computer from work for Home use, and I need to figure out what would be the best way to transfer databases I create at home to work? I have a zip 250 disk, but what would be the best method?, What files need to be copied, what does it all entail?
Thanks for the help
Kevin
Short version - how can I create a server login for a remotely connected machine on a simple 2 computer XP home network connected via router?
Long version - I'm doing an Access-SQL Migration. I used the migration assistant (which creates DSN-less linked tables) to convert the data to SQL Server, and now I'm at the point of making all of the modifications to my Access front end so that the two play nice.
I have SQL Express running on my laptop. I would like to do the Access work on my desktop because a) I can work faster with the fullsize keyboard and b) the install at my client's location will include users hitting the database over their network and I'd like to simulate that while I'm making the modifications.
My Access front-end works 100% fine on my laptop. The Access front end will NOT connect when I run it on my desktop.
My guess is that this is due to not having a server login or DB user associated with the account on my desktop machine. In view of that, I'm trying to create those items on my server.
So, I open SSMS on the laptop and try to create a Server login. Under "Login Name:" I enter "DesktopAccountName" and it fails saying "Windows NT user or group 'DesktopAccountName' not found. Check the name again."
If I click the "Search" button next to "Login Name:" The only "Location" that I'm given is "LAPTOP" and that's greyed out preventing me from changing it.
Both machines are running XP home. My network is simply called "Home" if that means anything.
I'm planning to establish a recovery plan for my SQLServer 2000databases. How to change home and data directories?
View 3 Replies View RelatedHi,
How can I hide breadcrumb shown at the top of report and Home link for a Browser role ??
thanks,
prashant
Hi
I am new to SQL / SQL Server and have downloaded SQL Server 2005 Express.
I also appear to have an existing SQL Server program on my PC which includes Query Analyzer. I wish to use Query Analyzer. Is this compatible with SQL Express?
When I try to open Query Analyzer using Windows Authentication I get the error msg:
'Unable to connect to server HOME-DHGV3DIC8N:
Server: msg 17, level 16, state 1
[Microsoft] [ODBC SQL Server Driver] [Shared memory] SQL Server does not exist or access denied.'
I am guessing that I need to create some sort of server which I can use to run SQL server.
Could anyone let me know how I do this? And also if I will be able to run Query analyzer on SQL Express edition.
I'd be really greatful
Regards
Mark