hello, i want to learn servoy but i dont have any background about it, can you teach me how to start with it? i’m having a hard time connecting with my database, im using SQL Server Management Studio Express for my database… i have this servoy-MySQL-miniHowTo pdf file, it says their some information about the servoy and sqL but i’m having a hard time dealing with it, can you teach me how to start? thank you for those who are going to help me. Godbless
i really need and want to learn it so please help me
You seem to mix up 2 very different servers: MySQL (Sun/Oracle) and Microsoft SQL Server.
Using SQL Server Management Studio Express you are using MS SQL Server (Express edition), not MySQL so the MySQL miniHowTo you are refering to is not pertinent (and actually it is a tutorial on how to use MySQL as a Repository - which is yet another thing entirely)!
In any case, what you need to do to connect to your data in Servoy Developer is setup a new database server: in the Solution Explorer (the panel on your right in Servoy Developer), open the Resources node (the first one), right-click on the ‘Database Servers’ node and choose ‘New Server… MS SQL (freetds)’ this will open a new panel which will give you a template to fill with your own connection info (Server Name will be the name that is used in Servoy to access your database - can be anything you want - User name and password must be filled with a user’s credentials that has access to your database in read/write mode - and URL will most likely (if you are using SQL Server on the same machine as Servoy) be:
jdbc:jtds:sqlserver://localhost/XXXXX
where XXXX is the name of the database you want to use.
When you close and save that window, Servoy will perform a test to check if it can access you db, if it can’t it will say so, and you will have to verify your informations.
If Servoy can access, then you’re all set… now follow some tutorials on how to use your data on forms, scripts, etc…
Hope this helps,
sir thank you for the reply, i really need help and im just a beginner, do you have any other accounts like yahoomail or facebook? so that i can contact you when i need help? btw thanks a lot for those information.
if you are just a beginner, don’t start using different databases at first, just use (PostgreSQL) what Servoy gives you by default at first. So that you learn the tool
If you have to use an existing data filled database then do what patrick told you and create a server connection to it.
thanks sir.i will practice the advice of sir patrick., my company is using SQL Server Management Studio Express as our databse thats why i also need to use it as my database. thanks for your help sir…
sir is this the right driver
http://www.microsoft.com/downloads/en/c … laylang=en
for SQL Server Management Studio Express?
servoy already includes the jtds driver that should work for a sql server.
If you want or need to use a microsoft driver i would download the 1.1 version:
sir what will i do if i got an error like this ? “connection factory returned null from creatConnection”
i think you have configured your server settings that incorrectly, because that is an exception that is generated when your driver doesn’t give a connection back based on url and properties (driver.connect(_connectUri,_props))
are you sure that you have a right url? and the right properties (username/password)