Web Services - Database Discussion Boards

Robert Rohde12-Jun-05 3:22

12-Jun-05 3:22

As far as I know there is no method to change the output of the GetXml function. So you will have to convert it afterwards. If you are willing to read some docs have a look at the XslTransformclass. I provides a .Net wrapper around XSLT which can be used to transform the structure of XML files.

sql

rohollahabadan8-Jun-05 21:21

rohollahabadan

8-Jun-05 21:21

I want to publish my site and want to register new server from the enteprize maager.i entered the name of the server and followed the wizard but the"sql server doenot exist or access is denied"has bee shown.(i used the windows autentication).also when i used server au.. and enter the login and the user name, the message has bee shown again.
what is the problem?
mabey it is from the way that i setup the sqlserver or the version of sqlserver,because the sqlserver work correectly when i use the local server.
Thank you!

Re: sql

Colin Angus Mackay9-Jun-05 1:10

Colin Angus Mackay

9-Jun-05 1:10

So... you are trying to register a SQL Server that is on a remote machine in your local Enterprise Manager.

Can you ping the remote machine? If yes, then do you have a firewall in place that could prevent the remote SQL Server's communications?

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

Re: sql

Vasudevan Deepak Kumar11-Jun-05 2:51

Vasudevan Deepak Kumar

11-Jun-05 2:51

Hi:

Please check on the following:

1) Since it is a remote machine, ping it and see whether ICMP Packets are being acknowledged. These will ascertain you that the system is up.
2) You need to ensure that you are connecting to a proper instance of SQLServer. Not always Instance Name and System Names can be identical. You could have chosen a different instance for the SQLServer in case there are multiple on the same system.
3) You need to ensure that the SQLServer Service you are connecting is running on the remote system and on the correct port.
4) In line with (3), also ensure that port 443 communication between your system and the remote system are not blocked by either your firewall or the remote system firewall.

Did this help you?

Deepak Kumar Vasudevan
Personal Web: http://vdeepakkumar.netfirms.com/
I Blog At: http://deepak.blogdrive.com/

Working with stored procedure´s transactions in .NET

riv_luis8-Jun-05 10:00

riv_luis

8-Jun-05 10:00

Hi All,

I'm trying to work with stored procedure in VB.NET but there were some problems with that, I hope someone can help me.
First, is there a way to manage a stored procedure's transaction from VB.NET?, I tried something like this (see code below) but when I do commit an error appears because the transaction is already closed.

................
Dim objConexion As New OleDbConnection(strConexion)
Dim trans As OleDbTransaction
Dim objComando As OleDbCommand = New OleDbCommand("fun_codigos", objConexion)
objComando.CommandType = CommandType.StoredProcedure

.......defining parameters...............

objConexion.Open()
trans = objConexion.BeginTransaction
objComando.Transaction = trans
Dim objDataReader As OleDbDataReader = objComando.ExecuteReader
objDataReader.Close()
objConexion.Close()

Dim salida As Int64
salida = objComando.Parameters("@p_cod_servicio").Value
Label1.Text = salida
trans.Commit() -------> here an error appears!

I have to manage the transaction from VB.Net not from inside the stored procedure.

Second, I want to pass some parameters from VB.NET to an stored procedure but there is an error like this: "ORA-06550: line 1, column 18: PLS-00382: expression is of wrong type ORA-06550: line 1, column 7: PL/SQL: Statement ignored "
I checked parameter's type in VB.NET and there were the same as in stored procedure.

I'm working with Oracle 8i.

I hope you can help me.

Thanks in advance

Re: Working with stored procedure´s transactions in .NET

Colin Angus Mackay8-Jun-05 10:31

Colin Angus Mackay

8-Jun-05 10:31

DISCLAIMER: I don't know much about oracle so this is just a guess out of the air.

Does your stored procedure have a begin/commit transaction block in it already? I'm guessing that if your stored procedure commits the transaction already then putting a BeginTransaction() and Commit() in your code may not be necessary.

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

Re: Working with stored procedure´s transactions in .NET

riv_luis9-Jun-05 2:17

riv_luis

9-Jun-05 2:17

