Logo

Advertisement

Cannot Initialize The Data Source Object Of OLE DB Provider

social.msdn.microsoft.com

When I try to run this SQL "Select * from� [GGSyncCSV]...[MerchoMasterInfo#CSV]",� I am getting the following error. � OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "GGSyncCSV" returned message "Unspecified error". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "GGSyncCSV". � The [GGSyncCSV] link server was created by following SQL statement a couple months ago. � EXEC master.dbo.sp_addlinkedserver @server = N'GGSyncCSV', @srvproduct=N'Jet 4.0', @provider=N'Microsoft.Jet.OLEDB.4.0', @datasrc=N'D:IntegrationGordonGotch', @provstr=N'Text' EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'GGSyncCSV',@useself=N'False',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL � GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'collation compatible', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'data access', @optvalue=N'true' GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'dist', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'pub', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'rpc', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'rpc out', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'sub', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'connect timeout', @optvalue=N'0' GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'collation name', @optvalue=null GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'lazy schema validation', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'query timeout', @optvalue=N'0' GO EXEC master.dbo.sp_serveroption @server=N'GGSyncCSV', @optname=N'use remote collation', @optvalue=N'true' � The SQL statement "Select * from� [GGSyncCSV]...[MerchoMasterInfo#CSV]" always returns the content of the CSV file until 2 days ago.�� � I like to ask: is there anything that causes OLE DB provider "Microsoft.Jet.OLEDB.4.0" not working properly? � Any possible solution for this issue? � Thanks.

View Answers
Very similar questions

Advertisement

Advertisement

How Can I Access Dbase? social.msdn.microsoft.com

Hi, I want to access dbase database, can anyone help? I try : SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Data Source=D:Account;Extended Properties=DBASE III;', TRANS.DBF) and I got the following message : OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Could not find installable ISAM.". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)". Thanks and I really appreciate any help joe

Linked Foxpro Tables In SQL2005 Reporting Services social.msdn.microsoft.com

� It worked before... Now even Domain admins get the error (Except on the server itself): � An error has occurred during report processing. (rsProcessingAborted) Query execution failed for data set 'getEmp'. (rsErrorExecutingCommand) Cannot initialize the data source object of OLE DB provider "VFPOLEDB" for linked server "tele". � � The link works fine in Management studio, and the designer.. Help Please!

Fresh SQL Server 2005 Giving Problem In Accessing Access 97 File Through Jet Ole DB Provider bytes.com

Problem:Jet 4.0 Ole DB Provider stops working the momemt SQL 2005 server is installed. Environmental steps: 1.Installed XP Sp2 2.Installed SQL 2005 Server with SP1 3.Trying to import data from an access 97 file Actual problem:The linked server gets created but when try to read data we get attached error The problem displayed is following [02/19/07 18:24:47]: Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "MGMTREPORTS". OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "MGMTREPORTS" returned message "Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.". Steps to recreate USE [master] GO EXEC sp_addlinkedserver @server = 'PROLMDB', @provider ='Microsoft.Jet.OLEDB.4.0' , @srvproduct ='OLE DB Provider for Jet', @datasrc = 'c:PRO_LM_DB.MDB' GO -- Set the DBF files' logins. EXEC sp_addlinkedsrvlogin @rmtsrvname = 'PROLMDB' , @useself = false , @locallogin = NULL , @rmtuser = NULL , @rmtpassword = NULL GO SELECT [TRACK_ID] , [EQUIP_ID] , [PROD_ID] , [SERIAL_NO] , [TOP_BOTTOM] , [START_TIME] , [END_TIME] , [TIME_STAMP] , [LMNC_NAME] , [Archive] , [PAGERID] , [ENDTIME_STAMP] , [PROD_NAME] FROM PROLMDB...TRACKDATA GO

SQL Reporting :: An Error Occurred During Local Report Processing Query Execution Failed forums.asp.net

i am new at reporting service things when i try to create a report i got this error and idea how to fix it An error occured during local report processing. An error has occured during report processing. Qery execution failed for dataset 'ds_testtablosu' Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MMDB"

Problem In Linked Server To Access social.msdn.microsoft.com

windows xp pro iis 5.0 office 2002 sql server express 2005 linked server: lkdb Provider: Microsoft.Jet.OLEDB.4.0 product: Jet 4.0 data source: d:db est.mdb provider string: Provider='Microsoft.Jet.OLEDB.4.0'; Jet OLEDB:System database='d:dbSecured.MDW';Data Source='d:db est.mdb';user id=rep; password=1234;; got error message: OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "lkdb" returned message "Could not find installable ISAM.". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "lkdb".

Linked Server Setup Error social.msdn.microsoft.com

I'm trying to link my local SQL 2005�with a remote�oracle database.�I have downloaded the oracle 10g client.� It seems the client installed a data source driver for me to use (Oracle in OraDb10g_home2).� I created a new data source named 'Company'�which I have successfully connecting using that driver.� � The following is the script I'm using to create my linked server: � USE master GO sp_addlinkedserver @server = 'Company', @provider = 'OraOLEDB.Oracle', @srvproduct = 'oracle', @datasrc = 'Company' GO sp_addlinkedsrvlogin @rmtsrvname = 'Company', @useself = 'false', @rmtuser = 'Company1', @rmtpassword = 'MyPassword' � These both execute successfully. � Then when I go to make a select call: SELECT * FROM OPENQUERY(Company, 'SELECT * FROM CAMPUS') � I get the following error: Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "OraOLEDB.Oracle" for linked server "Company" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "Company". � I think my proplem may be that this provider does not match with my data source.... Any ideas? �

Can't Connect To Oracle Dbase With SQL Server 2005 Express bytes.com

Hi, I'm attempting to connect to an Oracle database using SQL Server 2005 Express (OS is Windows XP Professional) and having absolutely no luck. Here is the information SQL Plus gives me about the database when I log in - Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production As you can see I have no problem connecting with the Oracle specific tools (SQL PLUS and PL/SQL Developer). I've tried creating a linked server with both the Microsoft provided OLE DB provider and the Oracle provider. With the Microsoft Provider I get the following error when attempting a query in the query edit window. OLE DB provider "MSDAORA" for linked server "ORACLE" returned message "Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.". Msg 7303, Level 16, State 1, Line 2 Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "ORACLE". When I try connecting withe Oracle provider I get the following - OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLETEST2" returned message "ORA-01017: invalid username/password; logon denied". Msg 7303, Level 16, State 1, Line 2 Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLETEST2". I've set the password up as a local to remote login mapping using the security page of the Linked Server property dialog. The username / password are definitely correct -- I used them to log in using SQL PLUS and PL/SQL Developer. I'm using an Oracle 9 client. PLEASE HELP !!!!! Thanks, Signed Frustrated

Linked Server Data Access Problem social.msdn.microsoft.com

Hi, � Here is the problem: � I have a server that is linked to two other servers.� The server I am linking has SQL Epress installed, whereas the servers I am linking to (and getting the data from) are enterprise versions of SQL.� I used the following code to link both the servers (changing the server name and the datasrc field) and both worked fine. � Code Block EXEC sp_addlinkedserver @ Server='SALEEN', @ srvproduct = 'SQL OLEDB Provider', @ provider = 'MSDASQL', @ datasrc = 'Debtsolv_Test' GO � EXEC sp_addserverlogin 'SALEEN', 'false', 'NULL', 'sa', '**********' � � One of the links is fine and I have no error messages when trying to access the data, but the second link throws this error when I attempt to get any data from the linked server: � Code Block OLE DB provider "MSDASQL" for linked server "SALEEN" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified". Msg 7303, Level 16, State 1, Line 3 Cannot initialize the data source object of OLE DB provider for "MSDASQL" for linked server "SALEEN". � � I am pretty new to SQL and am totally stumped!� If any one has any ideas I would be greatful. � Thanks � �

Run Openquery(mdx) Through A Linked Server social.msdn.microsoft.com

Hi, I run openquery() from a client application(sql 2005) to query SSAS data(sql 2005) through a linked server(sql 2005), but I get the following error: OLE DB provider "MSOLAP" for linked server "LINKEDMINING" returned message "An error was encountered in the transport layer.". OLE DB provider "MSOLAP" for linked server "LINKEDMINING" returned message "The peer prematurely closed the connection.". Msg 7303, Level 16, State 1, Procedure gettpdt, Line 3 Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "LINKEDMINING". And, I am sure that I have made the MSOLAP provider Allow inprocess. What can i do for this. Please advise.

Problem With Linking SQL 2005 To SQL 2000 Again social.msdn.microsoft.com

I have SQL Server 2005 on IA based server and SQL Server 2000 and I have to make linked server on SQL 2005. But I had an error: The OLE DB provider "SQLNCLI" for linked server "DENEB" reported an error. Authentication failed.Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "DENEB".OLE DB provider "SQLNCLI" for linked server "DENEB" returned message "Invalid authorization specification". (.Net SqlClient Data Provider). I searched Web for resolve this problem and find what i need run sql script instcat.sql for the Sql Server 2000. Script was saccesuful complete, but problem did not resolve. Please help me!

Advertisement

Error Running Openquery(mdx) Through A Linked Server social.msdn.microsoft.com

I'm trying to create linked server to access DMX functions from�SQL Server�as per: � Executing prediction queries from the relational server http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/3914.aspx I create the link this query EXEC master.dbo.sp_addlinkedserver @server = N'KLSSQL01AnalysisServerLink', @srvproduct=N'Analysis Services 2005', @provider=N'MSOLAP', @datasrc=N'kls-sql01', @catalog=N'AnalysisServicesPredictorPrototype' GO SELECT * FROM OPENQUERY(KLSSQL01AnalysisServerLink, 'select node_caption, node_type from [Misuse Abuse Profile].content') where [Misue Abuse Profile] is the Mining model Provider options: Allow in process I receive the follwing error: OLE DB provider "MSOLAP" for linked server "KLSSQL01AnalysisServerLink" returned message "An error was encountered in the transport layer.". OLE DB provider "MSOLAP" for linked server "KLSSQL01AnalysisServerLink" returned message "The peer prematurely closed the connection.". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "KLSSQL01AnalysisServerLink". I found this post but there was no resolution. run openquery(mdx) through a linked server http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=924869&SiteID=1

Import Excel Data Into Sql Express forums.asp.net

hi, i need to import excel data(2000 records) into sql server table. i did all possible ways. but still i am getting the error     OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Could not find installable ISAM.". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".   i used the query SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLdata.xls;Extended Properties=Excel 11.0',HDR=YES,Sheet1$)   and also SELECT * FROMOPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLdata.xls; Extended Properties=''Excel 11.0''')...[Sheet1$]   but no luck i have configured linked server through management studio express.   can any one suggest me how to achieve this. is there any easy way   Thanks

Link Server To An Access Database social.msdn.microsoft.com

Hello, � I am getting an error trying to select data from a Linked Server that is connected to a secured MS Access database.� I have entered the login and password for an admin in the sytem but I am still getting the error below.� It seems that all of the examples shown on the Online help are for unsecured databases.� Can anyone help me with this issue? � Thanks � Will � SELECT * FROM TMS_SECURED...Assignments � OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TMS_SECURED" returned message "You do not have the necessary permissions to use the '\FileSrv-05ProductionTMSTMS-DATA.mdb' object. Have your system administrator or the person who created this object establish the appropriate permissions for you.". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TMS_SECURED".

SQLNCLI Errors With Sql 2005 Linker Servers social.msdn.microsoft.com

Hi, I am trying to setup up a linked server in our test environment that allows Server A to run a stored procedure that writes to server B. However, I am receiving the following errors when attempting to make the connection and execute the stored procedure. OLE DB provider "SQLNCLI" for linked server "TEST2" returned message "Invalid authorization specification". Msg 7399, Level 16, State 1, Procedure Test_SP, Line 230 The OLE DB provider "SQLNCLI" for linked server "TEST2" reported an error. Authentication failed. Msg 7303, Level 16, State 1, Procedure Test_SP, Line 230 Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "TEST2". I've created a user (linkuser) that has db_reader/db_writer access to the destination box. I'm using SQL Server under the Server type on the General Tab. I've added the user(linkuser) as the local login to impersonate on the destination box. However, the stored procedure is still erroring. Any Suggestions? Thanks, J

