I have an xml document that was serialized into a byte stream and persisted to a database. I any get the byte stream back, but how do I convert it into an xml file again?
Hi Guys,
i tried to open the website from broswer project is deployed at IIS i am getting this exception
Exception information:
Exception type: SqlException
Exception message: Cannot open database "TestDB" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
any solution?
Regards
kumar
I am working on project that must need to protect data (revealing code is not main problem) files. We are using Java + Netbeans. Is there any facility that will create jar in encrypted format? We are also using sqlite for database - so putting text file in encrypted format is not proper option for us too.
Hi All,
We want to install sql server 2005 on Windo
ws 2000 Server. We are able to install database service engine, analysis services engine and integration services.
But we are unable to install workstation components like SSMS.
Does anybody faced this problem?
What is the fix for this?
Thanks,
Raghu
Hi,
I am using CI + Doctrine + MySQL and I am getting the following CRUD errors:
(1) When trying to create a new record in the database with this code:
$book_title = 'The Peloponnesian War';
$b = new Book();
$b-title = $book_title;
$b-price = 10.50;
$b-save();
I get this error:
Fatal error: Uncaught exeption 'Doctrine_Connection_Mysql_Exception' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'title' in 'field list' in ...
(2) When trying to fetch a record from the database and display on my view page with this code:
$book_title = 'The Peloponnesian War';
$title = $book_title;
$search_results = Doctrine::getTable('Book')-findOneByTitle($title);
echo $search_results-title; (in view file)
I get this error:
Fatal error: Uncaught exception 'Doctrine_Connection_Mysql_Exception' with message 'SQLSTATE[45S22]: Column not found: 1054 Unknown column 'b.id' in 'field list" in ...
And finally, when I try to update a record as follows:
$book_title = 'The Peloponnesian War';
$title = $book_title;
$u = Doctrine::getTable('Book')-find($title);
$u-title = $title;
$u-save();
I get a similar error:
Fatal error: Uncaught exception
'Doctrine_Connection_Mysql_Exception'
with message 'SQLSTATE[42S22]: Column
not found: 1054 Unknown column 'b.id'
in 'field list''in ...
Here is my Doctrine_Record model:
class Book extends Doctrine_Record{
public function setTableDefinition()
{
$this->hasColumn('book_id');
$this->hasColumn('isbn10','varchar',20);
$this->hasColumn('isbn13','varchar',20);
$this->hasColumn('title','varchar',100);
$this->hasColumn('edition','varchar',20);
$this->hasColumn('author_f_name','varchar',20);
$this->hasColumn('author_m_name','varchar',20);
$this->hasColumn('author_l_name','varchar',20);
$this->hasColumn('cond','enum',null, array('values' => array('as new','very good','good','fair','poor')));
$this->hasColumn('price','decimal',8, array('scale' =>2));
$this->hasColumn('genre','varchar',20);
}
public function setUp()
{
$this->setTableName('Book');
//$this->actAs('Timestampable');
}
Any assistance will be really appreciated. Thanks in advance.
i tried to get it to work but i never seem to have to luck, i go a code snippet for a blog and still no dice. This is the code.
EXEC sp_configure filestream_access_level, 1
GO
RECONFIGURE
GO
CREATE DATABASE NorthPole
ON
PRIMARY (
NAME = NorthPoleDB,
FILENAME = 'C:\Temp\NP\NorthPoleDB.mdf'
), FILEGROUP NorthPoleFS CONTAINS FILESTREAM(
NAME = NorthPoleFS,
FILENAME = 'C:\Temp\NP\NorthPoleFS')
LOG ON (
NAME = NorthPoleLOG,
FILENAME = 'C:\Temp\NP\NorthPoleLOG.ldf')
GO
![It would be great if someone can point me in the right direction on this topic
I have the following admx:
And I have to add the (AccData, CntactData, PhnNumber, FnclDetail)entities to the database in one shot
What’s the best practices to do the add operation for the above entities??
]1
Is SQLCacheDependency used in context of ASP.net or can it be used for a project of .net only. Rather tahn using ASP.net i am receiving request by listening on a port.I want to store data for my session in cache.If this data is fetched from database then i want it to be updated using something like SQLCacheDependency.Can I configure it for my use or is it restricted for use with asp.net cache.
The new version of SQLite has the ability to enforce Foreign Key constraints, but for the sake of backwards-compatibility, you have to turn it on for each database connection separately!
sqlite> PRAGMA foreign_keys = ON;
I am using SQLAlchemy -- how can I make sure this always gets turned on?
What I have tried is this:
engine = sqlalchemy.create_engine('sqlite:///:memory:', echo=True)
engine.execute('pragma foreign_keys=on')
...but it is not working!...What am I missing?
Hi,
My company receives data from an external company via Excel. We export this into SQL Server to run reports on the data. They are now changing to PDF format, is there a way to reliably port the data from the PDF and insert it into our SQL Server 2008 database?
Would this require writing an app or is there an automated way of doing this?
For several of my cuke scenarios, I want to POST the user to a page with an object in the params, so that Rails will make a new object in the database. Is there a convenient way to send a POST+params to an action (either using something in cucumber or rails) or do I have to write my own function using Net::Http?
Hi sir,
I need to upload image in table as well as in folder.please help me ,how i will save image in folder and database. please describe the method.
Thanks
Manish
hello,
i have this crazy label for each time i create a migration that use the time instead of a integer. it makes things very hard to switch between the version of the database that you want to use.
i also have this crazy ID for each object that i create :
How can set up rails to have easy version and id numbers.
thank you
Hi,
i want to create google map for own site.my task is that i have to fetch some information from database and i want to show in google map,with my icon.some thing like
"http://www.jaap.nl/koophuizen/Groningen///_/_/1/?rad=5km&min=450000&max=1000000"
in right side ,google map is showing,excatly i want to show my google map.if any have idea please help me
Thanks
Manish
[email protected]
i want to submit the text from jeditable, store it in the database and then i don´t want to render the updated text back to jeditable field, i want to update the whole div in which the jeditable field (and maybee other text fields) is.
f.e.
i change the username via jeditable inplace editor, then i store the changes in the db and now i want to update the complete div which contains the username (in place editor) and also other divs, cause after the username changes, the email changes, too.
I have some text data in database which I have retrieved in a Cursor, and I am displaying it in a ListView. What I want to do now is that when you select click a particular row in the list its text content should be displayed in full screen and the user should be able to scroll horizontally (like scrolling between iPhone home screens) to view the contents of the Cursor.
We are planning to use BDC to read and probably write to a SQL Server content database on external server. I have heard that there are many security issues that you may run into or should be aware of before setting up BDC.
has anyone faced or knows any security issues with BDC. Thanks.
i want to host an asp.net mvc website on godaddy, is economy hosting sufficient? economy hosting's database is mysql. can this be converted to mssql(or perhaps postgresql)?
Hi,
I'm in the process of building an app related to healthcare IT. My company wants to be able to distribute it through the appstore, but only if a device identified by the UDID of is specifically provisioned in the database. I've got all that built, but I was wondering if Apple might reject something like this.
Has anyone had any experience with activation codes?
Thanks,
Teja.
I'm getting a "The OLE DB provider "Microsoft.ACE.OLEDB.12.0 has not been registered" error. I have the data objects library downloaded and I have "Microsoft Office 12.0 Access database engine Object Library" selected.
I'm running the Windows Vista 32-bit operating system.
Any ideas would be greatly appreciated.
According to wikipedia!
http://en.wikipedia.org/wiki/ORDBMS
IBM's DB2, Oracle database, and
Microsoft SQL Server, make claims to
support this technology and do so with
varying degrees of success
So, are these products true "ORDBMS" like PostgreSQL? or they are they are long way from it? can someone plz! point me to any link where i can read about the features still to be implemented by these RDBMS to become true ORDBMS!
How convert a string into a ActiveSupport::TimeWithZone? My dilemma is this. I need to update a field (called updated_at). The field in mysql is datetime, and the class is ActiveSupport::TimeWithZone. But the dates are strings like "10/17/2008". I used "10/17/2008".to_date (And I intend .to_time and to_datetime), and even if in console the ActiveRecord class save succesfully, the field in the database still is the current date...
Thanks in advanced.
From within TFS 2008, is there a way to view the disk space taken up on the server by a project (or by all projects)? Or is this something that can only be done by looking directly at the underlying database?
I have a PHP redirect page to track clicks on links. Basically it does:
- get url from $_GET
- connect to database
- create row for url, or update with 1 hit if it exists
- redirect browser to url using Location: header
I was wondering if it's possible to send the redirect to the client first, so it can get on with it's job, and then log the click. Would simply switching things around work?
Hi, I am learning python for a while, now I like to learn python for web, using python as a back-end of website. where and how do I start learning this:
Example usages are : connecting database and retrieve and store information from forms