Database Discussion Boards

Dave Kreskowiak14-Jun-07 16:46

14-Jun-07 16:46

The best way to keep the column from prying eyes is to encrypt the password before you store it in the database. Read this[^] article here on CP for a good explanation on the do's and dont's of storing passwords.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: password

S Douglas17-Jun-07 22:18

S Douglas

17-Jun-07 22:18

Dave Kreskowiak wrote:
Read this[^] article here on CP for a good explanation on the do's and dont's of storing passwords.

Very good article, Thanks

set global max_allowed_packet=16777216

WhiteGirl2314-Jun-07 3:19

WhiteGirl23

14-Jun-07 3:19

Hi,
I work on a project which convert a database access in mysql and I have a field
which has 9 Mb and when I try to convert this field in mysql I get the error:

Error:Unable to write to stream<br />

I put the mysql sintax:

set global max_allowed_packet=16777216

but it doesn't work.

Maybe I didn't put it right.
I put this command in my program.

Please help.
Thanks

-- modified at 9:18 Thursday 14th June,

Re: many to many relationship

originSH14-Jun-07 1:40

originSH

14-Jun-07 1:40

You use a third table between the 2 tables you wish to have a many to many relationship between

Table1
-ID

Table2
-ID

Table1ToTable2
-Table1ID
-Table2ID

Re: many to many relationship

sangramkp14-Jun-07 1:49

sangramkp

14-Jun-07 1:49

the 3rd table having the 2 columns will be composite primary key or foreign key or both.

Thanx Confused | :confused:

Re: many to many relationship

Giorgi Dalakishvili14-Jun-07 2:14

Giorgi Dalakishvili

14-Jun-07 2:14

Both will be foreign keys

my articles

Re: many to many relationship

sangramkp14-Jun-07 2:29

sangramkp

14-Jun-07 2:29

thanx for clearing my confusion Big Grin | :-D

Re: many to many relationship

Giorgi Dalakishvili14-Jun-07 2:33

Giorgi Dalakishvili

14-Jun-07 2:33

You are welcome

my articles

Re: many to many relationship

sangramkp14-Jun-07 18:59

sangramkp

14-Jun-07 18:59

Hi,

I have gone through the third table having two columns will be foreign key columns and composite primary key....

its a correction

Sangram Smile | :)

"oledbexception:could not update currently locked".

tomertro14-Jun-07 1:03

tomertro

14-Jun-07 1:03

Hi
i am using data base Access 2000.

my code implemnting nestsed transactions where using more then one connection
i get the following exception: "oledbexception:could not update currently locked".

i cant put the whole code but i can demonstrate:

if (!Modified) return;

Modified=false;

OleDbTransaction transaction =null;

try

{

OleDbCommand command = new OleDbCommand();

command.Connection=conn;

transaction=conn.BeginTransaction();

command.Transaction=transaction;

command.CommandType = System.Data.CommandType.Text;

command.CommandText = "Delete * from tab";

command.ExecuteNonQuery();

try

{

OleDbConnection secondCon=GetAnotherConnection();

MyClasss.SaveTo(secondCon,Number)

}

catch(Exception ex)

{

throw new Exception("Can't save " + ex.ToString());

}

MyClasss

{

public void SaveTo(OleDbConnection conn,int Number)

{

OleDbTransaction transaction =null;

try

{

OleDbCommand command = new OleDbCommand();

command.Connection=conn;

transaction=conn.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted);

command.Transaction=transaction;

command.CommandType = System.Data.CommandType.Text;

command.CommandText = "Update [Field Records] " +

" SET " +

"[ Cost Periodic]='" + (periodic?"True":"False") + "';";

command.ExecuteNonQuery();

transaction.Commit();

}

catch(Exception ex)

{

if(transaction!=null)

{

transaction.Rollback();

}

throw new Exception("Can't save" + ex.ToString());

}

}

}

Please give your advice.
Thanks in advance.

To save a file in a SQL 2005

Saranya B13-Jun-07 23:44

Saranya B

13-Jun-07 23:44

Can anyone help me to save a file in SQL Server 2005. Confused | :confused:

My application will be used by the user to attach the approval mails (Either html or word or any files).
How can i save and retrive from SQL Server 2005? OMG | :OMG:

Anticipating for your replies...

Regards,
Saranya Balasubramanian

Re: To save a file in a SQL 2005

Colin Angus Mackay14-Jun-07 1:01

Colin Angus Mackay

14-Jun-07 1:01

Use a varbinary(max) column type. Use that type in parameters when you add data to the database. When you select it the result will by a byte array in your .NET application.

Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

Re: To save a file in a SQL 2005

Giorgi Dalakishvili14-Jun-07 1:53

Giorgi Dalakishvili

14-Jun-07 1:53

This will help you: http://support.microsoft.com/kb/309158[^]

my articles

To get the data from another table...

codingrocks13-Jun-07 23:32

codingrocks

13-Jun-07 23:32

I am doing an application in which i have to retrieve data from multiple tables...

the scenario is like this...

a head_quarter table have state field...as numeric

and a state table hav the same fields....as varchar...

i wanna retrieve the data from head quarter table using stored procedures and the numeric id should be returned to a string...
considering the string then i hav to get the name of the state from state table and put it into the web page...

my stored proc is

--Author: SAJAN A PILLAI

--Created: 9:14 AM 6/14/2007 THURSDAY

CREATE PROCEDURE sp_GetCurrentHQ

