dsn_oracle_sql-server-2012_sql-server (page 2) Questionssubmit your own question

I'm a student learning programming. I need to find out what web address gets my database and server. I need to find out what the database name is.

I try to transfer a classic-asp-application from Windows Server 2008R2/II7 to 2016/II10 and SQL 2008 to SQL 2016. The application works fine with IIS10 and SQL 2008. Also with IIS7 and SQL 2016.

SSIS package works fine in Visual Studio, But when deployed it says gives error, SQL Jobs fails execution

Hello. I have an Oracle 11g Express installation on my personal Windows 7 PC. Its DB name is the default - XE. I can connect to it in sqlplus just fine.

I'm trying to make use of gMSA's to connect from ASP/X code to an MS SQL 2016 server. I've configured the gMSA with permissions on the target database and set up the gMSA on the source server, but can't get a connection string configured to use the account.

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.

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.

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."

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".

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 database

I want to Connect from Oracle to MS SQL Server with a connection string to pass location (IP) / username / Password and SQL Database !

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 data

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.

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;

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!

Hi All I have informix DB and I am connecting to the database using ODBC Query tool through DSN connection. I can connect to database using dsn without username and password but I can't connect if I give the same settings in the connection string.

ODBC connection in Oracle . Have written a VB script which connects to an Oracle database using ODBC connection string. When trying to connect its gives me an error [Microsoft][ODBC Manager] Data Source Name too long.

Trying to connect to a SQL Server 2014 and receive the error : (System.Data.OleDb.OleDbException: '[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.')

Hi, I'm maintaining a C# .NET application. It is connected to an MSSQL database via ODBC connection. The constring is: Driver={SQL Server};Server=##.##.#.#;Database=QA;UID=SYS;PWD=__;

Hi everyone I´m working with Visual studio data tools to create a DTSX that will work in SSIS. when I create the ODBC Connection I need to write a USER and PASSWORD for this connection but the password is not persistent.

I need to insert in oracle db multiple rows with INSERT ALL statment. I note oraoledb.oracle provieder doesn't run with this statment. It needs Driver={Oracle in OraClient11g_home1} connection. It is correct?

Hi I've taken over a ASP.Net site using an Oracle back-end, I can get it to connect to the database on our development PCs but on the live server, I'm having an issue as follow and wonder if anyone could help as not an Oracle expert and the Oracle server was setup many years ago...

Hi I've taken over a ASP.Net site using an Oracle back-end, I can get it to connect to the database on our development PCs but on the live server, I'm having an issue as follow and wonder if anyone could help as not an Oracle expert and the Oracle server was setup many years ago...

Hi I've taken over a ASP.Net site using an Oracle back-end, I can get it to connect to the database on our development PCs but on the live server, I'm having an issue as follow and wonder if anyone could help as not an Oracle expert and the Oracle server was setup many years ago...

I have developed an ASP.Net Web Forms website on my local computer. I installed SQL Server Express 2017 on the local computer. I have a SQL Server database connected to SQL Server Express using the following code in web.config:

Connection is not opening when I try to open using VB.Net to MS SQL server 2016 with port 1600. My connection string is "Public globconnectionstring As String = "Server=learningserver.com,1600;Database=learning;User ID=readonly;Password=readonly"

Hi ADO is undeprecated. There is a new release of ADODB driver for SQL Server. It supports SQL Server from 2012 to 2017 and Azure also. Follow the link: https://blogs.msdn.microsoft.com/sqlnativeclient/2018/03/30/released-microsoft-ole-db-driver-for-sql-server/

I have to use fixed Domain user in connection string to connect to SQL server. But the logged user for windows is different. Is there any solution . this is requirement of our project. Please help .

Hello, I'm working on programmatic queries relying on the Oracle provider for OLE DB (in VB script). I can successfully query my database using the standard syntax: Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;

Hello, Could anyone please tell me what do I need to do in order to connect to Oracle 11g through VB script. I already had my tnsnames.ora file set up on my machine and I was able to TNSPING to the Oracle 11g database and I was also able to SQLPLUS mylogin/mypassword@database.