Connecting To Sql Server 2005 From Pocket Pc 2003 Emulator

Nov 12, 2007

Hi. I have a problem. I'm working at the moment on application witch should write and read data from sql server. The application should work on windows mobile devices. I'm linking this code to event on a button:





Code Block private void menuItem1_Click(object sender, EventArgs e)
{

SqlConnection sqlCon;
sqlCon = new SqlConnection(String.Format(@"Data Source={0};Initial Catalog={1};User ID={2};Password={3}",
@"192.168.54.149sqlexpress", "MojDom", "kuba", "abuk"));
sqlCon.Open();

string insertString = @"insert into {0} values ('{1}', {2})";
SqlCommand cmd;

cmd = new SqlCommand(string.Format(insertString, "MojDom", "Kuba", 15), sqlCon);
cmd.ExecuteNonQuery();


if (sqlCon.State == ConnectionState.Open)
sqlCon.Close();

}



and on line sqlCon.Open() i get exception:




Code Block

System.Data.SqlClient.SqlException was unhandled
Message="SqlException"
Class=20
LineNumber=0
Number=6
Procedure="ConnectionOpen (Connect())."
Server="192.168.54.149\SQLEXPRESS"
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 AIHouse.FormMain.menuItemSettings_Click()
at System.Windows.Forms.MenuItem.OnClick()
at System.Windows.Forms.Menu.ProcessMnuProc()
at System.Windows.Forms.Form.WnProc()
at System.Windows.Forms.Control._InternalWnProc()
at Microsoft.AGL.Forms.EVL.EnterMainLoop()
at System.Windows.Forms.Application.Run()
at AIHouse.Program.Main()
And when im using exactly the same code in windows console application everytihng works fine when i run it on pc with sql server and emulator, or other pc connect to network. I'm working on emulator of Pocket PC 2003, I've "put" it in cardle and the emulated device has connection to my pc and internet, the firewall is off.

I really dont have any idea why it's not working.

sorry for my english, but its not my foreign language.

thx for sugestions and reply.

regards Kuba

View 3 Replies


ADVERTISEMENT

Cannot P/Invoke SQLCEME30.DLL When Debugging Pocket PC 2003 SE Emulator

Sep 22, 2006

I'm trying to debug an assembly with System.Data.SqlServerCe - and when I deploy to a IPAQ 2210 - I get no errors! Alas, when I try to debug using the Pocket PC 2003 SE Emulator - I get the "cannot P/Invoke SQLCEME30.DLL" exception.

Can anyone offer directions?

best regards,
Walther

View 9 Replies View Related

RDA - Vb 2005 App - Desktop && Pocket Pc Emulator - Error: 80072F76 Native Error: 28035

Oct 12, 2006

RDA - vb 2005 app - desktop & pocket pc emulator - error: 80072F76 native error: 28035

PDA info:
.NET CF 1.0 env-string...
MS SQL client
MS SQLCE 2.0 dev
MS SQLCE 2.0

DESKTOP info:
Microsoft SQL Server Management Studio Express 9.00.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

copied an app from http://www.codeproject.com/netcf/PocketPCwithSQLCE/PocketPCwithSQLCE_Src.zip
modified its CONFIG.XML to...
<?xml version="1.0" encoding="utf-8" ?>
<Configuration>
<DatabaseServer>192.168.1.89</DatabaseServer>
<DatabaseName>D1Temp</DatabaseName>
<DatabaseLogin>sa</DatabaseLogin>
<DatabasePassword></DatabasePassword>
<SQLCEURL>http://192.168.1.89/SqlMobile/sqlcesa30.dll</SQLCEURL>
<LocalDBConnect>Provider=Microsoft.SQLServer.OLEDB.CE.2.0; Data Source=My DocumentsMyFav.sdf;</LocalDBConnect>

<LocalDBLocation>My Documents</LocalDBLocation>
<LocalDBName>MyFav.sdf</LocalDBName>
<IISLogin>192.168.1.89/Jason</IISLogin>
<IISPassword>batman2005</IISPassword>
</Configuration>

error is "Header information is either corrupted or missing. [,,, header name,,]"

have spent weeks google-ing trying to get this to work, to no avail.
Has ANYONE got RDA PULL to work with above setups?

View 1 Replies View Related

Can't Open .sdf DB On Emulator (Pocket PC)

Mar 28, 2008

Hi,