FoxPro Linked Server www.sqlteam.com

Hi all, I'm having issues with a FoxPro linked server. I've set up a linked server to a FoxPro dbc using the Microsoft OLE DB Provider for Visual FoxPro. When I'm on Management Studio on my server the link appears to be working fine and a stored procedure I've created to get the indo from the dbc and put it into a temp table works fine. However, when I try to execute the sp on management studio on my local machine I get the following error: OLE DB provider "VFPOLEDB" for linked server "tern" returned message "Invalid path or file name.". Msg 7303, Level 16, State 1, Procedure usp_SSRS_007, Line 28 Cannot initialize the data source object of OLE DB provider "VFPOLEDB" for linked server "tern". And I also get a similar error when I try to test the connection of the linked server on my local machince. This is now driving me nuts , so many many thanks in advance for any help!!!

SQLExpress Linked Server To Oracle Express 10g social.msdn.microsoft.com

Trying to set up a development environment on an XP SP2 machine with an installation of SQLExpress and Oracle 10g Express.� Having been trying to create a Linked Server in SQL to access the Oracle EX database.� Have had no luck using either Oracle driver or Microsoft driver.� With Oracle driver get the following error on an openquery statement: select * from openquery(xe,'select top 1 * from HR.REGIONS') Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "OraOLEDB.Oracle" for linked server "xe" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "xe". I am mapping a Windows authenticated login to an Oracle login/password in the Linked Server setup.� I can connect to the Oracle database fine using Oracle tools.� Likewise, I can connect to SQL Server database just fine.� I have set up the linked server using the Oracle Service Name in the TSNAMES.ora file as the Data Source in SQL Server. ('XE')� What could I be doing wrong?� What else can I check? �

SQL 2005 FoxPro Issues!! social.msdn.microsoft.com

Hi all, I'm having issues with a FoxPro linked server. � I've set up a linked server to a FoxPro dbc using the Microsoft OLE DB Provider for Visual FoxPro. When I'm on Management Studio on my server the link appears to be working fine and a stored procedure I've created to get the indo from the dbc and put it into a temp table works fine. � However, when I try to execute the sp on management studio on my local machine I get the following error: � OLE DB provider "VFPOLEDB" for linked server "tern" returned message "Invalid path or file name.". Msg 7303, Level 16, State 1, Procedure usp_SSRS_007, Line 28 Cannot initialize the data source object of OLE DB provider "VFPOLEDB" for linked server "tern". � And I also get a similar error when I try to test the connection of the linked server on my local machince. � This is now driving me nuts, so many many thanks in advance for any help!!! �

Linked Server Issue social.msdn.microsoft.com

I am having trouble configuring a linked server.� I have a "master" server from which I run queries off of.� But, I am getting an authentication error on my destination server, and I can not figure out why.� If I put the sa password in the definition it connects, but I have over 80 servers, and I don't put my sa password in for any of those linked servers.� � I have checked my destination server, and I am an admin on that box. � Here is my query: � select DBName ,log_size ,log_space_used_percentage,status from OMAAW75N.DBATools.dbo.NiceLogSpaceUsed � Here is my error: � OLE DB provider "SQLNCLI" for linked server "OMAAW75N" returned message "Invalid authorization specification". Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "SQLNCLI" for linked server "OMAAW75N" reported an error. Authentication failed. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "OMAAW75N". � � Any suggestions? � �

Linking Access Tables Into SQL Server 2005 www.sqlteam.com

I am trying to add a linked table to my server, it is an access table. Here is the code i am using but i get an error: EXEC sp_addlinkedserver @server = 'AITdb_be2', @provider = 'Microsoft.Jet.OLEDB.4.0', @srvproduct = 'Access', @datasrc = '\kcapp03deptsCommonEIQAIT DBTestAITdb_be.mdb' GO -- Set up login mapping using current user's security context EXEC sp_addlinkedsrvlogin @rmtsrvname = 'AITdb_be2', @useself = 'false', @rmtuser = 'Admin', @rmtpassword = '' GO -- List the tables on the linked server EXEC sp_tables_ex 'AITdb_be2' GO ERROR: OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "AITdb_be2" returned message "The Microsoft Jet database engine cannot open the file '\kcapp03deptsCommonEIQAIT DBTestAITdb_be.mdb'. It is already opened exclusively by another user, or you need permission to view its data.". Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "AITdb_be2".

Access Linked Server: Works In SQL2000 But Not SQL2005 social.msdn.microsoft.com

I am runing Windows 2003 which has both SQL2000 and SQL2005.� � The following works in 2000 but not 20005 � � Code Snippet DECLARE @sql nvarchar(4000) set @sql = 'sp_addlinkedserver @server = N''dbAccessPO'', @provider = N''Microsoft.Jet.OLEDB.4.0'', @srvproduct = N''OLE DB Provider for Jet'', @datasrc = N''C:Temppopts.mdb''' exec sp_executesql @sql set @sql = 'sp_addlinkedsrvlogin ''dbAccessPO'', FALSE, ''sa'', ''Admin'', NULL' exec sp_executesql @sql � � Running this: � Code Snippetselect * from dbAccessPO...MyTable � � Produces this error: � Code Snippet OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "dbAccessPO" returned message "Unspecified error". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "dbAccessPO". � � I login using sa for both instances. � I could really use your help. � Thanks.

Very-NewBie Linked Server Problem social.msdn.microsoft.com

I'm having a problem selecting from an Excel linked server... � 1. Create a new simple Excel file at C:DeleteMe.xls and add a couple column headers and a row of data. e.g. � -------------- ColA | ColB | -------------- 123 �| 456� | ------------- � 2. Execute the following command in SQL Server 2005 Management Studio... � EXEC sp_addlinkedserver ������� @server = 'ExcelSource', ������� @srvproduct = 'Excel', ������� @provider = 'Microsoft.Jet.OLEDB.4.0', ������� @datasrc = 'Database=C:DeleteMe.xls', ������� @provstr = 'Excel 5.0' � select * from ExcelSource...[Sheet1$] � If you're like me, you'll get the following error: � Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "ExcelSource" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "ExcelSource". � � Does anyone have a solution? � THANKS in advance.

Export Data From Excel Into An Existing SQL Table www.sqlteam.com

Hi everyone, I am new with SQL and I tried to use the code below to export data from Excel into an existing SQL table, but I keep on receiving the following message. Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)". To export data from Excel to existing SQL Server table, Insert into dbo.Base_Intraday Select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:Shortcuts6 - Bolsa de Valores1 - Bolsa de Valores - Bovespa;HDR=YES', 'SELECT * FROM [Link$]') Can anyone help me on this? Thanks

Need Help Importing Data From Excel To My SQL Database bytes.com

Hey guys, I am trying to import data from an Excel spreadsheet into my SQL database. I am running SQL 2005. I following Microsoft's instructions for creating a linked server, and it appeared to work. However when I run this query: SELECT * INTO test FROM OPENQUERY(EFORMS, 'SELECT * FROM [Form Tracker Baseline$]') I get the following error: The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "EFORMS" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "EFORMS". Test is the table that will receive the imported data. Eforms is the name of my linked server, and Form Tracker Baseline is the worksheet name. The error sounds like it can not locate my spreadsheet. Any ideas why I am getting this message? Is there an easier way to do this import? Thanks,

SSIS Import Wizard Does Not Recognize The Excel Format social.msdn.microsoft.com

I have an Excel file(.xls) that I need to import to SQL Server database. I am trying to use the Import wizard. However, when I select the file and click next I get the warning "External table is not in the expected format.(Microsoft JET Database Engine)" .�I opened the .xls file using a text editor. It looks like�some html document. � <html xmlns="urnchemas-microsoft-comfficeffice" xmlns:x="urnchemas-microsoft-comffice:excel" xmlns="http://www.w3.org/TR/REC-html40"> <head>................. � I also used OPENQUERY to see if it works. � SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0 xml;HDR=Yes;Database=C:myexcelfile.xls', 'SELECT * FROM [Table1$]'); � SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:datamyexcelfile.xls', 'SELECT * FROM [Table1$]') � I get the following errors.� OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "External table is not in the expected format.". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)". � Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)". � When I open the file and save it to overwrite the existing .xls file it works fine. � Is there a way to import such�files using SSIS without having to open�and save it? � Thanks in advance! � Tkaram

Linked Server Setup www.sqlteam.com

I am trying to set up a liked server using the UI in Management studio. In the Object Explorer I can see the server i want to link to MyServer2 and I have connected to it. I goto to the server in which i want to create the link MyServer1 and click on Server Objects then Linked Servers, New Linked Server. In the server name I enter the server I want to link to, MyServer1. I don't know what to enter or where after that? What else do i need to set up? When i try this select i get the following error. select * from MyServer1.MyDB.dbo.MyTable Error: Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "SQLNCLI" for linked server "MyServer1" reported an error. Authentication failed. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "MyServer1".

Inconsistent Linked Server Query Results social.msdn.microsoft.com

Hello, I have a linked server�named 'Charlie_File'�to an Excel Workbook that I set up in SQLServer 2005 Management Studio. The workbook is on my local C drive. Sometimes, I get the results back that I expect when I run the following query; SELECT * FROM OPENQUERY(Charlie_file, 'SELECT * FROM [Feb$]') Sometimes, on subsequent runs of the above query, I get the following message; Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "MSDASQL" for linked server "Charlie_file" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "Charlie_file". There seems to be about a minute or so of a delay before the query will run correctly on subsequent attempts. Is there a connection issue here where a connection blocks subsequent attempts to select the data within a specific time span? Thank you for your help! cdun2

Problems Trying To Insert Data Into The Database Using Excel social.msdn.microsoft.com

� Hi all, � I have encountered a problem. In the past i run a sql query to select all the data from the excel file and insert them into my SQL database. However recently i encountered an error when i run the query. � Msg 7399, Level 16, State 1, Line 4 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "excel_ls" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 4 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "excel_ls". � How i solve this error. Any ideas? � � Thanks

OLE DB Connection Error; Provider Becomes Unavailable To Linked Server social.msdn.microsoft.com

We have a SQL2005 server install running on a Win2003 Server.� It has a linked server to iHistorian using the iHOLEDB provider for iHistorian. Randomly and after a few execution to this provider, we start getting errors Msg 7303, Level 16, State 1, Line 2 Cannot initialize the data source object of OLE DB provider "IhOLEDB.iHistorian" for linked server "fspheafhs1".I created a data source in VS2005 for BI on the SQL server using the iholedb provider.� This was successful.� However, all queries or OPENQUERY statements to the linked server fail.� This seems to continue until SQL Server is restarted. Does anyone know how to reset a provider in SQL Server or tell if the SQL Server is having trouble with the provider?� There are no message in the SQL Error Log. Again the provider continues to work outside of SQL Server, but no longer can be accessed from within SQL Server. Thanks in advance.

Oracle Linked Server Connection Error After Upgrading To SQL 2005 social.msdn.microsoft.com

Hello all. I upgraded a SQL 2000 installation to SQL 2005 this past weekend. Minimal issues overall, but one that did crop up relates to a linked server to an Oracle database. The linked server worked before the upgrade, and stopped working immediately after. We're running on Windows 2003 x64, latest service pack. The linked server is set up using the MSDAORA provider. The error I'm getting post-upgrade is: ===================== OLE DB provider "MSDAORA" for linked server "PROD" returned message "ORA-06413: Connection not open.". Msg 7303, Level 16, State 1, Procedure RDM_GET_REP_LIST_SP, Line 12 Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "PROD". ===================== A tnsping from the server works fine.�I've also tried recreating the linked server. Any help would be appreciated. Let me know what other information would be useful. Thanks, Adam

