How to create a SAPConnection in .Net Code with .NET Data Provider

SQL Server Integration Services

Index ‹ SQL Server

- Previous
  - 1
    - What is wrong with query? SQL Server does not support the ANSI SQL CREATE TABLE AS syntax. Your ANSI SQL syntax is also incorrect in that you are not specifying the column name after that CREATE TABLE nor in the SELECT list of the query. In any case, you will have to use SELECT INTO to create a table from a query source in SQL Server. Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 2
    - SQL Insert/Update Trigger Thanks loads cos its working now!! i also twisted it to work on a delete query...but I cant find which keyword I should use to utilise it in an UPDATE trigger! can anyone help me please Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 3
    - Date literals in expressions? Phil Brammer wrote: "12/30/1899" It has nothing to do with the date format. When using apostrophes, SSIS complains that the apostrophe is an unexpected character. When using quotation marks, it complains that DT_DATE can't be implicitly converted to DT_WSTR. And number (pound) signs are the syntax for direct references to lineage IDs. Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 4
    - Question about aggregate function No I still don't have the solution. Can you give me your solution step by step Thanks, Hendrik Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 5
    - Could not find stored procedure How can i track it Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 6
    - stupid question on graph width. when I create graph (Pia) the graph take 80%, and the labels take 15%, example here: http://img2.tapuz.co.il/forums/1_91779074.jpg is it possible to grow the place of the labels I try look on the properties and I didn't find. thanks! Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 7
    - Some tables do not appear when using linked server Connect as the user/login used for sp_addlinkedsrvlogin and run the following statement to verify permissions. Code Snippet select * from fn_my_permissions('dbo.your_table_or_view_name', 'OBJECT'); Compare the result for the _good_ and _bad_ object. Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 8
    - Using SQL Server 2005 DM Add-in without Windows authentication I fixed the problem. First, I created a brand new web site in IIS. The default web site was somehow 'controlled' by sharepoint (I removed custom http headers and so on, but SharePoint would mysteriously be in the request-response loop). Then I had a problem with the .NET Framework version. I had conflicting .NET versions (32- vs 64- bit version of the .NET 2.0 Framework). That caused problems to my app pool in IIS (and to ASP.NET). I followed some steps to set the default .NET Framework version. After IIS was setup correctly I was able to connect from the add-in to the SSAS instance (through the HTTP pump). As my calculus professor would say: trivial! Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 9
    - Double Quotes in CSV File trust me, I have that box checked but it's not parsing correctly Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 10
    - Can't Set variable Through Command Line The syntax is wrong. Check Phil's posts above. -Jamie Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 11
    - Subscription sends 2 emails Can you create subscriptions using SQL 2005 workgroup edition I looked through report manager, but can't seem to find anything about subscriptions. Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 12
    - String constants must end with a double quote. Use this query: ="select r.Questionid, Questiondesc, r.loannum, a.FirstName, a.LastName , r.rating, LoanOfficer, Processor from customersurveyrating r inner join customersurveyquestion q on r.questionid = q.questionid inner join loan l on l.loannum = r.loannum inner join Borrower a on r.loannum = a.Loannum where Len(questiondesc)>0 and a.Borrcode = 1 order by questiondesc" Then add a new calculated dataset field (View -> Datasets -> right-click on dataset and click "Add" -> select "Calculated field" option and type the name "Name" and value = "=Fields!FirstName.Value & " " & Fields!LastName.Value") Goto Data tab and then edit the dataset and go to Filters tab: Under Expression type "=IIf(Parameters!Type.Value="LoanOfficer", Fields!LoanOfficer.Value, IIf(Parameters!Type.Value="Processor", Fields!Processor.Value, Parameters!Names.Value))" Under operator select "=" Under Value type "=IIf(Parameters!Type.Value = "LoanOfficer" or Parameters!Type.Value = "Processor", Parameters!Names.Value, "-ALL-")" This is one way of solving this issue. Also check the following link: http://www.developmentnow.com/g/115_2004_11_0_0_452537/String-constants-must-end-with-a-double-quote-error.htm this may help you to solve it in the simplest way if it applies to you Shyam Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 13
    - Last working day from last year! How can I get the last working day for the last year for each row in data source.. how can I include it inside a transform like derivaded column Help me!! Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 14
    - PDF Rendering bug We are trying to publish a group of financial reports using SQL Server Reporting Services. We have hit a snag when we try to render the reports in PDF format. The leading spaces of each line are stripped in the output file. For example: Department 10.7240 - ICU Expenses SubDepartment -------- ------------- 1,200 100 454 150 Becomes: Department 10.7240 - ICU Expenses SubDepartment -------- ------------- 1,200 100 454 150 Does anyone know a solution for this problem By the way, we did upgrade to SP2. That did not correct the problem. Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 15
    - Relationships vs. no relationships Not a problem. (Often tables have columns such as [CreateDate], [CreateUser], [ChangeDate], [ChangeUser], etc. so as to clearly indicate that it is metadata and not part of the dataset.) Still, based upon your initial post, I think that you would be best served with only two tables. Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 16
    - Merge replication reinitialization deleted all data Hello, When I reinitialized a subscription from SQL2005 db (publisher) to a SQL 2000 DB (Subscriber) and had the Upload changes before reinitialization turned on, the data from the SQL 2000 db didn't get uploaded. This resulted in a loss of 2 days worth of data. Does anyone have any idea if there's anywhere that data is kept. (unfortunately a series of errors caused our backups to not be running on the 2000 db either). Thank You Bob Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