I'm a developer of VB.NET mobile applications at work. We have used Access in the past, and manually pushed flat files to and from the scanner. We are now exploring SQL CE.

Trouble is, I am having a difficult time figuring out how to open SQL CE databases on the Pocket PC emulator. I've worked more on the middleware programs in the past - and have just dealt with ADO.NET connection strings - not the actual development on the scanner itself.

I am try to figure out how to actually connect to SQL Server CE on the Pocket PC 2003 SE emulator.

When I deploy the application on the emulator, it installs SQL Server CE onto the emulator. However, I'm not sure how to install the sample database (starting off with Northwind.sdf for testing purposes) onto the emulator. I'm also not positive the connection string is correct - as it seems to be different than typical ADO.NET.

Here's my code (for connecting to the database) so far.





Code Snippet

Public Class SampleInventorySystem

Private _conn As SqlCeConnection
Public Sub New()

' This call is required by the Windows Form Designer.
InitializeComponent()


_conn = New SqlCeConnection("Data Source = .Northwind.sdf") 'This is one of 'many connection strings I've tried



End Sub
Private Sub SampleInventorySystem_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load


Dim cmd As New SqlCeCommand()


cmd.Connection = _conn
cmd.CommandText = "SELECT [Employee ID], [Last Name], [First Name], Photo FROM Employees"




Try


_conn.Open()
Catch ex As Exception
MessageBox.Show("Error opening database", "Error")
End Try

End Sub

End Class
When I deploy the application, the Try Catch block catches the error "Error Opening Database". I've also tried putting the full path for the connection string. Is there a folder which I should directly put the .sdf file into the emulator - similar to the folder directory of the scanner? (i.e. Storage Card/...)

Thanks for your help!

View 4 Replies View Related

[Ask]Getting Files From Pocket Pc Emulator To Desktop Pc

Jun 8, 2006

hi...!
I'm creating a small device application using visual studio.NET 2003. Is it possible to get a sql server ce database file (.sdf) that i created at the pocket pc emulator to my desktop pc ?
If that's possible, then can you tell me how to do that ??

thanx b4

View 5 Replies View Related

HELP: SqlCeConnection Path Error In .NET Compact Framework (Pocket PC Emulator)

Apr 4, 2007



Hi all,



I am trying to access my SQL Server database through SqlCeConnection:



cecon = new SqlCeConnection("Data Source=D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf");

cecon.Open();



I am getting the following error:



System.Data.SqlServerCe.SqlCeException was unhandled
Message="The path is not valid. Check the directory for the database. [ Path = D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf ]"
HResult=-2147467259
NativeError=25009
Source="SQL Server 2005 Mobile Edition ADO.NET Data Provider"
StackTrace:
at System.Data.SqlServerCe.SqlCeConnection.ProcessResults()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at nddbpda.frmCeMain.frmCeMain_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 nddbpda.Program.Main()





When I tried to get the path from which the database file is being accepted, I got a different path:



string path;

path = System.IO.Path.GetDirectoryName(

System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);

MessageBox.Show(path);



This code gives me this path:



Program Filesddbpda





Then I changed the path in my connection string to this:



cecon = new SqlCeConnection("Data Source=\Program Files\nddbpda\nddbpdadatabase.sdf");

cecon.Open();



When I ran my application it worked (virtually), but the database is not getting updated (for obvious reasons).





What should I do now to correct this?



Thanks in advance.

Saswata.



View 3 Replies View Related

HELP: SqlCeConnection Path Error In .NET Compact Framework (Pocket PC Emulator)

Apr 4, 2007



Hi all,



I am trying to access my SQL Server database through SqlCeConnection:



cecon = new SqlCeConnection("Data Source=D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf");
cecon.Open();




I am getting the following error:



System.Data.SqlServerCe.SqlCeException was unhandled
Message="The path is not valid. Check the directory for the database. [ Path = D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf ]"
HResult=-2147467259
NativeError=25009
Source="SQL Server 2005 Mobile Edition ADO.NET Data Provider"
StackTrace:
at System.Data.SqlServerCe.SqlCeConnection.ProcessResults()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at nddbpda.frmCeMain.frmCeMain_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 nddbpda.Program.Main()






When I tried to get the path from which the database file is being accepted, I got a different path:



string path;
path = System.IO.Path.GetDirectoryName(
System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
MessageBox.Show(path);






This code gives me this path:



Program Filesddbpda






Then I changed the path in my connection string to this:



cecon = new SqlCeConnection("Data Source=\Program Files\nddbpda\nddbpdadatabase.sdf");
cecon.Open();






When I ran my application it worked (virtually), but the database is not getting updated (for obvious reasons).





What should I do now to correct this?



Thanks in advance.



Saswata.

View 5 Replies View Related

Connecting Sql Server 2005 On Windows 2003 Using ASP Local

Feb 17, 2007

Hello!I'm migrating an IIS/SQL-Server application from Windows NT4.0 and SQL-Server 2000 to Windows 2003 Server and SQL-Server 2005.My problem is that it is not possible to connect local (IIS and SQL-Server 2005 are runnng on the same node) using ODBC. Running theapplikation on a remote IIS (XPPro) all works fine. I can't see anydifferences in the ODBC-configuration.Any idea?Thanks

View 5 Replies View Related

Connecting To SQL Server 2005 Express Edition From VS 2003?

Apr 13, 2006

Hi,

How do I connect to Sql Server 2005 express from Visual Basic. Net 2003 ?

Kumar

View 4 Replies View Related

Connecting Visual Studio 2003 To SQL Server Express 2005 Edition

Jan 11, 2006

I was wondering if it is possible to connect the SQL Server 2005 Express Version to Visual Studio 2003.If its possible , how can it be done?Cos i seem to have an error if i do so.

View 4 Replies View Related

VS 2005/SQL Server2005 - Direct Connection From Win Mobile Emulator To Desktop SQL Server 2000 Or 2005

Aug 10, 2007

Hello Everyone,

I'm trying to connect to Desktop SQL Server 2000 from Windows mobile PC Emulator (VS 2005). I need a direct connection using connection string to SQL Server 2000 through local wireless network without IIS.

Bellow is the code that I use. After executing this code I get an error on line Conn.Open(). Error says SQL Server does not exist or access denied.
SQL is un and running, and I can log in using SA username from the desktop. Even if I chance IP for another SQL server in my connection string I still get the same error. There is no firewall of any kind running.


Dim connectionSTR As String = "Persist Security Info=False;Integrated Security=False;Server=192.168.0.202,1433;initial catalog=MyDB;user id=sa;password=;"

Dim Conn As SqlConnection

Conn = New SqlConnection(connectionSTR)

Conn.Open()


If Conn.State = ConnectionState.Open Then
MessageBox.Show("Open")
End If


About my environment: SQL Server 2000 is running on Desktop PC with Windows XP SP2. Application which I need to connect to SQL Server is in Visual Studio 2005. I execute the application in Windows Mobile PC Emulator and try to connect to SQL Server from emulator.

Your advice and help is very appreciated

Thank you

Ika


View 3 Replies View Related

How To Connect With SqlServer 2000 In Pocket PC 2003 Application.

Oct 31, 2007

How to Connect sqlServer 2000 in Pocket PC 2003 Application.
In Packet PC 2003 Application I have to connect to sql server 2000 on
my machine. The application gives error if connected using sqlConnection. Is SQL server CE necessary to connect to sql server 2000 in .Net Compact Framework?

View 1 Replies View Related

SQL 2005 Express And Visual Studio 2003 - Connecting

Jul 20, 2006

I have Visual Studio 2003 and had used it successfully with MSDE. I recently upgraded to SQL 2005 Express and cannot seem to connect to the SQL server. it appears in the list of servers on localhost, but when I try to create a new database it tells me that it "cannot create databases on this server." It will not even open up any existing databases.

I have .NET 2.0 installed. I uninstalled SQL and reinstalled it, but nothing seems to help. I feel I must be missing something, but do not know what.

I no longer have the MSDE installation files, so I hope I can get Studio to talk to SQL Express.

Any help is appreciated.

View 22 Replies View Related

Connecting To SQL Express 2005 Via Web.Config File In Visual Studio 2003

Oct 30, 2007

Hi
 I am following a project to build a small E-Commerce site from a book I have purchased and I have having problems connecting to the SQL Database with the code supplied.
The book is Apress Beginning ASP.NET 1.1 E-Commerce
http://www.amazon.co.uk/Beginning-ASP-Net-1-1-E-Commerce-Professional/dp/1590592549/ref=sr_11_1/202-7684451-7995058?ie=UTF8&qid=1193780707&sr=11-1
 The code added to the Web.Config file is :
<configuration>
<appSettings>
<add key="ConnectionString" value="Server=(local)NetSDK;Integrated Security=True;Initial Catalog=JokePoint" />
</appSettings>
 
The connection details are in a class file called Catalog.vb and is as follows
Imports System.Data.SqlClientPublic Class Catalog
Public Shared Function GetDepartments() As SqlDataReader
'Create the connection objectDim connection As New SqlConnection(connectionString)
'Create and initialize the command objectDim command As New SqlCommand("GetDepartments", connection)
command.CommandType = CommandType.StoredProcedure
'Open the connection
connection.Open()
'Return a SqlDataReader to the calling functionReturn command.ExecuteReader(CommandBehavior.CloseConnection)
End Function
Private Shared ReadOnly Property connectionString() As String
GetReturn ConfigurationSettings.AppSettings("ConnectionString")
End GetEnd Property
End Class
 The error is.....
Cannot open database "JokePoint" requested by the login. The login failed. Login failed for user 'MachineNameASPNET'. 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: Cannot open database "JokePoint" requested by the login. The login failed. Login failed for user 'MachineNameASPNET'.Source Error:




Line 15: 'Open the connection
Line 16:
Line 17: connection.Open()
Line 18:
Line 19: 'Return a SqlDataReader to the calling function
Source File: C:MyCommerceSiteJokePointBusinessObjectsCatalog.vb    Line: 17 Stack Trace:




[SqlException: Cannot open database "JokePoint" requested by the login. The login failed.
Login failed for user 'MachineNameASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
JokePoint.Catalog.GetDepartments() in C:MyCommerceSiteJokePointBusinessObjectsCatalog.vb:17
JokePoint.DepartmentsList.Page_Load(Object sender, EventArgs e) in C:MyCommerceSiteJokePointUserControlsDepartmentsList.ascx.vb:44
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()

The connection tests ok in Visual Studio 2003. All permissions are set using SQL Management Studio Express 2005.
The book is using SQL 2000, I have been trying different connection syntax's in the Web.Config file all day and now I have a big headache. I know its something simple, can anyone please advise ?
Thanks in advance.
 
Mark

View 3 Replies View Related

Need Help On A Visual Basic.net Pocket Pc App. With SQL Server CE 2005 And SQL Server 2005 Synchronization Problem

Aug 12, 2007



Hi,
I am developing an application for pocket pc 2003 smart device which utilizes synchronization between SQL CE 2005 and SQL server 2005 by means of REMOTE DATA ACCESS method call PULL( ) and PUSH( ) but currently these are the details of the error Im encountering when PULL( ) method is called:


Error code: -2147467259
Descripion: An error occured on the computer running IIS.Restart the IIS server.

Minor error: 28022
Source: SQL server CE
Currently Im developing this application as a final project and due to some limitations I have setup my pc to act as the SQL server and the IIS server both on the same machine.

Any help will be appreciated, thanks.

View 5 Replies View Related

Sql Server 2005 &&amp; Pocket Pc2003Se Connection

Dec 21, 2006

how do i connect to sql server with pocket pc2003 se emulator.it gives me the sql exception all the time.i tried to install virtual machine network adapter but result is same.Am i missing something?



Thanks in advance

View 1 Replies View Related

Beginner Q: Pocket PC Access To SQL Server 2005

Feb 28, 2006

Hi,

I am a total beginner to Pocket PC, and a 2-month beginner to SQL Server 2005 and Visual Studio 2005. I made a database Pillbox.mdf, and wrote a Windows Forms program to access it. It's really easy. I just added a Data Source, chose tables and Stored Procedures, and dragged them onto my forms. It automatically created adapter classes and a DataGrid for me.

Next, I wanted to do the same thing for Pocket PC. I did the same drag and drop thing, and was happy to see the empty DataGrid in the emulator (design-time) form. From here on, trouble. When I ran it, it said it could not connect.

So some questions:

1) Does my connection string have to change? It has 3 parts: machine name, database name, and security spec. It specifies my machine name. Is that ok? Is it known by the Pocket PC, or do I have to specify http something? Does my machine have to change any settings to become a "server"? It's just a standalone PC with no network. I understand the emulator chooses to pretend that it's not "on" my computer. Is the database name known by the Pocket PC? (Same type of question.) And is Windows authentication ok on a Pocket PC? Or must I create a name/password pair on SQL server?

2) When I went to modify my connection string, I noticed a setting to specify the Data source. For SQL Server 2005, it asks me for a dbo, but for SQL Server Mobile, it asks me for a *.sdf file. What type of file is this? Is there a way to generate this from my other database? Is it not possible to have the the Pocket PC app point to the same database as the Windows app? Oh... does the sdf represent the Pocket PC's local database? If so, then my question is just how to populate it. But I will also have to update the main database at some point. I guess I'm confused about how Pocket PC's are supposed to work.

