SQL 2005 Mobile : The File Is Not A Valid Database File

Jun 8, 2006

I used SQl Server replication to create a new database (as I did using Visual Studio 2003) but when I go the Pocket PC and click on the file I get a native error 25011 with a description

The file is not a valid database file
An Internal error has occurred[,,,Databasename,,]
Interface defining error: IID_IDBInitialize

When I check on my Pocket PC what programs are available I've got Query Analyser 3.0 and SQLCE Query. It appears that the .sdf file is associated with SQLCE Query because when I use that to try and connect to the same database I get the same error.

If I use Query Analyser 3.0 (after having copied the .sdf file) to the temp directory I'm able to open the database.

There is a similar post to this one but it doesn't help me.

Is it that SQLCE Query is wrongly associated with the .sdf file?

If so how do I change that?

Or is there some other problem preventing me clicking on the .sdf db to open it?

I have recreated my project in Visual Studio 2005 and rebuilt all my components in 2005. There are some external ones that I use that I can't do this for.

The following is the build output that I get when I deploy to a clean PDA with a hard reset performed

------ Build started: Project: Printing, Configuration: Release Any CPU ------
No way to resolve conflict between "System.Data.SqlServerCe, Version=3.0.3600.0, Culture=neutral,

PublicKeyToken=3be235df1c8d2ad3, Retargetable=Yes" and "System.Data.SqlServerCe, Version=1.0.5000.0, Culture=neutral,

PublicKeyToken=969db8053d3322ac, Retargetable=Yes". Choosing "System.Data.SqlServerCe, Version=3.0.3600.0, Culture=neutral,

PublicKeyToken=3be235df1c8d2ad3, Retargetable=Yes" arbitrarily.
Printing -> C:DevmillarMobileSellercode2005MobileSellerMobileSellerPrintinginReleasePrinting.dll
------ Build started: Project: MobileSeller, Configuration: Release Any CPU ------
Consider app.config remapping of assembly "System.Data, Culture=neutral, PublicKeyToken=969db8053d3322ac, Retargetable=Yes"

from Version "1.0.5000.0" [] to Version "2.0.0.0" [C:Program FilesMicrosoft Visual Studio

8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.Data.dll] to solve conflict and get rid of warning.
Consider app.config remapping of assembly "System.Windows.Forms, Culture=neutral, PublicKeyToken=969db8053d3322ac,

Retargetable=Yes" from Version "1.0.5000.0" [] to Version "2.0.0.0" [C:Program FilesMicrosoft Visual Studio

8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.Windows.Forms.dll] to solve conflict and get rid of warning.
Consider app.config remapping of assembly "System, Culture=neutral, PublicKeyToken=969db8053d3322ac, Retargetable=Yes" from

Version "1.0.5000.0" [] to Version "2.0.0.0" [C:Program FilesMicrosoft Visual Studio

8SmartDevicesSDKCompactFramework2.0v2.0WindowsCESystem.dll] to solve conflict and get rid of warning.
C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Microsoft.Common.targets : warning MSB3247: Found conflicts between different

versions of the same dependent assembly.
MobileSeller -> C:DevmillarMobileSellercode2005MobileSellerMobileSellerMobileSellerinReleaseMobileSeller.exe
C:DevmillarMobileSellercode2005MobileSellerMobileSellerMobileSellerfrmInvoice.vb(546,9): warning VSD101: Members not

supported by the device platform should not be called: System.Windows.Forms.Panel.set_Text is not a supported method in this

platform.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerMobileSellerfrmInvoice.vb(634,9): warning VSD101: Members not

supported by the device platform should not be called: System.Windows.Forms.Panel.set_Text is not a supported method in this

platform.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerMobileSellerfrmInvoice.vb(706,9): warning VSD101: Members not

supported by the device platform should not be called: System.Windows.Forms.Panel.set_Text is not a supported method in this

platform.
C:DevmillarMobileSellercode2005MobileSellerMobileSellerMobileSellerfrmInvoice.vb(846,9): warning VSD101: Members not

supported by the device platform should not be called: System.Windows.Forms.Panel.set_Text is not a supported method in this

platform.
Done building project "MobileSeller.vbproj".
------ Skipped Deploy: Project: BO, Configuration: Release Any CPU ------
Project not selected to build for this solution configuration
------ Skipped Deploy: Project: Printing, Configuration: Release Any CPU ------
Project not selected to build for this solution configuration
------ Deploy started: Project: MobileSeller, Configuration: Release Any CPU ------
Deploying 'C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOinReleaseInTheHand.Data.Adoce.dll'
Deploying 'C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOinReleaseInTheHand.Interop.dll'
Deploying 'C:DevmillarMobileSellercode2005MobileSellerMobileSellerPrintinginReleasePocketHTMLprint_NetCF.dll'
Deploying 'C:DevMILLAR CODE CABINETVS2003CFReferencesUSICF.dll'
Deploying 'C:DevVS2005CFReferences
eleaseSignature.dll'
Deploying 'C:DevVS2005CFReferences
eleaseRealUpDown.dll'
Deploying 'C:DevmillarMobileSellercode2005MobileSellerMobileSellerPrintinginReleasePrinting.dll'
Deploying 'C:DevVS2005CFReferences
eleasePhoneAPI.dll'
Deploying 'C:DevVS2005CFReferences
eleaseMVnetApplication.dll'
Deploying 'C:DevVS2005CFReferences
eleaseMobileHList.dll'
Deploying 'C:DevVS2005CFReferences
eleaseMobileGrid.dll'
Deploying 'C:DevVS2005CFReferences
eleaseImageButtons.dll'
Deploying 'C:DevVS2005CFReferences
eleaseCreditCardValidator.dll'
Deploying 'C:DevmillarMobileSellercode2005MobileSellerMobileSellerBOinReleaseBO.dll'
Deploying 'C:DevmillarMobileSellercode2005MobileSellerMobileSellerMobileSellerinReleaseMobileSeller.exe'
========== Build: 3 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 1 succeeded, 0 failed, 2 skipped ==========

View 5 Replies


ADVERTISEMENT

SQL Mobile Create Sdf File From SQL 2005 DB

Dec 28, 2006

Hi,

I'm trying to create a SQL Mobile .sdf file from my SQL Server 2005 database and cannot. I read the ms support docs for doing this and have had no luck . I created the respective publication and SQL Subscription for the db and when i run the process (not sure if i'm running the right process - docs don't say) it creates a directory under a "unc" directory with all my table objects (articles) with subscription/replication files for each table such as .cft, .bcp, .dri, .prc, .sch, and .trg. But no .sdf file for my SQL Server 2005 database.

All I want is the .sdf file so that i can copy it to my Pocket PC device and then connect my mobile application to it. I want to copy my SQL Server 2005 database to my device so that the mobile app uses the db on the device. Sounds easy - but it's not. Can someone tell me the easiest way to do this or point me to a doc that explains it. I checked the ms support docs and they state "after the .sdf file has been created..." in "Pre-building a SQL Server Mobile Database" doc. Where/How is the .sdf file created is what I would like to know?

Any help would be appreciated.

Thanks - Dave





View 16 Replies View Related

SQL 2012 :: Transaction Log Shipping Secondary Error - Tuf Is Not A Valid Undo File For Database

Jun 18, 2015

I received an alert from one of my two secondary servers (all servers are running 2012 SP1):

File 'E:SQLMS SQL ServerMSSQL11.MSSQLSERVERMSSQLDATAMyDatabaseName_DateTime.tuf' is not a valid undo file for database 'MyDatabaseName (database ID 8). Verify the file path, and specify the correct file.

The detail in the job step shows this additional information:

*** Error: Could not apply log backup file 'MyDatabaseName_DateTime.trn' to secondary database 'MyDatabaseName'.(Microsoft.SqlServer.Management.LogShipping) ***

*** Error: Table error: Page (0:0). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1.

