Design Question About Webservices

Mar 30, 2007

Hi,

I need to expose data in a SQL server 2005 database as a webservices. I have 2 options to choose. I can create an End point in sql or build a webservices in .NET.

So what are de advantages and disadvantages of those 2 approaches ?

Of course they want the webservices secure. I know that authentication is not a problem since we use windows integrated security for the intranet. But what will happen if we move to an extranet or the internet ?

But how do you enable authorization ? and Context security ? Is context security better done in .NET then in SQL ?

Thanks in advance.

View 3 Replies

Webservices And SQL 2005

May 15, 2007

Hey guy and gals,
I need to connect to a web service from a Sproc, can this be done? I've google and found out about Httpendpoints but that is running the web service on the server, not connecting to one from the server in a sproc. Any ideas or site links would be helpful. TIA.
Jason

View 1 Replies View Related

SQL Connections Stop & Webservices

Oct 10, 2007

Hello, I appeal to all to save me from this situation.

I have a WebService in VB.net by IIS and a operation to connect to the SQL server and run a query and others operations. All fine...

But after a certain time only the SQL operations don't respond nothing, the others are OK. So the problem is not in the IIS i think and something between the IIS and the SQL Server.

Can you give me some light about this PLEASEEEE :D ?
Thanks

If any of you need the source say it.
Thanks

View 9 Replies View Related

Triggers Calling WebServices

Mar 16, 2006

Yes, I know there is at least one other thread about this type of thing, but my error is a bit different............

I have been trying to call a webservice from within a trigger and i keep receiving the following error:

Msg 6522, Level 16, State 1, Procedure wepTestTrigger, Line 1

A .NET Framework error occurred during execution of user defined routine or aggregate 'wepTestTrigger':

System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.EnvironmentPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

System.Security.SecurityException:

at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)

at System.Security.CodeAccessPermission.Demand()

at System.Net.CredentialCache.get_DefaultCredentials()

at Triggers.wepTestTrigger()

.

The statement has been terminated.

How or what do I need to do in order to call this webservice?

Thank you for any help.

Wayne E. Pfeffer

View 3 Replies View Related

Windows Authentication And WebServices.

Jun 14, 2006

If the web service is talking to a SQL Server database and the authentication used is SSPI (Security Support Provider Interface
) / windows authentication, does the ASP.Net user or machine id user
need to be added to the list of allowed ids to the database server? Or
am I misunderstanding the security constraints?

If I run my code through an Nunit test conduit, I can retrieve data,
but If I run it through my webservice it fails authentication.

advTHANKSance

View 1 Replies View Related

Calling WebServices Asynchronously From SQL CLR

Sep 18, 2007

I'm assuming it's possible to call a web service asynchronously from a SQL CLR function, is this correct or is there a fundamental flaw in calling the asynchronous methods?

I've tried coding a sample and despite creating a new thread, which in turn calls the web service asynchronously and using newthread.join I can never get the webmethodasync_completed sub to be called.

View 1 Replies View Related

How To Create Installer For Webservices

Nov 24, 2007

Hi Experts,
I have to create Installer or setup for my project.
My project Containg 2 webservices and one applicationProject.
I donot Know About Installer How To create SetUp For AboveProject . I want In setup wizard shows in grid it shows the 2 Webservices and PrudentialApplications. and How To add a sqlserver Bootstrapper in this application.
Regards
Venkat.

View 2 Replies View Related

WebServices: This Complex Type Does Not Contain Any Properties

Aug 9, 2007

Hello everyone,
I am newbie in SSIS and I have one problem.
I have defined in Control Flow one WebService Task, specified the WSDL-File.
I have chosen one method from WS as Input. But this method requires one parameter of the ArrayOf_xsd_string type.
If I try to choose it, I receive following error:

===================================
This complex type does not contain any properties. (Microsoft.SqlServer.WebServiceTaskUI)
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.CustomGridControl.HandleEllipseBtn(Int64 row, Int32 col)

in my WSDL-File it already defined:

Code Snippet<complexType name="ArrayOf_xsd_string"><complexContent><restriction base="soapenc:Array"><attribute ref="soapenc:arrayType" wsdl:arrayType="xsd:string[]"/>