Reg: Export Excel 2003 To Sql Server 2005 www.sqlteam.com

I want to export Excell 2003 to Sql Server 2005. I am having the following error while execute the query. declare @SQL varchar(8000) create table #temp(i int identity(1,1),SiteName varchar(100),SiteDescription varchar(5000),SiteURL varchar(500),CategoryName varchar(200)) set @SQL='Insert into #temp Select * From OPENROWSET (''Microsoft.Jet.OLEDB.4.0'',''Excel 8.0;Database=' + 'a.xls' +';HDR = YES;IMEX=0'',''SELECT * FROM [Sheet1$]'')' exec (@SQL) The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)". I need a solution urgently. help Pls

Can Not Access Excel File Using OpenRowset social.msdn.microsoft.com

� I am using SQLServer 2005 SP2. I enabled the� Ad Hoc Distributed Queries� and DisallowAdhocAccess registry option is explicitly set to 0. Query is working fine when I remote desk to the server and execute when I run same query from my workstation I am getting following error � Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)". � Any help is appreciated. Thanks -- Farhan �

Linked Server Using Microsoft.Jet.OLEDB.4.0 Problem social.msdn.microsoft.com

Hi all, I'm using following code to create linked server and then access data EXEC sp_addlinkedserver N'XLS', 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', 'C:DataProdukthierachie.xls', NULL, 'Excel 5.0;' EXEC sp_addlinkedsrvlogin N'XLS', FALSE, NULL, Admin, NULL SELECT�*�FROM XLS...SWProdukthierachie$ When executing the select statement I get following error message OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "XLS" returned message "Unspecified error". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "XLS". Strange�is that when I run this code on�dev machine it works fine. But when I try to execute it on my�second (pilot)�machine it ends with the error message posted. I'm not a admin on the pilot machine so I don't know it's exact configuration but I'm beeing assured that the only difference is that on pilot machine there is no Visual Studio installed. I'm running SQL Server 2005 9.0.1399. Could anyone give me some hints? Thx fleshi

OpenRowSet And OpenDataSource Fail On Production To Open Excel Data social.msdn.microsoft.com

The following statement fails when using SQL Analyzer under sa but works on all of our development and staging server.� All are SQL Server 2005 SP1.� We upgraded production over the weekend from SQL Server 2000, creating a new instance machinenameSQL2005. SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=d:data est.xls', 'SELECT * FROM [Sheet1$]') The error we are getting only in prodcution is: OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)". Any help seriously appreciated, � Tronn

Import From Excel To Sql social.msdn.microsoft.com

Hii I want to import data from excel�2003 �to sql.(sql server 2005). i am using windows xp. when i am using the code i get the error. the code is : SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 11;Database=D:BAESystemsTest_Log.xls;HDR=YES','Select * From [Sheet1$]') � � The error is : OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Could not find installable ISAM.". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)". � please get me out of this trouble.

Any Idea Why OpenRowSet To Open Excel File Doesn't Work Well In SQL 2005? social.msdn.microsoft.com

Maybe it worked once, but in most time it doesn't work, query like below � select top 10 * ��� from OpenRowSet('microsoft.jet.oledb.4.0','Excel 8.0;hdr=yes;database=\ws8webablefilessitefiles4000010 eibcactive.xls', 'select * from [crap2$]') I got error OLE DB provider "microsoft.jet.oledb.4.0" for linked server "(null)" returned message "Unspecified error". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "microsoft.jet.oledb.4.0" for linked server "(null)". but the same query can run without any problem on a SQL 2000 server run on a server in the same network. Any idea?

OLE DB Provider For ODBC And Oracle bytes.com

Hi, I created a linked server for MS SQL Server 2005 Express to an Oracle database using the OLE DB Provider for ODBC. My ODBC Source uses the Microsoft ODBC for Oracle driver. I'm using the OLE DB Provider for ODBC instead of the Oracle OLE DB providers because those don't handle Oracle's Numeric Data Type well. When I set this up yesterday it worked fine. However I log in today and attempt to run sp_tables_exec against my linked server and get the following OLE DB provider "MSDASQL" for linked server "WHATEVER" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "WHATEVER" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "WHATEVER" returned message "[Microsoft][ODBC driver for Oracle][Oracle]". Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "WHATEVER". I can tnsping the server, and I have no trouble connecting with the Oracle OLE DB provider I try to set up ODBC logging but the log file is blank -- same with attempting to set up logging for Oracle's network client. I've been dealing with crap like this the last 4 days, something works one day, then the next nothing (I've done nothing to change the configuration between these outages). Can anyone help me? Thanks Frustrated

Recurring Issue - OPENROWSET For Excel Query Stops Working , Cured By Restart Of SQL Server social.msdn.microsoft.com

Hi, � I am having a recurring issue that involves a stored proc using OPENROWSET to query an excel file. I used the surface area config to enable this on the server, and made sure that is still set. After an undetermined amount of time, the OPENROWSET query starts failing with this message: OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)". I corrected this previously by restarting the SQL server, but not before I checked permissions, the excel file itself, etc, and that was the last thing to try. I am using SQL 2005 with SP1 installed - my primary approach to tackling this issue is to install the SP2, but I did not find this bug referenced in the fixes, and was wondering if anyone else had further insight. Thanks, Darrell Young

&&"Could Not Find Installable ISAM&&" social.msdn.microsoft.com

Hi, when l use the ADO.NET with the following query, SELECT * INTO XLImport5 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C: estxltest.xls', 'SELECT * FROM [Customers$]')i get the following error, i.e.Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query "SELECT * INTO XLImport5 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C: estxltest.xls', 'SELECT * FROM [Customers$]')" failed with the following error: "Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Could not find installable ISAM.".". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.Task failed: Execute SQL TaskAny idea, what's wrong?Regards,YB Lim

EIX000: (-329) Database Not Found Or No System Per www.sqlteam.com

I am creating a linked sever from Informix server to SQL server 2005. And it is giving me the error of database not found or no system permission error. While my DSN is working find and test connection successed what could be the reason ? can any body help. below is the error Cannot initialize the data source object of OLE DB provider "Ifxoledbc" for linked server "LIBRARY". OLE DB provider "Ifxoledbc" for linked server "LIBRARY" returned message "EIX000: (-329) Database not found or no system permission.". (Microsoft SQL Server, Error: 7303)

Access Linked Server social.msdn.microsoft.com

� I have created a Linked Server to an Access DB on a Novell 6.5 server.� The Windows 2003 server with SQL 2005 Server on it is logged in as a Novell user with appropriote rights to the folder where the mdb is stored.� The mdb is unsecured. � EXEC sp_addlinkedserver �� @server = 'JetShowData', �� @provider = 'Microsoft.Jet.OLEDB.4.0', �� @srvproduct = 'OLE DB Provider for Jet', �� @datasrc = 'k:groupssalesshowfiles2007 Show.mdb' I have successfully created the link and queried the mdb while logged into SQL as Administrator using Windows Autentication.� I have set up permissions for another SQL user account (I think) to use the linked server?�� I have added the linked server login as folllows: � sp_addlinkedsrvlogin 'JetShowData', false, NULL, 'Admin', NULL � This should allow any user to access the linked server.� I did try adding a login for a specific SQL user account (sp_addlinkedsrvlogin 'JetShowData', false, 'cbonallo', 'Admin', NULL) but that did not make any difference. � The error I am getting when I try to either test the connection or run a query is the same one I was getting when I had the MSSQLSERVER service running under a local account( I had to change is so that SQLSERVER had network access rights): � TITLE: Microsoft SQL Server Management Studio ------------------------------ "The test connection to the linked server failed." ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "JetShowData" reported an error. Authentication failed. Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "JetShowData". OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "JetShowData" returned message "Cannot start your application. The workgroup information file is missing or opened exclusively by another user.". (Microsoft SQL Server, Error: 7399) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3027&EvtSrc=MSSQLServer&EvtID=7399&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ This Access db does not have a workgroup file becasue it is unsecured.� This error is being reported incorrectly since it is the exact same one when SQL did not have permissions to access the network.� I also tried it from another Windows Autenticated user account and got this message: � TITLE: Microsoft SQL Server Management Studio ------------------------------ "The test connection to the linked server failed." ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "JetShowData". OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "JetShowData" returned message "Unspecified error". (Microsoft SQL Server, Error: 7303) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3027&EvtSrc=MSSQLServer&EvtID=7303&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ � � I'm thinking I need to somehow I need to give the user account�network access rights, too??� Or some other permissions?� Any help will be greatly appreciated!! � Cory Bonallo Retail Services Developer � � �

Permissions For Network Services social.msdn.microsoft.com

I have created a Linked Server to an Access DB on a Novell 6.5 server. The Windows 2003 server with SQL 2005 Server on it is logged in as a Novell user with appropriote rights to the folder where the mdb is stored. The mdb is unsecured. EXEC sp_addlinkedserver @server = 'JetShowData', @provider = 'Microsoft.Jet.OLEDB.4.0', @srvproduct = 'OLE DB Provider for Jet', @datasrc = 'k:groupssalesshowfiles2007 Show.mdb' I have successfully created the link and queried the mdb while logged into SQL as Administrator using Windows Autentication. I have set up permissions for another SQL user account (I think) to use the linked server? I have added the linked server login as folllows: sp_addlinkedsrvlogin 'JetShowData', false, NULL, 'Admin', NULL This should allow any user to access the linked server. I did try adding a login for a specific SQL user account (sp_addlinkedsrvlogin 'JetShowData', false, 'cbonallo', 'Admin', NULL) but that did not make any difference. The error I am getting when I try to either test the connection or run a query is the same one I was getting when I had the MSSQLSERVER service running under a local account( I had to change is so that SQLSERVER had network access rights): TITLE: Microsoft SQL Server Management Studio ------------------------------"The test connection to the linked server failed." ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "JetShowData" reported an error. Authentication failed. Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "JetShowData". OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "JetShowData" returned message "Cannot start your application. The workgroup information file is missing or opened exclusively by another user.". (Microsoft SQL Server, Error: 7399) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3027&EvtSrc=MSSQLServer&EvtID=7399&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ This Access db does not have a workgroup file becasue it is unsecured. This error is being reported incorrectly since it is the exact same one when SQL did not have permissions to access the network. I also tried it from another Windows Autenticated user account and got this message: TITLE: Microsoft SQL Server Management Studio ------------------------------"The test connection to the linked server failed." ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "JetShowData". OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "JetShowData" returned message "Unspecified error". (Microsoft SQL Server, Error: 7303) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3027&EvtSrc=MSSQLServer&EvtID=7303&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ I'm thinking I need to somehow I need to give the user account network access rights, too?? Or some other permissions? Any help will be greatly appreciated!! Cory Bonallo Retail Services Developer

SQL 2005 Express &&amp; Oracle 10g Linked Server social.msdn.microsoft.com

Hi all, I am trying to access an Oracle DB from SQL server. My environment: - Windows 2000 - SQL 2005 Express - Oracle 10g & Client & Oracle Provider for OLD DB 10.2... - MDAC 2.8 I linked Oracle from within SQL Management studio. When I try to access Oracle tables I get the error "Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle.1" for linked server......" I test the connection to Oracle via OraOLEDB.Oracle.1 using a UDL file and the connection is successful. � *** I posted the same thread to Oracle forum but I didn't get any reply *** Any ideas what is wrong ?? �

Linked Server Error social.msdn.microsoft.com

HI � I have win 2003 64 sp2 SQL 2005 sp2.� I downloaded an informix 64bit driver 3.00FC�then set system dsn which works fine when i apply and test the connection. � I tried to create a new linked server using Microsoft OLE simple provider against the odbc when I get this error � Does anyone have any suggestions?? � � Many thanks � � Robert � � TITLE: Microsoft SQL Server Management Studio ------------------------------ "The test connection to the linked server failed." ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Cannot initialize the data source object of OLE DB provider "MSDAOSP" for linked server "CERP". (Microsoft SQL Server, Error: 7303) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3186&EvtSrc=MSSQLServer&EvtID=7303&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------

