connect from ASP app: device

Showing posts with label device. Show all posts

Thursday, March 22, 2012

cant find file id 3 when trying to restore

Hi I am trying to restore a dbase in mssql2000 and am getting the error
cannot find file id 3 on device so it does not restore, just wondering what
the problem may be. Thanks Paul.
Paul G
Software engineer.
Hi,
Use RESTORE HEADERONLY command to get the files associted with the backup
file.
Thanks
Hari
SQL Server MVP.
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:A7B258E8-ED47-4293-BAB7-5E0639B50DE4@.microsoft.com...
> Hi I am trying to restore a dbase in mssql2000 and am getting the error
> cannot find file id 3 on device so it does not restore, just wondering
> what
> the problem may be. Thanks Paul.
> --
> Paul G
> Software engineer.
|||ok thanks for the information.
Paul G
Software engineer.
"Hari Prasad" wrote:

> Hi,
> Use RESTORE HEADERONLY command to get the files associted with the backup
> file.
> Thanks
> Hari
> SQL Server MVP.
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:A7B258E8-ED47-4293-BAB7-5E0639B50DE4@.microsoft.com...
>
>

cant find file id 3 when trying to restore

Hi I am trying to restore a dbase in mssql2000 and am getting the error
cannot find file id 3 on device so it does not restore, just wondering what
the problem may be. Thanks Paul.
--
Paul G
Software engineer.Hi,
Use RESTORE HEADERONLY command to get the files associted with the backup
file.
Thanks
Hari
SQL Server MVP.
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:A7B258E8-ED47-4293-BAB7-5E0639B50DE4@.microsoft.com...
> Hi I am trying to restore a dbase in mssql2000 and am getting the error
> cannot find file id 3 on device so it does not restore, just wondering
> what
> the problem may be. Thanks Paul.
> --
> Paul G
> Software engineer.|||ok thanks for the information.
--
Paul G
Software engineer.
"Hari Prasad" wrote:

> Hi,
> Use RESTORE HEADERONLY command to get the files associted with the backup
> file.
> Thanks
> Hari
> SQL Server MVP.
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:A7B258E8-ED47-4293-BAB7-5E0639B50DE4@.microsoft.com...
>
>

cant find file id 3 when trying to restore

Hi I am trying to restore a dbase in mssql2000 and am getting the error
cannot find file id 3 on device so it does not restore, just wondering what
the problem may be. Thanks Paul.
--
Paul G
Software engineer.Hi,
Use RESTORE HEADERONLY command to get the files associted with the backup
file.
Thanks
Hari
SQL Server MVP.
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:A7B258E8-ED47-4293-BAB7-5E0639B50DE4@.microsoft.com...
> Hi I am trying to restore a dbase in mssql2000 and am getting the error
> cannot find file id 3 on device so it does not restore, just wondering
> what
> the problem may be. Thanks Paul.
> --
> Paul G
> Software engineer.|||ok thanks for the information.
--
Paul G
Software engineer.
"Hari Prasad" wrote:
> Hi,
> Use RESTORE HEADERONLY command to get the files associted with the backup
> file.
> Thanks
> Hari
> SQL Server MVP.
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:A7B258E8-ED47-4293-BAB7-5E0639B50DE4@.microsoft.com...
> > Hi I am trying to restore a dbase in mssql2000 and am getting the error
> > cannot find file id 3 on device so it does not restore, just wondering
> > what
> > the problem may be. Thanks Paul.
> > --
> > Paul G
> > Software engineer.
>
>sql

Tuesday, March 20, 2012

Cant expand SQL6.5 database

I have a SQL 6.5 database where I need to expand the size
of a database. The database device has been expanded but I
seem to be missing something when it comes to expanding
the database.

The database in question is named edidata. When I enter
the Expand Databases screen I see my database named
edidata. At the top of the screen are two drop down boxes
one lableled Data Device and the other is Log Device. In
the the Data Device drop down I see only

none
new
Database x
Database y

(But not edidata)

I have several hundred Meg available on the device and
additionally lots of Disk space not yet allocated.

When I pull up the Log Device drop down this database device name
does appear. If I attempt to expand any of the other 3 databases on this server I'm able to see this database device name in the drop down list.

In case it matters I do have both a Data base
and Log contained within this Database device.

