Search Results

Based on @Peter Simpson's code (here), I developed a library that allows you to connect directly to MySql, MsSql (for the moment) databases with B4A and B4J. To be clear, you don't need JRDC to connect to the database located on a server (I am working on a version for b4i, but it is only obtainabl
link: It is exclusive to MS SQL, MySQL
link: ExecQuery("SHOW TABLES") Do While RS.NextRow Log(RS.GetString2(0)) Loop End If Tested with Firebird database and wor
link: I don't need My SQL but I am very interested in MSSQL Server...

I'm not sure I fully understand your question. MS Sql Management Studio is a tool to create databases, this thread however is for creating web apps that save data to databases esp mysql.

Hello, The minimum MS SQL version required is : MS SQL 2014 Express Thank you, Saif
link: What version of MS-SQL did you used for this app?

i love MS SQL, the dialect is very easy to understand and the license is also fairly easy to get. You want non limited free non commercial? use developer edition you want limited free commercial? use express edition you want unlimited non free commercial? anything else. you will be okey with ms
link: If I develop with .NET, I will go for MS SQL. If I develop with PHP or B4X, I go for MySQL. Currently, I am focusing on the latter.
link: You have forgotten the cons. 1 - it's heavy 2 - tied to heavy IIS (at least when I was using it -many years ago - it was like that)
link: Which of the two do you prefer to use?

Hello Dear, The Database is MS SQL (.bak file) is included in the .zip file (the source code) I think you still didn't restore the database to your own MS SQL and you are still connected to our server database :) The MySQL script is for the database creation which will be the same as MS SQL datab
link: Hello Dear, The MS SQL database engine is free, just use the express version. and you can install it on any VPS, PC,Laptop. In our case it's install
link: ok now i understand. you mean for the table creation. got. it. actually, i have only tested it and looked at the code. i plan to connect it to my m

Hi everybody, Happy new year, I would like to share this tool which helps to list MSSQL database tables , their structure and data. It is a Win32 program written by me and inspired by B4X ♥️, a splendid package of programming IDEs. I though it can help any B4X user to view their databases especially
link: Can you provide the source code? Someone might be interested in converting it to B4J which the community can help in improving
link: I have already written most of the B4J code. It will be available as soon as it is finished.

Hi Erel thanks for the reply. MS SQL is the database type I am using (Microsoft SQL Server). I am working with the JdbcSQL library. I mainly need help with my SQL I do not know how to write that, see my above question. Thank you any help would be greatly appreciated.
link: Hello Could please inform how you did the setup of remote MS SQL server Connectivity?
link: Dim InputStream1 As InputStream InputStream1 = File.OpenInput(File.DirAssets, strFilePathName) Dim OutputStream1 As OutputStream OutputS
link: Hi Guys, Please could someone help me out. I am trying to save a local image into my remote SQL Server database. I want to save the image to a record

Hello Dear, Yes, all the projects (B4A + B4J + MS SQL) are open source. We have created a background service which you can import it into your own apps and it will check the licenses for each client by checking with the database using the deviceID. Thank you, Saif
link: Hello, only ms-sql? Thank you.

Something more: you ask about documentation about MS SQL/B4A integration. Please understand difference between MS SQL and MySQL as difference between two different world: Linux/Unix and Microsoft. I don't comment your choice (MS SQL is very good database system anyway) but the best approach to solve
link: Hendasa, it is a community forum. for that reason it is better to ask the community and not a certain person. and it is always good to start with the
link: Have you read THIS ?
link: hello Eurojam(stefan) thanks for your reply, but please let erel answer this , i have gone through user guide but there is no chapter for MS SQL all

' 'Register Input Parameters MSSQLProcedure.AddInputParameter(1,MSSQLProcedure.SQLINTEGER,"29929") ' 'Register Output Parameters MSSQLProcedure.AddOutputParameter(2,MSSQLProcedure.SQLINTEGER) MSSQLProcedure.ExecProcedure(MSSQLConnection) MyResultSet = MSSQLProcedure.FetchRe
link: Hi KeirS I was asking if the above will work for MsSQL, but I guess I got my answer after changing the syntax to "exec StoredProcedureToCall ?, ?, ?

Powered by ColBERT