MS OLE DB For ODBC With Oracle ODBC Source Headaches bytes.com

Hi all, I am having trouble getting linked Oracle 9 server in MS SQL Server 2005 Express to work properly. My machine is running Windows XP. The Microsoft and Oracle OLE DB Providers have problems dealing with Oracle's Numeric Data Type, so I decided to use Microsoft's OLE DB for ODBC Provider and an Oracle ODBC source. When using the Microsoft ODBC for Oracle Driver in my ODBC source I have inconsistent behavior. Sometimes my queries are processed properly, then other times I get the following error OLE DB provider "MSDASQL" for linked server "ODBCBEAST" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "ODBCBEAST" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "ODBCBEAST" returned message "[Microsoft][ODBC driver for Oracle][Oracle]". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "ODBCBEAST". I have no idea why sometimes I can connect to the linked server with no problems and why other times it performs like this. I'm not changing anything about the system I can think of. When I use an Oracle client (PL/SQL) I have absolutely no problems connecting. TNSPING returns that the connection is good. This is unacceptable so I decided to try my luck with the Oracle 10g ODBC driver. However when I use this and perform an openquery select against the linked server I get back only 11 rows, when I know that the database has over 100 rows (in fact when using the Microsoft ODBC driver and it works that's what I get). I figured maybe the buffer setting needed to be raised in the ODBC configuration so I took it from 64000 to 600000 (a magnitude of 10) but I still get back only 11 rows. I'm at my wit's end. Any suggestions on resolving one or the other problem would be much appreciated. Thanks much

Linked Server To Access 97 Problems - HELP! forums.databasejournal.com

I am trying to configure a linked server to a local Access database with no security and only one table. I set it up and tested on a test machine first and all works fine. I then did the same on our production box and receive the error below. Server: Msg 7303, Level 16, State 2, Line 1 Could not initialize data source object of OLE DB provider 'Microsoft.Jet.OLEDB.4.0'. [OLE/DB provider returned message: Not a valid account name or password.] I then set it up on another production box and it worked for a while but now I get a different error. Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. [OLE/DB provider returned message: Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.] Is there a server level setting that could be different on these machines that could be causing this?

Reporting Service Vfpoledb Problem social.msdn.microsoft.com

We have a vfp free table directory linked to our SQL 2005 server called tele select * from tele...employee runs in Management studio we have a test report designed in BIDS that uses this query. The report runs on the server. On other machines, loged in as domain admin we get this error: An error has occurred during report processing. Query execution failed for data set 'cnj'. Cannot initialize the data source object of OLE DB provider "VFPOLEDB" for linked server "tele". the vfpoledb provider is set to allow inprocess...

Could Not Find Installable ISAM www.sqlteam.com

I'm new here and this is my first post. I am not sure if this is the right place for me to post this problem but I really need your help guys. I've been looking for a solution of this problem for almost a week now. I'd googled a lot but of no result. What I want to do is to import records from access 2000 database to SQL 2005 Express. I use the following statement to import records: SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Data Source="D:SamplesMydatabase.mdb";User ID=Admin;JET OLEDB:Database Password=mypass', 'tblTab1') The following error shows: Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)". I dont know if the statement is correct or I am missing something. I had reinstalled my MS Access but this does not help either. By the way I'm using Access 2003 and my database is 2000 access version. Hope somebody can help me get out of this. thanks, bodjo

Why Can't T-sql Access An Oracle Database When VB6 Can? social.msdn.microsoft.com

� Hi all, SQL Server 2005 SP2 Windows XP Pro SP2 Oracle 10g Client 10.2 Oracle Data Access Components 10.2 VB6 Oracle Rdb 7.1 (not Oracle RDBMS). � I trying to access a remote Oracle Rdb database via a linked server in SQL Server 2005�management studio but having no luck.��The remote database is accessed via an�Oracle alias in TNSNAMES.ORA called my_oledb (see below) and I know it works ok becuase �I'm able to access the remote database via VB6 (ADODB) using a very simple app whose connection string looks like this... � con.ConnectionString = "Provider=OraOLEDB.Oracle.1;User ID=someusername; Password=topsecret;Data Source=my_oledb" � I got this example VB appication off the net but have to admit I'm not sure of the difference between OraOLEDB.Oracle.1 & OraOLEDB.Oracle. � The alias in TNSNAMES looks like this... � my_oledb = �(DESCRIPTION = ��(ADDRESS_LIST = ���(ADDRESS = (PROTOCOL = TCP) (Host = spike) (Port = 1527)) �) ��(CONNECT_DATA = (SERVICE_NAME = oci_oledb) �) ) � I can also TNSPING this alias without any probems. � My SQL server linked server is setup as follows. � exec sp_addlinkedserver @server = 'MFP2', @srvproduct='Oracle', @provider = 'OraOLEDB.Oracle.1', @datasrc = 'my_oledb' � � � exec sp_addlinkedsrvlogin @rmtsrvname='MFP2', @useself='false', @locallogin='sa', @rmtuser='******', @rmtpassword='******' � Using both openquery and four part naming (?) I get the following errors � � � select job_title from mfp2...jobs OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2" returned message "ORA-01017: invalid username/password; logon denied". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2". � There are no schemas in the Oracle database so I've just used three dots between the linked server and the table name. Again I know this syntax works becuase I have used it sucessfully with ODBC drivers. � select * from openquery(mfp2,'select * from jobs') OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2" returned message "ORA-01017: invalid username/password; logon denied". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2". � The passwrods are correct on the Oracle database as these are the ones used in the VB6 application. � Trying to expand the catalogue also causes management studio to hang. � Anyone spot the obvious mistake? � I did read on the net a while ago that registry entries might be rquired on the PC/server, is this still necessary? � Thanks in advance � Dave

Why Can't T-SQL Access Oracle DB When VB6 Can? www.sqlteam.com

Hi all, SQL Server 2005 SP2 Windows XP Pro SP2 Oracle 10g Client 10.2 Oracle Data Access Components 10.2 VB6 Oracle Rdb 7.1 (not Oracle RDBMS). I trying to access a remote Oracle Rdb database via a linked server in SQL Server 2005 management studio but having no luck. The remote database is accessed via an Oracle alias in TNSNAMES.ORA called my_oledb (see below) and I know it works ok becuase I'm able to access the remote database via VB6 (ADODB) using a very simple app whose connection string looks like this... con.ConnectionString = "Provider=OraOLEDB.Oracle.1;User ID=someusername; Password=topsecret;Data Source=my_oledb" I got this example VB appication off the net but have to admit I'm not sure of the difference between OraOLEDB.Oracle.1 & OraOLEDB.Oracle. The alias in TNSNAMES looks like this... my_oledb = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = spike) (Port = 1527)) ) (CONNECT_DATA = (SERVICE_NAME = oci_oledb) ) ) I can also TNSPING this alias without any probems. My SQL server linked server is setup as follows. exec sp_addlinkedserver @server = 'MFP2', @srvproduct='Oracle', @provider = 'OraOLEDB.Oracle.1', @datasrc = 'my_oledb' exec sp_addlinkedsrvlogin @rmtsrvname='MFP2', @useself='false', @locallogin='sa', @rmtuser='******', @rmtpassword='******' Using both openquery and four part naming (?) I get the following errors select job_title from mfp2...jobs OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2" returned message "ORA-01017: invalid username/password; logon denied". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2". There are no schemas in the Oracle database so I've just used three dots between the linked server and the table name. Again I know this syntax works becuase I have used it sucessfully with ODBC drivers. select * from openquery(mfp2,'select * from jobs') OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2" returned message "ORA-01017: invalid username/password; logon denied". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2". The passwrods are correct on the Oracle database as these are the ones used in the VB6 application. Trying to expand the catalogue also causes management studio to hang. Anyone spot the obvious mistake? I did read on the net a while ago that registry entries might be rquired on the PC/server, is this still necessary? Thanks in advance Dave

Why Can't T-SQL Access Oracle DB When VB6 Can? social.msdn.microsoft.com

� Hi all, SQL Server 2005 SP2 Windows XP Pro SP2 Oracle 10g Client 10.2 Oracle Data Access Components 10.2 VB6 Oracle Rdb 7.1 (not Oracle RDBMS). � I trying to access a remote Oracle Rdb database via a linked server in SQL Server 2005�management studio but having no luck.��The remote database is accessed via an�Oracle alias in TNSNAMES.ORA called my_oledb (see below) and I know it works ok becuase �I'm able to access the remote database via VB6 (ADODB) using a very simple app whose connection string looks like this... � con.ConnectionString = "Provider=OraOLEDB.Oracle.1;User ID=someusername; Password=topsecret;Data Source=my_oledb" � I got this example VB appication off the net but have to admit I'm not sure of the difference between OraOLEDB.Oracle.1 & OraOLEDB.Oracle. � The alias in TNSNAMES looks like this... � my_oledb = �(DESCRIPTION = ��(ADDRESS_LIST = ���(ADDRESS = (PROTOCOL = TCP) (Host = spike) (Port = 1527)) �) ��(CONNECT_DATA = (SERVICE_NAME = oci_oledb) �) ) � I can also TNSPING this alias without any probems. � My SQL server linked server is setup as follows. � exec sp_addlinkedserver @server = 'MFP2', @srvproduct='Oracle', @provider = 'OraOLEDB.Oracle.1', @datasrc = 'my_oledb' � � � exec sp_addlinkedsrvlogin @rmtsrvname='MFP2', @useself='false', @locallogin='sa', @rmtuser='******', @rmtpassword='******' � Using both openquery and four part naming (?) I get the following errors � � � select job_title from mfp2...jobs OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2" returned message "ORA-01017: invalid username/password; logon denied". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2". � There are no schemas in the Oracle database so I've just used three dots between the linked server and the table name. Again I know this syntax works becuase I have used it sucessfully with ODBC drivers. � select * from openquery(mfp2,'select * from jobs') OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2" returned message "ORA-01017: invalid username/password; logon denied". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle.1" for linked server "mfp2". � The passwrods are correct on the Oracle database as these are the ones used in the VB6 application. � Trying to expand the catalogue also causes management studio to hang. � Anyone spot the obvious mistake? � I did read on the net a while ago that registry entries might be rquired on the PC/server, is this still necessary? � Thanks in advance � Dave � � � � � � � � � �

Cannot Connect Using ADO With Excel Microsoft Jet Provider 4.0 social.msdn.microsoft.com

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., � � � �

Linked Server Excel Import Doesn't Work In Vista social.msdn.microsoft.com

I was using linked servers to import Excel spreadsheets into SQL Server Express 2005.� This worked fine with Windows XP and Office 2003. � I have just migrated all my stuff to Vista and Office 2007.� Linked servers just can't be created: � TITLE: Microsoft SQL Server Management Studio Express ------------------------------ "The linked server has been created but failed a connection test. Do you want to keep the linked server?" ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------ Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "XXX". OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "XXX" returned message "Unspecified error". (Microsoft SQL Server, Error: 7303) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=7303&LinkId=20476 ------------------------------ BUTTONS: &Yes &No ------------------------------ The parameter values I used are: � Provider: Microsoft Jet 4.0 OLE DB Provider Product name: Excel Data source: D:...somelocalfile.xls Provider string: Excel 8.0 � I gave full access rights to the Data source file and folder to NETWORK SERVICE and SQLServer2005MSSQLUser$MOZART$SQLEXPRESS where mozart is my PC name. � If I change Data source or Provider string to some garbage string, the exact same error message appears.� So it appears the error might be in the Provider? � Help help please.

Paradox Linked Server Problem www.dbforums.com