Any help would be greatly appreciated.

Thank you
..Having mixed use devices always complicates things. (If you have run into the point where the Log starts, I think you may be out of luck for additional data space on that device for that DB. Other DBs would still be able to use free space beyond the Log boundary within the device.)

The tsql to add 500MB (if available) should be something like:

Alter DataBase edidata
On Edidata_DeviceName = 500
Go

(You would have to use the correct names, of course.)|||You might consider creating another device called something like EdiDataLogDevice, (designating it for Log use only), and moving the existing EdiData Log there (from its current location).|||As you can tell I don't do a great deal of DBA work with MSSQL. I know how to create the Database device but I'm not sure of how to move the Log to the new device. Does anyone have any pointers?|||Originally posted by Dale Marthaller
As you can tell I don't do a great deal of DBA work with MSSQL. I know how to create the Database device but I'm not sure of how to move the Log to the new device.

Q1 Does anyone have any pointers?

A1 I rarely do anything with 6.x Sql Servers anymore, (other than a rare upgrade), but I'd probably start by testing the following on a dev server / dev DB (should work):

/* I guess I'd do something Like this (#0 Full Backup Dump!) */
/* 1 Create the extra device (use an appropriate size, not 2048): */
Disk Init
Name = 'EdiDataLogDev',
PhysName = 'c:\EdiDataLogDev.Log',
VDevNo = 8,
Size = 2048
Go
/* 2 Make sure the extra device is there: */
exec sp_helpdevice
/* 3 Check out the existing DBs, existing DB Log / LogSpace: */
exec sp_HelpDB
exec sp_HelpDB EdiData
exec sp_HelpLog
dbcc Sqlperf(LogSpace)
Go
/* 4 Add the new device to the DB: */
Alter DataBase EdiData On EdiDataLogDev
exec sp_HelpDB EdiData
/* 5 Mark the new device on the DB for Log Only: */
exec sp_LogDevice EdiData, EdiDataMixDev
Go
/* 6 Verify the changes, carefully note the following: */
exec sp_helpdevice
exec sp_HelpDB EdiData
/* 7 Then create some dummy tables, populate them in EdiData, dump the log etc. (flush the log from the old device): */
Dump EdiData With Truncate_Only
/* 8 Verify the changes, carefully note the following:*/
exec sp_helpdevice
exec sp_HelpDB EdiData
/* 9 EdiDataLogDev should be Log Only, and the original Dev should be Data Only */|||Thank you I will tackle this today.

Wednesday, March 7, 2012

Can't Create New Database on Device via ActiveSync

In VS2005 RTM using

Server Explorer -->
Right Click DATA CONNECTIONS -->
Add Connection -->
Datasource=Microsoft SQL Server Mobile Edition--> Data provider = .NET Framework Data Provider for SQL Server Mobile Edition-->
ActiveSync Connected Device

when I hit Test Connection I hear ActiveSync's connect sound and I get this error

Microsoft Development Environment

Microsoft 5QL Server 2005 Mobile Edition and/or NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding.

Has anyone experienced this? I can very easily create the database on my desktop, but even though the option to use activeSync is offered, it does not appear to work in VS 2005 RTM.

Is that true?

Thanks,

Wil Pannell

Hi Wil,

Creating a DB on a device over Active Sync is a prime feature and it works very well too in VS 2005 RTM.

Here are the things you should check:
1) Did Active Sync detect the connection and turned green?. And, which Active Sync version are you using, Is it the latest or the old?
2) Is your device running the supported Windows CE Version?
3) Are you able to browse files & folders on the device using Windows Explorer?
4) Did you do any uninstallations and installations in the mean time? Check whether the SQL Mobile data provider is listed in .NET Framework config file machine.config.

Hope this helps!

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation|||I'm having this problem as well.

Wil, did you sort it out in the end?
|||

Did you verify the things specified above? And, still facing the same problem, then let me know.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||Yes everything was still not working correctly and I reinstalled everythnig.

Turned out that VS2005 wasn't depolying CF2 and the SQL Mobile Database engine properly on the device or the emulator.

I had to manually install the CF2 and the SQL mobile DB engine for it to work. The error message VS2005 gave didn't help at all with tracking this down.
|||

