Re: sqlserver - Database Discussion Boards

sqlserver2000 database backup

renuka9011-Feb-08 20:21

11-Feb-08 20:21

HI,
how will operating system update database backup daily by itself in sqlserver2000?could U pls help me?are their steps?how to do that?first, i to have to take backup or what?

renuka

Re: sqlserver2000 database backup

D. Shyam11-Feb-08 21:04

D. Shyam

11-Feb-08 21:04

Create a SQL Server JOB with below code

EXECUTE master..xp_sqlmaint '-D <dbname> -WriteHistory -BkUpOnlyIfClean -CkDB -BkUpMedia DISK -BkUpDB -UseDefDir -DelBkUps 1DAYS -BkExt "BAK" -VrfyBackup -UpdOptiStats 15'

DUMP TRANSACTION <dbname> WITH TRUNCATE_ONLY

---------
Shyam Benagal

Firewalls and remote connections

blackjack215011-Feb-08 19:32

blackjack2150

11-Feb-08 19:32

Hi.
Our company has some old VB6 programs which connect to a database through ODBC providers (for SqlServer, Access or MySql, depending on what the client prefers).
I wrote two new modules in C#, .NET 2.0 which connect to the same databases but using the .NET OldDb(for Access) and SqlDb or MySql Connector components.

The annoying thing is that more than once, we had reports from customers saying that they cannot use the .NET programs, but the VB6 ones were working. After turning off their firewalls they all worked. The error messages indicate timeouts while reaching the server.

I can't figure out the reason for this. I mean if the DB server is set to work on the default port, why would ODBC connection would be allowed by the firewall and the .NET connection would be timed-out?

Any clues or similar experiences?
Thanks.

sql and pl/ sql [modified]

Member 470807711-Feb-08 18:57

Member 4708077

11-Feb-08 18:57

what is teh diff b/w sql and pl/ sql?

raja

modified on Tuesday, February 12, 2008 1:05 AM

Re: sql and pl/ sql

Christian Graus11-Feb-08 19:00

Christian Graus

11-Feb-08 19:00

What does this have to do with ASP.NET ?

SQL is the language all databases use. There are many variations, such as T/SQL, PL/SQL, etc. They are dialects, SQL is the core language.

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Re: sql and pl/ sql

Joe11-Feb-08 19:34

Joe

11-Feb-08 19:34

What is the difference between a programmer and a slacker?
Google not working where you live??

Give a man a fish, he'll eat for a day. Teach a man how to fish, he'll eat for lifetime.
Pradeep Joe

sqlserver [modified]

Member 470807711-Feb-08 18:49

Member 4708077

11-Feb-08 18:49

what is the diff b/w create and create alter stored procedure in tee sql server?

raja

modified on Tuesday, February 12, 2008 1:04 AM

Re: sqlserver

Venkatesh Mookkan11-Feb-08 18:57

Venkatesh Mookkan

11-Feb-08 18:57

Are you preparing for any interview?? You are keep on asking questions.

Instead of asking questions here, you can google it.

To my knowledge, this forums helps the people to fix their issues rather than answering 5 marks questions.

[Venkatesh Mookkan]
My: Website | Yahoo Group | Blog Spot

sqlserver [modified]

Member 470807711-Feb-08 18:44

Member 4708077

11-Feb-08 18:44

what is diff b/w inline query and the stored procedure?

raja

modified on Tuesday, February 12, 2008 1:05 AM

Re: sqlserver

Gandalf_TheWhite11-Feb-08 18:59

Gandalf_TheWhite

11-Feb-08 18:59

Hi dude.
I think u have faced Interview in very near past.
Just don't rely only this forum go through Google and search for More That will help
Them main diffrence between InlQuery ans SP is as follow.

InlineQuery = This is written in ur class file.
StoreProc = This is written in sql server.

Inlinequery = Syntax is checked in Sql Server.
StoreProc = Doesn't need checking.

InlineQ = Needs Compilation
StoreProc = No required Compilation.

InlineQ = When Grand Searching Requires Inline Query Becomes Very Handy and Easy To handle
StoreProc = It is not as much as powerful for searching.

Now search for other resources and Post here whatever u find. Poke tongue | ;-P

Sql Record Select

sivaprakas11-Feb-08 16:07

sivaprakas

11-Feb-08 16:07

hi anyone give query to select first 4 records , select last 4 records , select next 4 records and select previous 4 records in MSSqlServer

Re: Sql Record Select

Elina Blank1-Mar-08 11:45

Elina Blank

1-Mar-08 11:45

More info needed: your result recordset must be ordered by something?
Check this " Row_Number() over"

Sincerely,
Elina

Life is great!!!
Enjoy every moment of it! Blush | :O

Sql Select [modified]

NewToAspDotNet11-Feb-08 7:19

NewToAspDotNet

11-Feb-08 7:19

Hi all,
I have to select some data from a table where customer_name is not equal to John .
i used :
select data from table where customer_name != 'john'
select data from table where customer_name <> 'john'

bud it doe's not work. can somebody give me a good query?

thanx

modified on Monday, February 11, 2008 1:56 PM

Re: Sql Select

Ashfield11-Feb-08 7:45

Ashfield

11-Feb-08 7:45

You need quotes around john:

select column1,column2 etc
from table
where customer_name != 'john'

Assuming SQL Server you will need single quotes normally

Bob
Ashfield Consultants Ltd

Re: Sql Select

NewToAspDotNet11-Feb-08 7:57

NewToAspDotNet

11-Feb-08 7:57

I did, stil not working

Re: Sql Select

Ashfield11-Feb-08 22:34

Ashfield

11-Feb-08 22:34

Ok, I sort of assumed you were using SQL Server and customer_name was a standard varchar column, in which case the != syntax will work fine. I have to say, its difficult to give good answers to poorly defined questions.

1. What type of RDBMS are you using? SQL Server? What version?
2. Please post your table definition.

If the customer_name is a char rather than a varchar there will be trailing spaces to pad to the length of the field, eg if customer_name is char(5) then your query should read != 'john '

While NOT LIKE '%john%' as suggested by Krish -KP should work it will not use any indexes on the customer_name column so there could be performance issues.

If you can supply this info then someone will be able to answer your question, but a good alternative is to try reading the the help, thats why it was written Hmmm | :|

Bob
Ashfield Consultants Ltd

Re: Sql Select

Krish - KP11-Feb-08 17:34

Krish - KP

11-Feb-08 17:34

Check this ....

<br />
SELECT data FROM table WHERE customer_name NOT LIKE '%john%' <br />

hope your customer_name column is of Char datatype or contain john along with some more characters

Regards
KP

Re: Sql Select

Ashfield14-Feb-08 8:18

Ashfield

14-Feb-08 8:18

Obviously not that important then as you have not responded to my questions in an attempt to help you.

Bob
Ashfield Consultants Ltd

Again Crystal Report

simworld11-Feb-08 4:36

simworld

11-Feb-08 4:36

again I am sending the same problem but this time I searched in google for the code,and use the code that I got from this forum
what I have found i am sending,

---------------------------------------
CrystalReport1 report=new CrystalReport1();

report.ReportOptions.EnableSaveDataWithReport = false;

CrystalDecisions.Shared.TableLogOnInfo myLogin;

CrystalDecisions.Shared.ConnectionInfo oCRConnectionInfo = new CrystalDecisions.Shared.ConnectionInfo();

foreach (CrystalDecisions.CrystalReports.Engine.Table myTable in report.Database.Tables)
{
myLogin = myTable.LogOnInfo ;
//myLogin.ConnectionInfo.ServerName="(local)";
myLogin.ConnectionInfo.ServerName=".";
myLogin.ConnectionInfo.UserID = "sa" ;
myLogin.ConnectionInfo.Password = "123456" ;
myLogin.ConnectionInfo.DatabaseName="temp";

myTable.ApplyLogOnInfo(myLogin) ;
myTable.Location.Substring(myTable.Location.LastIndexOf(".") + 1);

}

OleDbConnection oleConn = new OleDbConnection("Provider=sqloledb; data source = .; initial catalog = inventory; user id = sa; password = 123456");

oleConn.Open();
OleDbDataAdapter da = new OleDbDataAdapter("select * from student",oleConn);

DataSet ds=new DataSet();

da.Fill(ds);

CrystalDecisions.CrystalReports.Engine.ReportDocument myReportDocument;

myReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
myReportDocument.Load(@"C:\Inetpub\wwwroot\temp\CrystalReport1.rpt",CrystalDecisions.Shared.OpenReportMethod.OpenReportByTempCopy);

myReportDocument.SetDataSource(ds);
this.CrystalReportViewer1.ReportSource =myReportDocument;

CrystalReportViewer1.DataBind();

CrystalReportViewer1.RefreshReport();

CrystalReportViewer1.DisplayToolbar = true;

CrystalReportViewer1.DisplayGroupTree = false;

oleConn.Close();

I did not got any error but my crystal Report Viewer contains no data i.e. it contains only Crystal Report Toolbar ,no data(Blank Report)

If I use F11 to run step by step ,I found the execution did not enter in the following Code.

foreach (CrystalDecisions.CrystalReports.Engine.Table myTable in report.Database.Tables)
{
myLogin = myTable.LogOnInfo ;
//myLogin.ConnectionInfo.ServerName="(local)";
myLogin.ConnectionInfo.ServerName=".";
myLogin.ConnectionInfo.UserID = "sa" ;
myLogin.ConnectionInfo.Password = "123456" ;
myLogin.ConnectionInfo.DatabaseName="temp";

myTable.ApplyLogOnInfo(myLogin) ;
myTable.Location.Substring(myTable.Location.LastIndexOf(".") + 1);
}

What urgent modifications I need to perform?
Help me.
I am using .Net version 2003.

PDF Problem

simworld11-Feb-08 4:29

simworld

11-Feb-08 4:29

this problem already this in this forum,but my problem still be there,I googled the following code, and try to run,but did not work.
---------------------------------------

CrystalReport1 report=new CrystalReport1();
CrystalDecisions.Shared.TableLogOnInfo myLogin;
foreach (CrystalDecisions.CrystalReports.Engine.Table myTable in report.Database.Tables)
{
myLogin = myTable.LogOnInfo ;
myLogin.ConnectionInfo.Password = "123456" ;
myLogin.ConnectionInfo.UserID = "sa" ;
myTable.ApplyLogOnInfo(myLogin) ;
}
CrystalReportViewer1.ReportSource=Server.MapPath("CrystalReport1.rpt");

CrystalReportViewer1.DataBind();

CrystalReportViewer1.RefreshReport();

CrystalDecisions.Shared.DiskFileDestinationOptions diskOpts = new CrystalDecisions.Shared.DiskFileDestinationOptions();

report.ExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;

report.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;

diskOpts.DiskFileName =Server.MapPath("Output.pdf");

report.ExportOptions.DestinationOptions = diskOpts;

report.Export();
Response.AddHeader("Content-Disposition","attachment;filename=Output.pdf");

Response.ContentType = "application/pdf";
Response.WriteFile("C:\\Inetpub\\wwwroot\\temp\\"+ "Output.pdf");

Response.End();

Response.ClearContent();

Response.ClearHeaders();

Response.Buffer = false;

Download option is comming,when trying to open that pdf file after downloading or just trying to open.

Error Meassage is
......

"There is an error Opening this Document.The File is damaged and could not be Repaired."

---
NOTE::: In Crystal Report Viewer the data is showed.

How can I solve that.I am using .Net version 2003

Reporting in MS Accesss

Vimalsoft(Pty) Ltd11-Feb-08 0:54

Vimalsoft(Pty) Ltd

11-Feb-08 0:54

hi all, i thought this was the right place to post this Question about access. i have a report that is Ouputed as snapshot file,and it designed in MS Access. and when i run the Report i get the report without line, and it supposed to have lines as i have Displayed in the images i have sent. how can i do the other one to have lines. links to my Screen shots here

http://www.vbforums.com/attachment.php?attachmentid=62181&d=1202730083[^]

http://www.vbforums.com/attachment.php?attachmentid=62182&d=1202730099[^]

Thanks

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

enable remote connection for sql server 2000?

eyeseetee11-Feb-08 0:09

eyeseetee

11-Feb-08 0:09

Hi
does any1 know how to enable remote connection for sql server 2000?

thanks

difference

trilokharry10-Feb-08 23:03

trilokharry

10-Feb-08 23:03