Database

Bram van Kampen wrote:

The second is that I need a proof of concept, which has no security implications. If I can make my SQL DB open to all callers (i.e. No Security checks whatsoever) I can show my supporters something that works.

Bram van Kampen wrote:

The security aspect is a matter of DB configuration and Connect String. That can be sorted independently at a later date.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Eddy Vluggen wrote:

Nothing is as permanent as temporary code. If it works without "fixing", then
there's a good chance it won't be fixed.

Eddy Vluggen wrote:

How about switching temporarily to MS Access?
 

Bram van Kampen wrote:

How do I access that with SQL,

Bram van Kampen wrote:

and do the SQL Constructs make sense for a pure SQL database.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Eddy Vluggen wrote:

Bram van Kampen wrote:

and do the SQL Constructs make
sense for a pure SQL database.

It uses SQL, but I don't know how the
word "pure" fits in.

Bram van Kampen wrote:

I extrapolate from the above that

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Eddy Vluggen wrote:

Which credentials did the Management Studio use to connect to the database?

Eddy Vluggen wrote:

Yes, but that's local to your machine - the database-server has it's own
security. There's two modes; first there's Windows Authentication, which takes
the user that's currently logged into Windows to authenticate (and is DBO when
creating a table). One doesn't need a password in that case, since you already
provided a username/password when logging into Windows. That's the preferred
way. Alternative, there's "mixed mode", where SQL accepts a username/password
combination (with "sa" usually being the name of the admin account).

SqlConnection myConnection = new SqlConnection("server=b-pc\\Softguard;"+
                                       "database=SgTextiles; " +
                                       "User ID=sa;Password=12345;" +
                                       "Trusted_Connection=true;" +
                                       "connection timeout=5");

Quote:

System.Data.SqlClient.SqlException (0x80131904): Cannot open database "SgTextiles" requested by the login. The login failed.
Login failed for user 'b-PC\Bram'.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean

Bram van Kampen wrote:

Was this security system per chance written by 'Franz Kafka'?

Bram van Kampen wrote:

I have since reset the database to 'Mixed Mode'

Bram van Kampen wrote:

My first priority now is to connect to the DB

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Eddy Vluggen wrote:

Should work if you change the connectionstring. I'll reply to the other post
later today.

Quote:

System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'sa'.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

Bram van Kampen wrote:

This version 3 will need to connect to the internet, so the security issue becomes important.

Bram van Kampen wrote:

I had to shut down the terminal several times to get rid of the internal
compiler error.
When I eventually got it running, I got:

Bram van Kampen wrote:

I also think, important reading for IT consultants, designers et all. Two of the books he wrote, 'The Process' and 'The Castle' are worth reading.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

mAzeem22 wrote:

i Required SQLite based Dictionary for android

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Patient
Patient_id
Patient_name

Medicine
med_id
medicine_name
patient_id

attachment
attachment_id
attachment
patient_id

Arun kumar Gautam wrote:

now i want data as
patient_name medicine_name attachment

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

CREATE PROCEDURE addTitle
@ErrorDtls VARCHAR(100) OUTPUT
BEGIN
	BEGIN TRY
		-- Insert Statement 
		Create table #temp(ID int,fName varchar(20))
		Insert into #temp(ID,fName)values('a1','test') 
		SELECT @ErrorDtls = NULL 
	END TRY
	BEGIN CATCH -- While Error this Block will work
		-- Insert Error table 
		Insert into apl_Error(Error_Desc,Error_Date)
		SELECT RTrim(LTrim(Cast(ERROR_STATE() as CHAR(10))))+','+ RTrim(LTrim(Cast(ERROR_LINE() as CHAR(5))))+','+ERROR_PROCEDURE()+','+ERROR_MESSAGE(), GETDATE()
		-- Frame Error Message
		SELECT @ErrorDtls ='Error on Inserting'			
		
	END CATCH
END

-- Execute Statement
DECLARE @ErrorDtls VARCHAR(100) 
EXEC addTitle @ErrorDtls=@ErrorDtls OUTPUT
SELECT @ErrorDtls

CREATE TABLE apl_Error 
(
	Error_Desc VARCHAR(MAX),
	Error_Date DATE 
)

CREATE PROC SAMPLE
@ERROR_DESC VARCHAR(MAX) OUTPUT
AS

BEGIN
	BEGIN TRY
		CREATE TABLE #TABLE(ID int,fName varchar(20))
		INSERT INTO #TABLE VALUES('A1','CHOICE')
		SELECT @ERROR_DESC=NULL
	END TRY
	
	
	BEGIN CATCH
	INSERT INTO apl_Error(Error_Desc,Error_Date)
	SELECT cast( RTRIM(LTRIM(CAST(ERROR_STATE() as CHAR(10)))) +','+ RTRIM(LTRIM(CAST(ERROR_LINE() AS CHAR(5))))+','+ERROR_PROCEDURE()+','+ERROR_MESSAGE() as varchar(max)),GETDATE()

	SELECT @ERROR_DESC='Error on Inserting'		
	
	
	END CATCH

END

DECLARE @NAME VARCHAR(MAX)
EXEC SAMPLE @ERROR_DESC=@NAME OUTPUT
SELECT @NAME AS Error_Description

Error_Desc  Error_Date
1,8,SAMPLE,Conversion failed when converting the varchar value 'A1' to data type int.   2013-07-05