Glad that things are working on your end.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||I have the same problem to at Visual Studio. I try to fix the error using this step.
1. I install the compact framework using NETCFv2.wm.armv4i.cab file. Status done.
2. I install the SQL CE database server using Mobile first, you can find it at folder
drive:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\armv4i
The file list are :
- sqlce30.dev.ENU.ppc.wce5.armv4i.CAB
- sqlce30.ppc.wce5.armv4i.CAB
- sqlce30.repl.ppc.wce5.armv4i.CAB
3. I've got the error like described above, the error also raised on Emulator too, so i uninstall the SQLCE
4. I instal the SQL using Client, you can find it at folder :
drive:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Client\v2.0\wce500\armv4i
The file list are :
- sql.dev.ENU.ppc.wce5.armv4i.CAB
- sql.ppc.wce5.armv4i.CAB
5. There no error again on Emulator, but on Visual Studio still have the same error.

Ok then where is the problem, Thanks.

PS: I use WM5 Pocket PC Emulator and the Visual Studio is VS2005
|||If you have uninstalled and reinstalled .NET Fx after VS Installation, this problem would arise. Can you please search for Data Providers in .NET Framework config file.

%SystemDrive%\WINDOWS\Microsoft.NET\Framework\v2.0.xxxxx\config\machine.config

Open this file in NOTEPAD, and search for "SQL Server CE Data Provider". If it is not there then, you may try adding the following line AS IT IS in Data Providers section.

You may need to restart the VS or even the PC to make VS detect this new setting.

Let us know if this has worked for you!

Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

I also faced this problem and have tried to solve it. Finally, I myself found one that I never thought before.

You can simply run sqlmobile30devtoolsenu.msi file again to install Mobile Development Tool. This file comes with the VS 2005 Pro distribution in wcu\SQLCE folder.

Hope that help!

QUAN,

I love this site!

|||