Table error: Page (0:0). Test ((m_type >= DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 0.

Table error: Page (0:0). Test (m_freeData >= PageHeaderOverhead () && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192.
Starting a few minutes later, the Agent Job named LSRestore_MyServerName_MyDatabaseName fails every time it runs. The generated log backup, copy, and restore jobs run every 15 minutes.

I fixed the immediate problem by running a copy-only full backup on the primary, deleting the database on the secondary and restoring the new backup on the secondary with NORECOVERY. The restore job now succeeds and all seems fine. The secondaries only exists for DR purposes - no one runs reports against them or uses them at all. I had a similar problem last weekend on a different database that is also replicated between the same servers. I've been here for over a year, and these are the first instances of this problem that I've seen. However, I've now seen it twice in a week on the same server.

View 0 Replies View Related

An Attempt To Attach An Auto-named Database For File (file Location).../Database.mdf Failed. A Database With The Same Name Exists, Or Specified File Cannot Be Opened, Or It Is Located On UNC Share.

Sep 2, 2007

Greetings, I have just arrived back into the country (NZ) and back into ASP.NET.
 I am having trouble with the following:An attempt to attach an auto-named database for file (file location).../Database.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
It has only begun since i decided i wanted to use IIS, I realise VWD comes with its own localhost, but since it is only temporary, i wanted a permanent shortcut on my desktop to link to my intranet page.
 Anyone have any ideas why i am getting the above error? have searched many places on the internet and not getting any closer.
Cheers ~ J
 

View 3 Replies View Related

Sqlexpr.exe Is Not A Valid Win32 Application, I Downloaded The Sql Express 2005 Edition When I Click On Exe File. I Receive A

May 26, 2006

I am using a windows xp sp 2. I have visual web developer 2005 express edition. .net Framework 2. but when i downloaded the sql 2005 express edition. when i click on the sqlexpr.exe. I receive a message " sqlexpr.exe is not a valid win32 application".



just to try I downloaded the framework 2. for win32 , when i click on the exe file I receied the same message.



Well someone help me please with the sql server. i have almost given it up and using this tool for my last resort.

Thanks

trying hard

View 4 Replies View Related

Backup Master Key, Cannot Write Into File 'c: Empmaster'. Verify That You Have Write Permissions, That The File Path Is Valid.

Jul 12, 2006

Hi,



I tried to backup the master key by the following syntax :

OPEN MASTER KEY DECRYPTION BY PASSWORD = 'mypassword'

BACKUP MASTER KEY TO FILE = 'c: empmaster' ENCRYPTION BY PASSWORD = 'mypassword'

but it failed and i got the following message:

Cannot write into file 'c: empmaster'. Verify that you have write permissions, that the file path is valid, and that the file does not already exist.

NB: I am using the "sa" user to execute this command.

I know that we have a security permission issue , but where and how ?



Regards,

Tarek Ghazali

SQL Server MVP

View 12 Replies View Related

Getting An Error SQL Mobile Encontered A Problem When Openeing The Database; The Path Is Not Valid

Mar 3, 2006

I am using VS 2005, SQL 2005, SQL Mobile

The development environment & the SQL Box are two different boxes.

I am trying to create a simple application where I want to synchronize data between Pocket PC application's ( Emulator) local database(SQL Mobile) to SQL 2005 Database. I have tried the steps outlined in the following link

http://msdn2.microsoft.com/en-us/library/ms171908(SQL.90).aspx

Once I have completed all the steps as per the steps in the above link, I have copied the .sdf file to an another machine where I have the development environment. I have created a device application in VS 2005 and created a datasource poiting to the file (.sdf) copied locally.

Then I have added the following code
string filename = @"e:VelsunMobileTest.sdf";

public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
DeleteDB();
Sync();

if (VelsunMobileTestDataSetUtil.DesignerUtil.IsRunTime())
{
// TODO: Delete this line of code to remove the default AutoFill for 'velsunMobileTestDataSet.Customers'.
this.customersTableAdapter.Fill(this.velsunMobileTestDataSet.Customers);
}

}

private void DeleteDB()
{
if (System.IO.File.Exists(filename))
{
System.IO.File.Delete(filename);
}
}

private void Sync()
{
SqlCeReplication repl = new SqlCeReplication();

repl.InternetUrl =
@"http://currdev1/VelsunMobileTest/sqlcesa30.dll";
repl.Publisher = @"currdev1xx";
repl.PublisherDatabase = @"VelsunMobileTest";
repl.PublisherSecurityMode = SecurityType.NTAuthentication;
repl.Publication = @"VelsunMobileTest";
repl.Subscriber = @"VelsunMobileTest";
repl.SubscriberConnectionString = @"Data Source=""e:VelsunMobileTest.sdf"";
Max Database Size=128;Default Lock Escalation =100;";

try
{
repl.AddSubscription(AddOption.ExistingDatabase);
repl.Synchronize();
}
catch (SqlCeException e)
{
MessageBox.Show(e.ToString());
}
}

I would appreciate any help.



Thanks

-Sundar






View 1 Replies View Related

SQL 2005 Enterprise Edition The Image File Setup.exe Is Valid, But Is For A Machine Type Other Than The Current Machine

Nov 28, 2006

Hi All,

I have enterprise version software CD1 and CD2 of SQL server 2005

when i try to run setup.exe..the following error pops -up

The image file Setup.exe is valid, but is for a machine type other than the current machine

MY OS version is windows 2003 32bit Operating system...

I am suspecting the binarie may be of 64bit.. How do we check the binaries are 32 bit and 64 bit software

Thanks for your Help

Mohan



View 4 Replies View Related

The Configuration File Name Is Not Valid

Jan 28, 2008



The configuration file name "C:......XMLSSIS2005_ConStr.dtsConfig" is not valid. Check the configuration file name.

The path is correct but we got this error. Please help us.

View 1 Replies View Related

File Format Is Not Valid

Jun 12, 2015

when installing sql server error showing file format is not vaild

View 3 Replies View Related

The Database File May Be Corrupted. Run The Repair Utility To Check The Database File. [ Database Name = SDMMC Storage Cardwinp

Oct 9, 2007

yes,I have an error, like 'The database file may be corrupted. Run the repair utility to check the database file. [ Database name = SDMMC Storage Cardwinpos_2005WINPOS2005.sdf ]' .I develope a program for Pocket Pcs and this program's database sometimes corrupt.what can i do?please help me

View 4 Replies View Related

%1 Is Not A Valid Win32 Application - Trying To Execute A Batch File

Feb 12, 2008

Today I ran into the error (see title of this post) while trying to execute a batch file using SSIS. If anyone else runs into this problem I want to point them to my post on the issue, as I did not easily find a solution when doing the search myself: http://blog.lyalin.com/2008/02/1-is-not-valid-win32-application-ssis.html

Summary (So you dont need to visit my blog):

I was trying to execute a totally empty placeholder batchfile and this produces the "%1 is not a valid win32 application" error when using Execute Process Task. Simply add something to your placeholder file (like DIR command) and you can continue running your package without error

I hope this saves someone time in the future.


Comments? If anything in my post is inaccurate I hope you guys post some corrections.

Regards,

Dmitry
http://blog.lyalin.com

View 1 Replies View Related

An Attempt To Attach An Auto-named Database For File...failed. A Database With The Same Name Exists, Or Specified File Cannot Be

Mar 24, 2006

I know allot of folks are having this problem and I tried lots of things but nothing works. I understand the problem is coping the SQL Express on another server is the problem - I just not sure what to do?

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

This is the last statement on the Stack Trace:

SqlException (0x80131904): An attempt to attach an auto-named database for file e:wwwdata81d0493fwwwApp_DataTestDatabase.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735091

I checked my server forum and they said I had to name a database:
Example: Database=(unique name);

But this didn't work either.

I just tried a simple web project that has only one database and one table in SQL Express with one sqldatasource and one datagrid. It works fine on my pc but when I use the copy function in Visio Studio 2005 Pro - I can't run the site on the remote server: www.myjewelrydirect.com

I tried coping the database manually. I tried disconnecting the database before I copy it. Below is my connection statement:

<connectionStrings>
<add name="TestDB" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|TestDatabase.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>

With all the comments in these forums - this must be a bug.

I have been working on this problem for over 2 weeks - HELP!



View 1 Replies View Related

Package Failure - Multiple Synchronous Data Flows - File Name Not Valid – /3GB /PAE

Apr 23, 2008

I have a package with 10 synchronous dataflows, which, combined, load about 300MB of flat file data to a database. This package would run successfully on 2 of our database servers, but would regularly fail on a third. The server on which it was failing is a 4 processor box with 16GB Ram with Windows Server 2003, SQL 2005, SSIS and SSRS installed - much more robust than one of the others that the package worked on. The SSIS error messages returned alternated between the following (with no apparent reason why one would show up rather than another, though the first was the most common):

"The file name "\Server1Folder1File1.txt" specified in the connection was not valid."

"The file name property is not valid. The file name is a device or contains invalid characters."

"An error occurred while initializing the flat file parser."

For the first error message, the error would report different connection managers and their associated file as invalid from run to run. All of the files across the 10 dataflows resided in the same network folder, and the package would read in and process a few of them before failing, so the problem was definitely not the connection string.

Searching the forums, etc. for these errors provided no useful information - given the real cause of the problem, these error messages are worse than unhelpful, they send you looking in the wrong direction. It was only when trying to track down another problem on the same server that I discovered the issue. When trying to copy database backups greater than 12GB over the network to this server, the operation would fail with an "Insufficient System Resources" message.

Some research led to the discovery that problem was caused by the /3GB switch in the boot.ini file of the server (don't let your Server team use that switch if you have 16GB of memory or more). Removing the switch and setting SQL to utilize AWE, fixed both the file copy problem AND the SSIS package failure problem. The SSIS package failed, not due to a bad connection string, but rather to insufficient server resources (read memory) to handle the simultaneous connections.

I hope this may help any others trying to track down this kind of SSIS package failure.

I will also provide here what I have gleaned about setting up Memory usage for SQL Server 2005 running on 32 bit Windows Server 2003 (with the caveat that I am no expert €“ corrections and additional information are welcome).

The following links got me started in my research (thanks to the folks who provided such useful information):
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55191
http://articles.techrepublic.com.com/5100-10878_11-6091280.html
http://www.simple-talk.com/community/blogs/brian_donahue/archive/2007/09/30/37747.aspx
http://blogs.technet.com/askperf/archive/2007/03/23/memory-management-demystifying-3gb.aspx
http://www.modhul.com/2007/11/10/optimising-system-memory-for-sql-server-part-i/

Also, search BOL for:
Server Memory Options
Enabling Memory Support for Over 4 GB of Physical Memory
Enabling AWE Memory for SQL Server


Windows Server 2003 provides access to 4GB of virtual address space. By default, 2GB is assigned to the OS and 2GB to applications. This default can be change to 1GB for the OS and 3GB for applications by the use of the /3GB switch in the boot.ini file.

Physical memory over 4GB can be addressed by enabling Physical Addressing Extensions (PAE), which is done by setting the /PAE switch in the boot.ini file. This does not increase the systems virtual address space, rather it increases the size of the page table (which is maintained within the virtual address space), adding entries to reference the physical memory above 4GB.

It is important to note that these two switches are not interdependent (they do different things and you can turn each on or off regardless of the others status), though the combination of them has an impact on server performance and the maximum amount of physical memory which can be addressed.

The /3GB switch only impacts the allocation of the first 4GB of memory (virtual address space) between the OS and applications (default 50/50 % split, with switch on - 25% OS and 75% applications). The /PAE switch enables the system to reference/manage physical memory above 4GB, but does not alter the allocation percentages of the first 4GB of memory between the OS and applications. However, when PAE is enabled, the OS requires more memory within the first 4GB to manage the physical memory above 4GB (due to increased page table entries). With the /3GB switch, the OS has only 1GB of virtual address space, and only enough space to manage a total of 16GB of physical memory. If 32GB of physical memory is installed, 16GB of it will go to waste.

Address Windowing Extensions (AWE) is an API that allows an application to address more than the 2-3GB of memory that is available to applications within the virtual address space (first 4GB of memory). SQL Server can utilize AWE to take advantage of memory above the first 4GB that is made available via PAE, and can even reserve portions for its own use. I believe (though I can€™t remember where I got this bit) that SQL utilizes AWE memory only for the page cache (buffer pool €“ which seems to be a misnomer), and not for other operations.

To enable AWE, see the BOL references above.

The big question: what are the recommended settings for all of these? That all depends on what you have running on the server. You need to leave space for the OS, SQL Server and any other applications you have.

The hard and fast rules:
If you have more than 4GB of RAM, you must use the /PAE switch in order to take advantage of it.
If you have more than 16GB of RAM, you must NOT use the /3GB switch in order to take advantage of it.

Based on anecdotal evidence, I€™ve noticed the following generally recommended guidelines €“ assuming the server is dedicated to SQL.

Use of the /3GB switch seems to be a generally accepted practice if you have 8GB of RAM or less. For between 8 and 16GB, some say never use the /3GB switch, others say you can use it up to 12GB and still others up to 16GB. I interpret this to mean that it all depends on what types of loads are being placed on the server and that testing on individual servers will be required to determine whether or not to use the switch. Certainly that was my experience - the /3GB switch worked fine with 16GB RAM, until the server encountered a certain workload. For me, no more /3GB switch.

For setting SQL to use AWE, most seem to agree that it should be enabled if you have more than 4GB RAM. The setting of max server memory is more complicated. BOL seems to suggest (the €˜Server Memory Options€™ entry) a formula of Total Physical Memory minus 1-2GB for the operating system. Based on a desire to be a bit more conservative, I am now using the following formula:

max server memory = total physical memory

minus

4GB for the OS and application processes (since the AWE memory is utilized for page cache, not SQL processes)

minus

AWE memory required by other applications, including other instance of SQL Server


If anyone has additional insight, or a more refined equation, I could certainly benefit from it.

View 1 Replies View Related

Installing Sql Mobile Via CAB File

Nov 8, 2005

Hi guys,

View 1 Replies View Related

Windows Mobile 5.0 Application &&> Xml File &&> Sql Ce 3.5

Mar 12, 2008



Hi there, i am building a mobile app using vs 2008, the app has about 8 - 12 forms that collect data.. i am thinking of

i am trying to decide how i want to save the temporary work data while the user fills the data collection forms.

when the user selects to create a new report, i will

create a new xml file...
as user moves from form to form, i will update the file
when the user has finished filling up all the data i will create a transaction and insert the data into the sql ce database and delete the file...

i will be using sql ce 3.5
i think it supports transactions
i think it also supports identity.... i am using sql management studio 2005 standalone , so i cannot visually modify the 3.5 sdf.,..,. is there a tool for 2008 that will let me visually modify the table(s)? i dont want to use the 2008 feb community edition...

is there a better way to do this? should i skip the xml and go directly into sql ce insert (for the first record creation) and updates? i think this will be a performance killer on a win mob devilce (5.0)

p.s. i cannot store data in a class, and then commit the class to the transaction because if the application crashes i will loose class data, so xml file will be needed.,

suggestions?

View 7 Replies View Related

Mobile Sdf File Created On Server

Aug 15, 2007

Hi there,

Background: I've created an application to run on windows mobile 5.0 devices. It replicates to a publication on a server. To do this it goes through ASP.net. This creates the database on the Mobile Devices.

Issue: Problem is the initial download of the database is taking 2hours plus to replicate (create) for the first time. So I'm trying to create the .sdf file on the server, zip it, and send it across to the handheld. All subsequent replications take about 5 minutes.

Question: Does anyone know how, or have examples for creating a Mobile CE database on the server. I need to create it using ASP.net and go through a pre-existing publication where a hostname used for filtering.


http://msdn2.microsoft.com/en-us/library/ms173009.aspx explains how to create this in SQL Server Management Stuidio. How do you do the same thing over ASP?

Can this be done using SMO? How do you create a SQLServerCompactEdition database using normal .NET Framework? Thanks for your help!!

View 5 Replies View Related

How To Create, Install And Deploy Dts File For Sqlserver 2000 And Dtsx File For 2005 ?

Apr 24, 2007

Hi,



I am looking for tutorials about how to create dts et dtsx files.

Thanks for your help.



Arioule.

View 1 Replies View Related

How To Convert SLQ Server Express Database File To SQL Compact Edition File?

May 29, 2007

Hi all,



I have a database name MyDatabase (SQL Server Express Dabase File). Is there anyway that I could convert it to SQL Server Compact Edition File?



By the way does anyone here got any problem with programming in SQL Server Compact Edition? It troubles me.



Thanks,

bombie

View 6 Replies View Related

Access To The Database File Is Not Allowed. [ File Name = ],[,,] Happens In VS2005 Environ But SSMSE Is Ok?

Jul 20, 2007

I am developing a C# mobile 5.0SDK app that utilizes SQL2005 Compact Edition device files on Vista using as far as I know the latest SPs and versions.



Last night, I could open tables from the Server Explorer .sdf file, see the contents, edit the schema, etc. Now today, I assume all of a sudden,I am able to open schema but cannot open the table to see the contents. I get:



Microsoft SQL Server 2005 Compact Edition captioned error dialog box that says "Access to the database file is not allowed. [ File name = ],[,,]



Using Sql Server 2005 Management Studio Express, I can open the table, do queries etc. I have tried rebooting, deleting, opening old projects, deleting dataset, disconnecting mobile device, but I still get the same error. I have tried stopping the SQL Server(SQLEXPRESS) service on the server but get:



Cannot open MSSLQ$SQLEXPRESS service on computer 'p5w64'. Access is denied.



I have no idea what to do next to start moving forward again, other than try the XP environment which I will do next.



Has anyone experienced this problem?



Thank you.







View 9 Replies View Related

File Sharing Violation In SQL Server Mobile Edition

May 5, 2008



Hi,
I am facing a wierd problem working with SQL Server Mobile edition database. The code works fine for some time and then it suddenly starts throwing "There is a file sharing violation. A different process might be using the file."
I am disposing and closing the connection after each operation.
Please find the function code below which is being used for any database operation.

SqlCeConnection sqlCon = null;
try
{
sqlCon = ConnectionFactory.getInstance().getPrimDsConnection();
sqlCon.Open();
readCmd = sqlCon.CreateCommand();
this.prepareStmtManyRows();
dataReader = this.readCmd.ExecuteReader();
IList result = this.populateManyRows();
return result;
}
catch (SqlCeException sqlEx)
{
StringBuilder builder = new StringBuilder(
@"SqlCe Error in BaseReader.executeList() - ").Append(
sqlEx.Message).Append(':').Append(sqlEx.NativeError);
Log.getInstance().log(builder.ToString());
throw new DataAccessException(sqlEx);
}
finally
{
try
{
if( null != dataReader && ( !dataReader.IsClosed ))
{
dataReader.Close();
dataReader.Dispose();
}
if( null != readCmd) readCmd.Dispose();
if( null != sqlCon) sqlCon.Close();
}
catch (System.Exception ex)
{
}
}

I have also made sure that Query Analyzer is not running on my PDA.
I have been working on this since last one week but could not find a soultion.

Thanks,
A Islam

View 7 Replies View Related

How Do I Insert Data From A Flat File Or .csv File Into An Existing SQL Database???

Mar 29, 2006

How do I insert data from a flat file or .csv file into an existing SQL database???

Here what I've come up with thus far and I but it doesn't work. Can someone please help? Let me know if there is a better way to do this... Idealy I'd like to write straight to the sql database and skip the datset all together...

strSvr = "vkrerftg"

StrDb = "Test_DB"

'connection String

strCon = "Server=" & strSvr & ";database=" & StrDb & "; integrated security=SSPI;"

Dim dbconn As New SqlConnection(strCon)

Dim da As New SqlDataAdapter()

Dim insertComm As New SqlCommand("INSERT INTO [Test_DB_RMS].[dbo].[AIR_Ouput] ([Event], [Year], [Contract Loss],[Company Loss], " & _

"[IndInsured Loss Prop],[IndInsured Loss WC],[Event Info]) " & _

"VALUES (@Event, @Year, @ConLoss, @CompLoss, @IndLossProp, @IndLossWC, @eventsInfo)", dbconn)

insertComm.Parameters.Add("@Event", SqlDbType.Int, 4, "Event")

insertComm.Parameters.Add("@Year", SqlDbType.Float, 4, "Year")

insertComm.Parameters.Add("@ConLoss", SqlDbType.Float, 4, "Contract Loss")

insertComm.Parameters.Add("@CompLoss", SqlDbType.Float, 4, "Company Loss")

insertComm.Parameters.Add("@IndLossProp", SqlDbType.Float, 4, "IndInsured Loss Prop")

insertComm.Parameters.Add("@IndLossWC", SqlDbType.Float, 4, "IndInsured Loss WC")

insertComm.Parameters.Add("@eventsInfo", SqlDbType.NVarChar, 255, "Event Info")

da.InsertCommand = insertComm

Dim upComm As New SqlCommand("UPDATE [Test_DB_RMS].[dbo].[AIR_Ouput] " & _

"SET [Event] = @Event " & _

",[Year] = @Year " & _

",[Contract Loss] = @ConLoss " & _

",[Company Loss] = @CompLoss " & _

",[IndInsured Loss Prop] = @IndLossProp " & _

",[IndInsured Loss WC] = @IndLossWC " & _

",[Event Info] = @EventInfo", dbconn)

upComm.Parameters.Add("@Event", SqlDbType.Int, 4, "Event")

upComm.Parameters.Add("@Year", SqlDbType.Float, 4, "Year")

upComm.Parameters.Add("@ConLoss", SqlDbType.Float, 4, "Contract Loss")

upComm.Parameters.Add("@CompLoss", SqlDbType.Float, 4, "Company Loss")

upComm.Parameters.Add("@IndLossProp", SqlDbType.Float, 4, "IndInsured Loss Prop")

upComm.Parameters.Add("@IndLossWC", SqlDbType.Float, 4, "IndInsured Loss WC")

upComm.Parameters.Add("@EventsInfo", SqlDbType.NVarChar, 255, "Event Info")

da.UpdateCommand = upComm

da.Update(dsAIR, "TextDB")



************* ANY HELP WOULD BE GREATLY APPRECIATED************

THANKS

View 6 Replies View Related

DB Engine :: Recommended Size And File Growth For A Database And Log File?

Sep 22, 2015

What is the recommended size and file growth for a database and log file? We will be storing approx 10000 records a day.Currently we have the following:

CREATE DATABASE Dummy
ON 
PRIMARY
( NAME = Dummy_data,
    FILENAME = 'D:....DATADummy.mdf',
    SIZE = 250MB,
    FILEGROWTH = 25MB )
LOG ON
( NAME = Dummy_log,
    FILENAME = 'D:....DATADummy_log.ldf',
    SIZE = 50MB,
    FILEGROWTH = 5MB ) ;
GO

View 3 Replies View Related

How Do I Insert Data From A Flat File Or .csv File Into An Existing SQL Database???

Mar 29, 2006



How do I insert data from a flat file or .csv file into an existing SQL database???

Here what I've come up with thus far and I but it doesn't work. Can someone please help? Let me know if there is a better wway to do this... Idealy I'd like to write straight to the sql database and skip the datset all together...

strSvr = "vkrerftg"

StrDb = "Test_DB"

'connection String

strCon = "Server=" & strSvr & ";database=" & StrDb & "; integrated security=SSPI;"

Dim dbconn As New SqlConnection(strCon)

Dim da As New SqlDataAdapter()

Dim insertComm As New SqlCommand("INSERT INTO [Test_DB_RMS].[dbo].[AIR_Ouput] ([Event], [Year], [Contract Loss],[Company Loss], " & _

"[IndInsured Loss Prop],[IndInsured Loss WC],[Event Info]) " & _

"VALUES (@Event, @Year, @ConLoss, @CompLoss, @IndLossProp, @IndLossWC, @eventsInfo)", dbconn)

insertComm.Parameters.Add("@Event", SqlDbType.Int, 4, "Event")

insertComm.Parameters.Add("@Year", SqlDbType.Float, 4, "Year")

insertComm.Parameters.Add("@ConLoss", SqlDbType.Float, 4, "Contract Loss")

insertComm.Parameters.Add("@CompLoss", SqlDbType.Float, 4, "Company Loss")

insertComm.Parameters.Add("@IndLossProp", SqlDbType.Float, 4, "IndInsured Loss Prop")

insertComm.Parameters.Add("@IndLossWC", SqlDbType.Float, 4, "IndInsured Loss WC")

insertComm.Parameters.Add("@eventsInfo", SqlDbType.NVarChar, 255, "Event Info")

da.InsertCommand = insertComm

Dim upComm As New SqlCommand("UPDATE [Test_DB_RMS].[dbo].[AIR_Ouput] " & _

"SET [Event] = @Event " & _

",[Year] = @Year " & _

",[Contract Loss] = @ConLoss " & _

",[Company Loss] = @CompLoss " & _

",[IndInsured Loss Prop] = @IndLossProp " & _

",[IndInsured Loss WC] = @IndLossWC " & _

",[Event Info] = @EventInfo", dbconn)

upComm.Parameters.Add("@Event", SqlDbType.Int, 4, "Event")

upComm.Parameters.Add("@Year", SqlDbType.Float, 4, "Year")

upComm.Parameters.Add("@ConLoss", SqlDbType.Float, 4, "Contract Loss")

upComm.Parameters.Add("@CompLoss", SqlDbType.Float, 4, "Company Loss")

upComm.Parameters.Add("@IndLossProp", SqlDbType.Float, 4, "IndInsured Loss Prop")

upComm.Parameters.Add("@IndLossWC", SqlDbType.Float, 4, "IndInsured Loss WC")

upComm.Parameters.Add("@EventsInfo", SqlDbType.NVarChar, 255, "Event Info")

da.UpdateCommand = upComm

da.Update(dsAIR, "TextDB")



************* ANY HELP WOULD BE GREATLY APPRECIATED************

THANKS

View 3 Replies View Related

Importing Data To An Existing Database Column From An .xsl File Or .cvs File

May 15, 2006

good morning,

 I want to load data that i receive everydays from my customers in .xls file format (excel) or cvs file format,  to the database that i have created on this purpose. but  when trying to do that whith SSIS; i got an error message .... that i can't import redudant data in my database column.

 

Best regards.

View 1 Replies View Related

Save File In SQL 2005 Database

Feb 14, 2007

Hello,

I am working on a ASP.NET 2.0 project with an SQL 2005 database.
I created a documents table with various columns including:
DocumentId and DocumentUrl

My documents will always be PDF's of SWF's (Flash Paper Files)

I will need to display this files in my web pages.

My question is:
Should I save the DocumentUrl in the database or should I save the file itself in the database?

And how can I save files in an SQL 2005 database?

Thanks,
Miguel

View 2 Replies View Related

Adding File Information To SQL Database On File Upload

Apr 18, 2004

Hi there :)

I'm in the final stage of my asp.net project and one of the last things I need to do is add the following file information to my SQL server 2000 database when a file is uploaded:

First of all I have a resource table to which I need to add:
- filename
- file_path
- file_size
(the resource_id has a auto increment value)

so that should hopefully be straight forward when the file is uploaded. The next step is to reference the new resource_id in my module_resource table. My module resource table consists of:
- resource_id (foreign key)
- module_id (foreign key)

So, adding the module_id is easy enough as I can just get the value using Request.QueryString["module_id"]. The bit that I am unsure about is how to insert the new resource_id from the resource table into the module_resource table on file upload. How is this done? Using one table would solve the issue but I want one resource to be available to all modules - many to many relationship.

Any ideas?

Many thanks :)

View 1 Replies View Related

Converting Mdb (Access File) File To A SQL Server Database

May 14, 2008



hello,

I'm not really sure my question belongs to here...

I have a database in Access (from microsoft office, of course), and I want to transfer convert it to SQL Server.
Does anyone know how I can do it? It must be very simple, but I haven't found it yet....

Thanks a lot!

- Miri

View 7 Replies View Related

Recovering Database From Transactional Log File(.ldf File)

Sep 23, 2007



Hi

I am in a trouble without doing any mistake. I restarted while in parallely my sql server was restarting i.e I opened a management studio.

When it booted up next time. I see that my database is gone. Though it is showed up in the server but has no node below it.
I then checked the mdf files and ldf files and found mdf file to be of 0 KB and ldf file is of 1.73 GB. My database was in full recovery mode but i did not take any database backup.

Here ais the entry from my SQL server log:

The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at offset 0000000000000000 in file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAHello.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
I wonder if now there is a case to recover my database..Can I restore/recover the database from .ldf file as it was in full recovery model?Any help i shighly appreciated.

View 5 Replies View Related

Web Services Task Editor: The Input Web Services Description Language (WSDL) File Is Not Valid

Mar 14, 2006

I am trying to prove I can use SSIS to connect to a web service. The WS I am trying to connect to was developed by a vendor and covered by a NDA, but I was able to reproduce the issue with a public WS.

Here are the steps to reproduce the issue:

In the Web Services Connection Manager, I entered http://office.microsoft.com/Research/Providers/MoneyCentral.asmx?wsdl in the URL window. I am able to successfully "test" the connection
I pasted the above link into IE and saved the resulting XML as a .wsdl file on my local machine. In the Web Services Task Editor, General Tab, I specify the path to the .wsdl file and click on "Download WSDL" button. No Issues
When I click on "Input" and select "MoneyCentralRemote" from the drop-down for Service, I receive an error message saying "This version of the Web Services Description Language (WSDL) is not supported"

So the questions are:

Did I perform the above steps correctly?
What WSDL versions are supported in SSIS?
How can I tell what WSDL version was used to create the .wsdl I am trying to access?
If the WSDL is an unsupported version, is there a work-around to fix the issue?

View 3 Replies View Related

Connecting Database Engine (SQl Server 2005 File .*mdf) From Win CE 5.0 Platform

Jun 26, 2006

Is this possible to connect do the Database Engine (on sql server 2005 on XP platorm - file *.mdf (not mobile *.sdf)) from win CE 5.0?

I tried to do this :
ConnectionStringSQLServerCE = "Data Source=WORK_STATION\SQLEXPRESS;Initial Catalog=dbMachines;Integrated Security=False;Password=Panel;User ID=Panel";

SqlCeConnectionCE = new SqlConnection(ConnectionStringSQLServerCE);

SqlCeConnectionCE.Open();

but I catch error:
catch (PlatformNotSupportedException ex)
€žPlatformNotSupportedException€?
I noticed that I see server because when I use:
ConnectionStringSQLServerCE = "Data Source=WORK_STATION\SQLEXPRESS";

zwraca błąd typu

catch (SqlException ex)
€œLogin failed for user ''. The user is not associated with a trusted SQL Server connection.€?

I used
using System.Data.SqlClient;

from Compact Framework 2.0 under Visual Studio 2005 Device Application Windows CE 5.0

can anyone help me?

View 1 Replies View Related

Can I Create Database Using Backup File In SQl Server 2005 Express Edition

Jul 21, 2007

hi
       i have a database file backup which is having no extension (eg saims) . Can i create a database using this backup in sql server expression edition.
 Or else is there any way to get the .mdf file from sql server 2005 full edition??????????????
Thanx in advance

View 2 Replies View Related

RESOLVED RESOLVED An Attempt To Attach An Auto-named Database For File &&<file String&&> Failed &&>&&>&&> But ONLY After SSE Reinstall

Sep 16, 2007

RESOLVED RESOLVED RESOLVED

DOH! When I rebuilt the OS, I changed the data partition ID's, and didn't remember to change them in the connetion strings

Not great, but better than continuing to bang head against wall.

Would like to say to MS appreciators that the VS2005 reinstall actually went quite well, considering.

===========================================================================





I built an app, works fine. Had the development environment working fine (VS2005 (SP0) and SQL Server Express). It had been stable for months, no problem.


Then I had to reinstall XP Pro...(finally threw too many conflicting programs into it, I guess...)


I managed to get VS2005 reinstalled ok. However, when I opened and compiled my existing app in VS2005, using Cassini, I got the dreaded error:

An attempt to attach an auto-named database for file <file string> failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

I also get this error for the compiled copy of the app on the same machine, running on IIS. (Where it also previously worked fine).


The Connection strings are all of the form

connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=(specific file string).MDF;Integrated Security=True;User Instance=True"


I appreciate that there are zillions of posts on this issue. I'm hoping that someone might know why this should happen in this particular case.


The thing that's different about this case is that the app was working fine; I have the app deployed on a demo machine and also on a remote server as well as on the development machine.


The only thing that changed is that there was this fresh install of SQL Server Express.


I tried using >> sp_configure user instances enabled','1';RECONFIGURE <<< in SSMSEE, which took, but didn't help.


So something is different in SSE. Since the app is stable everywhere else, I REALLY don't want to go through and adjust the connection strings...MUCH better to figure out what SSE needs to be happy with the existing connection strings...as it was before.

Any suggestions would be appreciated.

Thanks!

EDIT----TRIED SOME THINGS:




Changed folder and file permissions to allow ASPNET full access to the .mdf's and log files (though never had to do this before on the development machine.) No change...

Can see the table contents within the .mdf through SSMSE, and also through Server Explorer in VS2005.

So because the problem happens with both IIS and Cassini, I'm assuming it's got to be an issue between ASPNET and SSE.

EDIT --- TRIED SOME MORE THINGS:

I dimly remember that when I had this problem before, it was that the error message was too "dumb". It wasn't my file that had the permissions problems, it was that the SSE System Databases had to have permissions with respect to ASPNET.

I tried to set that up but I'm a complete newb on this area, so I don't know if I did it right. In SSMSE I created a Login for MyComputer/ASPNET, and gave it all permissions and roles, and then made it an owner for the four system databases...but no joy.

Any pointers on this last piece would be helpful.

EDIT - MORE INFO

The error details

[SqlException (0x80131904): An attempt to attach an auto-named database for file <filestring>.MDF failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739123
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +170
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +349
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181

View 1 Replies View Related







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