How do I connect to SQL Server remotely and administer my datbase objects? I need to connect to my database in the web hosting company's server. I have the server name, IP address, my database username & password. I have an installation of SQL server 2000 in my machine. I searched the net but couldn't find understandable links. Can I use...
Hi, We are developing an order taking system in PDA using C# in .netcf 2.0. So we are having mysql server as our back end. Is that the web service is the only way to connect mysql with PDA? Or is any other methods available..? ...
I am a newbie in silverlight. and I want to know that how can we connect our application to a Database. I am using a SQL 2005 server as a Database. and I don't want to use Linq... so please suggest me how can i make connectivity either directly in silverlight or by using a web service I don't have any problem in using webservices. Pleas...
Hi, One of our customers has a newish problem: the application grinds to halt. Thread dump shows that all threads are hanging on network IO in jdbc calls. We/I have never seen these 'network IO' hangs. Typically a slow machine w/ DB problems has either a) one or two long-running queries or b) some type of lock/deadlock. In either of t...
I have all the details to connect to a Oracle database on the network. I am able to connect to the Oracle database using Oracle developer express. How do I connect to Oracle db from VB.net. I added reference to system.data.Oracleclient and specified the connection details and it gave me Listener error. Please help ...
Platform: Windows XP, Qt Creator Ide 4.5.2 MySql is setup here as well. I want to establish database connection with Qt and mysql. The line QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL"); generates error like below: QSqlDatabase: QMYSQL driver not loaded QSqlDatabase: available drivers: QSQLITE QODBC3 QODBC It seems QMYSQL ...
I want to print a value that is returned by sql server. If NOT Exists(SELECT * FROM ItemList WHERE ItemName='txtItemNama') BEGIN INSERT INTO ItemList (ItemName) VALUES('txtItemNamea') END ELSE BEGIN Print 'Duplicate' END This query will either return me either no of rows effected or Duplicate I want to ...
I have a problem connecting to IBM (universal) database using JDBC. I wrote the code in Notepad using Java and I loaded drivers of IBM database i.e(driver name and connection URl). When I run the code using general compilation (javac code.java and java code) I am getting an error message "cannot find the driver" but I specified the corr...
I need to develop a single routine that will be fired each 5 minutes to check if a list of SQL Servers (10 to 12) are up and running. I can try to obtain a simple query in each one of the servers but this means that I have to create a table, view or stored procedure in every server, even if I use any already made SP I need to have a re...
My kind webhost (1and1) royally asked me to go elsewhere to do something like this. I have 2 sites. One of them was developed by a .Net programmer. Now I am contracted to implement a PHP site and fetch data from the .Net site. There is an ASP.Net form that a customer fills and when they hit submit, the data gets stored in SQL Server DB...
Hi, I have sql server 2008 installed on my dev machine. How I figure out things like, the name of the server, do I connect to it using windows auth or using sql auth. If I connect using sql auth what is my account information. I set it up a while back and I dont know how to read all the sql server install and configuration information....
I have installed SQL server 08 express edition and then tried to connect using SQL server management studio, but getting below error: TITLE: Connect to Server Cannot connect to My-PC\SQLSERVER. ------------------------------ ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establish...
Does anybody know how psql accesses PostgreSQL database? What it uses odbc, jdbc or some native database library? ...
Can any one give The Example php code for connecting and getting a sql stored proceedure ...