I downloaded and installed this and it worked once for me, then it errors out. I have the Standard Version of SQL Server on my machine and it gives me an error saying that it cannot connect using the SQLEXPRESS. Obviously its not installed.
Does anyone have the script that i can run to create the DB in SQL? Can you post it here or email it to me???
Right, sorry i should have been a little more clear. I did that and it points at the database. The issue i am having is that I have the script it gives you to create the tables and all the PK and FK and whatnot, the issue is that it didnt give me the script
to create the user table (for example). So i was hoping that maybe someone has the db all up and running and could script it out for me.
Djinnx
Member
5 Points
8 Posts
Database Script
Jul 19, 2007 08:29 PM|LINK
Hey all,
I downloaded and installed this and it worked once for me, then it errors out. I have the Standard Version of SQL Server on my machine and it gives me an error saying that it cannot connect using the SQLEXPRESS. Obviously its not installed.
Does anyone have the script that i can run to create the DB in SQL? Can you post it here or email it to me???
Web Developer
www.SteveDevelops.NET
chetan.sarod...
All-Star
65739 Points
11138 Posts
Re: Database Script
Jul 20, 2007 03:43 AM|LINK
Check in web.config for connectionString, configure it according to your server name, password etc.
Let me know if this helps you.
Senior Software Engineer,
Approva Systems Pvt Ltd, Pune, India.
Djinnx
Member
5 Points
8 Posts
Re: Database Script
Jul 20, 2007 08:53 PM|LINK
Right, sorry i should have been a little more clear. I did that and it points at the database. The issue i am having is that I have the script it gives you to create the tables and all the PK and FK and whatnot, the issue is that it didnt give me the script to create the user table (for example). So i was hoping that maybe someone has the db all up and running and could script it out for me.
Web Developer
www.SteveDevelops.NET
chetan.sarod...
All-Star
65739 Points
11138 Posts
Re: Database Script
Jul 23, 2007 03:57 AM|LINK
If your connectionString is right, then why can't you connect to the DB...?
In Time Tracking System, it uses inbuild Membership classes for user creation, updation etc..
You have to register your DB with ASP.NET Membership classes by executing the command line utility in VS prompt
aspnet_regsql, it will open one window, where you have to configure DB.
Hope it will help you, let me know.
Senior Software Engineer,
Approva Systems Pvt Ltd, Pune, India.
chetan.sarod...
All-Star
65739 Points
11138 Posts
Re: Database Script
Jul 24, 2007 03:58 AM|LINK
Have you tried, what I suggested to you.
Let me know whether it is helpful to you.
Senior Software Engineer,
Approva Systems Pvt Ltd, Pune, India.
chetan.sarod...
All-Star
65739 Points
11138 Posts
Re: Database Script
Jul 25, 2007 03:43 AM|LINK
Have you got any solution or solved your problem ?
Post it on forum.
Senior Software Engineer,
Approva Systems Pvt Ltd, Pune, India.
Djinnx
Member
5 Points
8 Posts
Re: Database Script
Jul 25, 2007 08:44 PM|LINK
lol, sorry sorry. i got so caught up in it i forgot to mark it.
I just had to register my db with the command line tool.
Thank you for your help!
Web Developer
www.SteveDevelops.NET
chetan.sarod...
All-Star
65739 Points
11138 Posts
Re: Database Script
Jul 26, 2007 03:50 AM|LINK
Great....Thanks for marking as answer.
Senior Software Engineer,
Approva Systems Pvt Ltd, Pune, India.