1 d
Error 7303 linked server sql?
Follow
11
Error 7303 linked server sql?
You might be looking for a new social media platform, and Discord might be your best bet. Then I opened Microsoft SQL Server Management Studio and navigated to SQL SERVER > Server Object > Linked Servers. The folder contains a working schema I import each of the files by executing individual stored procedures, using OPENQUERY. The cookie is used to store the user consent for the cookies in the category "Analytics". Create a SQL Server Linked Server to MySQL. The cookie is used to store the user consent for the cookies in the category "Analytics". I have added an ODBC Data Source on server 101. I get the following error: OLE DB provider "OraOLEDB. Method2: Use mapped security context for the linked server and modify the job to run as OSQL. Ensure that server B is running listening for external connection and accessible from server A by network connection. Today again my linked server drops out and thrown with an error: Error: Cannot create an instance of OLE DB provider "MSOLAP" for linked server "Expense_Cube". Most database startups avoid building relational databases, since that market is dominated by a few goliaths. Here's how to get started. I have personally seen when people use Linked Server there are a number of issues from authentication to performance. 0 Access Database Engine via a linked server. OLE DB provider "MSDASQL" for linked server "myLinkedServer" returned message " [Pervasive] [ODBC Client Interface] [Client LNA]Connection attempt timed out. November 26, 2019 at 12:25 pm we migrated the linked servers from sqll 2005 to sql 2016 , when i tried to test the connection of a linked server getting the below error Linked Server Error 7303- Cannot initialize the data source object of OLE DB provider The Linked Server has been setup using SQL Server Management Studio. It may not be a database that your application recognizes, or the file may be corrupt (Microsoft SQL Server, Error: 7303) Under the Console Root, expand Microsoft SQL Servers > SQL Server Group > Local > Security > Linked Servers for SQL Server 2000. This worked fine up until last week when it just seemed to stop working. Oracle" for linked server "*****". In that case, I would lean towards an SSIS, PDI (Pentaho Data. These messsages may … EXEC mastersp_addlinkedserver. I couldn't find a way of applying authentication delegation with an adhoc query, short of adding a linked server pointing to the excel file but for my requirements the following worked. As mentioned, the linked server works fine on the machine where it's defined. I am trying to create a Linked Server from an office based SQL Server Installation to a remote MySQL database. Enter the system DSN name for the Data source. Security, Login: Using the login's current security context (have also tried using this security context and. Go to Enterprise Manager in the MS SQL Server and under the security folder, select the linked server, verify the following connection parameters: Provider: "Microsoft OLE DB Provider for ODBC Drivers". I would test everything with the 'sa' account and then change that when it goes to production Sep 15, 2017 at 17:32 Type whatever name you want in that box. If you use this method of defining a linked server, the name specified in Linked server must be the network name of the server. 0;Database=FilePath\fileName. OLE DB provider "MSDASQL" for linked server "SF" returned message "[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application". Thanks in advanced for your soon reply! #3 Roxana on 2009-12-22 17:37 You verified you have the. Since you are using a 64 bit server, you want the 64 bit drivers for linked servers. To get a list of installed OLEDB providers, use the SQL Server Management Studio and navigate to the "Server Objects" node and expand the "Linked Server" node. But i've still problems to connect I get "access denied" and "using password no" which indicates that the password defined in the ODBC data source is not even used in MySql. 3 Unicode (64-bit) Yes, many users, and we are extracting information out of the access databases in order to process information more efficiently in SQL. To set the mapped security context for the linked server: Right-click the linked server, and then click Properties. All the above seems ok (Microsoft SQL Server, Error: 7303). Ever tried to learn SQL, the query language that lets you poke at the innards of databases? Most tutorials start by having you create your own database, fill it with nonsense, and. Under Server Objects -> Linked Servers, Right click -> New Linked Server. Right-click the provider you want to configure and select Properties. oPreProcessExecution(RunType runType, ExecutionMode& executionResult) Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MISYS_SBM11". The Following solution is based on Oracle 11g and above versions. (Microsoft SQL Server, Error: 7303) Step 1: Remote desktop to SQL Server. (Microsoft SQL Server, Error: 7303) These errors only happen … I am trying to make a link between MySQL and MSSQL databases using ODBC Drivers. However in SQL server management studio, I am apparently lacking some authentication piece. To get a list of installed OLEDB providers, use the SQL Server Management Studio and navigate to the "Server Objects" node and expand the "Linked Server" node. See full list on learncom Oct 7, 2021 · I then delete the linked server The basic SQL script is attached. On this server, I created a linked server to a Microsoft Access Database called Property, which lives on a separate windows file. Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MYSQLDNS". I had several Linked Servers in my MS SQL Server database from which I was able to successfully query for a while. Advertisement Server comput. 0 Access Database Engine via a linked server. I would try downloading and installing the 64-bit version of the Access … Are you trying to create a linked server to another SQL Server? The error message suggests you are using ODBC instead of OLE DB. For whatever reason, when you visit an iTunes App Store link in the Chrome browser on iOS, it gives you an error and displays a string of text. Now trying to create the Linked Server. For instance, try to trace things on the Informix side. To get a list of installed OLEDB providers, use the SQL Server Management Studio and navigate to the "Server Objects" node and expand the "Linked Server" node. I created a SQL Server linked server and it's been working fine for last 2 years and suddenly not working. --HERE and HERE OLE DB provider "MSOLAP. The spreadsheet is on a network share and is spaces in the name and macros enabled on it (xlsm) The Linked server provider has "Allow inprocess" the SQL Man is running as administrator but i keep getting this error: Here will be entered configuration to connect to MySQL server: In the Linked server text box of the General tab, enter the name of how the linked server will be called (e MYSQL_SERVER). Sorted by: Reset to default The key to this issue is this line: Cannot create an instance of OLE DB provider "OraOLEDB. I got to the wizard to add a linked server and I configured it like so: Linked. Specify an OLE DB server type other than SQL Server. Voila! OLE DB provider "MicrosoftOLEDB0" for linked server "(null)" returned message "Unspecified error". The primary option for executing a MySQL query from the command line is by using the MySQL command line tool. (Microsoft SQL Server, Error: 7303) SQL Server Error: 7303 Event Logged or not: No. Server Type - Select "Other data source" as server type. Will use the same scripts from my previous post to create Linked Server to point to the Excel source. Linked Server: NewServer. The first thing to understand is that all linked server objects are accessible by everyone in the public database role (normally everybody). Search for SQL Server Service and right click it and select properties. Go to Enterprise Manager in the MS SQL Server and under the security folder, select the linked server, verify the following connection parameters: Provider: "Microsoft OLE DB Provider for ODBC Drivers". November 26, 2019 at 12:25 pm we migrated the linked servers from sqll 2005 to sql 2016 , when i tried to test the connection of a linked server getting the below error Linked Server Error 7303- Cannot initialize the data source object of OLE DB provider The Linked Server has been setup using SQL Server Management Studio. (Microsoft SQL Server, Error: 7303) To be clear, I'm looking to resolve the linked server issue that I'm currently facing, rather than consider alternatives such as Openrowset. I would check into the steps in these two but in particular checking and changing, if you can, the user who runs SQL Server: Cannot create an instance of OLE DB provider MicrosoftOLEDB for linked server null Yes, I can create SQL Linked Server on both servers, but running the "OPENQUERY" works only on first one (server1). And finally run import all your excel data to SQL server by running the below mentioned command : SELECT * INTO TargetTableName FROM OPENROWSET('MicrosoftOLEDB0', 'Excel 12. To get a list of installed OLEDB providers, use the SQL Server Management Studio and navigate to the "Server Objects" node and expand the "Linked Server" node. So that to me takes the login account out of the question. From my virtual machine I am able to use openquery to query my linked server. Adding and removing a few of the following suggestions will hopefully do it for you: 1) xlsx files need to be called with Excel 12. We would like to show you a description here but the site won't allow us. ups com drop off The purpose of this document is to explain how to fix issues running a SSIS package, Linked Server and SQL Agent which are using Oracle OLEDB under 64bit SQL Server. Step 2: Browse to PostgreSQL's official download site for psqlODBC and download the zip file containing the x64 bit The file we will download is called psqlodbc_09_03_0300-x64-1 We can see the driver is for PostgreSQL 9. Choose the Other data source radio button and from the Provider list, choose the Microsoft OLE DB Provider for ODBC Drivers item: On the server side run (dbaccess->Info->Nls). We have an application that uses the Access databases and is too large to rewrite now, so we have to keep the Access databases currently. Otherwise, the following message will appear when testing the SQL Server ODBC data source connection and the name of the SQL. Oracle" for linked server "CBSLINKED" returned me. Right-click Shared Memory, and then click Disable. Cannot initialize the data source object of the OLE DB provider "MSASQL" for linked server. servers to find the list of all defined linked servers and their associated OLEDB providers. I then delete the linked server The basic SQL script is attached. The LS was created, however our test connection attempts always return this: Cannot initialize the data source object of OLE DB provider "OraOLEDB. The primary option for executing a MySQL query from the command line is by using the MySQL command line tool. It is giving me the following error: TNS:listener does not currently know of service requested in connect descriptor". Oracle' for linker server ''. Oracle' for linker server ''. Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MANTIS". Oracle" for linked server "ABCD" returned message "ORA-03134: Connections to this server version are no longer supported (Microsoft SQL Server, Error: 7303). Ever tried to learn SQL, the query language that lets you poke at the innards of databases? Most tutorials start by having you create your own database, fill it with nonsense, and. I've created a System DSN to the instance and that passes the connection test, but when I try to create a linked server using that data OLE DB provider "MSOLAP" for linked server "XXX" returned message "The physical TCP/IP connection failed: An existing connection was forcibly closed by the remote host OLE DB provider "MSOLAP" for linked server "XXXX" returned message "The peer prematurely closed the connection (Microsoft SQL Server, Error: 7303) Enhancement Number Resolution. sp_testlinkedserver @name FETCH NEXT. OLE DB provider "OraOLEDB. free prodigy account An alternative is to set up login-mapping, but this is not good from a security. Cannot initialize the data source object of the OLE DB provider "MSASQL" for linked server. I need to create a linked server from a SQL server 2008 R2 instance on a 64 bit windows 2008 machine to a post Gre SQL on 32 bit machine. In this case, there is a real login into Windows and therefore the login is valid on the remote server. I can test the connection to the Windows ODBC both 64 and 32 successfully, and I have followed the following link to create a linked server … Method 1. 3 Unicode (32-bit) - This one is the one working with MS ACCESS3 ANSI (32-bit) ODBC 5. Hi All, I am trying to create a linked server to a PostgreSQL server. The permissions of that login on the remote. At this point i'm abit lost on whether im going in the right direction. Server virtualization allows for more than one server to operate on the same piece of hardware. we migrated the linked servers from sqll 2005 to sql 2016 , when i tried to test the connection of a linked server getting the. Linked server configuration: But I am still getting. The connection to the Linked Server is via my Broadbandinternet connection. Installing ODAC 11g 64 bit first in the SQL Server and then editing the TNS names solves the problem. Yes, I can create SQL Linked Server on both servers, but running the "OPENQUERY" works only on first one (server1). Aug 31, 2023 at 7:57. I had exactly this problem and I got it solved by doing these steps: 1) Go to Network Connections. Make the system administrator the owner of the job. Then check the Provider details while creating the Linked Server. If SQL Server is a named instance, type the name of the computer and the name of the instance separated by a slash (e WIN10\SQLEXPRESS). gacha characters Enter a provider string DRIVER={MySQL ODBC 31 Driver}; Under security, select Be made using this security context, enter the appropriate user id and password. Many a times I suggest people to keep away from Linked Servers as much as possible. OLE DB provider "MSDASQL" for linked server "databaseX" returned message " [Microsoft] [ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application". If you mean get data from the linked server, it seems not to support. but failed to retrieve data. Providing access to the linked server under specific SQL Server logins. OLE DB provider "MSDASQL" for linked server "MYSQL" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified". Microsoft today released SQL Server 2022,. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)". Ensure that server B is running listening for external connection and accessible from server A by network connection. Microsoft SQL Server 2008 (RTM) - 101600. The spreadsheet is on a network share and is spaces in the name and macros enabled on it (xlsm) The Linked server provider has "Allow inprocess" the SQL Man is running as administrator but i keep getting this error: The MySQL server is 101com. Advertisement In general, all of the machines on the Internet can be categorized as two types: servers and clients. I can test the connection to the Windows ODBC both 64 and 32 successfully, and I have followed the following link to create a linked server … Method 1. It can be annoying, then, to find yourself unable to connect to the server on which you have been b. How can I fix this? OLE DB provider "OraOLEDB. Provide the name for the Linked server, Select Other Data Source. However, if I run it from the SQL Server box itself logged in with my user account (just as I do from my laptop), it fails. This is the first crucial setting.
Post Opinion
Like
What Girls & Guys Said
Opinion
24Opinion
I have a SQL Server 2014 Standard (124100. Stored Procs are long, and irrelevant 138579-import-csvs. Select Microsoft OLE DB Provider for ODBC. Creating Linked Server to MySQL -- What am I missing? I have tried setting up a DSN and using the wizard to create the Linked Server object. I then delete the linked server The basic SQL script is attached. I can test the connection to the Windows ODBC both 64 and 32 successfully, and I have followed the following link to create a linked server … Method 1. Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "databaseX". Oracle" for linked server "LINKED_ORACLE" returned message "ORA-12154: TNS:could not resolve the connect identifier specified". To set the mapped security context for the linked server: Right-click the linked server, and then click Properties. Severity 16 Description: Indicates general errors that can be corrected by the user. " Twitter has resolved an issue that caused a widespread o. The test connection to the linked server failed. When you set up a linked server, you have the choice to re-use the credentials of the user, use a specific account or be anonymous. The error is pretty much the same when running the script and failing … Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "OraOLEDB. free land in washington state 0 Access Database Engine via a linked server. Expand Server Objects in object explorer and right click on Linked Servers folder and then click on New Linked server in the menu as shown below. 2) Click on Alt key and select Advanced and then Advanced Settings. If the linked server is defined as an instance of SQL Server, remote stored procedures can be executed Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (Microsoft SQL Server, Error: 7303) These errors only happen … I am trying to make a link between MySQL and MSSQL databases using ODBC Drivers. Our OPs team is asking me which ports are used to connect to the remote servers so that they can configure the firewall/switch properly (cannot ping some servers right now that I need to) failed with the following error: "Cannot initialize the data source object of OLE DB provider "MicrosoftOLEDB0" for linked server "(null)" Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly SQL Server is not able to. From my virtual machine I am able to use openquery to query my linked server. 0 is initialized under a user context that is not logged in to the SQL Server system where the linked server is defined. When errors appear on your credit report, they can have serious financial consequences. txt; If I run this script from my laptop using SSMS it works fine. SQL Server Identify the linked server as an instance of Microsoft SQL Server or an Azure SQL Managed Instance. Hi, i try to create linked servers in sql server 2014 to get the data from sqlite, but it showing this error messages. You might be able to find a similar package for 2013 by now. Oracle provider, select properties and check the "Allow inprocess" option. We would like to show you a description here but the site won't allow us. A combination of enabling the "Allow inprocess" provider option for the OraOLEDB. I have two SQL Server instances on same machine and I want to fetch data from each other. but failed to retrieve data. With its robust features and seamle. Find a company today! Development Most Popular Emerging Tech Development Langu. With this configuration: I get this error: I have tried with all these versions of MySQL OBDC Drivers: ODBC 5. Data is the lifeblood of any organization, and in the world of databases, SQL Server is one of the most popular choices. games 77 Enter the System DSN name for the Product name. (Microsoft SQL Server, Error: 7303) In the Product name box, put the name of the OLE DB data source to add as a linked server (e Excel). Make sure the user info is correct and has all the required permissions on the database. Made sure the Excel file was closed. Cannot initialize the data source object of OLE DB provider "ASEOLEDB" for linked server "BARCODE". Thanks in advanced for your soon reply! #3 Roxana on 2009-12-22 17:37 You verified you have the. When I attempt to create a linked server to the oracle database from SQL Server Management Studio, I get the error: Cannot create an instance of OLE DB Provider 'OraOLEDB. Installing ODAC 11g 64 bit first in the SQL Server and then editing the TNS names solves the problem. Oracle" for linked server "ABCD" returned message "ORA-03134: Connections to this server version are no longer supported (Microsoft SQL Server, Error: 7303). txt; If I run this script from my laptop using SSMS it works fine. I am running SQL Server 2012 on a server (server 1) and have set up a job to run a stored procedure which will summarize data from a series of tables and update a table on a linked server (server 2) which is also SQL Server 2012. 64 bit SQL severs need 64 bit drivers, same for 32 bits. I found some advices on different forum and follow it. jockstraps for men Providing access to the linked server under specific SQL Server logins. Enter a provider string DRIVER={MySQL ODBC 31 Driver}; Under security, select Be made using this security context, enter the appropriate user id and password. Symptoms Creating a Linked Server using 64 bit OraOLEDB and Micrsoft SQL Server 2008 Management Studio 64 bit fails when testing the connection with I need to make a linked server on a SQL Server instance to get data from Oracle, but I'm finding it difficult. I found some advices on different forum and follow it. Oracle" for linked server "TestOraLink" returned message "ORA-12154: TNS:could not resolve the connect identifier specified". The permissions of that login on the remote. txt; If I run this script from my laptop using SSMS it works fine. The Linked Server provider was Oracle Provider for OLE DB. (MicrosoftConnectionInfo) Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MYSQL". When the Informix oledb provider finds the "€" it complains as it's not suppose to be there, it won't be able to convert it to 1252. Advertisement In general, all of the machines on the Internet can be categorized as two types: servers and clients. Cannot initialize the data source object of OLE DB provider "OraOLEDB. I am trying to create a Linked Server from an office based SQL Server Installation to a remote MySQL database. Oracle" for linked server "ORA_CSSA2APD" returned message "ORA-12154: TNS:could not resolve the connect identifier. At present it connects using a SQL login (which works as I can connect to the linked server using the login), so I don't think its the Kerberos double hop issue.
So I think step 1 is done. Server Type: Other data source. sql-server; odbc; ibm-midrange; Share. Data is the lifeblood of any organization, and in the world of databases, SQL Server is one of the most popular choices. July 15, 2012 at 10:44 am I ran a script to create a Linked Server, however I was obviously not correct. Hi @scurrp, If you mean use SQL linked server connect to power bi dataset, it is possible. yuzutyie Oracle" for linked server "TestOraLink". The Linked Server works great when I login to the local server using a SQL-login account with sysadmin server role. I have two SQL Server instances on same machine and I want to fetch data from each other. He holds a Masters of Science degree and numerous database certifications. An error stating that a program cannot find a server indicates that there is a connection error. why did rj3 kill himself I can successfully run the stored procedure on it's own, but when the scheduled job runs, I get the following error: OLE DB provider "MSDASQL. But it cannot happen all the times and there are code blocks in their. Add "-g512;" to the front of the value for parameter "Startup Parameters". (MicrosoftConnec tionInfo) Cannot initialize the data source object of OLE DB provider “MicrosoftOLEDB0” for linked server “FTPsvr” OLE DB provider “MicrosoftOLEDB0” for linked server “FTPsvr” returned message “Unspecified error”. who uses word salad If a connection to @srv failed at the time of linked server creation: 7303 | Cannot initialize the data source object of OLE DB provider "SQLNCLI11" for linked server "whatever". Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41 Cannot initialize the data source object of OLE DB provider "MicrosoftOLED. Post restart of SQL server services. Type Services. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)". I have a local SQL Server 2008R2. 0 is initialized under a user context that is not logged in to the SQL Server system where the linked server is defined.
If I look at the properties of the linked server, there are pretty standard. Provider: Microsoft OLE DB Provider for ODBC Drivers. Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41 Cannot initialize the data source object of OLE DB provider "MicrosoftOLED. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "OraOLEDB. Web server log files identify server errors that need to be corrected, help identify suspicious activity and highlight security flaws. It would be best to use the … Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "BIDDY". Otherwise, the following message will appear when testing the SQL Server ODBC data source connection and the name of the SQL. Oracle" for linked server "TestOraLink" returned message "ORA-12154: TNS:could not resolve the connect identifier specified". If you are looking for a comprehensive solution to streamline your da. ConnectionInfo) 'Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked. I found some advices on different forum and follow it. I am running MSSQL 2008 R2, as well as MySQL 5 Both database servers are running on the same Windows Server 2008 machine. These errors indicate that SQL Server is not able to initialize the OLEDB provider that is specified in the definition of the linked server. Cannot initialize the data source object of OLE DB provider "OraOLEDB. I do know a surprising amount about FoxPro and dBASE and linked servers. nys wmu map with towns OLE DB provider "MSDASQL" for linked server "SF" returned message "[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application". (Microsoft SQL Server, Error: 7303) Step 1: Remote desktop to SQL Server. Ihave scheduled the Job to run when SQL Server Agent starts and I haveconfigured my SQL Server and SQL Server Agent to start when the OSstarts. If you plan on running 32 bit packages on the server, you would need to install the 32 bit ACE as well. Make sure the user info is correct and has all the required permissions on the database. Oracle in the list of Linked Server Providers. Oracle in the list of Linked Server Providers. The Oracle Application. I have configured Linked Server to a remote database. Here's my config: For security, I'm trying for now with a fixed security context, using the same credentials that worked when testing the connection with Oracle Net Configuration Assistant OLE DB provider "MSDASQL" for linked server "" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified". This was working on a sql 2005 box, but not on this 2k8 r2. When you tested it from the same machine, and SQL Server was running as a local account, it worked because it was able to re-use the admin privileges of you while you were logged-in. Oracle provider, select properties and check the "Allow inprocess" option. Provider: Microsoft OLE DB Provider for SQL Server. Oracle), restarting the SQL Server Windows service and lastly adjusting the permissions on the TNSNAMES Hi All, I am trying to create a linked server to a PostgreSQL server. The SQL Connection Manager may be inactive or using a different transport protocol from the client (Microsoft SQL Server, Error: 7303) Cannot initialize the data source object of OLE DB. I am trying to create a Linked Server from an office based SQL Server Installation to a remote MySQL database. Even for SA like for any other SQL Server login: To see all created linked servers in SSMS, under Object Explorer, chose the Server Objects folder and expand the Linked Servers folder: To create a linked server in SSMS, right click on the Linked Servers folder and from the context menu select the New Linked Server option: The New Linked Server dialog appears: Created a DSN and referred it in the Linked Server. The Following solution is based on Oracle 11g and above versions. This is the driver that gets installed along with the Oracle Client Components. Oracle" for linked server "UDW" Net SqlClient Data Provider) The solution is to go to the provider options and check allow inprocess. With later versions, expand Server Objects > Linked Servers. princess margret lottery (Microsoft SQL Server, Error: 7303) I have the client installed, a system ODBC using the tns names file working fine. I have to create a linked server to get the data from a mdb file (MS Access). 1 Driver]Lost connection to MySQL server at 'waiting for initial communication packet', system error: 10060". This issue happened to me, as well. You can also execute the following query if you don't have access to SQL Server Management Studio : Accessing an Oracle DB over a 64 bit system was a pain for many SQL Server DBAs. Security, Login: Using the login's current security context (have also tried using this security context and. but failed to retrieve data. Installing ODAC 11g 64 bit first in the SQL Server and then editing the TNS names solves the problem. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MicrosoftOLEDB0" for linked server "(null)". Adding and removing a few of the following suggestions will hopefully do it for you: 1) xlsx files need to be called with Excel 12. Make the system administrator the owner of the job. Sep 2, 2020 · Linked Server: NewServer.