Ok. I'll help you. What would you like to know exactly?

Can an example on this be given? I have been having trouble creating a 'registration' for my client. i am trying to let the user pick a username & password, if username is taken then retry. but so far i am unsuccessful. :\

*edit* I am not sure how to use a textbox& comandbutton along with SQL statements. i am alittle lost on this. Sorry i am new to programming. :\ help?

Hi,

Is there a reason this has to be done via SQL? I think, that your applet, wherever it is loaded... would have to also have access to SQL... do what I do and just make a simple winsock server daemon program in VB that listens for connections, receives command(s), and spits out answers. Have your applet connect to that to do the dirty work. build in encryption if you want.. then let the VB app talk to SQL... or even easier, save your data in .dat files on the VB server. Seems safer in my opinion.. then your only opening the vb app to the public, and not SQL itself. Optionally, but may be a lot harder, you could also make the VB server program in Jabaco instead--but I have not got this far with any of my apps, yet. (:

I can give you some of the snippets of code you would need for the different pieces in VB server and Jabaco client if you want, let me know.

Regards,
Jason

JasonS,

Yes it has to be SQL DB because the forum (phpbb)/client will use the same user and password tables. Creating the backend in VB and connecting to that seems to be the simplest way. There are a few hundred users so i don't need top notch security, but a basic encryption will work nicely. thank you very much for taking the time to answer and give advice to my problems. I hope to message you if i run into any trouble

Hey,

I should have a 'vbserver daemon and jabaco client' ready for you sometime this week. I will post a link for anyone to use for whatever they want when its ready. Eventually this will also be in the codebank on my site, but I havent implemented that into my site yet (soon), so I have just been posting zip links on the board for now. Its a bare bones login applet (and vb server daemon) screen where users can register, login, and provide an integer value (listbox items for what they wanna do once logged in, etc.) You can do whatever you want with it, morph it to your needs, please There is also a chat room feature built into it along with the ability to make commands. Several examples of how to do different commands for actions are in the code already so use that as a helper, you will just have to see.

Ill post as soon as the zip file is ready.

Regards,
Jason

Hello,

Here is the sample I promised. There is a readme file included in the zip, along with the source code to the VB6 server daemon and the Jabaco client, and their binaries incase you do not have VB6. You will at least need the VB6 runtime environment to run the daemon, or have VB6 installed.

The link to the archive file is http://www.tecktronic.net/authit/AuthIt_…Client_Srcs.zip

There is also a working demo in the apps section @ www.tecktronic.net

This sample does not connect to SQL at all, but I have left comments as to where you would want to perform these functions. You could also rewrite the (in the VB6 server project), the way it stores, checks, etc usernames and passwords to use SQL for that instead of .dat (user defined types saved to disk) files.

I hope this helps you. Read the readme file it explains alot more.

Any questions, feel free to ask, Ill try to answer as best as I can.

Sincerely,
Jason

Hey,

I also made a client for Android via B4A, that works with the same server that the java client. Here below is the link for the zips of the vb server source & jabaco client source, and another zip with the B4A client source.

http://www.tecktronic.net/authit/AuthIt_…Client_Srcs.zip
http://www.tecktronic.net/authit/AuthITAndroidClientSrc.zip

I feel this is a good demo of source code to show how to start off your multi user, interactive app, that offers a java (pc/mac) client and an android client, all using TCP.

You can see it working on my live server (www.tecktronic.net) in the apps section ... jabaco and android app are titled 'chat.tecktronic.net'.. click on eithr key icon to test it out via browsers and android browser.

Any questions, feel free to ask. I know the code isnt perfect but its a great working template set.

Enjoy (;

~Jason

all the links you provided is dead already?