I have a SQL Server 2005 linked server object to access a Paradox database. The object's properties are: General Provider=MSDASQL Product Name=remote server IP address Data source=System DSN name Security Connections will: Be made without using a security context (BDE is installed on the local machine and synchronised with DSN) Problem When I use OPENQUERY against this linked server, SQL Server works fine and fetches back the data in no time. If I then run the same query through a SQL Server Agent job I get the following error (from the job's log): [SQLSTATE 01000] (Error 7412) OLE DB provider "MSDASQL" for linked server "ABC" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". From then on, running the same query in Query Analyser either results in the query running on (despite the source table having only 10 rows and 2 columns) until I cancel it, or in the following error: Msg 7399, Level 16, State 1, Line 3 The OLE DB provider "MSDASQL" for linked server "ABC" reported an error. The provider reported an unexpected catastrophic failure. Msg 7303, Level 16, State 1, Line 3 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "ABC". If the machine is rebooted everything works fine again, until I run the query through SQL Server Agent (which uses the local system account). I can run an AS400 openquery anywhere without problems. I can also import Paradox tables directly from SS Management Studio and SS Integration Services (using the same DSN and BDE) without problems. Any help would be greatly appreciated. Thanks in advance, KarimK

Trouble With: Linked Server To Oracle Using OraOLEDB.ORacle Provider social.msdn.microsoft.com

Hi--   I am running SQL Server 2005 on Win2k3: Microsoft SQL Server Management Studio      9.00.2047.00 Microsoft Analysis Services Client Tools      2005.090.2047.00 Microsoft Data Access Components (MDAC)      2000.086.1830.00 (srv03_sp1_rtm.050324-1447) Microsoft MSXML      2.6 3.0 4.0 6.0 Microsoft Internet Explorer      6.0.3790.1830 Microsoft .NET Framework      2.0.50727.42 Operating System      5.2.3790 I have the OraOLEDB.Oracle provider installed to the (C:oraclexe) directory. I am having problems querying from linked oracle server.  When i setup oracle as a linked server and purposely enter an incorrect password the query i run tells me i have an incorrect password.   So it at least knows that.  when i set the correct password and run a query I get this error: (i replaced the real server name with "someServer".) Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "OraOLEDB.Oracle" for linked server "SomeServer" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "SomeServer".   This is how I set up my Linked server: Provider: "Oracle Provider for OLE DB" Product Name: SomeServer Data Source: SomeServer Provider String:  "Provider=OraOLEDB.Oracle;Data Source=SomeServer;User Id=MyLogin;Password=MyPassword"     The query I run is: Select * from [Someserver].[schema or database]..[tbl_name]   Any help???  What am i missing?

DB2OLEDB And Linked Server social.msdn.microsoft.com

Using 2005 developer edition and enterprise editions with SP2, HIS 2004 and DB2 z/os 7.1.2. I cannot set up a linked server with DB2OLEDB. The connection tests OK. I can set up a linked server with IBMDBDB2. Does anyone know for sure if this provider works with DB2 z/OS 7.1.2 ? Does anyone know what if anything the DB2 DBAs need to do to make this work other than what they have done for IBMDBDB2? This is the error when I try to look at catalogs: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) The OLE DB provider "SQL Server" for linked server "(null)" reported an error. One or more arguments were reported invalid by the provider. Cannot obtain the schema rowset "DBSCHEMA_CATALOGS" for OLE DB provider "SQL Server" for linked server "(null)". The provider supports the interface, but returns a failure code when it is used. (Microsoft SQL Server, Error: 7399): This is the error when I try to use the linked server in T-SQL: OLE DB provider "DB2OLEDB" for linked server "SDN0_MS" returned message "One or more errors occurred during processing of command.". OLE DB provider "DB2OLEDB" for linked server "SDN0_MS" returned message "A SQL error has occurred. Please consult the documentation for your specific DB2 version for a description of the associated Native Error and SQL State. SQLSTATE: 51002, SQLCODE: -805". This is the connection info. I have tried many variants of the provider string including all the variant I can find at microsoft.com. I have googled for hours, I have read BOL and I have read msdn/technet articles. EXEC sp_addlinkedserver @server='SDN0_MS', @srvproduct='Microsoft OLE DB Provider for DB2', @catalog='xxxx', @provider='DB2OLEDB', @provstr='Initial Catalog=xxxx;Data Source=xxxx;Network Transport Library=TCPIP;Network Address=xxxx;Network Port=50000;Package Collection=xxxx;Default Schema=xxxx;Process Binary as Character=False;;Host CCSID=37;PC Code Page=1252;' If I uninstall Host Integration Service and intall DB2OLEDB from the Feature Pack I get this error:"The test connection to the linked server failed." ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Cannot initialize the data source object of OLE DB provider "DB2OLEDB" for linked server "SDN0_MS". OLE DB provider "DB2OLEDB" for linked server "SDN0_MS" returned message "The authentication method used is not supported by the remote system. Contact your system administrator. SQLSTATE: HY000, SQLCODE: -1004". (Microsoft SQL Server, Error: 7303)

Linked Server Error !!! www.sqlteam.com

Hi Pals, We have an SSIS package within which we are calling a stored procedure which eventually call a sql server dbo.fn() which contains code to lookup data inside oracle using Linked Server for Oracle. We are calling the Package dynamically from the stored procedure by creating a SQL Server Agent Job, I am getting the below error very often. Can we fix the error in any way? “EXEC sp_UpdateTname 369,'939390',2008 " failed with the following error: "Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "ORATEST".". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. When I hard code global variables and ran the package I am able to see the successful execution of the package. Can anybody point out where could the error lies?

Code Page social.msdn.microsoft.com

Hello, I am getting following error Error: 0xC02020F4 at Data Flow Task, OLE DB Source [1]: The column "dbname" cannot be processed because more than one code page (936 and 1252) are specified for it. Error: 0xC02020F4 at Data Flow Task, OLE DB Source [1]: The column "dbsize" cannot be processed because more than one code page (936 and 1252) are specified for it. Error: 0xC02020F4 at Data Flow Task, OLE DB Source [1]: The column "Owner" cannot be processed because more than one code page (936 and 1252) are specified for it. Error: 0xC02020F4 at Data Flow Task, OLE DB Source [1]: The column "Status" cannot be processed because more than one code page (936 and 1252) are specified for it. Error: 0xC02020F4 at Data Flow Task, OLE DB Source [1]: The column "CompLevel" cannot be processed because more than one code page (936 and 1252) are specified for it. � When I run the package itself it is working fine and when I am calling the package from another package getting this error. From Parent package I sending servername for olde db source to this package. Thanks.

How To Insert Excel Data Into SQL Database? www.sqlteam.com

Hello to All, I'm searching a way get Excel data into SQL database and tried this "insert" process that given me error. Already create a table call "original_purged" contain column fields. Can anyone give me some tips to show the problem? INSERT Original_Purged SELECT OP_ID,RBDI,Title,Address,City,State,Zip,Plus4,Walkseq,Crrt,Endorse,City_rural,Dpb,Dpbc,updatedate FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="C:Original_Purged.xls";User ID=Ryan;Password=dellonee1405;Extended properties=Excel 5.0')...[52117639] ========================================================== Error occur............. Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication failed. [OLE/DB provider returned message: Cannot start your application. The workgroup information file is missing or opened exclusively by another user.] OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80040e4d: Authentication failed.]. thank you ryan, RV

Cannot Fetch A Row From OLE DB Provider &&"BULK&&" For Linked Server social.msdn.microsoft.com

I have an SSIS job that is pumping to a SQL Server Destination, hundreds of gigabytes of raw text files.� Today I received this strange error - does anyone have insight?� Also, how would I make the data tasks more stable and robust so that this doesn't cause package failure (retries, or something?) [SQL Server Destination [4076]] Error: An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available.� Source: "Microsoft SQL Native Client"� Hresult: 0x80040E14� Description: "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".". An OLE DB record is available.� Source: "Microsoft SQL Native Client"� Hresult: 0x80040E14� Description: "The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.". An OLE DB record is available.� Source: "Microsoft SQL Native Client"� Hresult: 0x80040E14� Description: "Reading from DTS buffer timed out.".

OLEDB Command Stage Error In SLOWLY CHANGING DIMENSION social.msdn.microsoft.com

I have created a sample dataflow to parse the employee details (empid,empname,empaddr) from a flat file to oracle 9i database table named employee(columns : empid,empname,empaddress - All are varchar2(15)) using SLOWLY CHANGING DIMENSION transformation for insert/update on the table. EMPID as Businees key EMPNAME and EMPADDR as changing attributes. Connection string is using Microsoft oledb provider for oracle. I am getting the following oledb command error. ----------------------------------------------------------------------------------- TITLE: Microsoft Visual Studio ------------------------------ Error at Data Flow Task [OLE DB Command 1 [2007]]: An OLE DB error has occurred. Error code: 0x80040E51. An OLE DB record is available.� Source: "Microsoft OLE DB Provider for Oracle"� Hresult: 0x80040E51� Description: "Provider cannot derive parameter information and SetParameterInfo has not been called.". Error at Data Flow Task [OLE DB Command 1 [2007]]: Unable to retrieve destination column descriptions from the parameters of the SQL command. Warning at {CF5DCB64-279E-45A4-A9A8-FF2FBB130980} [Insert Destination [1972]]: Cannot retrieve the column code page info from the OLE DB provider.� If the component supports the "DefaultCodePage" property, the code page from that property will be used.� Change the value of the property if the current string code page values are incorrect.� If the component does not support the property, the code page from the component's locale ID will be used. � ------------------------------ ADDITIONAL INFORMATION: Errors were encountered while generating the wizard results: Error at Data Flow Task [OLE DB Command [1996]]: An OLE DB error has occurred. Error code: 0x80040E51. An OLE DB record is available.� Source: "Microsoft OLE DB Provider for Oracle"� Hresult: 0x80040E51� Description: "Provider cannot derive parameter information and SetParameterInfo has not been called.". Error at Data Flow Task [OLE DB Command [1996]]: Unable to retrieve destination column descriptions from the parameters of the SQL command. Error at Data Flow Task [OLE DB Command 1 [2007]]: An OLE DB error has occurred. Error code: 0x80040E51. An OLE DB record is available.� Source: "Microsoft OLE DB Provider for Oracle"� Hresult: 0x80040E51� Description: "Provider cannot derive parameter information and SetParameterInfo has not been called.". Error at Data Flow Task [OLE DB Command 1 [2007]]: Unable to retrieve destination column descriptions from the parameters of the SQL command. � For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=ScdWizardGenerationErrors&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------

Linked Server Not Working www.sqlteam.com

I have a SQL Server 2000 running on win 2003 where there is Linked Sever. Recently we have upgrade the SQL server 2000 to SQL 2005 and things were fine but suddenly one day things stopped working when I have tested the connection for link server. It failed and gave me this error. What could be the possible error . The source it is linked is a System DSN which is linking is a remote server running Informix Database. The driver is Informix CLI-2.5 (32 bit). Is it the driver that is the cause of error or what ??? "The test connection to the linked server failed." =================================== An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Program Location: at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(String cmd) at Microsoft.SqlServer.Management.Smo.LinkedServer.TestConnection() at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.LinkedServerConnectionTest.Invoke() =================================== Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "INFORMIX_LIBRARY". OLE DB provider "MSDASQL" for linked server "INFORMIX_LIBRARY" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "INFORMIX_LIBRARY" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "INFORMIX_LIBRARY" returned message "[INTERSOLV][ODBC Informix driver][Informix]Unable to load locale categories.". (.Net SqlClient Data Provider)

Can't Connect To Linked SQL Server: Cannot Initialize The Data Source Object Of OLE DB Provider &&"S... social.msdn.microsoft.com

I find this most perplexing. � I have two servers, DEV and PROD.� Now my DEV server works just great, I can connect to the linked server, query, etc... all is well. � So I'm setting up my PROD server and when I go to add the linked server I get: Cannot initialize the data source object of OLE DB provider "SQLNCLI".... and Unable to complete login process due to delay in opening server connection. � Now I am running SQL Server 2005 and connecting to an SQL 2000 server. � The odd part is that this works just fine on DEV. � When I go to create the linked server I set: Linked Server: "LinkedServerName" Server Type: "SQL Server" � and that's it. � I go to Security and enter my DOMAINUSER.ACCOUNT and then enter the login creds for the linked server. � When I click "OK" I get the above mentioned error code. � Any thoughts? �

