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.
I'm new into using Automations and dotnet, so i'm trying to learn (if I don't explain correct ). I'm trying to connect from NAV 2016 to an external SQL Server 2014 to read and post data to this.
Hi, I want to connect UiPath(Robotic Process Automation) with oralce data base 12c. i tried alot to find the solution via google, but no success. please post your suggestion. I tried with the following string :
i have installed SQL server 2016 on a VPS that is running Win server 2016, i have enabled TCP/IC conectivity and made inbound rules for ports 1433,1434 and SQLSERV.exe.
Dear fantastic geeks, I'm reaching out to you wishing that you could help me with this one. I'm trying to connect a UNIT4 Agresso DB to PowerBI so I coulld create live visualization of the data; just like what has been done in this post but I'm nothing near that.
I have domain name, and host account with a service provider. I want to host a sql server database through the service provider. I'm developing a windows forms application that I want to access this database. Whats the way to go with this situation?
hi What does MLD=0 represent in the attribute of a Odbc Connectstring? Thanks N
I am getting error as below: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified I have installed the ODBC driver to connect to SQL server.
Hi I made a program in visual c# 2013 and aql 2012.i want to create connection string that automatically use and setup in a system with sql express.and so automatically attach database.how can i do????please help me
Hi , kindly assist.. am trying to import data from excel to sql database. am using excel 2016. am getting the following error " "System.ArgumentException: Keyword not supported: 'provider"
I have trouble to run my app when installing on another system the language is c# and I used DataAdapter and drag table to form to connect to db. when I Install on another system it gives sql server error :
I'm fairly new to databases and Web Services. A small project I want to do involves making a Web Service that connects to a database.
We have Two Site ( "A" & "B" ) and both site are different subnet (Site "A" 125 sunbet ) (Site "B" 240)and we has been installed Two type of SQL Cluster 2014 one site "A" and another one Site "B"
hi, I am using Oracle SQL Developer version 1.2.1. I want to connect to the Database server using VBScript. I wrote the below code but getting an Error "database source not found and no default driver specified".
Hi, Two questions I wish to ask.... Domain user id and password not working in connection string. Server=IDB01\MS;Database=Tax;User id=in\sqluser; Password=123**;Connect Timeout=0;
Hi All Can we get which application are connected to sql server and also best recommendation document to keep performance good please share documnets
I seem to be having problem with connection a SQL Server 2016 with AlwaysOn feature using the user credentials. Our DBA created a contained database user.
I have to support a VB6 app still in production (ugh). A customer is specifying our software needs to be PCI compliant which requires TLS 1.2.
the error is in conn.Open("Provider=SQLNCLI10.DLL;Persist Security Info=False;Initial Catalog=backup_db;Data Source=acer\JOSEPH")
I am trying to read from an SQL Server database which is hosted on MS Azure, through an ASP.NET WebForms website, created in Visual Studio 2013. I've stored the connection string in Web.Config, and have referenced it in the Code-Behind.
Hi, I am trying to use Microsoft Azure to host an ASP.NET Web Forms website, and connecting an SQL Server database (also hosted on Azure) to it. So far:
Using C #, connect to a database created with SQL Server 2014 Management Studio using Visual Studio 2015. I am interested to know which string to use to be able to connect from Visual Studio 2015 to "DatabaseProva"
I have a project where I have to send data from an Excel spreadsheet to an Oracle database. I have installed the latest Oracle client and the ODBC drivers.
I've read many questions about that problem but i still can't solve my problem. When I run my website on localhost everything is working. The problem happens when I run my site on SQL Server 2008. I've got an error:
I'm trying to export the data from multiple database from a single server into one excel using VBA code. Please can anyone help.
Hello, We decided to move towards the ODBC drivers. I installed the ODBC Driver 13 for SQL Server. For that we desided to use MSDASQL provider for ODBC Drivers , our existing application uses ADO and SQL SERVER 2008 R2.