(@cid numeric , @organization varchar(100), @hqaddr1 varchar(100), @hqaddr2 varchar(100), @hqcity varchar(50), @hqstate numeric, @hqpin varchar(7), @hqdistrict numeric,@hqplace numeric, @hqphone varchar(100), @hqfax varchar(100), @hqemail varchar(100), @hqwebsite varchar(100), @hqpan varchar(50), @hqtan varchar(50), @hqtin varchar(50),
@hqstatetaxno varchar(50), @hqcentraltaxno varchar(50), @hqfromdate datetime, @todate datetime)
AS
BEGIN
declare @state_name  as varchar(128);
select @state_name =  SHORT_FORM from states  where  ADM1 = '2';
set @st_name=@state_name;

select  OrgName,HqAdd1, HqCity,HqState,HqPin,HqPlace, HqDist, HqPhones ,HqFax,HqEmail,HqWebsite,HqPAN,HqTIN,HqStateTax,HqCentralTax,FromDate,ToDate from HQ where 	FromDate <= getdate() and ToDate >= getdate();

END
GO

please help me

SAJAN A PILLAI

C#.NET Programmer
TELESOFT INDIA PVT LTD...
BANGALORE

invalid objects

manni_n13-Jun-07 22:16

manni_n

13-Jun-07 22:16

i have just started learninf SQL 2000
when i mamakin simplest query in query analyzer select * from authors, where authors is the name of table,
its giving error that invalid object ' authors'.
how this error can be resolved???

Re: invalid objects

Sylvester george13-Jun-07 22:39

Sylvester george

13-Jun-07 22:39

1. check the authors tabls exists in the database
2. check whether you selected / pointed the right database

Regards,
Sylvester G
sylvester_g_m@yahoo.com

Re: invalid objects

Colin Angus Mackay13-Jun-07 23:07

Colin Angus Mackay

13-Jun-07 23:07

manni_n wrote:
its giving error that invalid object ' authors'.
how this error can be resolved???

If you are just learning a better question would be "What does the error mean?" so you can understand what it means in the future.

SQL Server has a number of database objects. These include tables, views, stored procedures, functions and so on.

You can get a list of all object in the database by typing

SELECT * FROM sysobjects

The message "invalid object" indicates that the object either does not exist, or it is the wrong type of object for the context in which you are trying to use it.

In this case you refer to a table object in the SELECT statement that does not exist (there may be another object in the system called authors, but that will be a different type of object, or be used in a different context.

How to return cursor from stored proc??

FishiFishi13-Jun-07 22:08

FishiFishi

13-Jun-07 22:08

Hi all

i wana come to know that how can i return cursor from a stored procedure???

Regards

Qaiser

Re: How to return cursor from stored proc??

Tirthadip13-Jun-07 22:36

Tirthadip

13-Jun-07 22:36

I think A cursor is a server side thing. You can't "return" this to a client.
Anyway why do u need this??

Tirtha

Do not go where the path may lead, go instead where there is no path and leave a trail.

Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist

Re: How to return cursor from stored proc??

N a v a n e e t h14-Jun-07 23:22

N a v a n e e t h

14-Jun-07 23:22

Why you need to return a cursor from a Stored Procedure ? I think you got confused with Oracle .. Is it ?

Navaneeth
My Website

How to get top n records

FishiFishi13-Jun-07 22:00

FishiFishi

13-Jun-07 22:00

Hi All

i want to get top 5 records from the table. what would be the query?

Regards

Qaiser

Re: How to get top n records

Tirthadip13-Jun-07 22:32

Tirthadip

13-Jun-07 22:32

Returning only the first N records in a SQL query differs quite a bit between database platforms. Here's some samples:

Microsoft SQL Server

SELECT TOP 10 column FROM table

PostgreSQL and MySQL

SELECT column FROM table<br />
LIMIT 10

Oracle

SELECT column FROM table<br />
WHERE ROWNUM <= 10

Sybase

SET rowcount 10<br />
SELECT column FROM table

Firebird

SELECT FIRST 10 column <br />
FROM table

Tirtha

Do not go where the path may lead, go instead where there is no path and leave a trail.

Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist

how to call a webservice from stored procedure in SQL Server2000?

chronossu13-Jun-07 21:27

chronossu

13-Jun-07 21:27

I've created a dll (with vb6) to call a webservice, and this works fine when called in vb6.
I need to run this from stored procedure in SQL Server 2000,
because we have many clients that run application that access an SQL server.
It'll be hard work to install the dll into each of the clients pc (and many of them don't have MS SOAP installed), so instead I've been planning to install the dll in the server that runs SQL server, while others clients can just use store procedure to get the result from the webservice (which access to another SQL server machine).
We've tried using linked server but the response is too slow.
When I've tried to create store procedure to access the dll, it always return NULL value.

Anyone can help with this problem?

Thanks in advance,

Chronos

create alias and tables on my pc and copy them with setup or create them in installed pc

upamir13-Jun-07 21:19

upamir

13-Jun-07 21:19

Have a good day.

Must i create alias and tables on my pc while design and copy them with setup or must i create them in installed pc.

so my real question,

i want to create password protected tables to use but i couldnt create this table in run time.i can do it from database desktop->restructure menu.
İs there anyway to create this table in runtime or make a table which is not protected in c++ and restruct it in c++;

thanks.

Text datatype not exceeding 8000 characters

Rajiya13-Jun-07 20:51

Rajiya

13-Jun-07 20:51

Hi,

I have a stored procedure which is having a input parameter as TEXT datatype. I am passing a string to it whose length is 9000. It does not accept more then 8000 characters of the string. How to solve this issue?
Is there any method in which i can increase the length of the datatype. or is there any other datatype whose datalength is more then 8000?

Thanks,

Riz

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.