SQL server connectivity Problem: - Database Discussion Boards

First Prev Next

Re: Record 'Deletion'

mr_lasseter5-Oct-06 5:44

mr_lasseter

5-Oct-06 5:44

This is a very common approach. There should be no problems implementing this into a stored procedure (except you will have to remove the item from the datagrid in the code).

Mike Lasseter

Re: Record 'Deletion'

Dayekh5-Oct-06 23:12

Dayekh

5-Oct-06 23:12

Thanks for the reply. Appreciate it. I'll go figure it out.

Take care.

Re: Record 'Deletion'

Private_Void6-Oct-06 9:16

Private_Void

6-Oct-06 9:16

I would Imagine that you are populating your Datagrid in a method. If you do not have a separate method for this I would highly recommend it. When the user activates the UI control to delete the record from the datagrid I would also call the method that populates your datagrid. If you call this method after you delete the DB record your Datagrid will automatically re-populate with out the record.

Hope this helps.

Pass wild card value to Where Like Statement.

japel5-Oct-06 0:36

japel

5-Oct-06 0:36

I have the below query but would like to use a wild card value to do the search.

I need to pass a value like "on" and find, Jason or Preston. It would be nick if it is also not case sensitive....

This value is coming from VB.Net App and this is messing with me...

My Access (SQL) statement is:

SELECT *
FROM MainTB
WHERE myCustomer Like [@myVar];

But the LIKE needs to be [%myVar%] I think.

Feedback welcome please......

When people make you see red, be thankful your not colour blind.

Re: Pass wild card value to Where Like Statement.

albCode5-Oct-06 0:41

albCode

5-Oct-06 0:41

SELECT *<br />
FROM MainTB<br />
WHERE myCustomer Like ('%myVar%');

Re: Pass wild card value to Where Like Statement.

japel5-Oct-06 1:06

japel

5-Oct-06 1:06

Running this query from access it does not ask me for an input it is looking for a user of %myVar%

As it is in the ' ' string quotes... I have already found this and tryed it...

Any other thoughts.....
?

When people make you see red, be thankful your not colour blind.

Re: Pass wild card value to Where Like Statement.

Chris Meech5-Oct-06 2:06

Chris Meech

5-Oct-06 2:06

The string concatenation character might help

select *
  from MainTB
 where upper(myCustomer) like '%'|upper(@myVar)|'%'

This will also make it case insensitive.

Chris Meech

I am Canadian. [heard in a local bar]

Nobody likes jerks. [espeir]

The zen of the soapbox is hard to attain...[Jörgen Sigvardsson]

I wish I could remember what it was like to only have a short term memory.[David Kentley]

SQL server connectivity Problem:

Shahzad.Aslam4-Oct-06 23:30

Shahzad.Aslam

4-Oct-06 23:30

The following error is occuring while attempting to connect to sql server the connection string is as follows:

"conn = new SqlConnection("Password=786;data source=DBSERVER;initial catalog=Venture;persist security info=False;user id=sa;workstation id=Venture;packet size=4096");"

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)

Re: SQL server connectivity Problem:

Jerry Hammond5-Oct-06 2:35

Jerry Hammond

5-Oct-06 2:35

I've seen this error occur when SQL Server is not running. Not sure that is your problem, but it is something to eliminate.

"We've all heard that a million monkeys banging on a million typewriters will eventually reproduce the entire works of Shakespeare. Now, thanks to the internet, we know this is not true." -- Professor Robert Silensky

Re: SQL server connectivity Problem:

Mike Osbahr6-Oct-06 10:51

Mike Osbahr

6-Oct-06 10:51

It could be exactly what it says. There is a configuration tool for SQL 2005 that will let you check this. Check the server protocols. There will be a short list something like this:

Shared Memory Enabled
Named Pipes Disabled
TCPIP Enabled
VIA Disabled

If you right-click on TCPIP and select properties you might be as surprised as me to find this:

IP1
Active Yes
Enabled No
Address 192.168.1.1
...

IP2
Active Yes
Enabled No
Address 127.0.0.1
...

Apparently SQL server comes with most things turned off. Try setting the Enabled(s) to yes and see if your problem changes. I was not using the TCPIP, so could not test it. Please post back if this made a difference.

>>>-----> MikeO

Re: SQL server connectivity Problem:

Shahzad.Aslam8-Oct-06 18:28

Shahzad.Aslam

8-Oct-06 18:28

Thanx!!
It is now working fine.
I just enabled the named pipe, after that it is working.

Table change event

RoyRose784-Oct-06 23:27

RoyRose78

4-Oct-06 23:27

Hey all,

Is there a way to know when table changed and who changed it?

is there a default table that logs those kinds of changes in MSSQL 2000?

Thanks
RoyRose.

Re: Table change event

Chris Buckett5-Oct-06 8:55

Chris Buckett

5-Oct-06 8:55

Nope, unless you've enabled it. Article here talks about it.[^]

If it's just one table, then you can implement it yourself using triggers etc...
Googling for "sql server audit trigger" provides a load of methods.