Cannot Initialize The Data Source.. Text File Linked Server social.msdn.microsoft.com

Hi All, � I have this very big text file (2.5 GB - which of course I am not able to open). This resides on a server which has SQL 2005. � I have created a linked server for this text file on my SQL database, and when I try to query the table, I get an error: � Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "txtsrv". � Why am I getting this error? When I make a dummy linked server on my local machine and test the steps it all works OK. but when I go to this server where the file and it's SQL instance is lying, I get this error. Please can someone provide me with some help on this? � Many thanks, ~S � P.S.� Here is how I created the linked server (I also have the Schema.ini lying under the same folder): � EXEC sp_addlinkedserver txtsrv, 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', 'C:SSAnalysis', NULL, 'Text' GO � �

Extract Data From Excel 2007 On Vista social.msdn.microsoft.com

Hello all, � I am in the process up testing an upgrade from XP to Vista, and the only thing that I am running into is that my linked servers for Excel that I defined no longer work. � The spreadsheet that I am trying to�open is in the 97-2003 format (not the 2007 format), yet I keep getting the same error message "Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TEST1" � Has anyone successfully created a linked server to an Excel spreadsheet on Vista, and if so, please can you provide some insight into what I am doing wrong. � I tried creating a linked server on an XP box running MS Office 2007, and it worked without any issues. � All comments welcome. � thanks � Steve

Error Expanding Tables In Linked Server To Pervasive www.dbforums.com

Pleeeease help? I get an error when expanding the Tables object under linked servers in Enterprise Manager on a MSSQL2000 server. I have a standard install of the Pervasive.SQL V8 data engine and DemoData db on my local PC. The SQL Server is also on my local PC. I manage to create the Linked Server using the MSSQL Enterprise Manager. I used the following configuration: Provider Name: Pervasive.SQL V8 OLE DB Provider Product Name: Pervasive.SQL V8 Data source: DemoData Provider string: <blank> Location: workstation03 Catalog: <blank> However when I try to expand the tables object under Linked Servers in the Enterprise manager I get the following error. Error 7311: Could not obtain the schema rowset for the OLE DB provider 'UNKNOWN'. The provider supports the interface, but retuns a failure code when it is used. OLE DB error trace [OLE/DB Provider 'UNKNOWN' IDBSchemaRowset::GetRowset returned 0x80040155 ]. How would I fix this? Thank you.

Unable To Extend Temp Segment By 64 In Tablespace TEMP (SSIS Error While Copying Data From Oracle) social.msdn.microsoft.com

I am transferring data from oracle and getting below error message. � I using 4 data flow tasks with in a single control flow and all the 4 tasks quueries same table but populates data in to different sql tables based on the where contidion � �[OLE DB Source 1 [853]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.� Source: "Microsoft OLE DB Provider for Oracle"� Hresult: 0x80004005� Description: "ORA-01652: unable to extend temp segment by 64 in tablespace TEMP ".

Unable To Retrieve Column Information When Using Ole Db Provider For Sybase social.msdn.microsoft.com

Hi All, � I am in process of transfering data from Sybase to Sql Server using SSIS 2005 �have taken a Data Flow Task in Control Flow tab In Data flow tab, I have taken one Ole DB Source and One OLe DB Destination For the source, I am using Sybase Adaptive Server Anywhere Provider 8.0 For Destination, I am using Sql Server 2005 database In Ole Db Source Editor , For OLe Db Connection Manager, I choose Sybase Connection For Data access mode, I choose Table or View For Name of the table or the view, I choose a table by name Table1( it lists all the tables from Sybase database) When i click on preview button or Columns link, I get the following Error Error at Data Flow Task [OLE DB Source [1]]: An OLE DB error has occurred. Error code: 0x80040E21. Error at Data Flow Task [OLE DB Source [1]]: Unable to retrieve column information from the data source. Make sure your target table in the database is available. ------------------------------ ADDITIONAL INFORMATION: Exception from HRESULT: 0xC020204A (Microsoft.SqlServer.DTSPipelineWrap) Please help me out. Thanks in Advance � Srinivas �

Linked SQL Servers www.sqlteam.com

Okay, so i have two sql servers on the same network. i want to be able to have them linked. so i went into management studio, and did the New Linked Server Wizard. i typed in the box "Server2" (name of the server i want to link to) and selected SQL CLIENT bullet now the sa logins are the same, and so are the windows logins for the server, so security shouldnt really be an issue. when i run: EXEC sp_tables_ex Server2 i get the following error: OLE DB provider "SQLNCLI" for linked server "Server2" returned message "Invalid authorization specification". Msg 7399, Level 16, State 1, Procedure sp_tables_ex, Line 41 The OLE DB provider "SQLNCLI" for linked server "Server2" reported an error. Authentication failed. Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41 Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "Server2". is this a username/password issue? the windows administrator accounts are the same, and so are the sa logins, is there something i can do to get past this? small update i tried: USE master; GO EXEC sp_addlinkedserver 'Server2', N'SQL Server' GO BEGIN TRY EXEC sp_testlinkedserver N'Server2'; END TRY BEGIN CATCH PRINT 'Linked Server not available'; RETURN; END CATCH ang got: OLE DB provider "SQLNCLI" for linked server "Server2" returned message "Login timeout expired". OLE DB provider "SQLNCLI" for linked server "Server2" returned message "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.". Linked Server not available

Distributed Transaction Error From CLR Trigger social.msdn.microsoft.com

I have a stored procedure in SQL2005 that queries and updates a linked oracle server. The sp runs fine from Management Studio, but when called by a CLR trigger I get�the following�error message: Command attempted: if @@trancount > 0 rollback tran (Transaction sequence number: 0x000000000000000032DD00000000, Command ID: 1) Error messages: The operation could not be performed because OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLE_LINK" was unable to begin a distributed transaction. (Source: MSSQLServer, Error number: 7391) Get help: http://help/7391 The operation could not be performed because OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLE_LINK" was unable to begin a distributed transaction. (Source: MSSQLServer, Error number: 7391) Get help: http://help/7391 A .NET Framework error occurred during execution of user defined routine or aggregate 'PriorityTrigger': System.Data.SqlClient.SqlException: The operation could not be performed because OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLE_LINK" was unable to begin a distributed transaction. Changed database context to 'pims'. OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLE_LINK" returned message "New transaction cannot enlist in the specified transaction coordinator. ". System.Data.S (Source: MSSQLServer, Error number: 6549) Get help: http://help/6549 Any thoughts or direction appreciated Richard

Adding A Linked Server social.msdn.microsoft.com

� HI, There is a requirement to transfer a table data from a oracle view to a SQL Server table. These both reside on the same box. I am trying to add the oracle instance as a linked server, like this: � EXEC sp_addlinkedserver @server = @SOURCE_SERVER_NAME, @srvproduct = '', @provider = @PROVIDER_NAME, @datasrc = @DATA_SOURCE_NAME � The server gets added. But When I use this string as part of a stored procedure (or even not use it there), which does the work of transfering the data as required, I get this error: � Server: Msg 7399, Level 16, State 1, Procedure UBS_PULL_HR_DATA, Line 125 OLE DB provider 'MSDASQL' reported an error.� [OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified] OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005:�� ]. � I have added this Name in the System DSM also. I dont know how to go about it. Can any one please help? � Thanks a lot and let me know if the question is not clear. � Mannu.

Linked Server - Excel Spreadsheet www.sqlteam.com

I am trying to set up a linked server in SQL Server 2005 to link to an excel spreadsheet. -I am selecting Jet 4.0 as the provider -Product name is Excel -Data Source is the path on our network to the excel file: N:Devon54034.0 Engineering4.01 ProcessLinelistIFCLDT Field.xls -Provider String is Excel 8.0 -Security | Login not defined is set to Be made using the login's current security context. The Excel file is an Excel 2003 spreadsheet. The worksheet is titled Pages I have a query window open in SQL Server Management Studio and the following is my select statement: SELECT * FROM DEVON_LINE_LIST...Pages$ I get the following error message: OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "DEVON_LINE_LIST" returned message "Cannot start your application. The workgroup information file is missing or opened exclusively by another user.". Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "DEVON_LINE_LIST" reported an error. Authentication failed. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "DEVON_LINE_LIST". I get similar error messages no matter which security settings I pick. Any thought as to what I can try to get this to work?

Union Of Views www.sqlteam.com

For a Union All of Views where both views look at the same openrowset file I get [OLE/DB provider returned message: Unspecified error] OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ]. Msg 7399, Level 16, State 1, Line 2 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. This probably occurs because the first view keeps the file open. Any workarounds on this?

Update Table From MS2005 To Oracle 9.2 - No Solution Works For Me social.msdn.microsoft.com

Hi, � I have been fighting this problem for several days now. � All I need to do is run a query against a table on mssql 2005 server and update a table (only update) in Oracle � Here are some of the things I have tried: � 1) from a forum tip, I set up a dataflow: OLE DB Source (MS SQL)�-> Derived Column -> OLE DB Command (Oracle) - I get "Error at Data Flow Task [OLE DB Command [2850]]: Columns "NyNamn" and "id" cannot convert between unicode and non-unicode string data types." � 2)�I have tried a�Source - OLE DB Source (MS SQL)�-> Derived Column ->�OLEDB Desination (Oracles OLEDB) - Error when trying to preview: TITLE: Microsoft Visual Studio ------------------------------ Error at Data Flow Task [OLE DB Destination [2953]]: SSIS Error Code DTS_E_OLEDBERROR.� An OLE DB error has occurred. Error code: 0x8000FFFF. Error at Data Flow Task [OLE DB Destination [2953]]: Opening a rowset for ""APPINV2"."OWNERS"" failed. Check that the object exists in the database. � ------------------------------ ADDITIONAL INFORMATION: Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap) � 3) I have tried a�Source - OLE DB Source (MS SQL)�-> Derived Column ->�OLEDB Desination (MicrosoftsOLEDB for Oracle) - Error when trying to preview: TITLE: Microsoft Visual Studio ------------------------------ Error at Data Flow Task [OLE DB Destination [2953]]: SSIS Error Code DTS_E_OLEDBERROR.� An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.� Source: "Microsoft OLE DB Provider for Oracle"� Hresult: 0x80004005� Description: "Unspecified error". An OLE DB record is available.� Source: "Microsoft OLE DB Provider for Oracle"� Hresult: 0x80004005� Description: "Oracle error occurred, but error message could not be retrieved from Oracle.". An OLE DB record is available.� Source: "Microsoft OLE DB Provider for Oracle"� Hresult: 0x80004005� Description: "Data type is not supported.". Error at Data Flow Task [OLE DB Destination [2953]]: Opening a rowset for ""APPINV2"."OWNERS"" failed. Check that the object exists in the database. � ------------------------------ ADDITIONAL INFORMATION: Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap) � I have full rights on the oracle�database with the account used, i can connect with toad with no problems. � To me, this should be a simple task. has anyone got any advice for me ? � Thanks �

Linking SQL 2005 Servers To SQL 2000 Servers Problems social.msdn.microsoft.com