the stored procedure makes an autocommit transaction when finish, but I don´t want it to do that. It´s like the stored procedure is inside a .NET loop and I want to commit when the loop (in .NET) finish so I don´t want the stored procedure autocommiting every time I call it.

Web Services

RSootarsing8-Jun-05 2:59

RSootarsing

8-Jun-05 2:59

Hi I have written a basic Webservice that returns values from a Dataset here is a code snippit
[WebMethod]
public DataSet CTX (string filter)
{
try
{
iDB2Connection connDB2=new iDB2Connection{
"DataSource=TDC01;" +
"userid=user;password=pass;DefaultCollection=collection;");
DataSet ds = new DataSet();
iDB2DataAdapter adpt = new iDB2DataAdapter();
string szSQLstmt = "Select * from table where REF='" +@filter+"'";
adpt.SelectCommand = new iDB2Command(szSQLstmt,connDB2);
adpt.Fill(ds);
return ds;
}
This works fine when i test it in ie returns the data in xml however what i want to be able to do is use this in Biztalk however biztalk can only see the root node <dataset> and nothing else can anyone offer me any advice of how to solve this problem.
Thanks in advance
Rohan

Re: Web Services

Colin Angus Mackay8-Jun-05 6:45

Colin Angus Mackay

8-Jun-05 6:45

I think you would be better finding a forum that specialises in BizTalk.

Also, I notice a security flaw in your code. You might want to read SQL Injection Attacks and Tips on How to Prevent Them[^] - The examples use SQL Server 2000, but the principles apply to all databases.

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

sp with temptables doesnt work in crystal reports

7-Jun-05 23:41

Hi,
I have written a stored procedure in SQL Server which uses temp tables and returns the rows of a temptable.

When i try to use this sp as datasource for Crystal report(Add Database), the fields are not listed.

Why is that? If this wouldnt work how do i implement this.

Am using a custom version of crystal report bundled in VS .NET.

Any help would be appreciated.

Thanks in advance
Geetha

Re: sp with temptables doesnt work in crystal reports

WoutL8-Jun-05 20:58

WoutL

8-Jun-05 20:58

This article could help: PRB: Error Messaging Referencing #Temp Table with ADO-SQLOLEDB[^]

Wout Louwers

Re: sp with temptables doesnt work in crystal reports

Geethalakshmi8-Jun-05 21:15

Geethalakshmi

8-Jun-05 21:15

Thanks for the help.

I use VB.Net, ADO.Net to execute the stored procedure. Even if i use "set noCount On", am not able to create the .xsd file.

Pls tell me how to implement it in .Net? I want the .xsd file to be created.

Thanks in advance.

security in SQL server

daneshmand7-Jun-05 23:11

daneshmand

7-Jun-05 23:11

hi
how can i increase the security of a designed program via SQL server.what is the role of stored procedures ?

Re: security in SQL server

Colin Angus Mackay8-Jun-05 0:13

Colin Angus Mackay

8-Jun-05 0:13

daneshmand wrote:
how can i increase the security of a designed program via SQL server

Just a few things off the top of my head:
Uses specific logins.
Do not grant access to the public role.
Grant access only to the objects that the users/roles actually require.

daneshmand wrote:
what is the role of stored procedures ?

Stored procedures can be used to protect the tables from direct access. You can revoke access to the tables and grant access only to stored procedures. That way the only way to access a table is through the stored procedure. This layer of abstraction can protect you as you can set up additional checks in the stored procedure before allowing the operation to complete.

You may also want to read: SQL Injection Attacks and some tips on how to prevent them[^]

Does this help?

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

web service based

ahmad mostafa7-Jun-05 22:43

ahmad mostafa

7-Jun-05 22:43

i'm using SQL in building my Database but I want to know what is the best code to design my web withen SQL

A.M

Re: web service based

Colin Angus Mackay8-Jun-05 0:22

Colin Angus Mackay

8-Jun-05 0:22

You don't design web code in SQL. Perhaps your question needs to be rephrased.

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

Re: web service based

ahmad mostafa8-Jun-05 0:30

ahmad mostafa

8-Jun-05 0:30

i know that but what i meant is what is the best code which will be combatable with the SQL

Re: web service based

Colin Angus Mackay8-Jun-05 1:08

Colin Angus Mackay

8-Jun-05 1:08

ahmad mostafa wrote:
i know that

Okay - but your original post indicated that you wanted to write a web application in SQL.

ahmad mostafa wrote:
what is the best code which will be combatable with the SQL

I'm assuming .NET code since you still haven't said the technology that will be linking to the SQL Server.

SqlConnection someConnection = new SqlConnection("connectionString");
SqlCommand someCommand = new SqlCommand("SQL Command Text", someConnection);
SqlDataReader reader = someCommand.ExecuteReader(); 
// Or someCommand.ExecuteNonQuery() if you don't have a result set
while(reader.Read())
{
    // Do stuff with each row here.
}

Does this help? If not, then you need to elaborate on your question.

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

amount of record can entered in each record

daneshmand7-Jun-05 22:35

daneshmand

7-Jun-05 22:35

Hi
I am programming a system that must input and process verey large amount item, for exmple for each year we entered 4000 record in each table.I decide use SQL server for this system.
now,I have tow question :

1- How many record can entered in each table that designed by SQL Server. If the amount of record caused decrease speed.

2- In a feild with image type an image with how size can be stored?

Re: amount of record can entered in each record

Colin Angus Mackay8-Jun-05 0:20

Colin Angus Mackay

8-Jun-05 0:20

daneshmand wrote:
How many record can entered in each table that designed by SQL Server

I don't know an upper limit but a system I'm working on is approaching a million new rows per day in just one of the tables - its been running for just under 2 years now.

daneshmand wrote:
If the amount of record caused decrease speed

Yes. But that is why you have indexes. 4000 rows per table per year is not going to cause too much of a problem anyway.

daneshmand wrote:
In a feild with image type an image with how size can be stored?

Do you mean "what size can be stored?".

If you read the SQL Server documentation[^] you will see that the maximum size is 2Gb.

Does this help?

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

Error when install sql server sp4

Mekong River7-Jun-05 12:52

Mekong River

7-Jun-05 12:52

Hi, I have download and install SQL server 2000 service pack 4 from here[^]. The problem is, when i extract and install the desktop edition from the file SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE there is an error display "The instance name is invalide". Then the installation wizard is disappear and the installation process is stop. I don't know why there is the problem. Can anyone give me some suggestion or idea relate to this issue????

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

Re: Error when install sql server sp4

Vasudevan Deepak Kumar11-Jun-05 2:59

Vasudevan Deepak Kumar

11-Jun-05 2:59

Hi:

I think you may need to use the commandline option. By default the setup tries to create and install.

I remember seeing some commandline switch for /update and also an option for SAPWD to work with strong passwords etc.

Deepak Kumar Vasudevan
Personal Web: http://vdeepakkumar.netfirms.com/
I Blog At: http://deepak.blogdrive.com/

Re: Error when install sql server sp4

Mekong River11-Jun-05 5:46

Mekong River

11-Jun-05 5:46

Vasudevan Deepak Kumar wrote:
I think you may need to use the commandline option.

Thank you very much for your comment. I also use the command line during the time that I install sql server 2k sp3a too. The command is: c:\sql2ksp3a\msde\setup.exe SAPWD=Admin DISABLENETWORKPROTOCOL=... I forget the command line but i already save it in a safe place. But I also use this method when I try to install sql server 2k sp4. But an error still occure, I will try to find the solution from the other source in order to install it.

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

SQL Server 2005: CREATE ASSEMBLY : Error 6218

Duncan Edwards Jones7-Jun-05 10:43

Duncan Edwards Jones

7-Jun-05 10:43

I'm trying to add a fairly simple assembly to SQL server 2005; but keep getting a message:
6218 : Assembly 'EnableIrelandSystem' failed verification, run peverify on the assembly.

So - the only thing remotely controversial in th eassembly is a reference to System.Runtime.Interopservices (for <StructLayout()> ).

Any ideas?

'--8<------------------------
Ex Datis:
Duncan Jones
Merrion Computing Ltd

Relation Between Databases

Majid Shahabfar7-Jun-05 3:00

Majid Shahabfar

7-Jun-05 3:00

Hi there,
How can I make a relation between two or more databases in one server?
Thank you in advance.

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