Database

Exposing Existing Code as a Web Service Using C#

6-Apr-02 17:42

ergin wrote:
I can't run the program unless I have entered the server with my password in advance. I must do that in the code.

I think you can also solve it with your IIS too.Go there and change the security of your project.

Mazy

"The path you tread is narrow and the drop is shear and very high,
The ravens all are watching from a vantage point near by,
Apprehension creeping like a choo-train uo your spine,
Will the tightrope reach the end;will the final cuplet rhyme?"Cymbaline-Pink Floyd

wolga6-Apr-02 10:16

wolga

6-Apr-02 10:16

I can open in VB.NET ADODB.Stream using Open() without parameters but I can’t do that in C# using Open() with or without parameters. Is this relates to SP1 or SP2?

Imports System.Web.Services
Imports system.Xml
Imports System.Configuration
Imports ADODB
Imports MSXML2
Imports System.Reflection.Missing

' Read the foramtted XML into the Stream
Stream = New ADODB.Stream()
Stream.Open() 'it works
Stream.WriteText(orderXML)
Stream.Position = 0
‘------------------------C#---------------------
ADODB.Stream Stream = new ADODB.Stream();
Stream.Open(); // compilation error (case 1)
Stream.Open("",ADODB.ConnectModeEnum.adModeUnknown,ADODB.StreamOpenOptionsEnum.adOpenStreamUnspecified,"",""); // runtime exception (case2)

//I tried another way to invoke Open()
Object[] p=new Object[5] ;
p[0] = Missing.Value;
Stream.GetType().GetMethod("Open").Invoke(Stream,p); //the same exception as in case2.

Partial BLOB processing in ODBC

6-Apr-02 6:43

Cannot figure out how to process BLOBS in parts via ODBC - i.e. how to get part of a BLOB into program variable and/or update it in place.

Is it possible at all?
Could anyone provide any comments on which ODBC functions to use?
Some examples would be very nice too.

Thanks.

Re: Partial BLOB processing in ODBC

Nick Parker17-Apr-02 6:57

Nick Parker

17-Apr-02 6:57

This link on Microsoft should help:

BLOB Info

Nick Parker

Oracle question

ernst.maurer5-Apr-02 22:47

ernst.maurer

5-Apr-02 22:47

Hello

I need to get Alert_SID.log file from my client application for parsing.
Can I make this (getting this file) via SQL Query (via ADO Connection to Oracle server) or other Oracle 8 services, without any additionaly services (non Oracle) for transfer this log file from Oracle server host to client host.

Thanks
Ernst Maurer

DataSet to XMLDataDocument - change tag names

MS le Roux5-Apr-02 1:05

MS le Roux

5-Apr-02 1:05

When I convert my DataSet to an XMLDataDocument, the XML result looks something like this:

<NewDataSet>
 <Table>
  <ID>123</ID>
  <Name>Bob</Name>
 </Table>
</NewDataSet>

How do I specify what the tagnames should be of the root and row elements? I would like my result to be something like this:

<Employees>
 <Employee>
  <ID>123</ID>
  <Name>Bob</Name>
 </Employee>
</Employees>

Is the only way to do this by first reading an XML schema into the DataSet? If so, is there a way to write the schema in such a way that only the root and row elements are renamed, but the column elements are processed as is?

Re: DataSet to XMLDataDocument - change tag names

Bruce Duncan5-Apr-02 9:12

Bruce Duncan

5-Apr-02 9:12

I'm just hazarding a guess here, but couldn't you set the DataSetName and DataTableName properties of your data structure/object.

some semi-pseudocode

dsEmployees.DataSetName = "Employees"
dsEmployees.Tables[0].DataTableName = "Employee"

Or I could be spouting a load of bull Smile | :)

Bruce Duncan CP#9088, CPUA 0xA1EE, Sonork 100.10030
Hi everyone. My name's Bruce. And I suffer from VB.

Re: DataSet to XMLDataDocument - change tag names

MS le Roux7-Apr-02 20:06

MS le Roux

7-Apr-02 20:06

It works

