Android Question Connecting B4A with Ms SQL Server

[Kenny Ali]

I was trying to run the tutorial example of Erel:
https://www.b4x.com/android/forum/threads/connect-android-to-ms-sql-server-tutorial.13166/

But when I try to test if the script were working by calling it from the browser gives me this error:
HTTP Error 404.3 - Not Found
You can not access the requested page due to the configuration of the extension. If the page is a script, add a driver. If the file should be uploaded, add a MIME assignment.

 

[Kenny Ali]

I also try to run tha app example that came with the tutorial and it gives me this error:

(Log)

 

[Erel]

This means that the ASP .Net script is not in the correct location. Why are you using this solution instead of jRDC2? jRDC2 is much more powerful.

 

[Kenny Ali]

I put it exactly where the example say to. C:/inetpub/wwwroot, and I also add the dll.

I’m sorry, what is jRDC2?
I don’t know what are you talking about when you talk about that.

 

[DonManfred]

I’m sorry, what is jRDC2?

The search is working....

https://www.b4x.com/android/forum/pages/results/?query=rdc2&prefix=1,2,3,17,24,29

 

[Erel]

I put it exactly where the example say to. C:/inetpub/wwwroot, and I also add the dll.

Which url are you entering on the PC browser when you test it?

 

[Kenny Ali]

http://192.168.1.3/test1.aspx?query=select * from table_1

I made an exactly db to try named test1 and the table_1 also.

 

[Kenny Ali]

Check out my screenshots

 

[lemonisdead]

You probably have to urldecode the query
As a side note : allowing direct access to the DB with a query without escaping it, is at least very dangerous

 

[Kenny Ali]

The example said that you could try it just like that, but ok, how can I urldecode the query?

 

[Kenny Ali]

As a side note : allowing direct access to the DB with a query without escaping it, is at least very dangerous

I get it. I'm just trying to run the example.

 

[Kenny Ali]

This means that the ASP .Net script is not in the correct location. Why are you using this solution instead of jRDC2? jRDC2 is much more powerful.

Erel, I tried with this tutorial:
https://www.b4x.com/android/forum/t...connector-rdc-connect-to-any-remote-db.31540/
I tried to follow every step and this is what I get.

Can someone help me out?

 

[DonManfred]

Use jRDC2! RDC is a few years old and deprecated.

 

[Kenny Ali]

Use RDC2! RDC is a few years old and deprecated.

Damn.
Thank you DonManfred, can you paste a link of a RDC2 tutorial, please?

 

[DonManfred]

I already did! see the search link above
https://www.b4x.com/android/forum/t...-rdc-remote-database-connector.61801/#content

 

[Kenny Ali]

I already did!

I checked the link that you gave me before, but it was a results of a search, and on that result I found RDC.

I'm gonna work with this new tutorial, thanks man.

 

[DonManfred]

and on that result I found RDC

BUT you was searching for jRDC2... Why you did not used the jRDC2 Link in the searchresult? I remember it was the third...

 

[Kenny Ali]

Update:

https://www.b4x.com/android/forum/threads/where-is-the-additional-libraries-folder.88453/

 

[Kenny Ali]

Hey guys, I'm getting this error when I run my remote server.

My config.properties code is this:

#SQL Server
DriverClass=net.sourceforge.jtds.jdbc.Driver
JdbcUrl=jdbc:jtds:KENNY://192.168.1.8/Test1
User=Kenny
Password=1234
ServerPort=17179

Debug=true
#******

Does someone know what's wrong?

Thanks for the help.

 

[Erel]

This means that RDC failed to connect to the database server. The JdbcUrl looks incorrect.