3) Do I have to deploy SQL CE or something? I think I read that Visual Studio does it automatically. It's a bit hard reading blogs because many comments talk about things that are now contained in VS. One blog was talking about 7 dlls that need to be downloaded to the Pocket PC.

4) My application just has to get a table, store it on the Pocket PC, and allow the user to modify and update records. The bandwidth should be low, as the table is small and updates should not be frequent. Is this a reasonable design? What I am asking is if it's ok to have direct database access, or if I should package up the data in some custom format, and use a Web service to pass the data back and forth. I have read and understood articles why you should not pass a Dataset in a web service, but the point was just that web services can be interoperable, so why spoil that with MS-only Datasets. In my case, I just want to get this simple app up and running quickly.

Thanks in advance.

View 1 Replies View Related

How To Migrate Data From Sql Server 2005 To Local Pocket PC?

May 8, 2006

Hi,

I have a database on a sql server 2005, and I would like to migrate data from sql server 2005 to local Pocket PC. How can I create a database on local Pocket PC and how to migrate the data from sql server 2005 to local Pocket PC? The operating system on Pocket PC is Microsoft® Windows Mobile„¢ 2003 Second Edition. Thanks in advance.

View 1 Replies View Related

SQL Server Mobile 2005 Merge Replication Failing Over SSL, But Can Browse Through Pocket IE.

