Dear all:
Is there a way to connect to a SQL Server mobile using native code C++?
I don't want to use the Compact Framework to access Data.
Does anybody knows how to connect to an SQLite database from VS2005 c++ for devices?
Thanks.
Alfredo Mendiola Loyola
Lima Perú
Hello All,
I want to know if it's possible for a database on multiple devices to put specific tables on specific devices?? and if this is possible how to do it??
Thanks for help
Mohamed hani
I am new to SS7. We are planning to rearrange our system databases so that the logs are on one drive
and the data files are on a different drive. I found a really good white paper on this but just want to
verify that there is not a problem with doing this. In sybase there were some restrictions on doing this.
Any info you have would be appreciated.
Is there a way to shrink database devices in SQL Server 6.5 Other than dropping and restoring?
View 1 Replies View RelatedJust wondering - on a straight RAID 5 system is there any advantage, performance or otherwise, to splitting a SQL 6.5 database over multiple database devices? Or for simplicity's sake am I just further off creating a single device and manually extending it as the database grows?
Thanks
RM
I got a quick question.
My database size has reached the limit of the drive, one option is to
add a new database device on a different drive, then expand in across
2 drives.
Anything I have to concern for a database on 2 database device on 2 logical drives (recoverability or ...?) compared to maybe another option:
reformat the whole disk and allocated more space to the original drive and recover (since in my case, all disk space have been formated) from backup....
Tony
Hi, I've to restore a bk into a new DB, because the old one has a lot of devices created on different places and phisical disks.
Im not sure to do that, cause Ive heard some problems with this action.
The old Db has 10 devices of data and 10 devices of log, and I want to create only one device of data (sum of all the data devices) and only one device of log (sum of all log devices)
Is it possible or not?
Tnx a lot!
Hi,
After I had transfered SSIS package to another PC I tried to open package and I got an error. ".. Failed to decrypt protected XML node "PackagePassword" with error . ".
It turned out, that the password wasn't saved in a OLEDB connection manager of the Package. However "save password" options checked!
But password field was empty.
As soos as I enter password the package executes successfully.
Question: How can I transfer a password for OLEDB Connection within a SSIS package to another developer's VS2005?
hi,
View 1 Replies View Related
Hi,
iam having vs2005 installed on my machine and i also installed sqlserver2005 dev edition on my machine...Now iam devloping a Window Appplication in which I need to populate a grid from Sqlserver2000 (dev edition) which installed on remote (i.e another network)....when i try to run my application it gives me a error tht "Unable to connect to sqlserver2005".actaully i specified in my connection string to connect to Sqlserver2000 on the remote machine.
I feel to know how to enable remote connection on Sqlserver 2000.So tht i can access this sqlserver2000 from another machine
With regards
Mahender
Good Evening All,
I've serached this forum and Google'd for a resolution to this issue, to no avail. Here's the scenario:
I'm running VS 2005 on Windows Media Center laptop and need to create ASP.net membership for my web application built using VB. I have SQL Server Developer installed with instance name MSSQLSERVER. Previously, I uninstalled SQL Express and installed Developer edition and can now open and utilize Management Studio.
Now, when I try to create a new SQL Server database in my solution's App_Data directory, I receive the above error. I already changed instance name in VS2005 per Tools-Options-Database Tools-Data Connections to MSSQLSERVER.
Could someone provide me with a list of procedures to ensure proper setup of VS2005 with SQL Server Developer Edition?
Thanks much for your help.
Just to verify that this was an issue, I downloaded web developer 2008 and I do not experience this same problem.
BUT when I go to add a dataset in vs2005 for an asp website - all my db files come up in the dialogue box but everyone that click (every db file) I get "This file is in use. Please enter a new name or close the file that's open in another program."
But, like I said, I downloaded 2008 and it does not occur. Plus I KNOW that the db's are not being used. Can someone give me a remedy to this?
I'm using ADOX 2.8 for table creation: The following is an example of a column defintion:
If CreateNewTable Then CreateNewTable = a.CreateColumn("ReferenceCount", ADOX.DataTypeEnum.adInteger)
If CreateNewTable Then CreateNewTable = a.CreateColumn("Document", ADOX.DataTypeEnum.adLongVarBinary) 'Oleobject
If CreateNewTable Then CreateNewTable = a.CreateColumn("EntityID", ADOX.DataTypeEnum.adWChar, 18) 'text
Where CreateColumn looks like this:
Public Function CreateColumn(ByVal ColumnName As String, ByVal Datatype As ADOX.DataTypeEnum, Optional ByVal Size As Integer = 0) As Boolean
'ADOX.CreateColumn - Called by Common.CreateNewTable
'CreateColumn creates a column described in the Table object so it assumes it is set.
'One method of setting it is to call Select Table after opening the database
If Not Me.ConnectionIsOpen Then
MsgBox("CreateColumn - Failed to Create Column : " _
& ColumnName, MsgBoxStyle.Exclamation, cNoConn)
Return False
End If
Dim col As New ADOX.Column
col.Name = ColumnName
Try
col.Type = Datatype
Catch e As Exception
MsgBox("CreateColumb - Failed to Create Column : " _
& ColumnName, MsgBoxStyle.Exclamation, e.Message)
col = Nothing
Return False
End Try
If Size <> 0 Then col.DefinedSize = Size
Try
Table.Columns.Append(ColumnName, Datatype)
Catch e As Exception
If Err.Number() <> 0 Then
MsgBox(Err.Source & "-->" & Err.Description, , "Error")
End If
MsgBox("CreateColumb - Failed to Append Column : " _
& ColumnName, MsgBoxStyle.Exclamation, e.Message)
Return False
End Try
col = Nothing
Return True
End Function
in CreateColumn("EntityID", ADOX.DataTypeEnum.adWChar, 18)
the 18 specifies the field width in the database. Yet no matter whether I use adWChar or
adVarWChar, Access always shows the field size to be 255.
Does anyone know why or how to fix that?
I added a connection (ADO.NET) object by name testCon in the connection manager - I wanted to programmatically supply the connection string. So I used the "Expressions" property of the connection object and set the connectionstring to one DTS variable. The idea is to supply the connection string value to the variable - so that the connection object uses my connection string.
Then I added a "Backup Database Task" to my package with the name BkpTask. Now whenever I try to set the connection property of BkpTask to the testCon connection object, by typing testCon, it automatically gets cleared. I am not able to set the connection value.
Then after spending several hours I found that this is because I have customized the connection string in testCon. If I don't customize the connection string, I am able to enter the "testCon" value in the connection property of the BkpTask.
Is this an intrinsic issue?
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.
Does anyone out there use a NAS device to place there database and corresponding images on?
View 2 Replies View Relatedhi, I usually back up the database to a file within the sql server box. then use a tape backup to back up the whole directory of the sql server in the d: drive.
Is this right way to do or there is a better way ?
Ahmed
I know that you need to create a device in 6.5 to do backups, but in 7.0, it seems to take care of this for you. However, there is still a device folder in the Management folder of version 7.0's console tree. Why would it be better to back up to devices, rather than anywhere else on the hard drive. Is there any way to easily schedule the deletion of backups on these devices? I know that with 7.0's Maintenance plans, you can schedule old backups to be deleted. But how do you do that for devices?
joe
How do I create more than 10 devices in sql server 4.2?
View 2 Replies View RelatedHello
I just tried to make a typed resultset from a SSCE v3.5 database, and recieved this message from Visual Studio:
"Typed ResultSets cannot be generated for tables on Microsoft SQL Server Compact 3.5 databases present on devices."
On the device, speed and low memory consumption is important. So it seems to me that this should be present ONLY on devices, because on the desktop we can just use the DataSet generator and not care about the overhead.
Anyway, ripped from what would have been a nice feature, the alternatives that comes to mind are:
1. Making my own resultset generator
2. Use typed DataSets
3. Derive from SqlCeResultSet and store the Field names in it, to build my own typed resultset class.
Any suggestions on what to do?
I asked about this a few mos ago over in the CF forum, but I'm hoping there's a better solution someone (Erik?) knows about here.
Is there a "standard" deploy script for SQL Server CE on devices? There doesn't even seem to be one in the d/l from Microsoft. During development, Visual Studio handles the installation of SQL Server CE on the device but deploying it on a device that isn't partnered to a dev box seems to be a matter of "just copy the cab file over".
While I'm willing to do that if I have to, it raises some other questions. How do I know if it's already there? How do I know if what's there is a newer version or not (and if it is, how do I abort this step)? How do I make sure some other application hasn't installed it already? Do I really even need to worry this?
I can just have my installer tell ActiveSync to put it on the device, but without knowing the above I'm kind of nervous about it.
Hi All,,
I want to get a list of backup devices for a selected database
ex :
Northwind Database i need to get the list of back devices for this db
any one know how the query could be written
best regards
Wafi Mohtaseb
I have taken backups and the backup devices are stored in C: drive and now i want them to be moved onto the other drive.So how can i do it without creating new devices and scheduling them again.
Any help would be appreciated.
Thanks,
Kris
i need to initialise the backup devices as the the backup files have grown so big thats its occupy hard drive space , each device is for @ day for all databse we use , what do i do
thanks
safac
Hello
Does anyone have experience/advice with large databases (5-10 Gig)? If so, I was wondering about
performance/other benefits of spanning a large database across multiple devices (different disks). Would anyone
vote for or against doing this?
Suggestions...
Thanks
Tim
Hi all
I have a raid 5 NT server 4.0 with SQL 6.5 running.
I perform backups on tranlogs every hour and db`s every night.
I also have another 16G Nt server not raid 5.
Can someone tell me if it is possible to mirror a device or a database
into the regular 16G NT server from raid 5 server?
HOW???
HOw about database mirroring??
And also whats the best solution when it comes to mirrorring in NT server?
Hi guys
I am relatively new to SQL Server admin and I have been handed a task of creating backup devices for a particular SQL Server which has 204 databases.
Rather than go through and create Full, Incramental and Transaction Log backup devices for each database is ther anyway of doing the following
Create a script to go through and for each database name in 'sysdatabases'
create a folder e.g sqldataackup\%databasename%
and within each folder create a backup device called
%databasename%_full
%databasename%_inc
%databasename%_log
Also all these databases are running in 'Simple' recovery mode so obviously I need to change this to 'Full' to enable incramental and log backups - is this possible using the same script.
Hope someone can help as the thought of doing all of this individually for each database scares me silly!!! :)
Thanks in advance for any help
Hanley
Hi,
I am using EMS SQL Manager for SQL Server (www.sqlmanager.net). I am trying to learn how to do backups of my database.
I am up to this step -> http://www.sqlmanager.net/products/mssql/manager/documentation/hs21640.html
I don't think I actually understand what a device is, how it's created, where it resides, etc. I would like to backup my remote datasource to my local computer's harddrive.
Can someone please explain how this 'device' works and how I should set up?
Thank you so much for any help :-)
jo
Hi all,
Can somebody tell me how to display reports created in SSRS 2005 in PDA/mobile devices? How to connect to the PDA device?
Hello,
I am using EM to administer SQL 6.5 SP5a and have a few dBs that do not show backup history by expanding the backup device. The server is regestered as SA and MSDB does contain the the correct data in the sysbackuphistory table. MSDB DBCCs OK and other dBs show history. I manage multiple SQL 6.5 servers but this is the first time I've seen this and can find no info in the various KBs or NGs..
Anyone have any clues?
Thanks,
Jack
Hi am new to this, I am doing some asp development and wanted to know if there is a way of specifying the drive to place log and data devices through sql statments or stored procedures.
--Tito
If I'm not mistaken, we can create a backup device OR backup files in SQL7. Can someone tell me which one is better?
View 1 Replies View RelatedHello--
I am trying to backup a VLDB (800+gig) to multiple devices. I am using 4 disk drives. Assuming all devices have the same performance, should the 4 devices fill equally? (IE 200gig per drive) If so, what would might happen if one of the 4 drives only has 100 gig free with the other 3 having 300 gig free each?
Thanks for the help--
Jeff