Could you help me? Where I can define this ArrayOf_xsd_string type, or how can I correct my problem?
Thanks a lot for your Help!
Regards,

View 1 Replies View Related

How To Render One Page At A Time Using SSRS Webservices

Apr 10, 2008

I developed a java proxy application for SSRS(Sql Server Reporting services) and able to render the reports by making webservice calls to SSRS webservices. But I am getting the data for the complete report. How can I get only a partial report( like page by page as we get in the Report Manager)? Which parameters should I pass.
As some of the reports are too big, the java application is getting memory issues and I want to limi the data that I get from SSRS.

Appreciate your suggestions.

View 6 Replies View Related

Using Web Services Data Source With A Param From Another WebServices

Apr 4, 2007

Hi !!!
I have to use 2 web services !
One (WebServices A) which contains methods I need to call, and the other (WebServices B) which contains a method who returns a autenticationCookie, that I have to use in parameter for call method from WebServices A ?
It is clear ? I hope...

So my question is how I can do ?
I know I can create few dataSet, but how can I pass a data from on dataSet (from my WebServices B) to the query on an other dataSet (from my WebServices A) ?

Thank your help !

View 3 Replies View Related

Need Help On Creating ENDPOINT To Define Webservices In SQL SERVER 2005!

Feb 23, 2006

Hi there, I am just trying to create an ENDPOINT to define a Web Service in Sql
server 2005. Here is my code
Create ENDPOINT AWService STATE = STARTED As HTTP ( PATH = '/ADVENTUREWORKS', AUTHENTICATION = (INTEGRATED), PORTS = (CLEAR), SITE = 'DEVISQLDM2005' ) FOR SOAP ( WEBMETHOD 'GetProductList' (NAME = 'AdventureWorks.Dbo.GetProductList'), DATABASE = 'AdventureWorks', WSDL = DEFAULT )
and when i run this T-SQL its complaining about
Msg 7807, Level 16, State 1, Line 1 An error ('0x80070057') occurred while attempting to register the endpoint 'AWService'.
I am trying this code to run on Windows XP pro and Sql Server 2005. Any
clue why its complaining about this ?
Thanks -D

View 1 Replies View Related

How To Call Via CLR One Dll Which Calls Two Webservices (endpoints) With Dynamic Parameter

May 23, 2007

I developed one DLL in vb .Net which call two web services (sql endpoints) I wish to use this solution but for hundreds of servers (endpoints) I want to ask if I could do that with dynamic parameters passed to de DLL CALL in sql server clr.

Actually when I compile de DLL I need to have referenced (hardcoded) the webservices (endpoints) and when I need a brand new endpoint I need to reference it, compile the dll and release.

I cannot find how to invoke the service within the DLL with the namespace or webservice name as parameter.

Mi code to invoke now my referenced end point is: (note that my endpoint name is rperez)

Dim CallWebService As New rperez.IntelisisServiceEndPoint

CallWebService.Credentials = System.Net.CredentialCache.DefaultCredentials

Call CallWebService.IntelisisService(ArchivoOriginal)

My class rperez.IntelisisServiceEndPoint is referenced (hardcoded) in the dll project I need it dynamic

Do I need to change my code to PROXY object ?

View 1 Replies View Related

Integration Services :: SSIS - WebServices To OLEDB Destination

Oct 8, 2015

I have requirement to update/insert the DPID based on the address which are passed as an input values.There are more than one address at the same time and I configured to get the address from the query which are correct and output of the address values will be stored as system object variable.I am then passing the system object variable to for each loop container and I have configured the collection and variable mappings as a variable for each input value.

when I pass the value manually to the web service task it works correctly.When I pass it as a variable to web service task it doesn't return any value.I have a data flow task which converts the ouput from web service task using the xml source converts it to oledb destination.I don't see any rows being written to the target table.

View 6 Replies View Related

Rendering Report Page By Page Using Webservices

Apr 10, 2008

How can I get only one page of data each time when I call the render menthod from the SSRS webservice

View 3 Replies View Related

