I have two database servers, one Dev and another one Test, I made lots of changes on Dev hance I tried to restore the backup of Dev Database on Test Server with same name everything same. Now with the same Credentials Login and Password my web application is failing to access the database on Test, by saying failing to access the Database.
Can anybody please help me in getting out of this situation. All I did was, Dev and Test are two different physical servers, took backup of Dev and restored it on the test, now Login fails.
Any help a link code snippet or even a suggestion helps a lot. Thanks in advance.
"There is already enough hatred in the world lets spread love, compassion and affection."
After restoring a database I run this script to drop and add the expected users. It assumes the users are already created on the new server. The underlying ID for the user name will be different on each server.
Declare csrPV Cursor Fast_Forward ForSelect name
Where issqluser = 1and hasdbaccess = 1AND name NOTIN ('dbo','IBMSQLDBA')
FETCH NEXT FROM csrPV INTO@UsrWHILE@@FETCH_STATUS = 0BEGINSet@SQL = 'DROP USER [' + @Usr + ']'Print@SQLexec (@SQL)
Set@SQL = 'CREATE USER [' + @Usr + '] FOR LOGIN [' + @Usr + '] WITH DEFAULT_SCHEMA=[dbo]'print@SQLexec (@SQL)
Set@sql = 'ALTER LOGIN [' + @Usr + '] ENABLE'exec (@SQL)
EXEC sp_addrolemember N'db_owner', @UsrFETCH NEXT FROM csrPV INTO@UsrENDCLOSE csrPV
Never underestimate the power of human stupidity
I just finished reading a book on deductive databases, which outlined the basics about Datalog and deductive databases (Deductive Databases and their Applications by M. Colomb, if anybody is interested). Now I wish to actually try using this acquired knowledge, and so here is the question.
What program do you advise using for somebody looking to work with Datalog for the first time (prefferably available for free for educational purposes)? I have been looking into it and thus far haven't found any software with it's own GUI and a good guide for newbies. (Most of them such as IRIS seem to be Java plugins, and I don't know how to make it work).
The book doesn't seem to suggest much of anything in terms of actual software to work with. It seems to be mostly about explaining Datalog on theoretical level (how the horn clause works within a database set-at-a-time environment and other concepts about it's inner workings) rather than outlining how to work with it on a specific platform.
Truth be told, as I am searching around, it seems there are no real Datalog focused platforms, just interpreters invoked as coding language libraries (for example IRIS for Java). The thing is, I have no idea how to make IRIS and it's libraries work. :/ Guess I will have to experiment around...
First of all sorry for any mistake I might give as English it is not my natural language.
My issues is: I built a query where I had to join 8 tables. The query should only be returning 4 rows but instead it is returning 8 rows as one of the tables I'm using in the join's has a field type to identify , for example if it is source and destination(0 or 1). The final result should return only one row with either with source and destination information base on the type. Two different columns (source,destination) but same row.
Any ideas how to solve this?
I appreciate any help.
Please find below a sample of the SQL. It is not the real script but reflects the scenario I tried to describe.
"select shipId,number,reference,[weight],SA.typeOfAddress,addressLine as Source, addressLine as Destination
FROM Shipments AS S INNER JOIN ShipmentAddresses AS SA ON SA.shipmentId = S.shipId
INNER JOIN Addresses as A ON A.addressId = SA.addressId"
This query is returning 2 rows:
shipId | number | reference | weight | typeAddress| Source | Destination |
1 1 ref1 12 0 London Road London Road
1 1 ref1 12 1 LiverPool Lliverpool
I would like a single row:
shipId | number | reference | weight | Source | Destination |
1 1 ref1 12 London Road LiverPool
Note: the type of address in the first example of results was just to indicate that 0 is source and 1 is destination.
SA.addressLine As Source,
DA.addressLine As Destination
Shipments As S
-- Source address:
INNERJOIN ShipmentAddresses As SSA
ON SSA.shipmentId = S.shipId And SSA.typeOfAddress = 0INNERJOIN Addresses As SA
ON SA.addressId = SSA.addressId
-- Destination address
INNERJOIN ShipmentAddresses As DSA
ON DSA.shipmentId = S.shipId And DSA.typeOfAddress = 1INNERJOIN Addresses As DA
ON DA.addressId = DSA.addressId
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
I found the MS SQL database for a specific application and needed to change a record in the database. What needs to be changed is a field with the name of a pdf that the points to a server folder that holds all of the application pdf files. What I did was rename the record field to the correct new pdf file name and copy the new pdf file to the server pdf folder. When I try to access the pdf file from the application I select view pdf link and the new pdf does not opens. In the application when the same link was select the original pdf opened to show the pdf content. After that I tied to change the pdf field in the database back to the name of the original file name and now when I select the same link that worked before with the original pdf file that opened before it will not open and appears to have the same problem as what I changed for the new pdf. I made sure that the file is still in the application directory and everything is back to the way I started and it still does open either the original or updated file. When I checked both file permissions I don't see anything wrong. I don't know what could of caused this.
Last Visit: 31-Dec-99 19:00 Last Update: 11-Feb-16 14:10