- Next
  - 1
    - What advanced features can be built with code in SQL Server 2005 Reporting Services? Hi, all experts here, Thank you very much for your kind attention. As we know the limited features on SQL Server 2005 Reporting Services, but we can build advanced features for it with coding on it. Would please any experts shed me any light on it in a summary like what advanced features could be added with coding on SQL Server 2005 Reporting Services Thanks a lot in advance for your kind help and advices. And I am looking forward to hearing from you. With best regards, Yours sincerely, Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 2
    - Accessing a real table from inside a TV UDF It's a compatibility bug between CLR TVF and "yield return" iterators in C#. C# compiler moves the data access code into auto-generated enumerator class, and defers its execution until the first call of IEnumerator.MoveNext() thus violating the CLR TVF requirements. Please look at the following code that reproduces the bug: Code Block public class TestClass { [ SqlFunction (Name = "fn_Test" , DataAccess = DataAccessKind .Read, TableDefinition = "ID int" , FillRowMethodName = "FillTest" )] public static IEnumerable Test() { List < int > values = new List < int >(); using ( SqlConnection conection = new SqlConnection ( "context connection = true;" )) using ( SqlCommand command = new SqlCommand ( "select ID=1 union all select 2 union all select 3" , conection)) { conection.Open(); foreach ( DbDataRecord dataRecord in command.ExecuteReader( CommandBehavior .CloseConnection)) { values.Add(dataRecord.GetInt32(0)); } } //solution that doesn't work for ( int i = 0; i < values.Count; i++) yield return values[i]; //working solution //return values; } private static void FillTest( object value, out int id) { id = ( int )value; } } Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 3
    - Adding a article causes ALL articles to be refreshed I have setup Transactional replication in SQL 2005 between two servers and have about 200 tables being replicated. The problem is that every time, I add or drop a table to replication, and start the Snapshot agent, it re-initializes every article and re-loads every article. This process takes 1 hour to complete and CPU usage goes to 100% during that time. This behaviour seems very different from SQL 2000 where I would start Snapshot agent and only the relevant tables were added/dropped. Has that functionality changed from 2000 to 2005 Am I not doing something right Thanks, Amir Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 4
    - Making a report smaller...? Alright. I'm stuck. I admit it! I have a bunch of names, and each name can have one or more 'roles'(operator, reader, key operator, etc. Just random words really.) attached to it. Using reporting services, I've managed to get the information I need with relative ease... the only problem is, with 900 some records to display, it's current length of 41 pages with just one column going down the left side of each page is not exactly preferred by my superior (can't say I blame him really. Looks kind of odd!) It looks like this right now: Name1 Function Function Function Name2 Function Function Name3 Function Function etc all the way down to page 41 I need it to look something like this: Name 1 Name 4 Name 7 Function Function Function Name 2 Name 5 Function Function Function Name 8 Function Function Function Name 3 Name 6 Function Function Function Function etc. Or some variation of... I've fiddled around, and merely adding one extra column to the initial table-layout with the same =(!UserName etc) just merely replicates the data in the second column... not giving me the new stuff. I'm quite new to reporting services, but none of the tutorials I've seen/done seem to accomodate for this... Heeelp! Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 5
    - Connect to SQL Server from a PDA I've changed my connection string to string connstring = @"Data Source=myserver;Initial Catalog=mydatabase;User ID=uid; Password=pwd" ; but it didn't solve my problem. /JO Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 6
    - Installing Express toolkit Hello I have SQL Express with Advance report tools installed. I have download the express toolkit to use the Business Intelligence, however after I have installed the add on, when ever I select the Musiness Intelligence Management Studio I have a browser looking for the file Devenv.exe file and a reinstall is not working. Can anyone help with this Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 7
    - SQL using 2003 AD Groups We have began to use Windows AUthentication for our SQL 2000 Server. When we llok atthe groups in AD we do not see any Domain Local groups Is there a reason for that Can I just add the group without browsing I assume DLG will work with SQL for security. Thanks Brent Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 8
    - How to find out PublicKeyBlob I have created a custom authentication for Reporting Services, and it works great if I edit the RsSvrPolicy.congif like the following: <CodeGroup class="UnionCodeGroup" version="1" Name="SecurityExtensionCodeGroup" Description="Code group for the security extension" PermissionSetName="FullTrust"> <IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\bin\myfile.dll" /> But the guideline says a strong named assemly is better, so I created a strong named assembly and registered it in the GAC, but how do I find out the PublicKeyBlob to enter in the config file Regards Andreas Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 9
    - SQL Server Windows Auth for ETL called by CreateProcessAsUser Hi, We've set up Kerberos Authentication for this. We used KB/articles regarding Kerberos/constrained delegation. I said that we solved the double-hop issue because I am now able to login the Web App and the DB server using my identity. Also, when running CreateProcessAsUser, it says on the trace logs that the "creator" of the process was my Identity. Also, in the Windows Events Log, in the information/warning/error messages for the ETL, it says that the "Operator" is the impersonated identity. Thanks. Regards, Lloyd Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 10
    - deAttach database thanx a lot Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 11
    - Cannot add a new folder under a Reporting Server Project Hello, I was just wondering why is there no option to add a new folder under a reporting server project. I have a reports project and under it i would like to add subfolders like Daily and Weekly just to make it more organized. I understand that during deployment, we can specify to which folder we want the report(s) to be deployed, but what is the reason behind not having an option to add a new folder Thanks, maui Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 12
    - Generic calculated measure Hi I have to create a calculated measure which is applicable for 16 measures. How can i specify it in a generic manner for eg: create member currentcube.ytd as sum(ytd(),[measures].[sales units]; here my scenario requires the calculation of YTD for many other measures also other than sales units so can i have something instead of [measures].[units], so that it will be generic. Thanks in advance. Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 13
    - SSIS Randomly Empties Out Column Data While Using Flat File Source I'm having a problem using the Flat File Source while using the underlying .Net classes to execute SSIS Packages. The issue is that for some reason when I load a flat file it Empty's out columns randomly. Its happening in the Flat File Source Task. By random I mean that most of the times all the data gets loaded but sometimes it doesnt and it empty's out column data. Interestingly enough this is random and even the emptying out of columns isnt a complete empty, its more like a 90% emtpying. Now you'll ask that is the file different everytime and the answer is NO. Its the same file everytime. If I run the same file everytime for 10 times it would empty out various columns maybe 1 of those times. This doesnt seem to be a problem while working with dtexec or the Package Executor utility. Need Help!! Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 14
    - Validating the parameter text box Hi, I have one date parameter in my report. The user will be able to manually enter or use the calendar control. In the case of entering manually, is there any way to validate the input string How can we prevent users from entering alphabets Also, is there any way to reduce the length of the parameter textbox. Can you please help Thanks, Sonu. Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 15
    - aggregation question Aggregation SUM adds the numbers together. Is there a similar aggregation function that returns the product of all the numbers Thanks Tag: How to create a SAPConnection in .Net Code with .NET Data Provider
  - 16
    - date output format Hi, I have the following problem. I have made a parametered report where i ask a begin date (@datefrom) and an end date (@dateto). when i enter my dates via the little calendar is see the format dd/mm/yyyy When i do a preview of report i have a textbox with the following expression : = "Total work time from " & Parameters!DateFrom.Value & " to " & Parameters!DateTo.Value but the output of the date format is mm/dd/yyyy. What can i do to have the output format dd/mm/yyyy Vincent Tag: How to create a SAPConnection in .Net Code with .NET Data Provider

Speedy2000

In the SQL Server Technical Article Microsoft .NET Data Provider for mySAP Business Suite is a Code example of how to invoke a BAPI in .Net Code. First line shows how to create a Connection to SAP, but there is no information in which lib the SAPConnection type is stored:

SAPConnection con = new SAPConnection("ASHOST=<SAPserver>; CLIENT=<client>;SYSNR=<sysnr>;USER=<user>;PASSWD=<password>;LANG=<logon language>");
con.Open();

Does somebody can help me

Top

Re: How to create a SAPConnection in .Net Code with .NET Data Provider

DarrenSQLIS

Assembly Microsoft.Adapter.SAP.SAPProvider

Top

Re: How to create a SAPConnection in .Net Code with .NET Data Provider

Speedy2000

Correct! That really helped me out! Thanks.

Top