DB Design :: Database Design For Matrix Representation

May 13, 2015

I have a scenario like below

Product1
Product2 Product3
Product4 Product5
Product1 1
1 0 0
1
Product2 1
1 0 0
1
Product3 0
0 1 1
0
Product4 0
0 1 1
0
Product5 1
1 0 0
1

How to design tables in SQL Server for the above.

View 2 Replies View Related

Database Design/query Design

Feb 13, 2002

Ok, I'm doing a football database for fixtures and stuff. The problem I am having is that in a fixture, there is both a home, and an away team. The tables as a result are something like this:

-------
Fixture
-------
fix_id
fix_date
fix_played

----
Team
----
tem_id
tem_name

-----------
TeamFixture
-----------
fix_id
tem_id
homeorawayteam
goals

It's not exactly like that, but you get the point. The question is, can I do a fixture query which results in one record per fixture, showing both teams details. The first in a hometeam field and the second in an away team field.

Fixture contains the details about the fixture like date and fixture id and has it been played

Team contains team info like team id, name, associated graphic

TeamFixture is the table which links the fixture to it's home and away team.

TeamFixture exists to prevent a many to many type relationship.

Make sense? Sorry if this turns out to be really easy, just can't get my head around it at the mo!

View 2 Replies View Related

DB Design :: Table Design For Packages

Aug 18, 2015

I would like to create a table called product. My objective is to get list of packages available for each product in data grid view column while selecting each product. Each product may have different packages type (eg:- Nos, CTN, OTR etc). Some product may have two packages and some for 3 packages etc. Quantity in each packages also may be differ ( for eg:- for some CTN may contain 12 nos or in other case 8 nos etc). Prices for each packages also will be different that also need to show. How to design the table..

Product name :
Nestle milk |
Rainbow milk
packages :
CTN,OTR, NOs |

CTN, NOs
Price:
50,20,5 |
40,6

(Remarks for your reference):CTN=10nos, OTR=4 nos
| CTN=8 Nos

View 3 Replies View Related

Help Me Design My DB

Nov 7, 2003

Hi all.

I'm going to create a big DB that will hold important info
(the usual stuff - Clients, Products, Orders...)

I wonder where should I use the IDENTITY field,
for example - on Orders I will have Order_ID...
(and where does SQL server the numbers of a deleted records)

My fear is that IDENTITY fields will go wrong somehow so I can
loose connections within the tables
(maybe when restoring my DB to some other locations... with DTS... or other issues)

1. When should I use IDENTITY field ?

2. If I do NOT - how can I lock a record when I add a new one

View 17 Replies View Related

DB Design

Jan 13, 2004

Hi,

I have 7 web forms wizard. after the user edit the fields, I need to keep a history log of the changed data only.

I am thinking of the following structure

log_id, user_id, field_id, old_value, new_value, transaction

Where field_id is a number indicates the changed field.
for example 1> First Name, 2> Last Name etc

Where transaction is ADD, DELETE, EDIT

Also i need to keep history of the details
for example an enterprise has 10 branches.
State, employees
NY, 1000
MD, 500

My log table will look like this
log_id, user_id, field_id, old_value, new_value, transaction
1, 1, 1, , Mick ,John , EDIT
2, 1, 3, ,NY , HI , EDIT
3, 1, 3, ,MD , , DELETE
4, 1, 4, ,500 , , DELETE
5, 1, 3, , ,NV , ADD
6, 1, 4, , ,700 , ADD

Is there a better way to log changes?

Thanks

View 1 Replies View Related

Design Q

Jan 16, 2004

I'm going to create a hardware/software inventory program to keep track on all the computers at the office. This program should be able to search the database using queries like "all computers with a cpu faster than 500Mhz".

I want some tips on my database design.

One solution is to create columns for each piece of hardware, i.e. cpu, ram, hdd etc etc. Then just run simple SELECT queries against them. The problem is that a computer may have many HDDs/CDs etc, and also other type of equipment may be entered in the database like switches and routers.

Another solution is to specify the valuetype + value in one table having a relation to another table containing the actual machines/routers/switches. The problem here is that I can't do numeric comparisons this way since "11" is less than "2", ("all computers with a cpu faster than 500Mhz").

