Microsoft .NET Data Provider For MySAP Business Suite Licence Implications?

Jul 25, 2007

Hello Everyone,



Does anyone know if there are any licence implications (SAP side) against Microsoft .NET Data Provider for mySAP Business Suite?



I heard from a colleague that if my SQL Server has (for example) 5 users, if SQL does connect to SAP, it would require the user license of 5 more users?



If there any implications similar to this one with SAP?



Regards,

Joseph

View 1 Replies


ADVERTISEMENT

Microsoft .NET Data Provider For MySAP Business Suite

Apr 20, 2007

Is this product SAP Certified?



I have read somewhere that any integration technology wrt SAP has to be SAP certified.



If no, what are the implications of using this in a project? will SAP refuse to support the customer because they are using a non-SAP certified product?



regards,

Abhishek.

View 3 Replies View Related

X64 Version Of Microsoft .NET Data Provider For MySAP Business Suite

Jan 18, 2007

Hi everybody,

Does anyone know if there is a x64 version of the Microsoft .NET Data Provider for mySAP Business Suite for use with SSIS? On the SAP site, I found a librfc32.dll which works under x64, but the x86 SAP Connector can't use it.

Thanks
Hans

View 3 Replies View Related

Microsoft .NET Data Provider For MySAP Business Suite, PROPER Version ???

Apr 18, 2006

This is available at http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

Currently this is tagged as pre-release software. A preview version. When will a fully licensed version be available?

Also, has anyone used it? Any experiences to share???



Thanks

-Jamie

View 11 Replies View Related

.Net Framework Data Provider For MySAP Business Suite

Feb 18, 2008

I am pulling data out of SAP ECC 6 to MS SQL server 2005 from Task - Import data .Net Framework Data Provider for mySAP Business Suite

The data which I am getting out of SAP gets multiplied by 1000 i.e. Table CE1LSC0 has field VVQTY which is Quantity€¦
The value of quantity in SAP is 8.0 when I pull in by the aforesaid tool it come as 8000.00.

Do anyone has any idea what is going wrong, I even ask the basis guys to reinstall the Function module required for .Net Framework Data Provider for mySAP Business Suite in SAP.

I uninstalled .Net Framework Data Provider for mySAP Business Suite tool and reinstalled it but still I am encountering the same problem.

View 1 Replies View Related

Do We Have Any Driver For SAP BW Other Than Mysap Business Suite

May 19, 2008

this is my second post regarding this SAP Driver.

SAP-BW (source)
mdx
SQL Server DB (destination)

i tried to connect to SAP (we are using SAP Logon software to connect to SAP-BW) this application software is provided with SAP Connector an OLEDB Driver for SAP. i think programmatically we can connect and get data from SAP via mdx or Bex queries.

i need this has to be done with our SSIS Package.
is that possible in SSIS?

please give me some good news. i'm doing in circular path. programmatically i'm firing a mdx query and getting an xml from the dataset and feeding that xml to my SSIS package ino order to load the data in to sql server database.

View 5 Replies View Related

MySAP Business Suite ERROR: Table Class INTTAB Is Not Supported.

Sep 13, 2007

Hi there,

we collect data from SAP via the Data Provider for MySAP Business Suite.
Everything works fine for Standard objects like KNA1 etc. but if we try to read data from a custom table we get the following error:





Code Snippet

