sql server 2005 - JTDS for MS SQL in android with ADT -


first of maybe repost of: https://stackoverflow.com/questions/13078271/trying-to-use-jtds-in-android-project, not sure, seems there's no answer in post i´ll try here, issue is, im trying connect ms sql 2k5 via jtds (though jtds connection fine, tried on pure java test , connect successfully) on android adt (eclipse) , can't found class in classpath getting typical exception classnotfoundexception, did encounter problem before did know solve (except running program via command line "java -cp" , cause don't know how dalvik, set classpath via "build path" eclipse option, put jar @ libs/, after xxx times of failure getting exception erase jars in libs/ , remove jars via "build path" option, clean project , restart eclipse, set jars again, still got same exception, still pending; configuring varible via windows classpath variable, other ideas guys?

software: windows 7 professional 32 bits jdk 1.7 adt eclipse jtds 1.3 (latest in web page) ms sql 2k5 android 4.2.2

note: if need code, ask (i don't think necessary, same code runs flawless in pure java via netbeans same jtds).

seems hard topic touch (cause of no answer) anyway, solve problem, here leave step step.

1: install ms sql 2k5 (be aware of put db access on mixed (window auth , sql user/pass , extrictly put password sa user mandatory)

2: install ms sql management studio (if want make things more easy, optional) create database via gui , prove inserting (or whatever doing db) android device being done.

3: configure ms sql, go to: sql server configuration manager; sql express protocols; tcp/ip in first tab (protocol) put "enabled" yes, in ip tab, put ipv4 enabled yes, ipv2 enabled yes , @ ipall put tcp port 1433.

4: go jtds-1.2.x-dist folder , enter x86 (if 32 bits os in case 64 x64 folder) sso , copy ntlmauth.dll jdk/bin or jre/bin folder.

5: won't paste code here string connection important thing:

conn = drivermanager.getconnection("jdbc:jtds:sqlserver://192.168.3.67:1433/androiddb", "sa", "1013")

6: aware ip used connecting android device ipv2 , not ipv4 default 127.0.0.1 or localhost if use of won't work, use ipv2 version.

i test real android device, samsung galaxy tab, if try emulator maybe must use 10.0.2.2 ip, not sure since didn't test it, 1 more important thing, time wrote 1.3.0 jtds wasn't working android 4.2, that's why said in jtds step @ jtds-1.2.x-dist, must use 1.2.x version now.

hope helpful anyone, regards.


Comments

Post a Comment

Popular posts from this blog

jquery - How can I dynamically add a browser tab? -

since using iframes house external pages are, accounts "not preferred method" , disallowed sites (flickr, one), want dynamically generate browser tabs. e.g., when user submits form, want dynamically generate tab on browser in response submitted. e.g., might want add new tab url like: http://www.bigsurgarrapata.com/contact how in jquery? you want form target attribute action attribute. http://www.w3schools.com/tags/att_form_target.asp browsers have ultimate control on result of target attribute open new tab value of _blank. <form action="contact_submit.php" target="_blank" method="post">
Read more

node.js - Getting the socket id,user id pair of a logged in user(s) -

i have web application done using node js , in it,i have authentication system requires users log in before can access pages. have 2 pages,the homepage , updates page. from read docs,a new socket id issued when user opens tab in browser. me being admin,i know socket id of logged in user , more so,the socket id,logged in user id pair logged in users. what method can use socket id,logged in user id pair make sure broadcast realtime info users online?.
Read more

keyboard - C++ GetAsyncKeyState alternative -

i using windows.h library's getasynckeystate function define key pushed on keyboard . here program returns int value of pushed key example. #include <iostream> #include <windows.h> using namespace std; int main (){ char i; for(i=8;i<190;i++){ if(getasynckeystate(i)== -32767){ cout<<int (i)<<endl; } } return 0; } but trying make opengl simple game , function appeared slow . there function not need cycle 180 times , if statement . thanks you're trying make opengl game, you're going use glfw. if that's case can away using glfwgetkey() such: if (glfwgetkey(glfw_key_up) == glfw_press) {...} if (glfwgetkey(glfw_key_down) == glfw_press) {...} that method nicely explained in tutorial 6 opengl-tutorial.org . should start first tutorial of beginners tutorials , later intermediate tutorials . if you're going make win32 window can listen wm_keydown or wm_keyup messages , virtua
Read more