Do I Need These OLEDB Properties When Opening A Database?
Sep 24, 2007
Howdy folks!
If I set the following three properties when creating a database, do I need to set the same properties when I open the same database later?
sscedbprop[0].dwPropertyID = DBPROP_SSCE_AUTO_SHRINK_THRESHOLD;
sscedbprop[0].dwOptions = DBPROPOPTIONS_REQUIRED;
sscedbprop[0].vValue.vt = VT_I4;
sscedbprop[0].vValue.intVal = 100;
sscedbprop[1].dwPropertyID = DBPROP_SSCE_MAX_DATABASE_SIZE;
sscedbprop[1].dwOptions = DBPROPOPTIONS_REQUIRED;
sscedbprop[1].vValue.vt = VT_I4;
sscedbprop[1].vValue.intVal = 4091;
sscedbprop[2].dwPropertyID = DBPROP_SSCE_ENCRYPTDATABASE;
sscedbprop[2].dwOptions = DBPROPOPTIONS_REQUIRED;
sscedbprop[2].vValue.vt = VT_BOOL;
sscedbprop[2].vValue.boolVal = (a_bEncrypted==TRUE)?VARIANT_TRUE:VARIANT_FALSE;
Thanks!
BTW, why is the max size not 4096?
View 3 Replies
ADVERTISEMENT
Jan 30, 2007
I used to do this in DTS but wondered how to do it in SSIS. I have a For Each ADO recordset loop that reads these four columns into variables:
DataSource Name, Name(for a WHERE clause), user and password.
For each "Building" there is a new server to connect to, with identical tables. I have 10 tables in the loop to pump from one database to a SQL 2005 database (i.e. 10 dataflows). I want to set the source connection information with the variables. My questions:
1. How do I set the connection information for the source connections? Do I just set the properties for the connection manager and then it sets for all the sources? What property do I set--do I need a script task?
2. How do I use the values from the "Name" column in a WHERE clause in each data flow?
Thanks!
Kayda
View 4 Replies
View Related
Nov 12, 2001
i have a 10 gb database which iam not able to poen through enterprise manager or sql query analyser in sql server 7.0, any solutions?
View 1 Replies
View Related
Jul 11, 2005
Hi,I am getting this error when i am connecting sql database.Error = "SQL Server does not exist or access denied."Can you please suggest me where i am going wrong.RegardsNaveen
View 2 Replies
View Related
May 3, 2005
Hi everybody,
I am using VB Webforms as my front end and MSDE 2000 as my back end. I am not able to drop a database after executing the following vb code on that database:
Dim vConnection As New SqlConnection(vConnectionString) Dim vAdapter As New SqlDataAdapter("SELECT party_type_code, party_type_name, party_type_imported" & _ " FROM Party_Type" & _ " ORDER BY party_type_name", vConnection) Dim vDataTable As New DataTable() vAdapter.Fill(vDataTable) vAdapter.Dispose() vConnection.Dispose()
On trying to drop the database using the SQL Command "DROP DATABASE PPCABCD2005", I get the error message:Cannot drop the database 'PPCABCD2005' because it is currently in use ...However, if I don't execute the above code, I am able to drop it. Why is it so? What is the solution to this problem?
View 2 Replies
View Related
Jan 2, 2005
Hello, Im new with databases.
I know that opening a connection to a DB is expensive. Usually I write a method that opens a connection to the DB then I execute a query and then close the connection. Pretty standard.
OK, so how do I handle opening connections to the database when I need to run multiple queries. For example, i have a webpage that need to query the database to see if the user has moderator privledges, then depending on that query I have to query the DB again for moderator specific information or non-modertaor information.
So in this case how do i handle opening connections to the DB. Is it ok to generally have to open a connection to a DB multiple times on a page load?
The obvious solution is to keep the connection open. That is, open a connection, query the Db, keep the connection open, do the conditional statment ( if is_Moderator) then query the DB again for the info that I need, and then close the connection. But, from all the books that Ive been reading this is not a good practice because business logic should not been in the dataAccess layer.
Any help would be much appreciated.
View 2 Replies
View Related
Feb 14, 2008
Hi there I dunno if this is the correct place to ask this.I got this database that is part of application, I need to convert/migrate it to any other current database like SQL server, the problem is that I dunno the database type, with his current application I know it got stored names and address, from the application I can only export 9999 records at the same time.The database is a 300mb DAT file.I have never done anything like this before so Any help or suggestions would be apreciatte, ty.Database opened with Index Data Suite:http://b.imagehost.org/0096/index_data_suite.jpgDatabase opened with Hex Editor:http://b.imagehost.org/0096/hex_pic.jpg
View 11 Replies
View Related
Dec 3, 1999
What are the differences between the database permissions, which can be granted in the database properties permissions tab (create table, create procedure etc.) and the predefined role db_ddladmin? It seems that the database properties permissions tab includes more permissions than the predefined role db_ddladmin.
Does anybody know the difference in terms of permission?
View 1 Replies
View Related
Mar 16, 2015
I have an ODBC connection string that is working fine with the following properties:
Database="XXXXXXX",Network="YYYYYY"; strangely no server is specified in the string, but it is specified in the ODBC Connection file.
I am trying to do a new server registration in SSMS for this database.However, I don't understand where the network spec is placed.
Under Registered server name I've tried:
YYYYYYXXXXX
When I browse the server for the database instance list, I receive "network path was not found".
I even tried:"XXXXXXX",Network="YYYYYY" for the registered server name.Same error message.
What am I doing wrong ?
View 1 Replies
View Related
Feb 10, 2008
Hi Guys,
I am try to create an application (WPF) that uses data from an SQL server database via a web service, all localized on my computer in a virtual folder.
The program work fine, it can retrieve the data from the database.
The problem arises when I want to open the same database with server explorer in VS2008 or with SQL server management studio.
Once I have used my application those two programs are not able any more to establish a connection with the database inviting me to close the program that is using the database. Even if I shut down my application and the full project those to program can not open it. I need to switch the computer off.
My application closes and dispose the connection as soon as the data have been retrieved.
The connection string that I am using is the following:
"Data Source=.SQLEXPRESS;AttachDbFilename=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataDataBaseName.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
The question is why am I seeing these problems?
What I am doing wrong
Am I opening a connection in a exclusive way without realizing?
Please help me, I am getting crazy!!!
Cheers
View 9 Replies
View Related
Dec 6, 2003
Hi,
I am trying to call a stored procedure to insert into my database. After I called Open(), it crashed on ExecuteNonQuery(). I get the following message.
Object must implement IConvertible.
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.InvalidCastException: Object must implement IConvertible.
Source Error:
Line 160:Try
Line 161:myConnection.Open()
Line 162:myCommand.ExecuteNonQuery()
Line 163:myConnection.Close()
What does this mean? If anyone encountered this error before, please let me know how to trace the error and fix it.
Thanks Gurus,
John
View 4 Replies
View Related
Dec 19, 2006
Hi,
I am writing an application for a device (HP IPAQ 6828) having Windows Mobile 5.0 using
-MS .NET Compact Framework 2.0 SP-1
-SQL Mobile 2005.
-VS 2005 .NET
The application uses Merge Replication. The error occurs in the Synchronise() Method of the SqlCeReplication object.
"SQL Server Mobile encountered problems when opening the database."
repl.AddSubscription(AddOption.ExistingDatabase)
repl.Synchronize()
I also checked the the connection string and it seems to be fine. Both my device and server can ping each other. Moreever I can also access the Web syncronization folder(on server) from the device.Is anyone having a resolution for this?
View 3 Replies
View Related
Nov 26, 2006
I am trying to deploy my mobile app to treo 700wx, but when i test the app, the application gives me an error message:
sql mobile encountered problems when opening the database
It happens when I sync data.
However, when I sync data users and customer info, it doesn't give this message, But when I sync (third time) order info, this message comes out.
--when i run on my PPC (HP ra1950), there is no this error message.
I think it is a bug?
BTW, which cabs file should I install on the Treo phone? (.Net ce, sql ce mobile30 ???)
Please help me out. Thanks
James
View 3 Replies
View Related
Oct 30, 2007
Hello!
I'm trying to connect a sql ce database from a PPC with WM 2003 to a sql server 2005 database.
I discover the class SqlCeRemoteDataAccess, so i've been trying, unsucessfuly, to get things working.
I googled a lot, i read Ms Articles from MSDN, i read some posts here, but can't find solution for my problem. As you can see in my code, i already tryed different aprroaches, differente connections strings, with "provider", without "provider", with "sspi", without "sspi", you name it...
I configure the sql server agent like i read in msdn, and he's working well, i'm able to see the message. ("Microsoft SQL Server Compact Edition Server Agent" when i open the url).
The sql database credentials are correct, i already check that.
I did everything i knew and i read, unfortunately i still can't manage to find a solution for an error message:
"SQL Server Mobile encountered problems when opening the database." The native error is 28559
That's an Exception error message, that appears to me.
Can somebody help me?
Thank you!
Code Block
string connString = "Data Source=\My Documents\inv.sdf;Persist Security Info=False;";
string rdaOleDbConnectString = @"Data Source=server;Initial Catalog=mycatalog;Integrated Security=SSPI;User Id=myLogin;Password=myPasssword;";
public void ImportDatabase()
{
//rda.LocalConnectionString =@"Data Source=\My Documents\inv.sdf";
//rda.InternetUrl = "http://myserver/sync/sqlcesa30.dll";
//rda.InternetLogin = "myLogin";
//rda.InternetPassword = "myPassword";
SqlCeRemoteDataAccess rda = new SqlCeRemoteDataAccess("http://server/sync/sqlcesa30.dll","myLogin","myPassword",connString);
try
{
// Try the Pull Operation
rda.Pull("localtable", "SELECT Cod, Name FROM People", rdaOleDbConnectString, RdaTrackOption.TrackingOnWithIndexes,"ErrorTable");
}
catch (SqlCeException exc)
{
// Handle errors here
//
MessageBox.Show(exc.Message + "-" + exc.NativeError);
}
finally
{
// Dispose of the RDA object
//
rda.Dispose();
}
View 1 Replies
View Related
Dec 19, 2006
Hi,
I am writing an application for a device (HP IPAQ 6828) having Windows Mobile 5.0 using
-MS .NET Compact Framework 2.0 SP-1
-SQL Mobile 2005.
-VS 2005 .NET
The application uses Merge Replication. The error occurs in the Synchronise() Method of the SqlCeReplication object.
"SQL Server Mobile encountered problems when opening the database."
repl.AddSubscription(AddOption.ExistingDatabase)
repl.Synchronize()
I
also checked the the connection string and it seems to be fine. Both my
device and server can ping each other. Moreever I can also access the
Web syncronization folder(on server) from the device.Is anyone having a resolution for this?
View 1 Replies
View Related
Oct 31, 2007
is there anyway to retrieve the database properties and display in an asp.net web form as a quick over view rather than logging onto the server to check, items such as size, space available, last backup data etc? Cheers
View 2 Replies
View Related
Sep 28, 2007
When I create a new database it asks for information regarding the Data files.
What is it for? Will this file get creted to the location that I write?
How often will it get copied there?
View 1 Replies
View Related
May 9, 2007
Hi.
I am trying to look for ways on how to get all the databse properties under each instance.
say I want to view the size, recovery model, physical location, etc.
The sys.database_files is only applicable per database. Is there a query, or a table in master database to get these or store these values?
thanks...
View 3 Replies
View Related
Mar 4, 2008
I am trying to find information on Database properties - more specifically, what the 'Space Available' means, because right now when I look at the properties of a database I am setting up, which will grow substantially I am sure, it says the database size is 154 MB and the Space Available is 42 MB. What is the Space Available? What does this refer to and is it going to be restricting the growth of the database? Thanks.
View 7 Replies
View Related
Oct 10, 2007
I'll try and ask one more time. Does anyone have a clue how to fix this?
"A SQL Server Compact Edition DLL could not be loaded. Reinstall SQL Server Compact Edition. [ DLL Name = sqlceca30.dll ]"
or
"SQL Server Compact Edition encountered problems when opening the database"
"Internal error: The database is not initialized."
I've been fighting this for well over a week now. My XP based version works fine but this error occurs routinely on my CE4.2 device. I cannot find anything meaningful using Google other than 'look for non disposed' replication objects which I've done. Is this bad hardware? I don't believe I'm out of memory as the app is about 1.2MB including about 8 DLL's and GC indicates I have about 300KB of objects at the time of the failure. I also use a bunch of static (global) objects that I use throughout the code.
It would be nice if I could get the lower level error messages causing these failures but that is probably too much to ask.
The odd thing is that it's only the replication engine that fails as even after the failure, the app can reopen the DB and work with the data just fine.
My basic order of the application is...
1 Open DB SqlCEConnection
2 Create/Prepare any SqlCECommand objects
3 Do work here
4 Dispose any SqlCECommand objects
5 Close DB
6 Dispose SqlCEConnection object
7 Create SqlCEReplication object
8 BeginSynchronize
9 ... error here..
10 Dispose SqlCEReplication object
11 Reopen DB SqlCEConnection
I've tried creating the Replication object at program start and that does not help. I'm guessing there is something about .net that I don't understand either with stack space, # dll's or whatever. I've rearranged the order of the Dispose, Create, SQL CE objects to include just about every permutation but still am hitting this same problem.
Are there any tools that can help me profile this app for memory problems or usage? Everything seems geared for .Net and not .NetCF.
thanks.
View 4 Replies
View Related
Oct 2, 2006
Hi,I'm creating a User Interface to display Sql database Properties, but I cannot find the right query to retrieved the info on database properties. The status that I get is "ONLINE", but it should be "NORMAL". Cannot find the right query to get the date of last database backup, last transaction log backup, and maintenance plan, etc.. Please help me [:'(]
View 2 Replies
View Related
Nov 19, 2004
Hello, Everyone:
There are some databases in a SQL Server. How to check,
1. User database numbers
2. Backup plan
3. Configuration
4. User database size
5. Nightly process
Thanks a lot
ZYT
View 1 Replies
View Related
May 17, 2007
I've been asked to provide some information about databases on an sql server.
I can use the following query to provide the names of all the databases:
select * from master.dbo.sysdatabases
What I'm also looking to provide is the current "size" of the database. I'm trying to find a table that I can link to that would provide the database size. I can manually find this number by right clicking on the database from enterprise manager, selecting "properties" and picking it up from the general tab.
This is sql server 2K...
Thanks.
View 2 Replies
View Related
Dec 17, 2007
database role properties/ permissions
when i click permissions it takes forever to pop up the window.
Anyone know why and how do i make it faster.
http://www.sqlserverstudy.com
View 5 Replies
View Related
Nov 27, 2006
Hello there,I have about 30 sql servers runnign multiple databases amd i need toaudit them so what i want to do is to log onto each server and thenmaybe export the database properties into an excel sheet or text file.Anyone know how to do that i am quite new to sql any help will beawesome.Regards and thanx in advance
View 2 Replies
View Related
Feb 24, 2014
When opening .sql files, I get a connect to database engine prompt every single time. how to stop this from prompting vs. just using my current active connection?
View 4 Replies
View Related
Feb 9, 2007
I have a solution with a couple of ssis projects in it. Everytime I open the solution, Visual Studio creates an extra .database file for the project's existing xxx.database file. The solution is under VSS control and VS2005 checks out the project and shows the file as a newly added file.
What causes this and how can I prevent this from occurring?
The files contain this:
<Database xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0" dwd:design-time-name="d3ce9653-3ac5-4ee5-85c3-7d60b2e5f109" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<ID>Publish</ID>
<Name>Publish</Name>
<CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
<LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
<LastProcessed>0001-01-01T00:00:00Z</LastProcessed>
<State>Unprocessed</State>
<LastUpdate>0001-01-01T00:00:00Z</LastUpdate>
<DataSourceImpersonationInfo>
<ImpersonationMode>Default</ImpersonationMode>
<ImpersonationInfoSecurity>Unchanged</ImpersonationInfoSecurity>
</DataSourceImpersonationInfo>
</Database>
There are 2 of us working on the solution and the other fellow does not see this behavior.
The files do not show up in the VS2005 solution explorer. If they are user specific as I suspect (impersonation info?), then they should not be added to the .dtproj project file.
Thanks!
View 3 Replies
View Related
Oct 12, 2007
I have created an .sdf database on my Desktop - and am able to open and close it just fine from my application program.
Whenever I try to:
Open it with the same program but installed on a different PC,
or:
Open it from a program running as a service on the development PC, I get the error
"The operating system does not support the Encryption Mode provided."
The working above is from the Version 3.5 Beta, but the same problem occurs with Version 3.1.
The Error code in Hex is 80004005
I can't find any reference to fixing this error - any ideas?
View 2 Replies
View Related
May 13, 2008
Using the following code we are having a problem connecting a clients WIndows Mobile device to the SDF under IIS. We have success elsewhere. Does anyone have any clues ?
Cheers Al
Dim repl As New SqlCeReplication()
Try
repl.InternetUrl = InternetUrl
repl.Publisher = Repl_Publisher
repl.PublisherDatabase = Repl_PublisherDatabase
repl.PublisherSecurityMode = SecurityType.DBAuthentication
repl.Publication = Repl_Publication
repl.Subscriber = Repl_Subscriber
repl.SubscriberConnectionString = Repl_SubscriberConnectionString
repl.DistributorLogin = Handhelds_User
repl.DistributorPassword = Handhelds_Password
repl.AddSubscription(AddOption.ExistingDatabase)
repl.Synchronize()
MsgBox("Synched!")
Catch err As SqlCeException
MessageBox.Show(err.ToString, "Error")
Finally
Cursor.Current = System.Windows.Forms.Cursors.WaitCursor
End Try
View 3 Replies
View Related
Mar 14, 2014
I have a SSIS package where im importing data from MS access database file .MDB. I chose Microsoft JET 4.0 OLEDB provider. When i select a table and preview the data, im getting the below error.
Error at Data Flow Task [OLE DB Source [1]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E09.
Error at Data Flow Task [OLE DB Source [1]]: Opening a rowset for "_tblDateDateEarnedMismatch" failed. Check that the object exists in the database.
But it is working for the other tables .
View 3 Replies
View Related
Aug 14, 2006
Due to a network time skew some time ago, all of the databases on an SQL system now have the following information stamped on them..
Within Enterprise Manager (SQL 2000), The "Last Database Backup" timestamp for each database is showing the year 2025.
Our backup system runs incrementally daily and a weekly full. Unfortunately, the timestamp does not seem to be updating as the year is as I guess in the future.
Can anyone advise of a procedure so as I can wipe this time skew date from each of the databases?
Many thanks folks!
View 4 Replies
View Related
Aug 10, 2012
I am trying to generate a report from the database. I am using Visio 2010. I would like to include the table names, column names , column types and the comments that I entered in the NOTES field associated with the tables and columns. Basically, I would like to generate a data dictionary report.
View 2 Replies
View Related
Dec 6, 2007
I have added alias datatypes using sp_addtype and would like to view the properties defined in it.
please let me knowhow to view the properties of them and also is there a way to list all alias datatypes existing in the current database along with their properties.
View 1 Replies
View Related
