Databases
StackOverflow2013
Postsdbo
POHow to create SQL server2005 database on remote machine using JDBC?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to create SQL server2005 database on remote machine using JDBC?
    primarykey
    data
    text
    <p>I am creating a desktop application, in which I have to log in into SQL Server 2005 on the remote machine and have to create a database, User etc. By using jTDS I am able to create a connection to the database as well as able to execute "SELECT" commnads but not able to execute database commands like- create database, create user etc. </p> <p>Here is my test code:</p> <pre><code>public class Test { // JDBC driver name and database URL static final String JDBC_DRIVER = "net.sourceforge.jtds.jdbc.Driver"; static final String DB_URL = "jdbc:jtds:sqlserver://10.96.11.31:1433;useNTLMv2=true;domain=myDomain"; public static void main(String[] args) { Connection conn = null; Statement stmt = null; try{ //STEP 2: Register JDBC driver Class.forName(JDBC_DRIVER); //STEP 3: Open a connection System.out.println("Connecting to database..."); conn = DriverManager.getConnection(DB_URL); //STEP 4: Execute a query System.out.println("Creating database..."); stmt = conn.createStatement(); String sql = "CREATE DATABASE STUDENTS"; stmt.executeUpdate(sql); System.out.println("Database created successfully..."); }catch(SQLException se){ //Handle errors for JDBC se.printStackTrace(); }catch(Exception e){ //Handle errors for Class.forName e.printStackTrace(); }finally{ //finally block used to close resources try{ if(stmt!=null) stmt.close(); }catch(SQLException se2){ }// nothing we can do try{ if(conn!=null) conn.close(); }catch(SQLException se){ se.printStackTrace(); }//end finally try }//end try System.out.println("Goodbye!"); }//end main }//end JDBCExample </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBill the Lizard
    1. USvermap
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to create SQL server2005 database on remote machine using JDBC?
      1. USJon
      1. VTFavorite
    2. VO
      singulars
      1. POHow to create SQL server2005 database on remote machine using JDBC?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COAs long as the login you are using has the appropriate permissions you should be able to do this in the same way, for example with the exeute() method of a Statement. Please paste the code you are using to execute and the error you are getting.
      singulars
      1. POHow to create SQL server2005 database on remote machine using JDBC?
      1. USJon
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload