Tag: connection

Will SqlClient or ADODB work if SQL Server is placed on a centralized server in network?

The scenario is that I will be placing database on a centralized server and all the clients will have front ends accessing it, as I am connecting the front end and the back end I run into the question of whether using ADODB or SQLClient as my connection driver. I had preferred SQL Client these […]

Application can't change DNS to IP on SQL Server connection

I have a weird issue in C#. I have SQL Server database hosted remotely. My C# application is connecting to this database using DNS name as Server name. Let’s say: “myremoteserver.com”. I use connection string etc. If I run my app from Visual Studio it’s working correctly. Connection is made, can do what I want […]

Debugging database connection leak in concurrent environment

I’m currently working on a project which was originally not build for high load. My problem atm is that at some point during the stress test (30 users) the application seems to “get stuck” and when it releases it spits out a lot of exceptions. Unable to get managed connection for [MY_DS] When I run […]

C# – Can't connect to my local DB, using SQLServer

I’m new to C# and I’m trying to connect my application to DB, so I tried this : public ActionResult ConnexionBD(){ SqlConnection cnx; cnx = new SqlConnection(“Data Source=C:\\Users\\Antoine\\Documents\\Visual Studio 2012\\Projects\\Application\\Application\\App_Data\\Database1.sdf;Initial Catalog=tstado;Integrated Security=True;Pooling=False”); cnx.Open(); SqlCommand cmd; cmd = new SqlCommand(); cmd.CommandText=”INSERT INTO Objet VALUES(1,’F’,”+DateTime.Now+”,’Moi’)”; cmd.CommandType = CommandType.Text; cmd.Connection = cnx; cmd = new SqlCommand(); cmd.CommandText = […]

SSIS dynamic connection to the source and destination.

Hi I want to create 1 SSIS packge that load excel file into a customer DB. I have 100 customers db’s and I also have evrey new week 100 excel files (All the DB’s and files have the same structure) the db’s name is the CustomerName and the excel file name is CustomerName_date. I want […]

Connecting java to SQL Server 2014

I’ve been having these problem for 2 straight days. I wanna cry lol. Anyway, I have Java 1.8, an Eclipse and SQL Server 2014. I’ve tried using JDBC ODBC and ucanaccess but it still gives me an error. Here is my code in ucanaccess: public static void main(String[] args) { try { Connection conn=DriverManager.getConnection(“jdbc:ucanaccess://C:\\Program Files\\Microsoft […]

SQL server for php whit USBWebserver

I have installed the lastest version of sql-server for php. I use a simple USBWebserver and I have pasted all the driver files to the map C:\php\ext (see image below). In the file php\php.ini, I have place this string behind: extension=php_sqlsrv_56_ts.dll Here can you see all the files in C:\php\ext for running the driver: Whit […]

SQL Server Management Studio – change connection to registered server?

Seems like this would be a fairly popular question to get asked, I did a quick search and didn’t see anything. I’m curious to see if there is a way around this. I spend my entire day in SSMS, and I am constantly changing my connection between many different servers while working within the same […]

Linking SQL to AutoCAD 2016

So I have learned how to create a connection between AutoCAD and my SQL Server using the ‘DBCONNECT MANAGER’ tool within AutoCAD. My next goal is to try and change the value/text of an existing label I have created in AutoCAD through an SQL update. I am fairly experienced in SQL but I am very […]

Connect Netbeans 8 to SQL Server 2014?

Win 8.1 Netbeans 8.0.2 SQL Server 2014 I’m trying to create a (very) small project — Nothing huge, just get data from SQL Server to Netbeans. Problem is I can’t seem to get a connection. Nor can I find any information about how to connect these versions. I’ve tried following steps to connect older Netbeans […]

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.