Thanks for posting back on how you solved it. However, I can not guess what went wrong in the first installation!

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||1) Did Active Sync detect the connection and turned green?. And, which Active Sync version are you using, Is it the latest or the old?
YES, Version 4.1
2) Is your device running the supported Windows CE Version?
Yes
3) Are you able to browse files & folders on the device using Windows Explorer?
Yes
4) Did you do any uninstallations and installations in the mean time? Check whether the SQL Mobile data provider is listed in .NET Framework config file machine.config.
Yes, it's listed
Any ideas?
Thank you very much...|||I had the same problem. After trying the suggested solutions, I installed it manually and it worked. (see http://msdn2.microsoft.com/en-us/library/ms171875.aspx)|||
Como fa?o para aparecer o Microsoft Sql Server Mobile Edition na tela de Change Data Source?
Teria como me ajudar?
Já instalei tudo e n?o aparece, at mesmo mudei o maching.config e n?o funcionou.
Pode me ajudar?

Can't Create New Database on Device via ActiveSync

In VS2005 RTM using

when I hit Test Connection I hear ActiveSync's connect sound and I get this error

Microsoft Development Environment

Microsoft 5QL Server 2005 Mobile Edition and/or NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding.

Has anyone experienced this? I can very easily create the database on my desktop, but even though the option to use activeSync is offered, it does not appear to work in VS 2005 RTM.

Is that true?

Thanks,

Wil Pannell

Hi Wil,

Creating a DB on a device over Active Sync is a prime feature and it works very well too in VS 2005 RTM.

Hope this helps!

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation|||I'm having this problem as well.

Wil, did you sort it out in the end?
|||

Did you verify the things specified above? And, still facing the same problem, then let me know.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||Yes everything was still not working correctly and I reinstalled everythnig.

Turned out that VS2005 wasn't depolying CF2 and the SQL Mobile Database engine properly on the device or the emulator.

I had to manually install the CF2 and the SQL mobile DB engine for it to work. The error message VS2005 gave didn't help at all with tracking this down.
|||

Glad that things are working on your end.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

Ok then where is the problem, Thanks.

%SystemDrive%\WINDOWS\Microsoft.NET\Framework\v2.0.xxxxx\config\machine.config

Open this file in NOTEPAD, and search for "SQL Server CE Data Provider". If it is not there then, you may try adding the following line AS IT IS in Data Providers section.

You may need to restart the VS or even the PC to make VS detect this new setting.

Let us know if this has worked for you!

Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

I also faced this problem and have tried to solve it. Finally, I myself found one that I never thought before.

You can simply run sqlmobile30devtoolsenu.msi file again to install Mobile Development Tool. This file comes with the VS 2005 Pro distribution in wcu\SQLCE folder.

Hope that help!

QUAN,

I love this site!

|||

Thanks for posting back on how you solved it. However, I can not guess what went wrong in the first installation!

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

Can't Create New Database on Device via ActiveSync

In VS2005 RTM using

when I hit Test Connection I hear ActiveSync's connect sound and I get this error

Microsoft Development Environment

Microsoft 5QL Server 2005 Mobile Edition and/or NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding.

Has anyone experienced this? I can very easily create the database on my desktop, but even though the option to use activeSync is offered, it does not appear to work in VS 2005 RTM.

Is that true?

Thanks,

Wil Pannell

Hi Wil,

Creating a DB on a device over Active Sync is a prime feature and it works very well too in VS 2005 RTM.

Hope this helps!

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation|||I'm having this problem as well.

Wil, did you sort it out in the end?|||

Did you verify the things specified above? And, still facing the same problem, then let me know.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||Yes everything was still not working correctly and I reinstalled everythnig.

Turned out that VS2005 wasn't depolying CF2 and the SQL Mobile Database engine properly on the device or the emulator.

I had to manually install the CF2 and the SQL mobile DB engine for it to work. The error message VS2005 gave didn't help at all with tracking this down.|||

Glad that things are working on your end.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

Ok then where is the problem, Thanks.

PS: I use WM5 Pocket PC Emulator and the Visual Studio is VS2005|||If you have uninstalled and reinstalled .NET Fx after VS Installation, this problem would arise. Can you please search for Data Providers in .NET Framework config file.

%SystemDrive%\WINDOWS\Microsoft.NET\Framework\v2.0.xxxxx\config\machine.config

Open this file in NOTEPAD, and search for "SQL Server CE Data Provider". If it is not there then, you may try adding the following line AS IT IS in Data Providers section.

You may need to restart the VS or even the PC to make VS detect this new setting.

Let us know if this has worked for you!

Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

I also faced this problem and have tried to solve it. Finally, I myself found one that I never thought before.

You can simply run sqlmobile30devtoolsenu.msi file again to install Mobile Development Tool. This file comes with the VS 2005 Pro distribution in wcu\SQLCE folder.

Hope that help!

QUAN,

I love this site!

|||

Thanks for posting back on how you solved it. However, I can not guess what went wrong in the first installation!

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||

1) Did Active Sync detect the connection and turned green?. And, which

Active Sync version are you using, Is it the latest or the old?

YES, Version 4.1

2) Is your device running the supported Windows CE Version?

Yes

3) Are you able to browse files & folders on the device using Windows Explorer?

Yes

4) Did you do any uninstallations and installations in the mean time?

Check whether the SQL Mobile data provider is listed in .NET Framework

config file machine.config.

Yes, it's listed

Any ideas?

