Kenny Ali Member Licensed User Jan 17, 2018 #1 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.
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 Member Licensed User Jan 17, 2018 #2 I also try to run tha app example that came with the tutorial and it gives me this error: (Log) Attachments Error B4A SQL Example.txt Error B4A SQL Example.txt 1.7 KB · Views: 681 Upvote 0
Erel B4X founder Staff member Licensed User Longtime User Jan 17, 2018 #3 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. Upvote 0
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 Member Licensed User Jan 17, 2018 #4 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. Upvote 0
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 Expert Licensed User Longtime User Jan 17, 2018 #5 Kenny Ali said: I’m sorry, what is jRDC2? Click to expand... The search is working.... https://www.b4x.com/android/forum/pages/results/?query=rdc2&prefix=1,2,3,17,24,29 Upvote 0
Kenny Ali said: I’m sorry, what is jRDC2? Click to expand... The search is working.... https://www.b4x.com/android/forum/pages/results/?query=rdc2&prefix=1,2,3,17,24,29
Erel B4X founder Staff member Licensed User Longtime User Jan 17, 2018 #6 Kenny Ali said: I put it exactly where the example say to. C:/inetpub/wwwroot, and I also add the dll. Click to expand... Which url are you entering on the PC browser when you test it? Upvote 0
Kenny Ali said: I put it exactly where the example say to. C:/inetpub/wwwroot, and I also add the dll. Click to expand... Which url are you entering on the PC browser when you test it?
Kenny Ali Member Licensed User Jan 17, 2018 #7 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. Upvote 0
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.
lemonisdead Well-Known Member Licensed User Longtime User Jan 17, 2018 #9 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 Upvote 0
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 Member Licensed User Jan 17, 2018 #10 The example said that you could try it just like that, but ok, how can I urldecode the query? Upvote 0
Kenny Ali Member Licensed User Jan 17, 2018 #11 lemonisdead said: As a side note : allowing direct access to the DB with a query without escaping it, is at least very dangerous Click to expand... I get it. I'm just trying to run the example. Upvote 0
lemonisdead said: As a side note : allowing direct access to the DB with a query without escaping it, is at least very dangerous Click to expand... I get it. I'm just trying to run the example.
Kenny Ali Member Licensed User Jan 17, 2018 #12 Erel said: 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. Click to expand... 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? Upvote 0
Erel said: 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. Click to expand... 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 Expert Licensed User Longtime User Jan 17, 2018 #13 Use jRDC2! RDC is a few years old and deprecated. Upvote 0
Kenny Ali Member Licensed User Jan 17, 2018 #14 DonManfred said: Use RDC2! RDC is a few years old and deprecated. Click to expand... Damn. Thank you DonManfred, can you paste a link of a RDC2 tutorial, please? Upvote 0
DonManfred said: Use RDC2! RDC is a few years old and deprecated. Click to expand... Damn. Thank you DonManfred, can you paste a link of a RDC2 tutorial, please?
DonManfred Expert Licensed User Longtime User Jan 17, 2018 #15 I already did! see the search link above https://www.b4x.com/android/forum/t...-rdc-remote-database-connector.61801/#content Upvote 0
I already did! see the search link above https://www.b4x.com/android/forum/t...-rdc-remote-database-connector.61801/#content
Kenny Ali Member Licensed User Jan 17, 2018 #16 DonManfred said: I already did! Click to expand... 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. Upvote 0
DonManfred said: I already did! Click to expand... 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 Expert Licensed User Longtime User Jan 17, 2018 #17 Kenny Ali said: and on that result I found RDC Click to expand... BUT you was searching for jRDC2... Why you did not used the jRDC2 Link in the searchresult? I remember it was the third... Upvote 0
Kenny Ali said: and on that result I found RDC Click to expand... 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 Member Licensed User Jan 18, 2018 #18 Update: https://www.b4x.com/android/forum/threads/where-is-the-additional-libraries-folder.88453/ Upvote 0
Kenny Ali Member Licensed User Jan 28, 2018 #19 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. Upvote 0
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 B4X founder Staff member Licensed User Longtime User Jan 28, 2018 #20 This means that RDC failed to connect to the database server. The JdbcUrl looks incorrect. Upvote 0
