|
hi friends
I tried to run the script db.sql using SQLCMD.I tried to execute it with the following command....SQLCMD -E -i C:\a\db.sql.
It is not working in my system.It is showing the error "Could not open connection to SQLSERVER [2]"..."login timeout expired"....But this command is working fine in other system.Would you help me to trouble shoot this problem
With regards
Denver
|
|
|
|
|
Looks like you haven't properly specified the SQL Server you are trying to connect to. Check the help for SQLCMD - SQCMD -Help will probably do it.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Oh thanxx Bob...let me check it
|
|
|
|
|
|
This is a problem solving forum, we try to help you solve your coding problems. This looks like a straight request for code  . There are many samples and examples that do this already available.
Do you seriously think someone is just giong to write these classes for you? The only thing you are going to di is set yourself up to be flamed, deservedly so.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
As you say "There are many samples and examples that do this already available" Why don't you provide the link?
I am not expecting the code for all the methods. I am looking for any example for any of the method mentioned in my post.
If you have solution pass it otherwise don't pass rubbish comments.
|
|
|
|
|
I've tried discussing this with you, it's plain you're not interested in discussing your problem, but just asking for someone to give you the code.
Christian Graus
Please read this if you don't understand the answer I've given you
"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 )
|
|
|
|
|
Christian Graus,
Let me clarify you, we have Fair Idea on Ado.net but in our project client have old Ado based COM Components using MTS and MSMQ. He wants us to convert that functionality of recordset and properties and events using the ADO.net and Microsoft Enterprise library.
we got some suggestion by writing the wrapper classes we can get the functionality.
We managed to write and map Ado.net table object to Recordset in wrapper class and we can able to manage the functionality of MSMQ and MTS using the interop services, but we are clue less to write the other properties and methods without using the ADODB Object.
We are looking for any clue or suggestion from anybody worked on wrapper classes on writing the properties / methods of ADO-recordset using Ado.net.
|
|
|
|
|
1) getBookmark()
2) setBookmark(currentBM)
I doubt you can do these, because you have no connection in ADO.NET, it's called and closed when you get a recordset.
3) Delete ()
Again, there is no concept of a current record, it does not exist. However, if you have a primary key, you can run a delete command based on the record you're looking at.
4) close ()
Your dataset does not connect to an open connection, it's not ADO, it's ADO.NET
5) getStatus()
6) getDataSource()
7) DataMember()
8) Update(Fields,Values)
9) ActiveConnection()
I am trying to google to help you, but all I am finding is your posts over the web asking this...
At the core, there is no active connection, no current record to delete or update, no data source in memory. ADO.NET makes a call and returns a view of the data. Your best bet is to work out how to do the same things, such as to make an update or delete call. There will be no one to one mapping of methods,.
Christian Graus
Please read this if you don't understand the answer I've given you
"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 )
|
|
|
|
|
Christian Graus,
Thank You for your mail and suggestions.
Regards,
Karpurapu
|
|
|
|
|
Wow, you invested more time and effort in this bloke than I was willing to. Well done, I'll refer this one to Hans 
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
We're not going to do a Google search/buy a book so you don't have to do the work. Please read the forum guidelines.
|
|
|
|
|
Hi All,
I have asked a similar question before on another forum, and although the answer that I received pointed me in the right direction, it did not help solve my problem. What I would like to do is to schedule the deletion of a row of data after X number of days have passed. For instance I want to delete the information of users from my database a week after their first
login. I was told that I can use SQL 2005 scheduler. I checked out the link that I was given by the person who responded to my post, and was unsatisfied by what I've read. I did not see helpful examples that show how to set up a schedule to delete info after sometime has passed. Please explain how to use SQL 2005 scheduler or point me to a site that is helpful. Thanks for your response.
modified on Monday, May 5, 2008 9:31 AM
|
|
|
|
|
1. Create a stored proc (delete from User where created < dateadd(d,-7,getdate()) will do
2. Create an SSIS/DTS package that executes the stored proc (optional but a good learning curve)
3. Create a Job that runs periodically and executes the package (I think you can use the Job schedulter to execute the procedure without the SSIS)
If none of this makes sense have a rat around the Enterprise Manager for SQL Server Agent
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
" 3. Create a Job that runs periodically and executes the package "
Why would I have to create a job to run execute the stored proc if the scheduler can do that? Can I just create a stored proc without a job to execute it? Thank you so much for your reply
|
|
|
|
|
Scheduler = Job, in SQL Server the scheduler is the job manager, it's how you schedule work to be done.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Since we are the procedures companies use the original powerbuilder 7.0 development.
powerbuilder 7.0 DataWindow for the use of multi-table connection, generated SQL statement,
"*=" Equals "left join", "=*" equals "right join".
But when I put the database to upgrade to SQL 2005, and compatible with the database-level adjustment to 9.0, the application error, suggesting that SQL 2005 does not support "*=" only support "left join"
I can only adjust to the compatibility of 8.0 (which did not upgrade and What is the difference between)
I should be how to solve it ?
|
|
|
|
|
"Powerbuilder 7.0"-generated statements,
SELECT ctn_in_out.ctn_no,
ctn_in_out.vessel_code,
ctn_in_out.voyage,
FROM ctn_in_out,
goen_action
WHERE ( ctn_in_out.vessel_code =* goen_action.vessel_code)
SQL standard statements
select * from ctn_in_out right join goen_action on
ctn_in_out.vessel_code = goen_action.vessel_code
|
|
|
|
|
I need to pass to a trigger two dynamic text parameters stored into a
table (I can obtain them via a simple select). How can I obtain such a
thing?
|
|
|
|
|
Member 4008492 wrote: I need to pass to a trigger two dynamic text parameters stored into a
table (I can obtain them via a simple select). How can I obtain such a
thing?
Do the select inside your trigger. You're not limited to just selecting from the insert/delete tables.
|
|
|
|
|
hi 
i am working in vb program and ther is error in my sql
<br />
SELECT * From ClassRoom <br />
Where Capacity >= " & SumCapacity & " <br />
and RoomID not in(SELECT RoomID from [Slot] where SlotID= " & Slots4Sec.Tables("Slot").Rows(0).Item(0) & " or SlotID= " & Slots4Sec.Tables("Slot").Rows(1).Item(0) & " or SlotID =" & Slots4Sec.Tables("Slot").Rows(2).Item(0) & " or SlotID =" & Slots4Sec.Tables("Slot").Rows(3).Item(0) & ")" <br />
& "ORDER BY Capacity asc"<br />
<br />
<br />
can any body find the error please i am Sure about table names and type and iam using access db 
|
|
|
|
|
What error message do you get?
I Love T-SQL
Don't torture yourself,let the life to do it for you.
|
|
|
|
|
hi Blue_Boy
when i fill may data set it gives error (Data type mismatch in criteria expression)
|
|
|
|
|
Parameter values which you add include inside single quotes.
" SELECT * From ClassRoom <br />
Where Capacity >= '" & SumCapacity & "' <br />
and RoomID not in(SELECT RoomID from [Slot] where SlotID= '" & Slots4Sec.Tables("Slot").Rows(0).Item(0) & "' or SlotID= '" & Slots4Sec.Tables("Slot").Rows(1).Item(0) & "' or SlotID ='" & Slots4Sec.Tables("Slot").Rows(2).Item(0) & "' or SlotID ='" & Slots4Sec.Tables("Slot").Rows(3).Item(0) & "') " <br />
& " ORDER BY Capacity asc"
I Love T-SQL
Don't torture yourself,let the life to do it for you.
|
|
|
|
|
thanks
i found the error it was that the type of roomid is different in the to table
thanks so much
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