Thank you very much...|||I had the same problem. After trying the suggested solutions, I installed it manually and it worked. (see http://msdn2.microsoft.com/en-us/library/ms171875.aspx)|||
Como fa?o para aparecer o Microsoft Sql Server Mobile Edition na tela de Change Data Source?
Teria como me ajudar?
Já instalei tudo e n?o aparece, at mesmo mudei o maching.config e n?o funcionou.
Pode me ajudar?

Can't Create New Database on Device via ActiveSync

In VS2005 RTM using

when I hit Test Connection I hear ActiveSync's connect sound and I get this error

Microsoft Development Environment

Microsoft 5QL Server 2005 Mobile Edition and/or NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding.

Has anyone experienced this? I can very easily create the database on my desktop, but even though the option to use activeSync is offered, it does not appear to work in VS 2005 RTM.

Is that true?

Thanks,

Wil Pannell

Hi Wil,

Creating a DB on a device over Active Sync is a prime feature and it works very well too in VS 2005 RTM.

Hope this helps!

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation|||I'm having this problem as well.

Wil, did you sort it out in the end?
|||

Did you verify the things specified above? And, still facing the same problem, then let me know.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||Yes everything was still not working correctly and I reinstalled everythnig.

Turned out that VS2005 wasn't depolying CF2 and the SQL Mobile Database engine properly on the device or the emulator.

I had to manually install the CF2 and the SQL mobile DB engine for it to work. The error message VS2005 gave didn't help at all with tracking this down.
|||

Glad that things are working on your end.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

Ok then where is the problem, Thanks.

%SystemDrive%\WINDOWS\Microsoft.NET\Framework\v2.0.xxxxx\config\machine.config

Open this file in NOTEPAD, and search for "SQL Server CE Data Provider". If it is not there then, you may try adding the following line AS IT IS in Data Providers section.

You may need to restart the VS or even the PC to make VS detect this new setting.

Let us know if this has worked for you!

Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

I also faced this problem and have tried to solve it. Finally, I myself found one that I never thought before.

You can simply run sqlmobile30devtoolsenu.msi file again to install Mobile Development Tool. This file comes with the VS 2005 Pro distribution in wcu\SQLCE folder.

Hope that help!

QUAN,

I love this site!

|||

Thanks for posting back on how you solved it. However, I can not guess what went wrong in the first installation!

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

Can't Create New Database on Device via ActiveSync

In VS2005 RTM using

when I hit Test Connection I hear ActiveSync's connect sound and I get this error

Microsoft Development Environment

Microsoft 5QL Server 2005 Mobile Edition and/or NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding.

Has anyone experienced this? I can very easily create the database on my desktop, but even though the option to use activeSync is offered, it does not appear to work in VS 2005 RTM.

Is that true?

Thanks,

Wil Pannell

Hi Wil,

Creating a DB on a device over Active Sync is a prime feature and it works very well too in VS 2005 RTM.

Hope this helps!

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation|||I'm having this problem as well.

Wil, did you sort it out in the end?|||

Did you verify the things specified above? And, still facing the same problem, then let me know.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||Yes everything was still not working correctly and I reinstalled everythnig.

Turned out that VS2005 wasn't depolying CF2 and the SQL Mobile Database engine properly on the device or the emulator.

I had to manually install the CF2 and the SQL mobile DB engine for it to work. The error message VS2005 gave didn't help at all with tracking this down.|||

Glad that things are working on your end.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

Ok then where is the problem, Thanks.

PS: I use WM5 Pocket PC Emulator and the Visual Studio is VS2005|||If you have uninstalled and reinstalled .NET Fx after VS Installation, this problem would arise. Can you please search for Data Providers in .NET Framework config file.

%SystemDrive%\WINDOWS\Microsoft.NET\Framework\v2.0.xxxxx\config\machine.config

Open this file in NOTEPAD, and search for "SQL Server CE Data Provider". If it is not there then, you may try adding the following line AS IT IS in Data Providers section.

You may need to restart the VS or even the PC to make VS detect this new setting.

Let us know if this has worked for you!

Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

I also faced this problem and have tried to solve it. Finally, I myself found one that I never thought before.

You can simply run sqlmobile30devtoolsenu.msi file again to install Mobile Development Tool. This file comes with the VS 2005 Pro distribution in wcu\SQLCE folder.

Hope that help!

QUAN,

I love this site!

|||

Thanks for posting back on how you solved it. However, I can not guess what went wrong in the first installation!

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||

1) Did Active Sync detect the connection and turned green?. And, which

Active Sync version are you using, Is it the latest or the old?

YES, Version 4.1

2) Is your device running the supported Windows CE Version?

Yes

3) Are you able to browse files & folders on the device using Windows Explorer?

Yes

4) Did you do any uninstallations and installations in the mean time?

Check whether the SQL Mobile data provider is listed in .NET Framework

config file machine.config.

Yes, it's listed

Any ideas?

Thursday, March 22, 2012

cant find file id 3 when trying to restore

cant find file id 3 when trying to restore

cant find file id 3 when trying to restore

Tuesday, March 20, 2012

Cant expand SQL6.5 database

Wednesday, March 7, 2012

Can't Create New Database on Device via ActiveSync

Can't Create New Database on Device via ActiveSync

Can't Create New Database on Device via ActiveSync

Can't Create New Database on Device via ActiveSync

Can't Create New Database on Device via ActiveSync

connect from ASP app

Blog Archive

About Me