I have try everything to retrieve data using JDBC from SQL data base, i have downloaded the JDBC Driver and i install it properly , but the initialization seem to be the problem because I'M using window authentication to sign in my SQL server and every tutorial i watch use Password and Username, when ever i call my application this way it return ClassNotFoundExceptional error:
I don't recommend Windows-based authentication for JDBC application. It's extremely non-standard and proprietary and will make your application difficult to use with other databases or environments. Create a username/password on the SQL Server.
Thank you for your respond so far everything have been working for me but i always get stock when it get to SQL, so i decided to uninstall my sql server i had on my system and to retsart it again so that i can simply make the username and password authentication with the JDBC, i have the JDBC 4 driver in my Program File already.
Kindly lead to where i can get the full Microsoft SQL server soft download on internet if can help. i prefer the enterprise edition while I'm using window 8 with Sony vaio Laptop, very important to me kindly help me!
You can download SQLserver Express with Tools from here SQLserver Express. It is not a trial version but a full working version of SQLserver. The SQLServer Express has processor and data limits but they should be adequate for development and for small applications.