Related
any detailed how to guide?, i can do it, i'm fairly tech savvy, so i just need to kneed out a few things. maybe if you caould start from the beginning and i can see where i went wrong.
logmein.com works, but i want something more personal, just bewtween the computer and my phone. somerthing that looks good and scales full screen preferably.
please guys?, point me in the right direction.. all the posts just keep saying to search and there's lots of info, but there's no step by step guide.
thanks guys!
ok i got it going.
first go to the computer you want to connect to and go to control panel / system
click on remote, enable remote users
go to start menu, run. type cmd
in command write "ipconfig /all"
take note of your ip address
on your phone go to remote desktop,
computer = your ip address
username = (go to startmenu, control panel, user accounts) use one of those names.
password = blank unless you have a password.
domain = i left blank.
connect full color unless it doesnt work for you
if you can connect and you get a password error
type the error you get inot google and you should get a fix as your first link.
try that.
blam, remote desktop, it's awesome.
Nice how-to...
this is the most succinct tutorial on how to do this that I've seen. I'm still having trouble, though. I get the "Cannot connect. Likely reason are: 1 the remote comupter is not set up for this. 2. Reached the maximum number of connections. 3. A network error occurred while connecting."
I have set up the XP PC, & taken down all firewalls. I only have one user account and it has a password. I've even tried using Hamachi with one of their VPN ip addresses (awesome and free for pc2pc). I 've combed trhough my router settings too, and tried to clear everything there, too. I can RD from an XP laptop, so ti seems to be something on the unit, to me. I've also setup file sharing w/ Total Commander (it's served my purposes amply).
I really have googled & googled & googled. If anyone has any idea what is going on, I'd be grateful for some ideas.
Have you enabled the RDP on the host computer?
Right click my computer
Properties
Remote
Then enable allow user to connect remotely.
Will only work on XP Pro, or Vista if you choose to allow older clients which they scaremonger you against by saying it's less secure.
Danke!
I've been scared away from Vista for the usual "new" OS reasons, but perhaps it's getting to be time for me to haul my old conservative back-end into the modern world.
Thanks so much for taking the time!
(and to Biohead: yes, I followed the instructions I lauded so vehemently.... ???)
you're running vista?
and you haven't been able to connect still, right?
sorry i could walk you through xp, but man vista sucks, i wouldn't touch it with a 10 foot pole.
i'm setting up remote desktop on my iphone
hahaha totally referred to this guide
and it sucks, so i'm sticking with vnc
man, i miss my exec/universal
dutchschultz said:
any detailed how to guide?, i can do it, i'm fairly tech savvy, so i just need to kneed out a few things. maybe if you caould start from the beginning and i can see where i went wrong.
logmein.com works, but i want something more personal, just bewtween the computer and my phone. somerthing that looks good and scales full screen preferably.
please guys?, point me in the right direction.. all the posts just keep saying to search and there's lots of info, but there's no step by step guide.
thanks guys!
Click to expand...
Click to collapse
Hope this helps
http://forum.xda-developers.com/showthread.php?t=366312
http://forum.xda-developers.com/showthread.php?t=294524
orb3000 said:
Hope this helps
http://forum.xda-developers.com/showthread.php?t=366312
http://forum.xda-developers.com/showthread.php?t=294524
Click to expand...
Click to collapse
you, my friend, are awesome
A possible solution for those of us on T-Mobile's standard web n walk
Sorry to resurrect this thread, but I thought I'd post my experiences here in case anyone else (like me) searches for a solution to enabling RDP on T-Mobile (UK at least).
I was having the same problem with remote desktop, it saying that the server was not available. I phoned up T-Mobile's helpdesk as recommended here and after getting past first line support (who didn't know what remote desktop was, and tried sending new connection settings to my phone to resolve the issue) I got through to someone who knew what they were talking about. Turns out that I'm on T-Mobile's "basic" or "handset-only" web-n-walk package, and it's not possible to use RDP on this. I assume they block the relevant ports. They told me that I could pay an extra fiver a month to upgrade to a version of web-n-walk which can handle RDP.
Well I told them I would think about it, but instead tried to find a way around it as the one or two times I need to use RDP are certainly not worth a fiver a month. My solution is probably only suitable for the more techy of us, but without much work and with no prior experience I managed to set up a SSH tunnel using FreeSSHd as a server running on my windows server (although a normal windows box should work fine - http://www.freesshd.com/) and zaTunnel as a client on my phone (http://www.zatelnet.com/zatunnel/main.php). Both programs are free.
Basically my phone takes all RDP connections and tunnels them over SSH to my windows server, which then turns them back into RDP connections. T-Mobile have no idea I'm using RDP, and if they block the SSH port in the future I can always change FreeSSHd to run on port 80 (for web). This will also work for other protocols T-Mobile might be blocking (FTP springs to mind).
Just thought I'd post this in case anyone was in my situation of needing RDP on their standard web'n'walk.
Edit Sorry posted this in the wrong thread! Will leave this post up however just in case someone finds it useful
echolock
Many thanks for the above have been searching everywhere for a fix to this. I am the same as you T Mobile (UK) and can't connect.
Could you give some additional advice as how you got the RDP to work.
For the record I can connect by Wi-Fi and by using a PAYG sim from a different carrier. However, I am on a contract with T Mobile and don't want to carry a different sim just to use the RDP.
I have installed both apps. I can make a connection from zaTunnel on Port SSH:24 to the freeSSHD server (SSH - listening on port 24). Other than adding a User and changing the default port to 24 there are no other changes I have made in freeSSHD.
Under the connections tab in zaTunnel I have left Network: Automatic with the other settings relevant to make a connection.
Under the ports tab of zaTunnel I have
LP> 3389,
IP/URL . IP of the desktop I want to connect to of 192.168.1.10
>RP 3389
When I the start the Remote Desktop app under my Windows Mobile 6.1 it indicates connecting the fails as before.
Also forgot to mention freeSSHD is running on the desktop I want to connect to.
Sure thing.
When you run Remote Desktop under Windows Mobile, make sure you connect to "localhost" NOT to the IP of the desktop you want to connect to.
Your other settings seem correct to me.
To attempt to explain a little, basically what happens is as follows. For simplicity's sake I will have three machines, your phone, your SSH server and your RDP server (although the latter two can be the same).
On your phone:
1) Remote Desktop connects to localhost on port 3389.
2) zaTunnel is listening on localhost on port 3389. It echos all commands sent to this port out on port 22 over your cellular connection to your SSH server, also providing details of your RDP server and port.
On your SSH server:
3) FreeSSHd receives the commands sent over port 22 and is told by zaTunnel to convert them to commands sent to your RDP server using port 3389.
On your RDP server:
4) Remote Desktop receives a normal RDP request over the normal port from your SSH server.
5) Responses are sent to your SSH server.
On your SSH server:
6) FreeSSHd receives the RDP responses, and sends them back to your phone over port 22.
On your phone:
7) zaTunnel converts the commands sent over port 22 back into RDP commands sent over port 3389.
8) Remote desktop receives a response from zaTunnel and thinks it's connected directly to an RDP server on localhost. In actuality it's connected to your RDP server using an SSH tunnel provided by zaTunnel and FreeSSHd.
Hope this makes sense, I'm not very good at explaining this!
Ah found another problem. The IP of your desktop you say is 192.168.1.10 - this is a local IP address so will only work on your local network.
Go to a website like http://whatismyipaddress.com/ from the machine you run SSHd on to find out what your current "external" IP address is. Bear in mind that most home broadband connections have a "dynamic" address which is allocated to you and might change from time to time - you can always use something like http://www.dyndns.com/services/dns/dyndns/ to set yourself up with a static hostname, and run a program on your machine which updates your hostname with the correct IP address every time it changes. Some routers have this functionality built in.
Thanks for the quick response and explanation.
Between posting and reading your reply I had worked out the RDP app needs the localhost or the IP 127.0.0.1.
I had come back here to post, so others would know in future.
Your other point you raised about the desktop IP. I have used this only in the ports tab on zaTunnel. The connection tab has a proper mydomainname.com address. (Provides email and a webmail interface).
Anyway, can connect now and thank you again in solving this for me. (If your in Leeds I will buy you a beer).
Ah yeah the 192.* address would work on the ports tab, fair enough. Might be worth pointing out if others read this that this is only the case if the machine you're trying to RDP to is on the same local network (or the same machine) as the machine you have FreeSSHd running on.
But good to hear you got it working Now hopefully T-Mobile won't cotton-on and decide to block port 22 too...
Hi All,
Does anyone know of a SQL client for Android? Just something for running basic queries when I need to check on a system and can't be arsed waiting for a computer to boot up. The databases I use are MS SQL Server.
I've searched about and can't find anything. I've also had a look at the dev docs for Android and it looks like it should be straight forward using the java.sql class but unfortunately Java isn't in my skill set at the moment and the day job & life in general doesn't leave me with much time to learn it.
If there isn't a program does anyone have any plans to write one ;-)
Cheers
Keith
Anyone ???
It'd be pretty darn insecure to open up your databases to use a remote client like that, why not just use something like phpmyadmin for it? It runs fine in the android browser and theres tons of alternatives that probably have iphone themes that would work great. Alternatively you could get debian set up and grab one of the hundreds of apps to do it in the repository
I need this as well. I'm constantly on SQL Enterprise Manager on my PC and when mobile, I have to teamviewer to my desktop and run queries there, which is such a torture.
I've bought RemoteDB, which I can't seem to get to work properly, I can't switch databases and the connection registry is very confusing.
Anybody?!
Also interested
I'm also interested in this topic.
As far as opening your db's up to the internet, that's a bogus argument. Anyone remotely managing enterprise databases will be using a vpn tunnel, and not the open web.
Having an Android app to connect to Microsoft SQL and Oracle would be extremely helpful. I've been trying to figure out how to mod Oracle's SQLDeveloper to do just that but without any success so far.
aSQL - Remote Control, new launch
Remote Control Client for Microsoft SQL Server 2005/2008/2008R2/2012.
aSQL - Remote Control Lite is a powerful Microsoft SQL Server client providing Access to your server in your Pocket. Access all of your databases, Jobs and Processes as well from your mobile device.Simple and Fast application providing advanced features.
aSQL - Remote Control Lite Provide features like:
- Providing connectivity to different servers on your Network.
- Ability to store Server Information for future use.
- Job START/STOP only a click away.
- Kill any running Processes From your mobile device.
- View Databases details - View File size.
Google Play Store link -
"market://details?id=com.sqlforce.aSQL"
SQL Client
Hi Guys
I looked for something like this for a while as well, and couldn't find anything that did what I wanted, so I made one myself
Key features I wanted are the following
Be able to connect directly to a db server. I used the jdts jdbc driver for Java to get this right
Be able to connect to any SQL Server db. I'll add support for Postgres and MySQL if this gains any popularity
List of all databases on the server (excluding system dbs) and allow you to quickly switch between them
List tables in the currently selected db, and generate Select statements for them
List stored procedures in the currently selected db, and pull the code for them so you can change it
Use a tabbed interface for the different sql queries, to allow you to run many queries at once
This is all done and works really well. Large queries take longer to run than they would on a pc, but they run nonetheless.
Let me know what you think, and feel free to suggest features. If enough people like it and use it, I'll bite the bullet and buy the developer so I can publish it on the Play store
I hope you enjoy it
ps. The installer is signed with the standard testing key, so you will need to go into your settings and allow applications from unknown sources
pps. I ask for internet access to get access to the network sockets, but dont actually connect to the internet.
danegoodwin -
I've downloaded it and played with it a bit - looks good. One feature I'd suggest off the top is storing the connection info. It's a pain having to enter the server address and username each time.
If you are still looking for a SQL client I had written one as well.
It should cover most of the popular databases and works well with tablets and phones.
SQLTool Pro
https://play.google.com/store/apps/details?id=com.nraboy.sqltool
I'm also open to suggestions and questions if anyone decides to give it a try.
nraboy said:
If you are still looking for a SQL client I had written one as well.
It should cover most of the popular databases and works well with tablets and phones.
SQLTool Pro
https://play.google.com/store/apps/details?id=com.nraboy.sqltool
I'm also open to suggestions and questions if anyone decides to give it a try.
Click to expand...
Click to collapse
so, this one does BOTH MySQL and MS SQL, and, your other one *just* MySQL ?
thanks, anyone
abbots said:
so, this one does BOTH MySQL and MS SQL, and, your other one *just* MySQL ?
thanks, anyone
Click to expand...
Click to collapse
Correct. The pro version will handle MySQL, MS SQL, PostgreSQL, Sybase, and Oracle up to version 10.1.
The MySQL version is strictly MySQL.
nraboy said:
Correct. The pro version will handle MySQL, MS SQL, PostgreSQL, Sybase, and Oracle up to version 10.1.
The MySQL version is strictly MySQL.
Click to expand...
Click to collapse
thanks for reply (and for nice app!)
nice, looks good... even better, seems to work well....connected to remote MySQL OK
suggestion: please auto-suggest correct ports for relevant SQLs
so, editing can only be done via queries ? (time to learn SQL syntax..?)
next, I'll try connecting to MS SQL, whilst I know a tiny bit about MySQL, I know nothing about MS, might be asking for help...
Nic,
need some help, if you can:
having issues with MS SQL, MS SQL is on a cloud server, for all I know, port could be blocked..
I've setup definition with port 1433, get 'failed to connect'
how to t/s outside of the app ?
should "telnet host 1433 " work ?
I'm getting
# telnet mssql2008.xx.yy 1433
Trying 202.111.22.33...
telnet: connect to address 202.111.22.33: Connection timed out
what else can I try ?
thanks for any pointers!
abbots said:
thanks for reply (and for nice app!)
nice, looks good... even better, seems to work well....connected to remote MySQL OK
suggestion: please auto-suggest correct ports for relevant SQLs
so, editing can only be done via queries ? (time to learn SQL syntax..?)
next, I'll try connecting to MS SQL, whilst I know a tiny bit about MySQL, I know nothing about MS, might be asking for help...
Nic,
need some help, if you can:
having issues with MS SQL, MS SQL is on a cloud server, for all I know, port could be blocked..
I've setup definition with port 1433, get 'failed to connect'
how to t/s outside of the app ?
should "telnet host 1433 " work ?
I'm getting
# telnet mssql2008.xx.yy 1433
Trying 202.111.22.33...
telnet: connect to address 202.111.22.33: Connection timed out
what else can I try ?
thanks for any pointers!
Click to expand...
Click to collapse
Hinting a default port is a good idea. I will see about adding in an upcoming release.
Yes right now anything beyond a simple select or delete must be done with a custom query. My goal is to make it more like the desktop editors, but since I am the only developer it might take a while. But I am not saying it won't happen.
If telnet is failing to connect then there is a firewall rule blocking your IP. Three things could fix this.
1. Add your IP to the database allow list (talk to the DBA)
2. If you can connect to the network the DB is on via VPN then you should. The db might be restricted to local IP
3. Use the SSH features of SQLTool to connect to a server on the databases allow list
You were smart to try the telnet. I would have done the same thing.
Feel free to contact me here or through the tools site. I'm happy to help
nraboy said:
You were smart to try the telnet. I would have done the same thing.
Click to expand...
Click to collapse
ahem, not that smart.....
forgot to specify sql type...... ooops
suggestion: don't allow save unless all req. stuff filled in...
OK, I seem to be in.
can I dump/backup with this app ?
thanks.
decent app, well done, wish you success in further development, if I can help in any way, happy to try
now I need to figure out how to dump this MS SQL into my Linux machine
abbots said:
ahem, not that smart.....
forgot to specify sql type...... ooops
suggestion: don't allow save unless all req. stuff filled in...
OK, I seem to be in.
can I dump/backup with this app ?
thanks.
decent app, well done, wish you success in further development, if I can help in any way, happy to try
Click to expand...
Click to collapse
Nice catch on the SQL Type. I will work to correct that.
For dump / backup are you referring to data or structure or both? Right now I have exporting DDL on my things to do list, but if you're referring to something else I'd like to hear it.
Thanks for the compliments on my app. I definitely want to hear more suggestions if you have them. Also please don't forget to rate well when you get a chance
Is there a working solution for this? cos i've searched the forum and apparently there is none. Can't believe the latest HTC Hero, the best android phone HTC can offer currently, has no proxy setting on wifi. It's like a big joke to me. I wish I had researched before I bought it
anyway, I've tried the "any cut" to create a shortcut to proxy settings and set accordingly, doesn't work.
Please anyone if you have a working solution, please share it with us.
openvpn
http://android.modaco.com/content/software/291919/openvpn-on-android/
thanks for you help.
but I dont think openvpn is the answer here...because in many places (my office for one) you can only access the web through a http proxy server. and htc hero doesn't allows that. not to mention the openvpn thing, which only works by connecting to a certain port which obviously is not allowed in such environment. openvpn can connect to a 443 port too but hey, we need to have a working http proxy first then we can connect using https, and the proxy server need to support https proxy...but that's not relevant here. so i cut the crap.
thanks anyway
any other solution to this android can't support proxy settings on wifi thing?
I don't know if this could work but try to mount the filesystem with write access through adb (I don't know how to do that), find one file that is used as a startup script (I don't know which one is it either) and place the following lines there:
Code:
export http_proxy=http://myproxy:port
export ftp_proxy=http://myproxy:port
Reboot the device, open a terminal (in the device) and type echo $http_proxy and see if outputs what is supposed to. If it does, maybe you're all set and you just need to test the web and see if it really works.
Sorry for not being able to help you with some of the steps but this is my basic linux knowledge kicking in, my android linux knowledge is below basic and I have no time to explore it further at the moment.
I'm curious about the results though .
http://code.google.com/p/proxysetting/
EDIT: doesn't work on cupcake apparently.
Hello all
Probably the question has been ask´d but here it goes...
is there allready a way do acess an on-line MySql DB from the android ?
I need to design an app to fetch and post data from a bd...
any ideas ?
ty all
You may find the following link to be helpful: http://shariqmobin.wordpress.com/2010/03/06/hello-world/
That requires some fiddling with firewalls and allowing external connections to your MySQL DB. If you're not comfortable with that (or not allowed by the DB server admin), you could consider creating a simple webservice or script to supply specific data from your DB.
thnkx m8
i will take a look @ it.
i do have acess to the db as we own the server where the db is
i´ll keep you guys posted
´´tnkx
RemoteDB (market). For extra security, connect to the host via ssh with ConnectBot and tunnel port 3306. It works, and I use it all the time.
It's a ***** to get it working the first time if you're new to ssh and/or tunneling, but it means you don't have to directly expose your database to the Internet. I *highly* recommend getting Toad to work with PUTTY before attempting it via Android, though.
Sent from my SPH-D700 using XDA App
hi guys,the company i am current working at uses a proxy connection for accessing the internet.(you have to go through the proxy in order to access the internet).but the proxy blocked most websites,so i tried to use a vpn connection over the company proxy to bypass the internet restriction.The problem is ,vpn connections are not allowed to go through the proxy.is there any way to bypass the block to use vpn or bypassing the proxy?I am currently using my company's wifi on an android device.please kindly help me to solve this problem.Sorry for my bad english and thank you for any help.
best wishes,
sunnytse1
*thanks button will be clicked if helped!
Anyone?
Sent from my LG-P880 using XDA Premium HD app
sunnytse1 said:
hi guys,the company i am current working at uses a proxy connection for accessing the internet.(you have to go through the proxy in order to access the internet).but the proxy blocked most websites,so i tried to use a vpn connection over the company proxy to bypass the internet restriction.The problem is ,vpn connections are not allowed to go through the proxy.is there any way to bypass the block to use vpn or bypassing the proxy?I am currently using my company's wifi on an android device.please kindly help me to solve this problem.Sorry for my bad english and thank you for any help.
best wishes,
sunnytse1
*thanks button will be clicked if helped!
Click to expand...
Click to collapse
the company i am current working also use VPN by setting the IP adress
the concrete operation is a little complicated, you'd better google for help
Good luck
The easiest solution would be to use 3G/4G and thus avoid any filter/proxy that your company WiFi has.
Assuming you don't want to do that, you should try to figure out what kind of VPN you're using. There are 4 main types:
1) PPTP - This one is old but supported in almost every OS natively (including Android). It's easy to setup a server for these using any Pro version of Windows. It's also easy to block.
2) L2TP - This one is more secure but also less supported. This one is also fairly easy to block. I think only Server editions of Windows can create this type of VPN.
3) IPSec - This is your Cisco-type VPNs. These tend to be more difficult to setup on the server side. Depending on how the network is configured this may be blocked too (but less likely).
4) OpenVPN - This is probably your best bet to avoid workplace blocking. You can configure it to use any protocol or port that you want, however it is very difficult to configure for a first time user. There are tutorials available online to help. You'll need an app (and maybe root) to use an OpenVPN-based VPN.