Any suggestions?

View 3 Replies View Related

Bad Design?

Feb 10, 2004

Table A
[ID] [SalesmanEmail] [SalesmanName]
Table B
[ID] [QuoteNo] [SalesmanID]
Table C
[ID] [Product] [QuoteNo]

Program A creates the records for Table C. In the process it reads from Table A and Table B.

Program B reads record from Table C. Program B now needs [SalesmanEmail] field.

The suggestion is to add [SalesmanEmail] to Table C. Is this good or bad design?

View 5 Replies View Related

Which Is Better Design?

Oct 15, 2004

hello,

i am working on a project with another guy as well. well, we have a table called lets say student and student_unit where student_unit holds the unit names the student is doing. and i was planning to use the same student_unit table to hold the result of that unit for that student as it is the case of adding one field but this guy who happens to be my boss thinks that result should be separated. but is it a better idea to make a separate table just for that result which is totally dependent on unit and student? that doesn't make any sense to me.

if asked why, he says for performance, modularity and object oriented approach and blah blah and honestly i think he knows nothing. so i would like u guys to tell him if there is really a need to create a separate table for attributes which is totally dependant on the same PK? having five more attributes on the same table hurts than creating a new table?

View 1 Replies View Related

Help With DB Design

Oct 27, 2007

I think I might have dug myself in a hole here, so could use some advice on database design.

Currently, I have a table that records meeting minutes. The design is:

Code:

minutesid | int | 4 | no nulls
minutescat | varchar | 255 | allow nulls
minutesnotes | text | 16 | allow nulls

What this does is set up a minutes category, such as "Members Present", and the notes for that category, such as "Mrs. Peacock, Mr. Green, Professor Plum, Colonel Mustard, Miss Scarlett". Each individual category has it's own ID.

I need to develop an archive of each of the minutes. So if there are 15 categories and associated notes for the 15 OCT 2007 meeting, how can I design the archive table to include all of those categories and notes into one record for 15 OCT 2007, then for 15 NOV 2007 and so on ...?

Hope that makes sense. Thanks in advance ...

View 5 Replies View Related

A Lil Help With DB Design

Sep 21, 2007

I have a table to store members. For each member, I have flags like manager, verified, etc. How should I be storing the flags? As individual columns in the same table and using bit datatype or creating a new table called MemberStatus and creating 1 row for each flag?

Thanx in advance.

Premal.

View 14 Replies View Related

Design DB

Mar 26, 2008

Hi,

I need to design a database, but i i just don know if i am doing it correctly.

Basically, i have an equipment which is sending me a lot of gauges readings (high limit, low limit, current level), electrical readings, hydraulic readings, alarms levels such as Fuel level, temperature level, etc etc, about 200 different types of readings, continuously. I may have different types of equipments and although most of the data are the same, some data types and its availability may be different too., depending on the type of equipment.

I want to keep this readings in a database, and this database will be updated constantly.

Should i create all of this different gauges readings in one big single table? If i do so, i only have one long row of data then for a particular equipment.If i put in different table, i can't see how i can create relationship among my tables with such kind of data.

Can you help on the possible ways of putting this equipment real time readings into DB?

View 3 Replies View Related

I Need Help In Design?

Mar 12, 2004

I am trying to create a database that is used to create/store estimates for a manufacturing company. There are many things to consider in this estimate but I will isolate this question to the takeoff itself:

There are several categories in which costs are estimated and they are as follows : Product(s), Site Work, Transportation (Shipping), Field Materials, etc...

Should each of the above have their own "Takeoff" table, or would using one table and a gategory table be a better way to go?

Mike B

View 2 Replies View Related

How Would You Design This?

Jun 18, 2008

The data that I have is the following:

Car Manufacturer Factory CarCode
---------------- ------- -------
Ford Houston F-Hou
Ford Reno R-Hou
Chevy Houston C-Hou
Chevy Las Vegas C-LV
Honda SLC H-SLC
Ford SanFran F-SF
Chevy Miami C-Mia

