4Story P-Server database connector [VB2008]

02/13/2013 15:36 glossypvp#1
Hi,

Again I'm glossy, and I made a server database connector DLL with Visual Studio 2008.

Q: Okay but what is this, and how I can use it?
A: Well, I guess you already know it, but if you don't, let me explain it.
With it you can connect and send MS SQL queries to your server.

Video: [Only registered and activated users can see links. Click Here To Register...]

Instructions:
Import DLL file as resource
Import some functions and the connector too in your code:
PHP Code:
Imports System.Data
Imports System.Data.SqlClient
Imports FourStory_Conn 
Okay, now create four textboxes and define some variables (you can skip it but it's recommended to don't skip it)
PHP Code:
 Dim server As String = host.Text
            Dim username As String = user.Text
            Dim pass As String = password.Text
            Dim database As String = db.Text
            Dim query As String = "" 
Then connect to our server and database:
PHP Code:
FourStory_Conn.Server.Connect(server, username, pass, database, query, True) 
Notice:
In the video I set the last propety in the code to False because I haven't sent any queries so that application isn't needed to excute the query.

Virustotal of DLL:: [Only registered and activated users can see links. Click Here To Register...]
Virustotal of sample project: [Only registered and activated users can see links. Click Here To Register...]

Good luck!

Edit:
I have added a sample project.
02/13/2013 21:07 stotterer09#2
I think, I'm the one and only vb.net programmer in 4s section and I don't need this dll sry

mfg

but you get a Thanks for the work
02/13/2013 21:15 WickenChings#3
It's not working for me.I still get an error when i try to debug.If i get no error i can't connect.
02/13/2013 21:20 stotterer09#4
Quote:
Originally Posted by spyropatrick View Post
It's not working for me.I still get an error when i try to debug.If i get no error i can't connect.
make it simple and use this tutorial:
[Only registered and activated users can see links. Click Here To Register...]
02/13/2013 21:24 WickenChings#5
Danke dir stotterer09.Hast du nen Lösungsweg für jemanden der mit Windows Authentification connecten will???Wäre nett.Habe mich schon selber dran versucht.Das einzigste was ich so in Visual Basic hinbekomme ist nen Launcher für die Dienste.
02/13/2013 21:49 stotterer09#6
Quote:
Originally Posted by spyropatrick View Post
Danke dir stotterer09.Hast du nen Lösungsweg für jemanden der mit Windows Authentification connecten will???Wäre nett.Habe mich schon selber dran versucht.Das einzigste was ich so in Visual Basic hinbekomme ist nen Launcher für die Dienste.
das ist nicht schwer du musst einfach einen anderen connection string benutzten wart ich post ihn denn den muss man einfach wissen ich glaub den gibts auch ned auf google:
Code:
sqlcon.ConnectionString = "Server=" & SQLServer & ";Database="& Datenbank & ";Trusted_Connection=yes;"
viel spaß
den launcher für die dienste den gibts schon von wem? na von mir :D
02/13/2013 23:26 glossypvp#7
Quote:
Originally Posted by spyropatrick View Post
It's not working for me.I still get an error when i try to debug.If i get no error i can't connect.
It's working fine, just check out the sample project file.
Virustotal of sample project: [Only registered and activated users can see links. Click Here To Register...]