Jan 28, 2008

Hi All, this system is scheduled to go live in near to a day... but i have hit an issue when switching on SSL. Any help would be greatly appreciated.

Device Env:
Windows Mobile 5.0 + Messaging and Security Feature Pack
SQL Server Mobile 2005.

Merge replication works fine without SSL. After running the Configure Web Sync wizzard to setup SSL merge replication no longer works. Note i checked using pocket IE by browsing to https://mycompany.com/pub/sqlcesa30.dll?diag and all worked fine. There was no prompt saying the cert was bad etc.

The certificate is a:
Equifax secure global ebusiness CA-1 cert.
Signature algorithm md5RSA
public key RSA(1024 bits)
thumbprint algorithm sha1

Stacktrace given is:
- ex {"A request to send data to the computer running IIS has failed. For more information, see HRESULT."} System.Data.SqlServerCe.SqlCeException
- Errors {System.Data.SqlServerCe.SqlCeErrorCollection} System.Data.SqlServerCe.SqlCeErrorCollection
Count 1 Integer
Item In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user. System.Data.SqlServerCe.SqlCeError
HResult -2147012858 Integer
InnerException Nothing System.Exception
Message "A request to send data to the computer running IIS has failed. For more information, see HRESULT." String
NativeError 28037 Integer
Source "Microsoft SQL Server 2005 Mobile Edition" String
StackTrace "at System.Data.SqlServerCe.NativeMethods.CheckHRESULT()
at System.Data.SqlServerCe.SqlCeReplication.Synchronize()
at MyApp.Helper.Replication.SynchronizeInit()
at MyApp.CallSynchronize()
at System.Windows.Forms.Control.OnGotFocus()
at System.Windows.Forms.Control.WnProc()
at System.Windows.Forms.ContainerControl.WnProc()
at System.Windows.Forms.Form.WnProc()
at System.Windows.Forms.Control._InternalWnProc()
at Microsoft.AGL.Forms.EVL.EnterMainLoop()
at System.Windows.Forms.Application.Run()
at MyApp.Program.Main()

View 2 Replies View Related

Cannot Install SQL Server 2005 On A Windows 2003 Cluster In Virtual Server 2005

Jun 5, 2006

I
am trying to install SQL 2005 in a 2-node virtual Windows 2003 cluster. I set
the cluster up through Virtual Server 2005 with 2 virtual nodes and one
virtual domain. The nodes can connect to each other as well as the
physical machine. When I try to install a fresh copy of SQL 2005 on my
cluster, I get an error every time. The
error stops the installation while checking system configuration after
installing prerequisites. The log file entry is as follows:

