We help IT Professionals succeed at work.

android - insert/select/upate data into MS SQL Server 2005

GlobaLevel
GlobaLevel asked
on
I have data that I need to insert/select/upate data into MS SQL Server 2005...does anyone have the connection strings...or the android/java code to perfomr this function? thank you
Comment
Watch Question

Awarded 2011
Awarded 2011
Commented:
Don't know if Android will have different connection strings, but

in general for JDBC connection to MS SQL 2005 connection string is:
java.sql.DriverManager.getConnection("jdbc:sqlserver://server;user=myuser;password=mypassword");

Open in new window


for mMicrosoft driver
http://www.microsoft.com/sql/downloads/2005/jdbc.mspx


for jTDS driver see here:
http://stackoverflow.com/questions/1862283/help-me-create-a-jtds-connection-string