Fehler bei Get ZZEUSGRP_WA [SAP ZZEUSGRP_WA [1]]: Microsoft.Adapter.SAP.SAPManagedProviderException: Table class INTTAB is not supported.
bei Microsoft.Adapter.SAP.SAPSelectHandler.CheckResult(SAPTable returnTab)
bei Microsoft.Adapter.SAP.SAPSelectHandler.ExecuteSelect(SAPTable tabFields, SAPTable tabStruct_Tab....
The error message tells me not to use a specific table type. So far so good.
The question is: What would be the workaround? What should I tell the SAP team who cares for the data structures?

Thank you for your advice in advance
Fridtjof

View 1 Replies View Related

Microsoft .NET Data Provider V1.0 For SAP NetWeaver® Business Intelligence

Aug 24, 2006

Hello,

I am using the Microsoft .NET Data Provider v1.0 for SAP NetWeaver® Business Intelligence to connect to SAP BW queries. I have tried looking for documentation on the connection string arguments but have not had much success. My question is this: How do you specify the connection timeout in the connection string:

Connection string example: DataSource=http://mySAPNetweaverBIServer:8000/sap/bw/xml/soap/xmla?sap-client=020

Cheers

View 2 Replies View Related

Problem Connection With SAP R/3 With .NET Data Provider For MySap

Dec 14, 2007

I tried to connect to a SAP with the .Net data provider. Either in SSIS or in C# custom code (using SapConnection class) when I try to open the connection I receive a :

The operation could not be completed.
------------------------------
ADDITIONAL INFORMATION:
A procedure imported by 'GInvoker, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' could not be loaded. (Microsoft.Adapter.SAP.SAPProvider)
------------------------------
The specified procedure could not be found. (Exception from HRESULT: 0x8007007F)
------------------------------

I doesn't matter of the connection parameter (server, user, pwd, sysnr, etc). ; I can leave it blank or fill correctly the error occurs. I guess it is a missing dll...

On the machine where I do the tries THERE is the Sap Gui installed (with the librfc32.dll in windowssystem32)

Thanks
Sandro

View 3 Replies View Related

Sql Server 2005 (business Intelligence Development Suite ) Problem Installing Sql 2005 On Vista (vs 2008)

May 7, 2008

I installed sql server 2005 sp2 including business intelligence development suite , however I got a message
some client components not compablitable .This morning I searched my programs and found that I have new
visual studio 2005 on my computer (before I just had vs 2008) as well as business intelligence
developer (which does not work) It seems I I would like to get rid of vs 2005 also
fix business intelligence studio . Previously I deleted vs 2005 express off my computer........(I have vista
and I would only like to keep tools meant for sql standard 2005 reporting services etc
here is a list of my sql sp2 install package
By the way I doubled clicked sql_tools.msi and did not run as administrator
Does that make a difference? I wonder if this is a problem with vs 2008 and sql 2005......

Time: 05/06/2008 20:49:23.437
KB Number: KB921896
Machine: BILLPREC690
OS Version: Professional (Build 6000)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.00.1399.06 x86
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x86 STANDARD
Analysis Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x86 STANDARD
Reporting Services (MSSQLSERVER) ENU RTM 9.00.1399.00 x86 STANDARD
Notification Services ENU RTM 9.00.1399.00 x86 STANDARD
Integration Services ENU RTM 9.00.1399.00 x86 STANDARD
SQL Server Native Client ENU 9.00.3042.00 x86
Client Components ENU RTM 9.00.1399.06 x86 STANDARD
SQLXML4 ENU 9.00.1399.06 x86
Backward Compatibility ENU 8.05.1054 x86
Microsoft SQL Server VSS Writer ENU 9.00.1399.06 x86

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
SQLWriter Microsoft SQL Server VSS Writer Service 2700

**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 3010
Error Description :
----------------------------------------------------------------------------------
Product : Analysis Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixOLAP9_Hotfix_KB921896_sqlrun_as.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Reporting Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRS9_Hotfix_KB921896_sqlrun_rs.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Notification Services
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixNS9_Hotfix_KB921896_sqlrun_ns.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixDTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_sqlncli.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 3010
Error Description :
----------------------------------------------------------------------------------
Product : SQLXML4
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_sqlxml4.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 1054
Product Version (Final) : 2004
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlWriter.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------

**********************************************************************************
Summary
Success, Reboot Required
Exit Code Returned: 3010

View 2 Replies View Related

ODP.Net Vs. Microsoft Oracle Data Provider In SSRS

Oct 9, 2007



Which one is better to use? Is there a significant difference between the two?

Does someone have the directions to add ODP.Net to my database connections list in SSRS?

Thanks

View 1 Replies View Related

How To Connect ADODB With Microsoft SQL Server Compact 3.5 (.NET Framework Data Provider For Microsoft SQL Server Compact 3.5)

Sep 12, 2007

Hi
We are checking VB 9 (Orcas).

we connected to database created under with sql server 7. with this code

Public cn As New ADODB.Connection

Public Sub OpenDB()


cn.Open("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial catalog=Reservation;Data Source=.")

End Sub
this code worked well.
we know sql7 is not compatiable with vista. please tell us how to connect it wiith sql2005 . we downloaded orcas express edition beta. we created a database also. please let u know how to connect with Microsoft SQL Server Compact 3.5 (.NET Framework Data Provider for Microsoft SQL Server Compact 3.5).

Rgds
Pramod

View 7 Replies View Related

The 'Microsoft.Jet.OLEDB.4.0' Provider Is Not Registered On The Local Machine. (System.Data)

Oct 25, 2007

I am on an XP Pro 32-bit laptop, running SQL Server 2005 Developer Edition. I want to import an Excel spreadsheet into one of my databases using (formerly known as) DTS. The Excel spreadsheet was created in 2003 (I have Office 2007 installed on this laptop). Whenever I try and do any OleDb import, I get the error:

TITLE: SQL Server Import and Export Wizard
------------------------------
The operation could not be completed.
------------------------------
ADDITIONAL INFORMATION:
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine. (System.Data)
------------------------------
BUTTONS:
OK
------------------------------



I cannot install/reinstall MDAC because I have the latest version. What else can I try?

As additional information, I also get the error when trying to import anything into or export anything out of Access 2007. I'm pretty sure MDAC is awful, but I still need OleDb providers for much of the work I am doing.

View 6 Replies View Related

Any Solution? Cannot Initialize The Data Source Object Of OLE DB Provider Microsoft.jet.oledb.4.0 For Linked Server (null).

Jul 22, 2007

This is a problem that never get solved, sometime I can use other way to avoid it, but havn't found a solution yet, i hope I can get some more idea here.

I am using SQL 2005, when I run



select * into #import1
from OpenRowSet('microsoft.jet.oledb.4.0','Excel 8.0;hdr=yes;database=\ws8webjeff2.xls',
'select * from [jeff2$]')



I get

Cannot initialize the data source object of OLE DB provider "microsoft.jet.oledb.4.0" for linked server "(null)".



when I try to compile a SP with that statement in it, I get the same error, like



create stored procedure test

as begin

select * into #import1
from OpenRowSet('microsoft.jet.oledb.4.0','Excel 8.0;hdr=yes;database=\ws8webjeff2.xls',
'select * from [jeff2$]')

end



so it seems the error may not relate to the real file, since at the compile stage, it should not check the real file?



On my live db, after I restart the SQL service, the statement will work, after a while, one or several days, I get the same error again. I can not restart my live db quite often for sure, so now I have another backup db server, I need run the statement on the backup server and then read the data from there.



I have the same problem at two places, both use SQL 2005.



So far there are three questions

1, why it works after restart, but only last for a while? something about memory? since the backup db seldom need restart and work fine after many days.



2, why it gives error in compile stage?



3, why two dbs in different Enviroment has the same problem



The most answer I have gathered so far is permission issue, true I got similar error if the import file is located in a place which SQL has no right to access. But in this case, it should not be.



Any other idea or suggestion?



thanks

View 2 Replies View Related

Temporal Data And Implications

Oct 27, 2014

I'm working with a temporal database of inventory which is updated daily. It looks something like this: TableID ProductID InventoryValue DateAdded DateExpired

The DateAdded field is placed when the row is inserted & each time new information is evaluated, it is considered against this row. DateExpired is finally set when a new row comes to replace it with a change in information. That part works.The part that doesn't work is that often, my distributors will omit inventory as a way of specifying a 0 quantity value. So If I had 100 rows & now I have 95, this means that 5 are now out of stock. Considering the way that my db is set up, it's difficult to identify whether no change was made or if I did not receive the inventory value. How would you set it up such that this is a consideration?

View 1 Replies View Related

Business Objects And Microsoft Reporting Services

Jul 20, 2005

Hi,I am evaluating Microsoft Reporting Services against Business Objectsas a reporting tool against SQL Server. I am primarily a BOBJdeveloper and am finding RS not easy to use. Can anyone provide anyfeedback to the overall comparison between these 2 products as I amfinding RS frustrating and am wondering if it is just a matter ofre-adjusting and spending more time on it or if anyone else is findingRS more trickey to use than BOBJ as wellI would be extremely grateful for any feedback.Many thanks in advanceLA

View 1 Replies View Related

Business Intelligence Hardware Architechture For Microsoft

Dec 11, 2007

Hi,
I have a hardware configuration Question on microsoft BI components.
We have a BI solution which is END to END on Microsoft . It has:

1)SQL Server 2005 SP2 Database
2)SSIS
3)SSAS
4)SSRS
5)Excel 2007
6)WSS 3.0 (portal).

Can anyone tell me how to split the hardware for alll the components above. I mean which components can/should be kept together and what other should be residing on other widows servers so that the performance is imporved.

As of now i was thinking of having Database and SSIS on one server box and the SSRS and WSS on another box.

Please Suggest.

Thankyou

View 1 Replies View Related

Microsoft OLE DB Provider For DB2

Feb 13, 2008

Is this included with SQL Server 2005? If so; how do I go about setting this up? Thanks in advance!!

View 1 Replies View Related

Microsoft OLE DB Provider For DB2

Nov 7, 2005

The Microsoft OLE DB Provider for DB2 can be downloaded as a part of the SQL Server 2005 Feature Pack located at:

View 19 Replies View Related

How To Use The Microsoft OLE DB Provider For DB2.

Jan 26, 2007

I follow the steps:

1.In configure OLE DB Connection Manager dialog, I click New.

2.In Connection Manager dialog ,I choose Native OLE DBMicrosoft OLE DB Provider for DB2.

3.In Connection Manager dialog I click the "Data Links" button. Now I am on "Data link property" dialog. 

4.On connection tab, I enter fmdb for data source, which is my remote database name. On Network section I choose TCP/IP Connection and set the right IP/Port. Uncheck Single sign-on and enter the user and password. Then comes the Database section. Database name fmdb for Initial catalog,"fmdbrun" for Default Schema, then what is Package Collection?(My db2 database is in a AIX/RS 6000 box).

5.On advanced tab, I choose DB2/6000 for DBMS platform, ISO 8859-1 Latin-1(28591) for Host CCSID, and ANSI/OEM Simplified Chinese GBK(936) for PC Code page, then what's Default qualifer, I eft blank.

6. Then I switch back to "connection" tab, if I left "Package collection" blank and click "Test Connection" button,I got "Test connection failed because of an error in initializing the provider.- invalid parameter". If I use FMDBRUN(the default schema) for "Package collection" and click "Test Connection", I got "Test connection failed because of an error in initializing the provider. - The network connection was terminated because the host failed to send any data. SQLSTATE:08S01,SQLCODE:-605".

 

Anybody knows what's wrong.

View 24 Replies View Related

Microsoft OLE DB Provider For Oracle

Oct 26, 2000

Hi,

I issued the following set of statements against an Oracle 8.0.6 table linked to Microsoft SQL Server 7.0 (SP2):

BEGIN TRANSACTION
DELETE FROM ORACLE_DATABASE..SCHEMA1.TABLE1 WHERE COLUMN2=123.45
ROLLBACK TRANSACTION

and received the following message:

Server: Msg 7391, Level 16, State 1, Line 1
The operation could not be performed because the OLE DB provider 'MSDAORA' does not support distributed transactions.

I searched BOL and found this sentence:

To perform distributed transactions between SQL Server and Oracle, you must use Oracle version 8.0.4.1 or later.

What am I missing? Is there a higher version of Microsoft OLE DB Provider for Oracle that supports distributed transactions (we are using the one that comes with Microsoft SQL Server 7.0 installation)?

Maja

View 2 Replies View Related

Microsoft OLE DB Provider For DB2 (DB2OLEDB.DLL)

Mar 10, 2000