*******************************************
Setup Consistency Check Report for Machine: --SERVERNAME--
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: Warning
Description:
IIS is not installed, therefore Report Server feature will be disabled
Action: Install IIS in order for Report Server feature to be enabled
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
<Func Name='PerformDetections'>
1
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution. Error information reported during run:
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "ComputerList" {"SqlComputers", "", ""} in cache
Source File Name: datastoreclusterinfocollector.cpp
Compiler Timestamp: Fri Sep 16 13:20:12 2005
Function Name: ClusterInfoCollector::collectClusterVSInfo
Source Line Number: 883
----------------------------------------------------------
Failed to detect VS info due to datastore exception.
Source File Name: datastoreclustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56
----------------------------------------------------------
Failed to find a cluster group that owned shared disk: J:
WinException : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: datastoreclustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56

View 3 Replies View Related

Why I Can't Connect Sql Server 2000 With Wm5 Or Emulator ?

Feb 26, 2006



Why I can't connect sql server 2000 with wm5 or emulator ?

I used windows server 2003, sql server 2000 Enterprie SP4, visual studio 2005.

My this code can connect to sql server with win application (.net framework 2.0) but can't connect to sql server with device application (.net compact framework).

Dim strcon As New SqlConnection("Data Source=192.168.0.3;Initial Catalog=nortwind;User ID=sa")

Try

strcon.Open()

Dim sqlcom As New SqlCommand("select * from products", strcon)

Dim s As String = sqlcom.ExecuteScalar.ToString

Catch ex As Exception

MessageBox.Show(ex.Message.ToString, "")

Finally

strcon.Close()

End Try

Question

1. How to tip for setup and config windows server 2003 and sql server 2000 can connect with device?

2. What's IP of device in running ?

View 23 Replies View Related

Emulator Error To Replicate Data On SQL Server

Aug 18, 2005

Hi Guys,

View 7 Replies View Related

SPS 2003 And MS SQL 2005 Server

Apr 13, 2008

I have a question? Can SPS 2003 use MS SQL 2005 Server?

View 4 Replies View Related

Wrong Version Of SQL Server Mobile Deployed To Emulator?

Feb 2, 2006

I am developing a mobile application with Visual Studio 2005 RTM. I created a .SDF database from scratch within the Server Explorer window. Based on the properties of the database, this is a version 3.0 DB. I then deploy the application to the Pocket PC 2003 SE Emulator and I receive an error when trying to open the database from my app. It's a very generic error:

System.SData.SqlServerCE.SqlCEException

I trap the error in my code, but there is no message in the exception object.

If I try to open it with Query Analyzer on the device, I get an error stating "The file is not a valid database file". It appears that SQL CE 2.0 was deployed to the emulator.

I noticed that when I add a reference in my project to the System.Data.SQLServerCE namespace, it defaults to this DLL:

C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev2.0System.Data.SqlServerCe.dll

I tried removing that and manually adding a reference by browsing to this 3.0 DLL:

C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev3.0System.Data.SqlServerCe.dll

I then receive the following build error:

Unable to load referenced library 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev3.0System.Data.SqlServerCe.dll': Version 2.0 is not a compatible version.

If I build the database in my application from scratch from within my code, everything works fine, which I believe is because it is a 2.0 database that is generated.

To make a long story short:

How do I get my project to reference the 3.0 SQL Server CE namespace and deploy it to the emulator?

View 1 Replies View Related

Installing SQL Server 2005 64 Bit On 32 Bit 2003 OS

Nov 27, 2007

Can you install 64 bit 2k5 sql server on 32 bit 2k3 OS, yes, no? if there is way then can anyone guide me.
thanks
Derek

View 5 Replies View Related

MS SQL 2005 + Windows Server 2003 SP2

Jul 13, 2007

At first I thought it was just me, but has anyone else noticed that SQL 2005 suffers a performance hit when you install Windows Server 2003 SP2?



Since SP2, memory and hard drive usage has gone through the roof on a number of servers I use. It may just be coincidence... but it seems unlikely.

View 6 Replies View Related

VS 2003 Assembly In SQL Server 2005

Oct 11, 2007



Hi to all,

i have one VS 2003 assembly,now i want to laod this asseembly in SQL Server 2005 .then i am going to write SQL-CLR 2005 function in which i want to use some functions of this VS 2003 assembly.is this possible?
please help me....

