I can't connect to my MS SQL databse during install. I have successfully installed FreeTDS and have an entry in my odbc.ini file that works for other programs (for what it's worth)
I went to my SQL Server and created a database through Enterprise manager called "timeentry". My SQL server is called rkk28 and is pinging. I think it's listening on port 1033.
I think I'm having syntax problems not quite knowing what to enter in the "Database Schema Name and/or path"
Also, will I be able to have 2 level time entry. I need the user to select a project and then a task under that project.
Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You don't need FreeTDS to run on MS-Sql server. Web Time Entry uses the JTDS JDBC driver to connect to MS-Sql. What verion of SQL Server are you running, (SQL Express??) Then can give you a better idea of what the URL would be..
See Ya!
P.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You need to install things on the same host as SQL Server (jTDS is looking to connect to localhost). What is the name of the MS SQL Server instance? You could try:
I can't connect to my MS SQL databse during install. I have successfully installed FreeTDS and have an entry in my odbc.ini file that works for other programs (for what it's worth)
I went to my SQL Server and created a database through Enterprise manager called "timeentry". My SQL server is called rkk28 and is pinging. I think it's listening on port 1033.
I think I'm having syntax problems not quite knowing what to enter in the "Database Schema Name and/or path"
Also, will I be able to have 2 level time entry. I need the user to select a project and then a task under that project.
Thanks
You don't need FreeTDS to run on MS-Sql server. Web Time Entry uses the JTDS JDBC driver to connect to MS-Sql. What verion of SQL Server are you running, (SQL Express??) Then can give you a better idea of what the URL would be..
See Ya!
P.
I'm running SQL Server 2000 SP4.
Thanks
Chris
You need to install things on the same host as SQL Server (jTDS is looking to connect to localhost). What is the name of the MS SQL Server instance? You could try:
timeentry;instance=your instance name
More details about connecting to SQL Server with jTDS can be found at http://jtds.sourceforge.net/
You can see our project web site about custom mods or if you need corp level support at http://pauljones.mine.nu/timeentry/
Paul....