Sitemap

Amicuk Programming Answers

SQL 2005 connection

-0001-11-30   Views:1

Advertisement

Hi, Well for some reasons I don't really know because SAP doesn't help me a lot on this. I just reinstall all my SAP software over SQL2005.  Everything was nice, and everything works fine from SAP and SQL2005 Now I'm loading the project I was used to

Hi,
Well for some reasons I don't really know because SAP doesn't help me a lot on this.
I just reinstall all my SAP software over SQL2005.  Everything was nice, and everything works fine from SAP and SQL2005
Now I'm loading the project I was used to work on in SQL 2000 just before the installation and now the connection to SAP never work from the DI API
and Of course I'm using dst_MSSQL2005 as the famous parameter for an SQL2005 connection
I did check the connection parameters and everything is all right.  If I'm able to connect with SQL Studio Manager, why not with the DI API ?
Is there something I should know here ?
Thank you for any help

The replay answer
Advertisement
Marc,
Are you able to connect with any of the DI API samples that come with the SDK?  Have you installed the DI API on the machine you are trying to run your code?  Have you installed the SQL Native Client for connectivity to SQL?
Eddy

Go to See the other 4 answers

Java to MS SQL 2005 connection

Category:DefaultRelease time:-0001-11-30Views:130

Hi good afternoon, I am facing problem while connecting with MSSQL Server 2005 through java. I am only able to connect with server using windows authentication. and when I tried to connect it with SQL server authentication using username as "sa"[More]

SQL 2005 connection

Category:DefaultRelease time:-0001-11-30Views:130

Hi, Well for some reasons I don't really know because SAP doesn't help me a lot on this. I just reinstall all my SAP software over SQL2005.  Everything was nice, and everything works fine from SAP and SQL2005 Now I'm loading the project I was used to[More]

SQL 2005 will not connect in SQL 2012 profiler

Category:DefaultRelease time:2015-10-11Views:130

We have a few SQL 2005 databases that we manage. I went to do a trace on them(recently upgraded to 2012) and it gives me the error, "SQL Server Native Client 11.0 does not support connections to SQL Server 2000 and earlier versions". According t[More]

Database connection to MS SQL 2005 (URGENT Help Needed)

Category:DefaultRelease time:2015-10-11Views:130

Hi all, Does anyone know how to connect my adobe form to MS SQL 2005? I have this code: try {      InitialContext initialContext = new InitialContext ();      DataSource dataSource = (DataSource) initialContext.lookup ("jdbc/MyAlias");       jav[More]

Dump while acessing tables in sql 2005 using DB connect

Category:DefaultRelease time:2015-10-11Views:130

we have a sql 2000 as source system in place and now i created sql 2005 source system with DB connect. bw version 3.0. tables naming conventions are according to SAP. when i click the button to show tables in source system (sql server) , it is throwi[More]

Possible for AIR app connecting to SQL 2005 server

Category:DefaultRelease time:2015-10-11Views:130

Is it possible using Flex AIR to connection to SQL 2005 server and fetch data ? If YES, whats step / process we need to follow please. We have the DB in sql 2005 and we want to develop desktop client and fetch the records from DB to AIR app."kamaljee[More]

Trouble connecting to SQL 2005

Category:DefaultRelease time:-0001-11-30Views:130

I'm using Flex 3, trying to connect to SQL 2005 via ASP with IIS7. I was following the instructions listed [url=http://livedocs.adobe.com/flex/3/html/help.html?content=data_3.html]here [/url] under the section "Generating an ASP .NET database applica[More]

Connecting to SQL 2005 from Oracle error

Category:DefaultRelease time:-0001-11-30Views:130

I have an Oracle Database and SQL Database on the same server and wants to use odbc to connect to the SQL 2005 database and query tables of my choice. I did configured the ODBC correctly and called the DSN TSH_ARCHIVE. I have tested it and it works g[More]

CF8 and connection pooling using MS SQL 2005 JDBC Driver

Category:DefaultRelease time:-0001-11-30Views:130

After upgrading one of our production servers to CF8 we're getting errors under load while connecting to MS SQL 2000 data bases using the MS SQL 2005 JDBC 1.1 driver instead of the driver cf8 ships with. The following error is recorded in the logs: E[More]

Trying to use Linked Servers in SQL 2005 to connect to RDB 7

Category:DefaultRelease time:-0001-11-30Views:130

I'm looking for detailed info on how to set up a linked server in SQL 2005 to connect to my Oracle RDB 7 database (running on VMS). I'm able to connect via odbc using VS.Net and Sql Server 2005 Reporting Services. I'm not sure if I need to use the OD[More]

Connect Non-SAP Oracle db (32bit) in sql 2005 (64 bit) using linked server

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I am connecting Oracle 10g database from SQL 2005 using linked server, in which i get the error "Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "L2ORACLE". OLE DB provider "MSDAORA[More]

Hot
After upgrading iPhones 5c and 4s to iOS 7.1.2., the phones have troubles in establishing a call connection. It takes considerably longer time and the phones are inaccessible for incoming calls. Does anyone encounter similar problems? Troubleshooting [More]
I has created a view and an Instead-Of trigger on that view. Now, I want to update this view in FORMS 6. I am unable to update this view and getting error FRM-40602. Is there any way to update this view updatable in FORMS6 or FORMS6 has not this feat [More]
Hi , I have to Compare two columns to see if they are matching or not....and give the count() of overrides if they are not matching/ I have got that with the below SQL: Count of Overrides = select count(Case when Col_1 != Col_2 then 1 else null end) [More]
My IPhone has water damage so the screen has stopped working, even though the phone is still on. I need to restore the phone to send it back to the company, however when I try to restore it on the computer, it prompts that I need to turn of "Find My [More]
I am using an uncompressed quicktime graphic within final cut that I have to take into dvd studio pro to create a dvd. When I export an mpeg2 and burn my dvd the graphic seems to look like I have lost Alot of contrast. The quality has been greatly lo [More]
Hello, recently I discovered a very useful feature, if you activate quick look on a Garageband project you can see the content of the arrange window. Is this also possible with Logic files? Or is this a feature for upcoming Logic Versions?Interesting [More]
Hell Experts, We have two DSOs as below: DSO1 - Contains Master list of customers DSO2 - Transactions of all customer. I want a report to show all customers who do not have any transactions. So thought of come up with all unique set of customers from [More]
Many databases in the market currently allows table/column names to be 128 characters long. Our developers are suggesting that 30-35 characters is the limit one should strive for. One thought is that Business Objects cannot handle queries bigger than [More]
I've recently upgraded to Mountain Lion and am now just learning about "Local Backups" and how they work.  This seems like a pretty neat feature and great extra data protection.  However, I now have trouble with 3rd party apps that monitor and n [More]
Hi I have an workbook. The query is on sheet2 and the result area is on sheet1. The query contains a hierarchy. I would like change the hierarchy display from key to name or key and name. Olap-Functions for active cells works well. But with my VBA co [More]