Thanks in advance.


Chetan S. Raut.

View 2 Replies View Related

SQL 2005 - Window 2003 With IIS Server

Sep 11, 2006

Dear ALl,

We have SQL 2005 running on Window 2003.

Our Dev team created a web application. Which user we need to add in the database and what permission we need to assign him. So web application can do read, write and modify in the database tables.


Database name = ACCT
IIS server name = MASS     (running on different machine win 2003)

What role following accounts play in the connection of iis to database server login.

1: ASP.NET
2: MASSii$1  & massiis1

If
<indentitt impersonate = TRUE  or False> in the config file..


 

Thanks in advance.

 

 

 

View 1 Replies View Related

Sql Server Mobile 2005 And VS 2003

Apr 17, 2007



Hi All:



I need one clarification. Can i use sql server Mobile 2005 and vs 2003 (.NetCF 1.0) for my application.



Thanks

Vamsi

View 5 Replies View Related

Win 2003 X64 + SQL 2005 &< Win 2003 32 + SQL 2000?

Jul 23, 2005

I may not be the best forum for this post, however I believe some onecan still help me or direct me somewhere else.I'm finding that win 2003 x64 and SQL 2005 CTP is slower than win 2003and SQL 2000.Machine A: Opteron 2.2 (248) w/ 2 cpus. 8GB memory. SCSI disk array.Windows Enterprise 2003 x64 final release. SQL Server 2005 enterpriseCTP.Machine B: Opeteron 2.2 (248) w/ 2 CPUs. 4GB Memory. IDE Drives.Windows Server 2003 (32bit) and SQL Server 2005 (standard).I'm using Cognos' DecisionStream as the ETL tool (32bit). I have theidentical job on both machines. Machine A is slower to do my nightlybuild (1h 20m) vs. Machine B (50m).I've done no tweaking of the databases. I Used SQL 2005's studio tocopy the database from Machine B to Machine A.The only major difference is the O/S and SQL, the machines are samespeed, however Machine A has twice the memory and faster disk; so Iwould expect it to be faster.Can anyone think of smoking guns I might be missing?TIA

View 2 Replies View Related

Connecting To SQL Server 2005 From Visual C# 2005 Express Edition

Sep 29, 2006

I had SQL Server Express Edition installed. I then uninstalled both it and Visual C#. I then installed SQL Server 2005 Developer's Edition and reinstalled Visual C# -- both on the same machine. I can connect to SQL Server 2005 using SQL Server Management Studio. However, Visual C# is a different story. When I try to add a new Data Connection, it defaults the data source to .SQLEXPRESS, which is no longer on my machine. I can select .MSSQLSERVER, but when I click on either OK or Test Connection, I time out with an error message -- error 25 - Connection string is not valid. The connection string that is shown at the bottom of the Advanced dialog box is -- Data Source=.MSSQLSERVER;AttachDbFilename=E:InventoryDataInventory_Data.MDF;Integrated Security=True;Connect Timeout=30;User Instance=True

View 12 Replies View Related

Connecting SQL Server 2005 Dev Edition To Visual Studio 2005

Apr 14, 2008



ok so i have set up SQL server 2005 on a Windows server 2003 machine. I am trying to connect to it via ODBC and/or Visual Studio 2005 on a computer running off the same switch. I have set SQL server to accept remote connections and named pipes as well as had the port unblocked. when i try and connect to it via Vista ODBC wizard or visual studio wizard it says that the server is not there or access is denied.

The server is set up for SQL authentication and i am 100% pos that the username/password i am using is correct. i am at a total loss as to what to do to get my vista machine to talk to that SQL server.

View 1 Replies View Related

Reg: Export Excel 2003 To Sql Server 2005

Mar 31, 2008

I want to export Excell 2003 to Sql Server 2005. I am having the following error while execute the query.


declare @SQL varchar(8000)
create table #temp(i int identity(1,1),SiteName varchar(100),SiteDescription varchar(5000),SiteURL varchar(500),CategoryName varchar(200))
set @SQL='Insert into #temp Select * From OPENROWSET (''Microsoft.Jet.OLEDB.4.0'',''Excel 8.0;Database=' +
'a.xls' +';HDR = YES;IMEX=0'',''SELECT * FROM [Sheet1$]'')'

exec (@SQL)



The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

I need a solution urgently. help Pls

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved