|
Have this at the top of your page
<%@ import Namespace="System.Data.SqlClient" %>
<%@ import Namespace="System.Data" %>
Then either in your script block or your code-behind, use something along the lines of:
Dim objConn As New SqlClient.SqlConnection
objConn.ConnectionString = "data source=SERVERNAME;initial catalog=DATABASENAME;uid=USERNAME;pwd=PASSWORD"
objConn.Open()
cheers
Phil
|
|
|
|
|
The only solution i had was reinstallinn MSSQL server on de dev. machine and from that moment on it works like a good machine.
After building the application i tryed to transfer it to the production server running the same software and with the same rights and users and it wont work.
I now wil try to reinstall MSSQL on the production server tomorrow and i hope the problems wil be solved once againg.
But the question is still there, why is this happening.
|
|
|
|
|
How can we save a paragraph (having Unicode characters, multi-lines)from Windows Forms or Web Forms into SQL Server and then retake it to Forms without changed. Please help! I really need it.
Thanks!
|
|
|
|
|
|
Thanks, i'll try it. I think i'm having a slight problem with my unicode typing program too.
Thanks a lot 
|
|
|
|
|
when writing to the database use:
insert into table(field)
values(N'bleh')
The N indicates unicode...
|
|
|
|
|
Hi,
I have a C++ application (MSVC6) that uses ADO - in fact just ported it from DAO to ADO. It works fine in Win2K and WinXP computers but is failing in a Win98 computer - the code is the same.
The problem is seen in a _RecordsetPtr Open command which fails with an Invalid Pointer error - the only pointer passed in the call is the _ConectionPtr which is opened in a call before. (Actually I am using the wrapper classes by Carlos Antollini, and have also posted this there). This happens in a computer with Win98 (which is located far away and I do not have access other than asking the user to do/try something). Any clues as to why only Win98? and not the other OS's. The failure happens the first time I do the Open call - which leads me to suspect something about the environment. I was able to open the database itself by an Open call to the _ConnectionPtr & in fact retrieved the property of the JetEngine version of the database (I need to make sure that they have equivalent of Access2000). So it is the _RecordsetPtr Open that seems to be the problem.
Any clues?
|
|
|
|
|
Hello all,
I created an index unique constraint in table in the database but i cant update the colume with this unique key constrint how can i do that.
Thanks
Hay
|
|
|
|
|
Make sure that you chose the correct column.
Ensure that the index is there
sp_help tablename
|
|
|
|
|
How can I see messages sent from SQL using ADO? In any quire analyzer I can see messages sent back from the db ie:
“Select * from authors” returns the following message “(23 row(s) affected)”
I need a way to programmatically trap and display the messages to the user. I know that Print statements are stored as error 0 and I can get those.
Ronald Hahn, CNT - Computer Engineering Technologist
New Technologies Analyst
HahnTech Affiliated With Code Constructors
Edmonton, Alberta, Canada
Email: rhahn82@telus.net
|
|
|
|
|
ADO or ADO.Net? Either way, the message "(23 row(s) affected)" is not sent back to the client; query analyzer makes that message. If you are using a datareader, then you can get the number of rows affected through the RecordsAffected property; in this case it would return 23, and you could show that to the client any way you want. If you are calling a stored procedure containing the SET NOCOUNT ON option, it will not return the row affected (I think it will always report 0, but I'm not sure).
|
|
|
|
|
So does the analyzer that is running the query generate all messages. How can I as a programmer know if a query actually went through?
set @Execstr = '[PUBS].[dbo].['+@table_name+']'
dbcc dbreindex ( @Execstr )
This code returns in query analyzer:
“DBCC execution completed. If DBCC printed error messages, contact your system administrator.”
How can I catch that?
|
|
|
|
|
If you want to see messages generated by 'PRINT', you have to trap the InfoMessage event of the connection object.
If you want to see the rows affected by a query, and the query is run using ExecuteNonQuery, then the return value is the number of rows affected.
You can also return any info you want from your stored procedures as output parameters, which you can read after running the query.
When running a stored procedure from query analyzer, messages con come from several sources:
1. Query analyzer can generate a friendlier message from info it receives (such as the 17 rows affected messages). You catch this in code using the return value of 'ExecuteNonQuery'.
2. The stored procedure can use the 'PRINT' statement, which causes query analyzer to display some info. You catch this in code in the IfoMessage event of the connection.
3. The stored procedure uses RAISEERROR. In code, if the severity level in RAISEERROR is less than 11, the the message can be caught in the InfoMessage event of the connection. If the severity level is greater than 10, I think it shows up as an exception, which you can catch in a try block.
So, you can collect any messages from dbcc by attching code to the InfoMessage event of the connection, and looking at the messages you collected after running the query.
|
|
|
|
|
So is there a way to do this in ADO and VB (not net) ExecuteNonQuery is not part of ADO and Event handling is not supported in VBScript. someday my boss will realize that asp isn't worth supporting.
|
|
|
|
|
In old ADO, the Command.Execute method accepts a RecordsAffected parameter which you can use to get the value.
I think the only place you can get the informational messages is through the InfoMessage event (which was available in old ADO as well), so you may be out of luck.
|
|
|
|
|
Even just using Print statements I can only get them as long as there is nothing else happening ie:
Print ‘haH’
Print ‘hehe’
Select * from authors
Print ‘hoho’
All I can ever catch is haha and hehe
How can I get the selects from the following:
declare @counter int
declare @countvalue int
select @counter = 0
select @countvalue = 100
Counter:
-- Controlled Loop Statement
if @counter < @countvalue
-- WHILE START
BEGIN
declare @msg1 varchar (225)
select @msg1 = '---------- MSG1 Current Counter Value = [ '
+convert ( char(10), @counter )
+']'
print @msg1
select @counter = @counter + 1
goto Counter
END
-- WHILE END
else
BEGIN
goto Terminate
END
Terminate:
ADO doesn’t seem to Return anything
|
|
|
|
|
How can I stop a quire before it has completed? In any query analyzer if a given query is taking to long to complete I can stop it and get the records that have returned. I need to do this with the ADO. My software seems to “go away” sometimes when large numbers of records are returned and this causes some users to think the computer has halted. Obviously thins will not do. Any suggestions would be much appreciated.
Ronald Hahn, CNT - Computer Engineering Technologist
New Technologies Analyst
HahnTech Affiliated With Code Constructors
Edmonton, Alberta, Canada
Email: rhahn82@telus.net
|
|
|
|
|
|
That won't work because I need the ability to capture all the data as well as having the ability to stop when a user clicks stop. I need an inturupt
Ronald Hahn, CNT - Computer Engineering Technologist
New Technologies Analyst
HahnTech Affiliated With Code Constructors
Edmonton, Alberta, Canada
Email: rhahn82@telus.net
|
|
|
|
|
sp_who2
fine the spid of the query your running
kill spid if its doing a write/update it will need to rollback if incomplete
if you do kill spid again it will show you how long it has left to rollback
|
|
|
|
|
Hey! I am making a website in Dreamweaver and I want to make a database for user registration and login. I set up the mySQL server and I am pretty sure I made the database right, using the mySQL Administrator program, but I keep getting the "HTTP Error Code 405 Method Not Allowed" error when I try to set up a connection from dreamweaver. I am trying to run mySQL locally and develop a website on the same machine (this one). I dont know what to do next because all of the websites out there refer me to set up an FTP connection in Dreamweaver that leads off to a domain....
Please help!!!
Thanks!
Anthony
|
|
|
|
|
Hi, I'm not sure if I'm doing my UPDATE's and DELETE's the proper way:
Basically, I want to make sure what I updates, or deletes, in fact exists (ie not deleted by another user) before I actually perform the operation:
Code:
o_session = SetupBISConnection(...)<br />
trx = o_session.BeginTransaction()<br />
<br />
Try<br />
'IF the object with specified UIN does not exist (that it's deleted by another user), then NHibernate will throw ObjectNotFoundException.<br />
obj = o_session.Load(GetType(CObj), UIN)<br />
Catch ex As NHibernate.ObjectNotFoundException<br />
'object to be updated does not exist - abort delete<br />
Throw ex<br />
End Try<br />
<br />
'Okay, if no exception so far, it means the object is there...<br />
o_session.Delete(plan)<br />
o_session.Flush()<br />
<br />
trx.Commit()
Any pointer? Thanks in advance.
Norman Fung
|
|
|
|
|
Hey guys, just downloaded, "NHibernate Query Analyzer", I unpacked it, but now wondering what to do with it. Is there any tutorial for this tool? Or should I resort to SQL Server's SQL Profiler... Thanks.
Norman Fung
|
|
|
|
|
Hi all,
I have got a problem with retrieving data from the tables, because I found out that the keys to join these two tables are mismatching. The key in one table HAS SPACES in it, but the key in the other table does not. Even I have tried to use the REPLACE function to get rid of the spaces to make them matching, it still does not work. Please have a look at the code below, and give me some ideas how to solve it.
SELECT P.UniformItem, P.ProductCode, P.ProductSize, U.Description, U.Rank, U.RepPolicy
FROM tProductCode P INNER JOIN vUniformItemJoin U
ON Replace(P.UniformItem,' ','') = Replace(U.UniformItem,' ','')
Very much appreciate if you can help me out.
Cheers
|
|
|
|
|
GoldenStar wrote:
SELECT P.UniformItem, P.ProductCode, P.ProductSize, U.Description, U.Rank, U.RepPolicy
FROM tProductCode P INNER JOIN vUniformItemJoin U
ON Replace(P.UniformItem,' ','') = Replace(U.UniformItem,' ','')
Wow - you match using string values, and then call functions like this within your select statement ? You need to fix your database, I'd suggest that P and U should both have an index which represents a UniformItem, and then a table should match the index to a string representation. That's called database normalisation. If you're not going to do that ( and you should ), then you should at least massage data going in, so you don't need this sort of stuff making the most simple select statement messy.
Christian Graus - Microsoft MVP - C++
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