I have a database design implemented already, but I'm receiving some disagreement about it from a co-worker. The way I see it is you have a car manufacturer and a factory location that are both unique, so I created a lookup table for each. I then created a branch table for the many-to-many relationship that exists between Manufacturer and Factory, and within that branch table I placed a column for CarCode, because it seems to me that Manufacturer and Location both determine the CarCode.

I also have an autonumber field within the branch table, which I then use for foreign key relationships.

Is there anything wrong with my design here?

Thank you in advance for your help!

View 5 Replies View Related

Design Help, Please...

May 1, 2007

I've fought with this issue for a week now and I can't come up with a simple way of doing it.

I have a database, with the following tables:
Members
MainCategories
Categories
Answers

The idea is that Members will log into the site, select the Categories from the MainCategories, fill out some data, which is stored in the Answers table. The problem is, each of the main categories have different fields. So a Main Category might be "Shoes" and the fields would be "Color,Size,Brand", and another Main Category might be "Cars" and the fields "Make,Model,Year,Color,Type,IsNew".

I thought about creating the Answers table with all the possible answers, linking it to the categories and members table, so we can view which members filled out answers for which categories.

Can anyone help me come up with a solution for this?

View 4 Replies View Related

Design Help

May 13, 2007

Please ignore my earlier post...

Please help me in designing the tables...
I used to get flat files which i need to import into a tables..
The flat files data which contains.....

FlatFiledata:
------------
100,1,xx,yy,,20030101
100,2,20030101
100,3,01,20030101

Below are the tables which i design please correct me..

Table1ForRow1
--------------
col Identity,
col1,100
col2,1
col3,xx
col4,yy
col5,,,
col6,20030101

Table1ForRow2
-------------
col Identity,
col1,100
col2,2
col3,20030101

Table1ForRow3
------------
col Identity,
col1,100
col2,3
col3,01
col4,20030101

When i queried then I want the output:
100,1,xx,yy,20030101,2,3,01

View 1 Replies View Related

Design

Jul 23, 2005

Hello all,I am trying to correctly model the relationship between products andversions within my db. The problem I have is how to store the versiondata. I need to collect the following information:1) Major Build Number (int)2) Minor Build Number (int)3) Build Number (int)4) SP number (int)What is the "correct" schema for this? How many tables and whatcolumns?(On a side note if any one has any links to useful examples of DBdesign could they post them?)Thanks,Jose

View 1 Replies View Related

Bad DB Design

Oct 30, 2007

I inherited a SQL 2005 database from my bro-in law that has tables with names in the spaces and spaces and other characters in the column names. I link to these tables in an MDB file. Access 2003 sees this fine, but Access 2007 returns odbc--call failed errors. Is there anything I can do short of removing the spaces and characters (? %) from all of the table and column names? Is there a switch I can throw that will tell Access 2007 to ignore this and work like a previous version?

Thanks.

View 5 Replies View Related

Help On DB Design

Jul 30, 2007

Hi,
I have a form where users can choose number of file uploads ( drop down ) and upload images. I need to store the path of images in database.I want to know what is the best way to store multiple file upload paths. As per my knowledge it possible to store paths in one field with delimiter. Is there any other good way to store the paths.

Raj

View 3 Replies View Related

DB Design Question

Sep 2, 2006

Hope this is in the right forum....Assume a DB design which has 3 entities Customers, Vendors, and Email-addresses. Customers and Vendors can have zero, one, or many Email-addresses. To normalize the many-to-many, I have an intersecting entity called Email-addresses-usage. I know how to handle the intersecting entity if it were only Customers and Email-addresses, i'm not sure about adding Vendors to the mix.My questions are:1) in sql managment studio, do I have a FK relationship from Customers to Email-addresses-usage and also a FK relationship from Vendors to Email-addresses-usage?2) If zero email addresses are allowed, how to I define a zero possibility from a relationship standpoint - i.e., do I just specify NOT enforing the FK constraint? but then, if email-addresses are present, I'd want the contraint to be enforced - how is this have my cake-and-eat-too accomplished?3) any tips/suggestions on how one might present this to an end user for data entry.Thanks

View 4 Replies View Related