I have one application in sap which takes sap data into idoc and want to send in sql server 2005

Create table other_sess( s_name varchar2(10)); insert into other_sess values(‘s2007′); insert into other_sess values(‘s2009′); insert into other_sess values(‘s2009′); commit; now i want to write a PL to retrive data from these sessions (s2007, s2008, s2009). from my current session. declare mold_session varchar2(10); cursor c1 is select s_name from other_sess order by s_name; begin open C1; loop…

hi everyone,i have been using OBI EE for the past 2 months.I have been using Oracle 10g database as a data source for OBI EE and it worked just fine and now im trying to use SQL server 2005 as my data source. My ODBC was succesful and i can import from that database but…

hi everyone,i have been using OBI EE for the past 2 months.I have been using Oracle 10g database as a data source for OBI EE and it worked just fine and now im trying to use SQL server 2005 as my data source. My ODBC was succesful and i can import from that database but…

i am a developer using VB 6 EE, SQL Server 2000 & Crystal Reports 7 and windows XP & Windows NT platforms. But now i installed Windows Vista. i installed VB 6 EE, but cant work with SQL Server 2000 or Crystal reports. can u please suggest me wat i need 2 do.

Hi, I am currently creating a report in SSRS which contains many tables including a graph on one page. The formatting is nice generally, but when there is no data in the graph, everything will be different. So, I am trying to keep the graph always visible to keep the formatting. Is that possible? Thanks,…

connect Powerbuilder 10 with Microsoft SQL??

Hya I have a formula into Excel worksheet cell this value comes from out side Excel. sometimes there is a number and sometimes it contains nothing. I have used isblank isempty when the cell is empty and they return true (due to the formula inside the cell) do u thing i can chek if the…

A few weeks ago we had a major crash that was caused by a bad install. I wiped the machine and reinstalled the OS (Windows Server 2003). At first everything appeared to be fine. We are using: 2 x 4 core 2.33 GHz Xeon E5345 Intel s5000XVN motherboard 12GB Ram ATI Radeon x300 Video The…

Is it adviceable to put SQL 2000 and 2005 in one single CLuster by putting them in different instances?

http://benchmarkitconsulting.com/colin-stasiuk/2009/02/19/please-vote-what-is-your-sql-server-2008-adoption-rate/ SQL Server 2008 RTM is over 6 months old now and I’m wondering what people are seeing so far in terms of adoption rate. What I’ve seen so far in the environments that I’ve been working on definitely falls in the 1% – 25% category. What has everyone seen in the environments that they…

http://benchmarkitconsulting.com/colin-stasiuk/2009/02/19/please-vote-what-is-your-sql-server-2008-adoption-rate/ SQL Server 2008 RTM is over 6 months old now and I’m wondering what people are seeing so far in terms of adoption rate. What I’ve seen so far in the environments that I’ve been working on definitely falls in the 1% – 25% category. What has everyone seen in the environments that they…

We have a database of around 3GB on SQL Server 2000 Standard Edition. What is the quickest way to backup the database at minimal cost, and how much time would it take to upgrade this database to SQL Server 2005?

We have a database of around 3GB on SQL Server 2000 Standard Edition. What is the quickest way to backup the database at minimal cost, and how much time would it take to upgrade this database to SQL Server 2005?

I run theis procedure against a link server (Quickbooks) It runs with no errors but will not return records. SELECT   *   FROM QODBC …Customer

How do I execute a UNIX shell (.sh) script from within an MS SQL Stored Procedure?

I have a problem with COM-objects which i create in CLR-assembly in VB.NET via CreateObject. When I compile this assembly as console project and run loging under any account on server, it works ok. But when i run this file from MS SQL, it can not create object. What may be reason for this?

Can somebody please explain how to fetch synonym names with the SQLTables function in ODBC API. I currently use the DSN created with SQL Native Client 10 and SQL Server 2005. My code is as follows:</p><p>ret = SQLTables(stmt, NULL, 0, NULL, 0, NULL, 0, <br>SQLCHAR*)”‘TABLE’,'VIEW’,'ALIAS’,'SYNONYM’”, SQL_NTS);</p><p>I am getting back a table and views in a result set –…

I would like to know if there any examples of using the SQL CLI APIs in a COBOL/400 program that may help me in using the APIs to call a stored procedure and process the result set(s) . Thanks Mike

I have created synonyms on tables in SQL Server 2005. Does anyone know of a way to make those synonyms available through ODBC for use in MS Access? I have installed the latest SQL Server Native Client development pack; but the synonyms do not show up in the list of tables when linking via ODBC.