(except that it's TableName instead of DataTableName). Thanks!

Difficult?

Ludwig Stuyck4-Apr-02 20:27

Ludwig Stuyck

4-Apr-02 20:27

I have to make a website on a win2000 server with ASP.NET. This website has to retrieve data from a db2 database on a linux server. Can someone tell me if this is possible and how I should do it?

ASP.NET is not a problem, but I have never worked with db2 and linux before.

Ludwig

OLEDB rowsets and disconnected processing

Bruce Duncan4-Apr-02 4:51

Bruce Duncan

4-Apr-02 4:51

I'm using the OLEDB consumer templates and VC6.

Is there a way I can get a rowset of data from the database, disconnect from the database, and then work with the data in a disconnected scenario.

Like disconnected ADO recordsets, but using plain vanilla OLEDB.

I've searched all over google(groups) and come up empty, plenty of similar questions to mine, but no useful answers (if any).

Bruce Duncan CP#9088, CPUA 0xA1EE, Sonork 100.10030
Hi everyone. My name's Bruce. And I suffer from VB.

Re: OLEDB rowsets and disconnected processing

Mazdak4-Apr-02 21:00

A really stupid problem with SQL

4-Apr-02 21:00

I don't know if it exists in OLEDB or not(I think it does).Use adUseClient for your cursor type. Smile | :)

Mazy

"The path you tread is narrow and the drop is shear and very high,
The ravens all are watching from a vantage point near by,
Apprehension creeping like a choo-train uo your spine,
Will the tightrope reach the end;will the final cuplet rhyme?"Cymbaline-Pink Floyd

add Db User by script.

Atila3-Apr-02 23:31

Atila

3-Apr-02 23:31

Is it possible adding a db user by script like creating a db by script etc...
Thanks

SQL Timeout Question

Nick Parker3-Apr-02 6:36

Nick Parker

3-Apr-02 6:36

I have written a DTS package that when run can takes a considerable amount of time to complete. I have found the problem areas within the package where a mass delete is taking place. Since I am unaware of future dataset sizes it will be deleting, is it possible to have my ActiveX script only increase the connection timeout period when it would typically timeout under the default time period. Or would it be considered ok to just increase the timeout period regardless of the dataset size? Thanks.

Nick Parker

Dan Pomerchik2-Apr-02 1:25

2-Apr-02 1:25

Well , I wrote a little app in VB that queries a table. I used DAO.I created a SQL generator that builds up a statement. But somehow only if I use * instead of % it works. For example , if i execute

select * from Phonebook where Firstname like 'M*'

I will get the appropriate records beginning with M. but if i write:

select * from Phonebook where Firstname like 'M%'

than all i get is an empty recordset! Why is that?! i remember that i used % before and it worked just fine. maybe someone knows what is the problem? thx!

James T. Johnson2-Apr-02 1:46

James T. Johnson

2-Apr-02 1:46

% is standard SQL, however Access (and thus DAO) uses *.

I got bit by the opposite problem when I made the transition from DAO to ADO/SQL Server

James

Sonork: Hasaki
"I left there in the morning
with their God tucked underneath my arm
their half-assed smiles and the book of rules.
So I asked this God a question
and by way of firm reply,
He said - I'm not the kind you have to wind up on Sundays."
"Wind Up" from Aqualung, Jethro Tull 1971

Dan Pomerchik2-Apr-02 1:46

2-Apr-02 1:46

Ahh thanks. And what about ADO ? Does it work with % or must use * too ?

James T. Johnson2-Apr-02 2:03

James T. Johnson

2-Apr-02 2:03

That I'm not sure about, I think it uses * for Access and % for others, but I'm not sure as I haven't done any ADO on Access. Oddly that was one combination I was able to avoid.

James

Sonork: Hasaki
"I left there in the morning
with their God tucked underneath my arm
their half-assed smiles and the book of rules.
So I asked this God a question
and by way of firm reply,
He said - I'm not the kind you have to wind up on Sundays."
"Wind Up" from Aqualung, Jethro Tull 1971

Mazdak2-Apr-02 3:38

2-Apr-02 3:38

James T. Johnson wrote:
but I'm not sure as I haven't done any ADO on Access

I used it.You have to use % . Smile | :)

Mazdak2-Apr-02 3:40

2-Apr-02 3:40

Dan Pomerchik wrote:
And what about ADO ? Does it work with % or must use * too ?

In ADO You have to use % . Smile | :)

Dan Pomerchik2-Apr-02 14:22

2-Apr-02 14:22

Oh this is crap, every time you have to use a different character OMG | :OMG:

Why can't they just SET a STANDARD and USE it in all db's/platforms/etc.!?
Anyway thanks guys, good to have some people who help Smile | :)

5-Apr-02 1:47

Dan Pomerchik wrote:
Why can't they just SET a STANDARD and USE it in all db's/platforms/etc.!?

How do you think they keep us on our feet? Smile | :)

Nick Parker5-Apr-02 1:49

Nick Parker

5-Apr-02 1:49

Dan Pomerchik wrote:
Why can't they just SET a STANDARD and USE it in all db's/platforms/etc.!?

How do you think they keep us on our feet? Smile | :)

Don't you hate it when you forget to log on with the message boards?

Nick Parker

Dan Pomerchik7-Apr-02 6:45