I am in the middle of a major migraton project, moving from x86 SQL 2000 to IA64 SQL 2005.� I have a business need to link to several legacy servers.� I have a number of problems I am trying to solve.� 1)� Linking a Kerberos server to a non-Kerberos server. 2)� Linking x64 or IA64 servers to�x86 servers. 3)� Linking SQL 2005 to SQL 2000. � Two of the errors I am encountering are: ------------------------------ TCP Provider: An existing connection was forcibly closed by the remote host. Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. OLE DB provider "SQLNCLI" for linked server "SCDC250DB" returned message "Communication link failure". (Microsoft SQL Server, Error: 10054) ------------------------------ And ------------------------------ The OLE DB provider "SQLNCLI" for the linked server "SCDC250DB" reported an error. Authentication failed.� Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "SCDC250DB". OLE DB provider "SQLCLI" for linked server "SCDC250DB" returned message "Invalid authorization specification". (Microsoft SQL Server, Error: 7399) � If someone has worked through these problems before, I would appreciate it if you could direct me to the relevant documentation to resolve these issues. � Thanks! � Brandon Forest Database Administrator Data & Web Services Team Sutter Connect Information Technologyforesb@sutterhealth.org

Db2 Connection Problems SSIS (OLEDB) social.msdn.microsoft.com

Hello, I'm trying to connect to a DB2 database via SSIS and I'm getting some problems: I'm creating a new OLE DB Connection Manager and I'm getting two distinct errors: 1) When I try to use "IBM OLEDB Provider for DB2 Servers" I can create the connection manager and the connection is tested successfully. But when I try to use the connection in OLE DB Source when I will list the tables I get this error: Could not retrieve the table information for the connection manager 'MyDataSource'. truncated. SQLSTATE=01004 �CLI0002W� Data truncated. SQLSTATE=01004 ADDITIONAL INFORMATION: truncated. SQLSTATE=01004 �CLI0002W� Data truncated. SQLSTATE=01004 (IBM OLE DB Provider for DB2 Servers) 2) When I try to use "Microsoft OLE DB Provider for DB2" when I try to test the connection I get this error: Test connection failed because of an error in initializing provider. The parameter is incorrect. Anyone had these problems ? Thanks, Guber

Linked Server To Pervasive 8 - Connection Error social.msdn.microsoft.com

Hello, I am currently migrating from SQL 7.0 to SQL2005.� So far everything is going well except for one thing, my linked server to a Pervasive 8.6 server database.� I've done the same configurations as with the SQL 7.0 server to create the linked server.� I've created an Pervasive ODBC Client DSN system�connection on the server called PervasiveDB pointing to the DataDB catalog, using TCP/IP as transport and the server name "PervasiveDB"�as the server address.� From this point, on the SQL2005 server, the DSN�connection is successfull and I can see the different catalog names of the PervasiveDB server.� When I create the Linked server on the SQL2005, I create exactly as done on the SQL7.0 which is : SQL7.0 server :� OS is Windows 2000 all service packs applied for both OS and SQL7.0 SQL2005 server : OS is Windows2003 standard edition�all service packs applied for both OS and SQL2005. Linked server name :� TestPervasive Provider : Microsoft OLE DB Provider for ODBC Drivers Product name:� Pervasive Data source: PervasiveDB Location: PervasiveDB Catalog : DataDB I get the following error when I try to query the data to test if the linked server I just created is successful: query :� SELECT * FROM testpervasive.DataDB..schedule error message: Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "MSDASQL" for linked server "TestPervasive" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "TestPervasive". Anybody can help me on this one?��I would greatly appreciate it !!�

Linked Server From SQL-Server 2000 To Oracle 8.1.7 bytes.com

We have a linked server, which worked fine, but we have just changed the collation sequence, in SQL-Server, from SQL_Latin1_General_CP1_CI_AS to Latin1_General_CI_AS. Now trying to use the Linked server, we get the following message: "Error 7399: OLE DB Provider 'MSDAORA' reported an error. The provider did not give any information about the error. OLE DB error trace [OLE DB provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error]." Ha anyone seen this before, because I am not sure why changing the collation sequence, would affect the Linked Server

Newbie: Why Do I Have To Use OPENQUERY To A Linked Server? (ODBC To Firebird Database) social.msdn.microsoft.com

Hello, pls. let me know where I could post if this is the wrong place. I have a Firebird 1.5 application. I created a linked server from my SQL Server 2000 to the firebird database.�In SQL Server Query Analyzer I get errors from�various ODBC drivers with "normal" queryies like � SELECT LVNR FROM LINKEDSRV...LVVERW � Pls. note, this all works perfectly in MS Access databases with ODBC-Links to Firebird! � From a programmer of a commercial ODBC driver I heard that this problem may be caused internally by SQL Server, there may be no solution possible in the ODBC driver. One workaround would be to use the OPENQUERY-Syntax like � SELECT * FROM OPENQUERY(LINKEDSRV, 'select LVNR from LVVERW ') � Are there any other solutions? Are there any known issues with firebird odbc-drivers and sql server? Are there any known good drivers for the use with sql-server? What is the purpose of OPENQUERY - workaround ODBC problems? Are there any settings in SQL Server 2000 (2005 Express) that could help? Are there any settings in ODBC DSN that would help? regards arno PS: Here are my favorite error messages Error -2147217900 [OLE/DB provider returned message: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 89 "Col1014"] (Source: Microsoft OLE DB Provider for SQL Server) (SQL State: 01000) (NativeError: 7312)Error -2147217900 OLE DB-Fehlertrace [OLE/DB Provider 'MSDASQL' ICommandPrepare:repare returned 0x80004005: ]. (Source: Microsoft OLE DB Provider for SQL Server) (SQL State: 01000) (NativeError: 7300)Error -2147217900 Der OLE DB-Provider 'MSDASQL' meldete einen Fehler. (Source: Microsoft OLE DB Provider for SQL Server) (SQL State: 42000) (NativeError: 7399) This "tricky" query does not work: SELECT LVNR FROM LINKEDSRV...LVVERW; Error -2147217900 OLE DB-Fehlertrace [Non-interface error: Column 'ERHALTENABSCHLAG' (compile-time ordinal 35) of object 'LVVERW' was reported to have a DBTYPE of 5 at compile time and 131 at run time]. (Source: Microsoft OLE DB Provider for SQL Server) (SQL State: 01000) (NativeError: 7300)Error -2147217900 Der OLE DB-Provider 'MSDASQL' hat inkonsistente Metadaten für eine Spalte übergeben. Die Metadateninformationen wurden zur Ausführungszeit geändert. (Source: Microsoft OLE DB Provider for SQL Server) (SQL State: 42000) (NativeError: 7356)

Importing Excel Using Linked Server And Passthrough Query social.msdn.microsoft.com

What: I am trying to import data from spreadsheets to SQL Server. � Where:�Windows Vista, SQL Server 2005 Express, Office 2007. � How: Using linked servers following KB306397. � In SQL Management Studio Express, I created a new Linked Server as follows, with everything else at default: Linked server: XLSX Provider: Microsoft Office 12.0 Access Database Engine OLE DB Provider Product name: XLSX Data source: D:XLSX.xlsx Provider string: Excel 12.0 The linked server was created ok. � I then followed KB321686 and ran this: � select * from OPENQUERY(XLSX, 'Select * From [Sheet1$]') � and got this: � Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "XLSX" reported an error. Access denied. Msg 7350, Level 16, State 2, Line 1 Cannot get the column information from OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "XLSX". � But if I ran:�� select * from OPENQUERY(XLSX, 'Select * From [nonexistent$]') � the error is: � Msg 7357, Level 16, State 2, Line 1 Cannot process the object "Select * From [nonexistent$]". The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "XLSX" indicates that either the object has no columns or the current user does not have permissions on that object. � It seems that there is an access rights problem if I get the sheet name correct.� May I know what I must do to get this to work.� I have already given read/write rights to the spreadsheet to NETWORK SERVICE and SQLServer2005MSSQLUser$servername$SQLEXPRESS. � From the same KB article, I also tried: � select * from XLSX...[Sheet1$] � but got this: � Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "XLSX" reported an error. The provider did not give any information about the error. Msg 7330, Level 16, State 2, Line 1 Cannot fetch a row from OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "XLSX". � Help help. � Thanks.

Connection To DB2 Using SQL 2005 64-bit (SSIS) social.msdn.microsoft.com

Hi, � Need help in pulling data from DB2 using SQL 2005 64-bit (in 64-bit Server), we were able to successfully install IBM ODBC Driver, link DB2 server in add linked server, and query data using SQL Management Studio. But when we tried to pull data in SSIS (BIDS), using [OLE DB Source] data flow task (having Native OLE DBIBM DB2 UDB for iSeries IBMDA400 OLE DB Provider), and used simple command query (select * from [DB2 library name].[table name]), we get this error: � [OLE DB Source [1]] Warning: Cannot retrieve the column code page info from the OLE DB provider.� If the component supports the "DefaultCodePage" property, the code page from that property will be used.� Change the value of the property if the current string code page values are incorrect.� If the component does not support the property, the code page from the component's locale ID will be used. � Many thanks for anyone who would help. � Regards, Eduardo

Import Access Tables (set Up As Pass-through Table Types To Oracle )--OLE DB Connection To Access Cannot... social.msdn.microsoft.com

Access Connection create a new Connection Manager by right-clicking in the Connection Managers section of the design area of the screen. Select New OLE DB Connection to bring up the Configure OLE DB Connection Manager dialog box. Click New to open the Connection Manager. In the Provider drop-down list, choose the Microsoft Jet 4.0 OLE DB Provider and click OK. Browse to the Access database file and connection set up---all good!!! � Dataflow task Add an OLE DB Source component Double-click the icon to open the OLE DB Source Editor. Set the OLE DB Connection Manager property to the Connection Manager that�I �created . Select Table from the Data Access Mode drop-down list. I cannot see the tables set up as set up as pass-through table types to a Oracle 9i db Any ideas please help � thanks in advance Dave

DTS Execution Error In SQL Server 2000..please Help Asap social.msdn.microsoft.com

� Hi, � when i execute a dts to copy one database from one server to another i am getting the following error: � [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB 'SQL OLEDB' reported an error.Authentication Failed. [Microsoft][ODBC SQL Server Driver][SQL Server]OLE/DB provider returned message: Invalid authorization specification] [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDB Initialize: Initiliaze returned 0x80040e4d: Authentication failed.]. � Please help me solve it.

Creating Link To Oracle Db www.sqlteam.com

Hi I'm trying to create link to oracle db and keep getting this error when I try to look at the oracle tables from enterprise manager. error 7399: ole db provider microsoft.jet.oledb.4.0 reported an error ole db error trace [ole/db provider microsoft.jet.oledb.4.0 idbinitialize::initialize returned 0x80004005:] I can connect to oracle db from sql server using oracle sqlplus and I have a ODBC connection to db that works. sql server 2000 os = MS windows server 2003 oracle client 10.2

Problems Moving Data Over 8000k In DB2 Varchar Column Into SQL Server Varchar(max) Using SSIS social.msdn.microsoft.com

� I have looked far and wide and have not found anything that works to allow me to resolve this issue. � I am moving data from DB2 using the MS OLEDB Provider for DB2.� The OLEDB source sees the column of data as DT_TEXT.� I setup a destination to SQL Server 2005 and everything looks good until I try and run the package. � I get the error: [OLE DB Source [277]] Error: An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available.� Source: "Microsoft DB2 OLE DB Provider"� Hresult: 0x80040E21� Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". � [OLE DB Source [277]] Error: Failed to retrieve long data for column "LIST_DATA_RCVD". � [OLE DB Source [277]] Error: There was an error with output column "LIST_DATA_RCVD" (324) on output "OLE DB Source Output" (287). The column status returned was: "DBSTATUS_UNAVAILABLE". � [OLE DB Source [277]] Error: The "output column "LIST_DATA_RCVD" (324)" failed because error code 0xC0209071 occurred, and the error row disposition on "output column "LIST_DATA_RCVD" (324)" specifies failure on error. An error occurred on the specified object of the specified component. � [DTS.Pipeline] Error: The PrimeOutput method on component "OLE DB Source" (277) returned error code 0xC0209029.� The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. � Any suggestions on how I can get the large string data in the varchar column in DB2 into the varchar(max) column in SQL Server 2005? � �

OLE DB Command Error SSIS social.msdn.microsoft.com

