SQL Server Reporting Services 2012 ODBC Connection String
I am trying to make a new ODBC connection to our company's SQL Server Reporting Services 2012 server to reach an Oracle db, however I've been unsuccessful trying to create the connection string. I've been told the tnsnames entry is available on the server, however when I try to connect to it the connection fails.
Locally on my PC the connection string is Dsn=ROD_UAT which functions fine, but not on the SQL Server Reporting Services 2012 server. I was hoping someone might have an idea of what the string should look like and contain. The ODBC connection is to an Oracle database, I have the host name, SID, port, ID and PW.
I've tried most ODBC strings on this site, but keep getting error, "The permissions granted to user 'TUS\AYO1XTT' are insufficient for performing this operation. (rsAccessDenied) Get Online Help".
Thank you in advance!
You will need to talk to your DBA that set up the oracle client and connection on the SQL Server. The connection string will be in the tnsnames.ora file on the server. Could be anything, depends how standardised your DBA is in their approach to defining the file. Essentially the string is an alias to a complex (ish) set of parameters that point at Oracle machine/instance/listening port.
Are you saying the tnsnames.ora entry is what I should use as the connection string? I thought the presence of the tnsnames.ora file means I only have to reference the entry in the connection string.
For instance, the tnsnames entry was called RODUAT, so my connection string would be Dsn=RODUAT. This approach doesn't work of course but I don't understand why the tnsnames.ora file is even needed if I create the entry as the connection string.
I actually supplied the DBA with the tnsnames.ora string, but it does not work when I use it as the connection string.
Non-Standard Port with SQL Server ODBC
Why does the SQL Server ODBC Connection page not mention any example of using a non-standard port? I was incorrectly trying to use the "Port" attribute as "Port=x" but that does not work.0 votes0 answersDavid Garcia3 weeks ago
NUODB to SQL database migration
Hi Guys I am using SQL Server 2012 , using import and export wizard i want to migrate nuodb databse to sql , but could not find any JDBC data source inside the wizard.0 votes0 answersGautam Raj3 weeks ago
Connection string issue in connecting to SQL Server
I am trying to connect my C# code to SQL Server. My connection string is not working. It gives the following error: "Format of the initialization string does not conform to specification starting at index 0."0 votes0 answersFaizan Rahman2 months ago
[Microsoft][ODBC Driver Manager] Data source file not found and no default driver specified.
I have a VBA code (in excel 2016) that i use to grab information from a MS SQL server (2008R). The connection works fine on the computer i wrote it on. When i run it on another computer i get the error "[Microsoft][ODBC Driver Manager] Data source file not found and no default driver specified".0 votes0 answerslee avery2 months ago
Remote MySQL Linked Server in SQL Server, only show names of the tables.
Remote MySQL Linked Server deployed in SQL Express Management Studio do not show any content and structure, it only LIST NAME of the tables belongs to the remote connected MySQL database0 votes0 answersAdrian Feldman2 months ago
connect from Oracle to MS SQL Server
I want to Connect from Oracle to MS SQL Server with a connection string to pass location (IP) / username / Password and SQL Database !0 votes0 answersFrank Lehmann2 months ago
Excel 2016 VBA OLE SQL connection help
Excel 2016 VBA to create an OLE connection to a sql 2014 db and then execute a stored procedure returning the results starting cell A1 on sheet :StoredProcData. Server & instance is QGZZZ\MYINSTANCE db is data0 votes0 answersRichard4 months ago
how to use regional settings when connecting to SQL Server with a connection string? Is there a parameter for it?
How do i specifiy to use the regional settings (those settings in Windows control panel) for numbers, dates and currency? When defining a DSN connection in ODBC manager Windows i can check to use the regional settings.0 votes0 answersMatthias Rebbe6 months ago
Difference between OraOLEDB.Oracle and OraOLEDB.Oracle.1
What is the different between these two connection strings? Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername; Password=myPassword; Provider=OraOLEDB.Oracle.1;Data Source=MyOracleDB;User Id=myUsername;0 votes1 answerTwenty Dily6 months ago
Connecting to Oracle using python's pyodbc library
I am trying to connect to Oracle 12c R1 using the python library pyodbc. I am having zero luck. Can anybody help? thx in advance!0 votes0 answerstodd Turczynski6 months ago
- Load more posts