Anyone knows where I can find and install the above driver.
Trying to use Link Server from SQL 7.0 to access AS400 database using OLE DB option.
Urgent matter... Help!!!!

Have already tried to find and install this driver using SNA Client Software with out any success. SQL 7 does not come with this OLE DB drivers. Any idea where I can get it.

Thank you in advance....

View 1 Replies View Related

Microsoft Ole Db Provider For Odbc Drivers

Oct 18, 2007

I'm not able to see microsoft ole db provider for odbc drivers on sql server 2005. Anyone know which driver I should install to see it?
I'm trying to create a linked server from as400 to SS2K5.




http://www.sqlserverstudy.com

View 2 Replies View Related

Cannot Connect Using ADO With Excel Microsoft Jet Provider 4.0

Feb 15, 2007

Hi:

I have a vb 6 app that exports data from sql to excel. The user has the ability to select either local or server. When they select server, the connection string is modified to include the server name instead of the local msde instance to look like this:

"provider=sqloledb;data source=MyServer;initial catalog=MyDatabase;user id=UserX;password=PasswordX;database=MyDatabase"

I'm using Microsoft Jet Provider 4.0 and OpenDataSource.

SELECT * INTO TempXL FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=C: estxltest.xls;Extended Properties=Excel 8.0')...[Sheet1$]

This code works fine when user is accessing msde on local, but when using above DSN, I receive the following message:

"2147217900 - OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEdB.4.0' IDBInitialize:: Initialize returned 0x800040005: The provider did not give any information about the error.]

When I trace the connection, these error messages occur:

Failed to set proper user name ('NT AUTHORITYSYSTEM') for the connection

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'TblXMyTable' because this table does not exist in database 'master'. (State 42S02) (Code 4902)

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TblxMytable'. (State 42S02) (Code 208)

[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. The provider did not give any information about the error. (State 42000) (Code 7399)

[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.]. (State 01000) (Code 7300)

I am especially puzzled by the second message because I am specifying the database name in my connection string as:

"provider=sqloledb;data source=MyServer;initial catalog=MyDatabase;user id=UserX;password=PasswordX;database=MyDatabase"

I can read from the server copy and copy to Excel, but I cannot write back to SQL. Can someone please tell me what I'm doing wrong?

Thanks in advance for any help.,

















View 1 Replies View Related

Web Service Task With An Provider Different From Microsoft

Dec 5, 2007



Hello,

I have a web service contained in a apache tomcat server and I try to execute a webservice and store the result into a flat file.But I have a message saying me that there is an error in the xml document.
I suppose that it's my wsdl file.
But my wsdl file is fine!!!
Can the error come from the provider of the web service (Apache Tomcat).
I suppose that because in every example on the internet I didn't see an example an tomcat or other web server use.

View 1 Replies View Related

Microsoft OLE DB Provider For DB2 In SSIS Vs. ODBC In DTS

Jun 12, 2007

I finally made data transfer between AS400 and SQL2005 work by using Microsoft OLE DB provider for DB2. I have tried other methods, some do not have build-in destination, some have unicode conversion problem. The only issue I have with this method is the peformance. For example, 300,000 rows load from AS400 take only 3 minutes with the ODBC connection in DTS, but more than 5 minutes with the microsoft OLD DB provider for DB2 in SSIS.



Does anyone have the same issue or figured out any tweaking that may speed up the transfer?



Thanks.

View 20 Replies View Related

The OLE DB Provider Microsoft.Jet.OLEDB.4.0 Has Not Been Registered

Feb 13, 2007

Hi All,

I am getting the below error while executing the opendatasource statement

SELECT ParamName, ParamDate,ParamNumber,ParamChar

FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',

'Data Source= c: estcmdmiscCSTARIntegrationParameters.xls;Extended properties=Excel 8.0')...[CSTARIntegrationParameters$]

Error :

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered

Enviromnet :

Windows 2003 64 bit with SP1 and sql 2005 installed.

Same code is executing fine in my local machine which is XP 32 bit.

Can some one help me in resolving this issue.