ChrisB

Reg. Query

aaraaayen4-Oct-06 21:17

aaraaayen

4-Oct-06 21:17

Hi friends,

Please give me solution for the following queries.

1) How to find 6th highest salary from Employee table
2) How to select duplicate rows in a table

Thanks in advance.

Thanks and Best Regards,
R. Sangeetha Priya

Prya

Re: Reg. Query

Eric Dahlvang5-Oct-06 6:02

Eric Dahlvang

5-Oct-06 6:02

1)In SQL Server:

select top 1 * from (select top 6 * from employee order by salary desc) as s order by salary asc

2)There are a few ways, but I like this one:

select * from (select count(*) as Duplicates, * from Employee group by name,salary) as tbl where Duplicates > 1

(but you have to have every field in the group by clause)

--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters

list boxes and databases

ranro20064-Oct-06 19:22

ranro2006

4-Oct-06 19:22

I had a Question I was hoping you might be able to help me with.

I am using VB.NET 2005 express and I have a list box that is bound to a table in a dataset. I want to be able to select one of the items in the list box and then use an item that corresponds to this item in the list box and I do not know how to do this.

For example, if I had a table named Person and this table had two fields one named PersonID (which is the key field), PersonName, and PersonAge. Say I had PersonName bound to the list box. So say I click on one of the PersonNames in the list box and then wanted to use the PersonAge, which corresponded to the name I had clicked, in a calculation. How would I access the PersonAge value?

I appreciate any help you could give me.

Thanks,

Re: list boxes and databases

albCode4-Oct-06 21:15

albCode

4-Oct-06 21:15

Check this example

http://www.thescripts.com/forum/threadnav348524-2-10.html

need code sample

jqt4-Oct-06 19:17

jqt

4-Oct-06 19:17

hey all!

i was wondering can any 1 give me a code sample in c++(if possible dono if is or not) for connecting to a data base. i have used hem before in php but have no idea how to do it in c++

thanx, jt

Re: need code sample

japel5-Oct-06 0:44

japel

5-Oct-06 0:44

This is a very open question...

What type of database???

If you just need the connection string check our http://www.connectionstrings.com

Also do you want to perform inline SQL / Procedures or use the VS ADO database objects...

Not much help but not much to go on...
Smile | :)

When people make you see red, be thankful your not colour blind.

select with TOP and COUNT

CandyMe4-Oct-06 17:26

CandyMe

4-Oct-06 17:26

Hi, please help
I wanna select top 5 from table satisfying a condition
and at the same time count the number of rows returned based on selection.

Select top 5 LastName, (Select count (*) from TBL where lastname = 'Cruz') as Count from TBL where lastname = 'Cruz'

assuming there are only 3 rows with Cruz as latname
result should be:

Lastname | Count
Cruz 3
Cruz 3
Cruz 3

I mean my query doesn't work and have researched over the internet.

Please help. thank you. Cry | :((

Gerri

Re: select with TOP and COUNT

albCode4-Oct-06 21:06

albCode

4-Oct-06 21:06

Select top 5 LastName,  count (*) as [Count] from TBL where lastname = 'Cruz'<br />
group by lastname order by [Count]  Desc

Re: select with TOP and COUNT

CandyMe4-Oct-06 22:05

CandyMe

4-Oct-06 22:05

it doesn't work, seriously. I already copy pasted and been doing some workarounds on this. using sql 2005. or what's wrong really? Cry | :((

thank u

Gerri

Re: select with TOP and COUNT

albCode4-Oct-06 22:08

albCode

4-Oct-06 22:08

Select top 5 LastName, count (*) as [Count] from TBL where lastname = 'Cruz'<br />
group by [Count]

Re: select with TOP and COUNT

Eric Dahlvang5-Oct-06 5:22

Eric Dahlvang

5-Oct-06 5:22

CandyMe wrote:
Select top 5 LastName, (Select count (*) from TBL where lastname = 'Cruz') as Count from TBL where lastname = 'Cruz'

If this isn't working, there is some other problem.

CandyMe wrote:
I mean my query doesn't work and have researched over the internet.

Can you be a bit more specific as to what error message you are getting. Maybe give us some samples of the data. According to what you have showed us here, there is absolutely NO reason your query should'nt return what you expect.

--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters

Re: select with TOP and COUNT

CandyMe5-Oct-06 18:00

CandyMe

5-Oct-06 18:00

I mean my query doesn't produce the result I'm expecting.

For instance, I selected Top 5 with a given condition. But 3000 passed this condition. Rowcount should only be 5.

Upon querying such

Select top 5 LastName, <br />
(Select count (*) from TBL where lastname = 'Cruz') as Count <br />
from TBL where lastname = 'Cruz'

Gerri

Last Visit: 31-Dec-99 18:00 Last Update: 4-Jun-24 21:32

Refresh

ᐊ Prev 1...1780 1781 1782 178317841785 1786 1787 1788 1789 Next ᐅ

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