Hi, when �we are using OLEDB Command we are getting the following error? when we use sql server as the source its working fine .but its throwing error when we try to connect the orcale database . Error at Data FLOW TASk[OLE DB Command[3863]]: An OLE DB error has occured :0x80040E51. An OLE DB record is available. Source : "Microsoft OLE DB Provider for Oracle" Hresult: 0x80040E51 Description: "Provider cannot derive parameter information and SetParameterInfo has not been called.".� ERrror at Data Flow Task [OLE DB Command [3863]]: Unable to retrieve destination column description from the Parameter of the SQL Command �Thanks & Regards Jegan.T � � �

Unable To Connect To OLAP Cube Through SSIS social.msdn.microsoft.com

I am trying to access Cube through SSIS and�have been�unable to set SSIS package with the work around provided here (https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=219068). On pasting the MDX query using the openrowset command on the OLEDB source editor, I get a pop up window with error 0x08000405 and the message that says 'syntax used for openrowset is incorrect' I also tried running this on SQL Management studio but, get the following error. OLE DB provider "MSOLAP" for linked server "(null)" returned message "An error was encountered in the transport layer.". OLE DB provider "MSOLAP" for linked server "(null)" returned message "The peer prematurely closed the connection.". Msg 7303, Level 16, State 1, Line 3 Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "(null)". � The server where the cube resides is on 64bit machine and I have 32-bit..could this be the reason for the issue? � I found this article on microsoft support website (http://support.microsoft.com/kb/947512 ) which describes the possible symptoms and causes for connectivity issues But, couldn't find a work around for it. � Here is the syntax of the query I am using in SSIS and query analyser SELECT * FROM OPENROWSET('MSOLAP', 'Integrated Security=SSPI;Persist Security Info=True;Data Source=<SERVERNAME>; Initial Catalog=<Catalog name>;' , �'MDX Query') AS Rowset_1 Any help with this issue is appreciated! � Thanks,

LINKED SERVERS forums.databasejournal.com

FOLKS I GET THE FOLLOWING ERROR WHEN I RUN A SELECT FROM THE LINKED SERVER THE LINKSERVER EXISTS AND THERE IS A RECORD IN SYSSERVERS TOO. Could not initialize data source object of OLE DB provider 'Microsoft.Jet.OLEDB.4.0' I AM NOT SURE WHERE TO GO FROM HERE. REGARDS GIRISH

Informix OLE DB Trouble social.msdn.microsoft.com

� � I am having trouble using an OLE-DB source in my data flow task.� I am using Informix.� In the OLE DB source editor I get the following message: � Warning at {4f24a418-f95e-4185-8989-4f960aaabd68} [OLE DB Source [1]]: Cannot retrieve the column code page info from the OLE DB provider.� If the component supports the "DefaultCodePage" property, the code page from that property will be used.� Change the value of the property if the current string code page values are incorrect.� If the component does not support the property, the code page from the component's locale ID will be used. � Using the preview button in the OLE DB source editor, it maps the integers to DT_I4 so most of the numbers in the preview convert as null and that is how they end up in the target.� I added a data conversion component and they still end up in the target as null.� � �

Loading Data To Db2 social.msdn.microsoft.com

Hi, � trying to load data from sql2000 to DB2 UDB 7.2 , � building SSIS package using wizard �case 1: �� source ole db -sql2000 destination IBM ole db provider for DB2 � data conversion compnent placed on data flow� page , package run fine case 2 �� source ole db -sql2000 destination microsoft ole db provider for DB2 � data conversion component NOT placed on data flow� page ,just source and destination , package fail (can't detect db2 code page) questions �if I transfer� 1000000 rows from sql to db2 ,what will happen ? �in case 1 :� �� is it single transaction�? �� is possible to set "Maxinsertcommitsize" or other property and commit every N rows ? case 2: �� if I remember� microsoft ole db driver for db2 (used in host integration server) forced�� commit every row. (I might be wrong) again ,�any �property� could be set� to �commit every N rows ? Thanks Alex � �

Linkedserver Error forums.databasejournal.com

I am trying to add a linked server. The example below is for an Excel spreadsheet but I get the same error message for an Access database. sp_addlinkedserver N'Excel', N'Jet 4.0', N'Microsoft.Jet.OLEDB.4.0', N'c:dataMySheet.xls', NULL, N'Excel 5.0' GO sp_addlinkedsrvlogin N'Excel', false, sa, N'ADMIN', NULL GO I am getting an error "Error 7303 Could not initialize data source object of OLE DB Provider Microsoft Jet OLEDB4.0" Not sure if it makes a difference but I am using Office 2000. Any hints appreciated.

Excel File As A Linked Server forums.databasejournal.com

I am trying to link an excel file as a linked server. I tried two methods unsuccessfully. first: using EXEC sp_addlinkedserver 'Ex', 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', 'c:list5.xls', NULL, 'Excel 5.0' GO When I run EXEC sp_tables_ex Ex, I get the error below. Server: Msg 7303, Level 16, State 2, Procedure sp_tables_ex, Line 20 Could not initialize data source object of OLE DB provider 'Microsoft.Jet.OLEDB.4.0'. [OLE/DB provider returned message: Cannot start your application. The workgroup information file is missing or opened exclusively by another user.] Second: I link the excel file using ODBC datasource: EXEC sp_tables_ex mylink, works fine with mylink being the linked server name. I get the table names eg. table1$, table2$.... However when I try to query the tables, I get this error: Server: Msg 7313, Level 16, State 1, Line 1 Invalid schema or catalog specified for provider 'MSDASQL'. thanks FS

SSIS Prototype... social.msdn.microsoft.com

I am building a prototype that will dynamically alter the source (Progress 10.1B DB) and SQL Server 2000 Destination. As I was trying to run the package, I ran into the following error. I have checked the Destination and it does have unicode data definitions. Why would I be getting the following error and that too, I do not see the very first SQL Statement (Select) being executed against the SQL Server Meta Data Database. Thanks in advance. TITLE: Package Validation Error ------------------------------ Package Validation Error ------------------------------ ADDITIONAL INFORMATION: Error at Data Flow Task [OLE DB Destination [1714]]: Column "ad_addr" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1714]]: Column "ad_type" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1714]]: Column "ad_name" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1714]]: Column "ad_line1" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1714]]: Column "ad_line2" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1714]]: Column "ad_line3" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1714]]: Column "ad_city" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1714]]: Column "ad_state" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1714]]: Column "ad_zip" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1714]]: Column "ad_country" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1714]]: Column "ad_ctry" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1714]]: Column "ad_attn" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1714]]: Column "ad_attn2" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1714]]: Column "ad_phone" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1714]]: Column "ad_ext" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1714]]: Column "ad_phone2" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1714]]: Column "ad_ext2" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1714]]: Column "ad_fax" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1714]]: Column "ad_fax2" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1714]]: Column "ad_ref" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1714]]: Column "ad_sort" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1714]]: Column "ad__chr01" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [1714]]: Column "ad__chr02" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [DTS.Pipeline]: "component "OLE DB Destination" (1714)" failed validation and returned validation status "VS_ISBROKEN". Error at Data Flow Task [DTS.Pipeline]: One or more component failed validation. Error at Data Flow Task: There were errors during task validation. (Microsoft.DataTransformationServices.VsIntegration) ------------------------------ BUTTONS: OK ------------------------------

Cannot Convert Between Unicode And Non-unicode String Data Types. social.msdn.microsoft.com

I have an Excel Source component hooked to an OLE DB Destination component in my SSIS 2005 Data Flow Task.  After I mapped the excel columns to the OLE DB table columns i get these errors below.  I noticed that for the first error, the Excel Field format (when you mouse over the column name in the mappings section in OLE DB component) is of type [DTWSTR] and the corresponding SQL field from my SQL table that it's mapping to is of type [DT_STR] when mousing over that field in the mappings in the properties of my OLE DB component.  All table fields in SQL Server for the table I'm inserting into are of type varchar. print screens here: http://www.webfound.net/excel_ssis.jpg http://www.webfound.net/excel_to_oledb_mappings.jpg Package Validation Error ------------------------------ ADDITIONAL INFORMATION: Error at Data Flow Task [OLE DB Destination [27]]: Columns "Commission Agency" and "CommissionAgency" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [27]]: Column "Product" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [27]]: Columns "Officer Code" and "OfficerCode" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [27]]: Columns "Agency Name" and "AgencyName" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [27]]: Columns "Agency Id" and "AgencyID" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [27]]: Columns "Tran Code" and "TranCode" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [27]]: Columns "User Id" and "UserID" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [OLE DB Destination [27]]: Columns "Acct Number" and "AccountNumber" cannot convert between unicode and non-unicode string data types. Error at Data Flow Task [DTS.Pipeline]: "component "OLE DB Destination" (27)" failed validation and returned validation status "VS_ISBROKEN". Error at Data Flow Task [DTS.Pipeline]: One or more component failed validation. Error at Data Flow Task: There were errors during task validation.  (Microsoft.DataTransformationServices.VsIntegration)  

Whats Wrong Error 7370 Msg (Linked Server) forums.databasejournal.com

EXEC sp_addlinkedserver @server = 'PMA99', --Server Name @provider = 'Microsoft.Jet.OLEDB.4.0', --Provider Name @srvproduct = 'OLE DB Provider for Jet',--Product @datasrc = 'H:HN2000AMASTEREPPma99.mdb'--Data Source I'm 100% sure that I use to run the same query as I today ran but I got this error message, any help pls..... Server: Msg 7370, Level 16, State 2, Line 1 One or more properties could not be set on the query for OLE DB provider 'Microsoft.Jet.OLEDB.4.0'. The provider could not support a required property.

Whats Wrong Here 7370 forums.databasejournal.com

EXEC sp_addlinkedserver @server = 'LinkedServer', --Server Name @provider = 'Microsoft.Jet.OLEDB.4.0', --Provider Name @srvproduct = 'OLE DB Provider for Jet', --Product @datasrc = 'C:DataX2000Master.mdb' --Data Source Before the above query was okay..... I used to run the same query as I today ran but I got this error message, any help pls..... Server: Msg 7370, Level 16, State 2, Line 1 One or more properties could not be set on the query for OLE DB provider 'Microsoft.Jet.OLEDB.4.0'. The provider could not support a required property.

Linked Server Error social.msdn.microsoft.com

Hello, SQL Server version is Enterprise Edition 8.00.2039 SP4 and one oracle database linked via Microsoft OLe DB provider for Oracle. Oracle db name: SCP. � One of the job inserts data to sql database from querying oracle database;� randomly fails with the error message below. ************************** INSERT INTO �mom_services ('SQL TABLE') SELECT�* FROM ��OPENQUERY(SCP,'SELECT SERIAL_NO_ FROM SCADMIN.DEVICEM1 WHERE CONTAINER=''MOM''') *************************** Server: Msg 7399, Level 16, State 1, Line 3 OLE DB provider 'MSDAORA' reported an error.� [OLE/DB provider returned message: Oracle error occurred, but error message could not be retrieved from Oracle.] OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005:�� ]. � What I have done; Oracle client uninstalled server restarted and oracle client installed . Linked server deleted and recreated but nothing changed. � � Any ideas ? Osman

New Transaction Cannot Enlist In The Specified Transaction Coordinator forums.asp.net

I'm getting this error: The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. [OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ] OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a]. http://support.microsoft.com/kb/839279 this didn't help any suggestions?

Error: USing SSIS OLE DBCOMMAND Please Help Folks!!!! (I'm New To It) social.msdn.microsoft.com

Hello , While running an SSIS data flow package , i receive the following error, Error: 0xC0202009 at Data Flow Task, OLE DB Command [1024]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. The RPC name is invalid.". It happens as i follow this procedure 1) Get data from D1(data source 1)..OLE DB source 2) See if data already exists in D2...Lookup transform 3) If it already exists, UPDATE the data already in D2 (update existing rows)...Ole db command I have a lookup transform before the i send that data to the ole db command. Please do advise as i cannot seem to workaround this. Thankyou