Also when I tried to check the providers by expanding the linked servers node in the SQL server management studio . i couldnt found the provider for jet.



Regards,









View 46 Replies View Related

Microsoft OLE DB Provider For Visual FoxPro 9.0

Feb 27, 2007

Im quite interested to see if any one is using Microsoft OLE DB Provider for Visual FoxPro 9.0 in an SSIS package. Is it possible to use this for free table directory like you can with the ODBC driver. ????

thanks kindly



My basic proccess is as follows: The source foxpro database has hundreds of dbf files ---the SSIS procress is as follows

1: Copy only required dbf files and/or matching .fpt files over to local drive on SSIS box(we only need 10 files)

use MS Visual Foxpro ODBC driver (free table option) and set up a system DSN--dataflow tab---datareader source--and away you go

View 1 Replies View Related

Microsoft OLEDB Provider Oracle

Nov 23, 2006

Hi,

Previously i was using oracle8i with ssis.ssis was working fine.later i have upgraded 8i to oracle 9i.now when ever i try to establish a new connection using Microsoft OLEDB Provider for Oracle.i am getting the following error "Oracle error occurred, but error message could not be retrieved from Oracle" .but i am able to access the oracle 9i database thru pl/sql and toad. what could be the problem?

Thanks

Jegan.T

View 2 Replies View Related

Microsoft##EESS And MSDE SQL 2000 On Windows 2003 Small Business Server

Jan 25, 2007

Currently a server running 2003 small business operating system has MSDE 2000 and Microsoft##SSEE.

A memory problem exists with SQL consuming over 50% of RAM. Total RAM is 4GB.

There is a SQL 2000 patch for this type of problem. However, it calls for SQL to be upgraded to SP4.

Problem:
Can this MSDE 2000 be upgraded with SP4 and have memory patch applied with Microsoft##SSEE also on this box?



Please let me know. Thank you.

View 3 Replies View Related

Error :(provider: Named Pipes Provider, Error: 40 - Could Not Open A Connection To SQL Server) (Microsoft SQL Server, Error: 53)

Mar 1, 2007

Hi,

I am trying to connect to my SQL Server 2005 but it gave me following error message.




TITLE: Connect to Server
------------------------------

------------------------------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)



So, Please help me to solve this problem.



tnks.

View 20 Replies View Related

Microsoft OLE DB Provider For SQL Server Error '80004005'

Mar 2, 2004

Hi friends,

Can anyone help me in connecting sql server and asp.
Wheneever try to do the connection, I am getting following error. All the connection string which i am using are correct.

can you help me.

Following are the error line

----------------------------------------------------------------

Microsoft OLE DB Provider for SQL Server error '80004005'

Invalid connection string attribute

/MAsteringASP/global.asa, line 17

Microsoft OLE DB Provider for SQL Server error '80004005'

Invalid connection string attribute

/MAsteringASP/test2.asp, line 21
------------------------------------------------------

Please ckeck my code which I am using for connection


Thank you

Graceson MAthew

----------------------------------------------------------------
<%@ Language =VBScript %>
<% option explicit %>

<Html>
<head>
<title> Database Connection </title>
</head>
<body>
<%

<!-- #INCLUDE FILE="adovbs.inc" -->

dim conn
dim sql
dim r
dim aConnectionString

Set conn=Server.CreateObject("ADODB.Connection")

conn.Mode=adModeReadWrite
conn.Open="Provider=SQLOLEDB;UID=Administrator;Password=passw d;Initial Catalog=nrth;Datasource=server ip;Port Number= 80"


Response.Write (" Database Connectivity")

%>
</body>
</html>

View 10 Replies View Related

Microsoft OLEDB Provider Error (with SQL Server And ASP)

Mar 8, 2004

Dear all,

Still i am having problem with connecting sql server with ASP (Intranet).

Following is the code which i am using for the connection now,

Set conn=Server.CreateObject("ADODB.Connection")
conn.open "DSN=aspfirst;Uid=;PWD=;"


The error mesage , generated by this code is attached with this mail. Please check the attachment and hel me in the same


Graceson

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved