| Author |
Topic |
|
cwtriguns2002
Constraint Violating Yak Guru
272 Posts |
 Posted - 2008-02-20 : 22:14:31
|
| Hi everyone.. I have a big problem.. :pI have created a installer for my application and database.When I run the installer it only creates the database but no tables created. But in some other workstation it works fine. I dont know what causes this problem....Please guide me.RON________________________________________________________________________________________________"I won't last a day without SQL" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-02-21 : 00:09:51
|
| You'd have to provide more details in order for us to help.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
cwtriguns2002
Constraint Violating Yak Guru
272 Posts |
Posted - 2008-02-21 : 02:20:17
|
| hi tkizer. It simply an installer that installed an application and creates a database to the workstation. The installer runs fine in my 3 workstations. It seamlessly installed the application and creates database and tables. While in my 2 workstations have some problem. It creates a database but no tables found in the database. I have checked the credential, security, etc and they have the same property as my 3 workstations... Do you have any idea about it?Thanks.RON________________________________________________________________________________________________"I won't last a day without SQL" |
|
|
|
cwtriguns2002
Constraint Violating Yak Guru
272 Posts |
Posted - 2008-02-21 : 03:58:53
|
| Anybody?RON________________________________________________________________________________________________"I won't last a day without SQL" |
|
|
|
megbot
Starting Member
17 Posts |
Posted - 2008-02-21 : 16:34:15
|
| Can you post some of the SQL from the application?Are you sure the username it is using to create the tables has create permission? Is it granted to the database after the database is created?Were there any changes whatsoever to the application between the time that it was installed successfully and then it was not?How many workstations are you talking about? 5? 3 successful and 2 not successful? What is differennt about thsoe two workstations? Is there a different level of code or OS patch? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-02-21 : 16:39:28
|
| When the installer runs and doesn't create the tables, did the installer provide errors? If not, then you'll need to run SQL Profiler (adding exceptions to it) to determine what is occurring.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
cwtriguns2002
Constraint Violating Yak Guru
272 Posts |
Posted - 2008-02-21 : 21:27:18
|
| sorry for the late reply....to answer your questions....Can you post some of the SQL from the application?- SQL is not created in my application... It's on the script. The script is just called in the application.Are you sure the username it is using to create the tables has create permission?- Yes. I am using the default username "sa".Is it granted to the database after the database is created?- Yes I think so. I tried to create a database and tables manually.How many workstations are you talking about? 5? 3 successful and 2 not successful? - Yes.What is differennt about thsoe two workstations? Is there a different level of code or OS patch?- are you reffering to service pack? if so, they have the same sp.When the installer runs and doesn't create the tables, did the installer provide errors? If not, then you'll need to run SQL Profiler (adding exceptions to it) to determine what is occurring.- It doesn't create error. in my application i tried to catch the exemption but it doesn't create any error. RON________________________________________________________________________________________________"I won't last a day without SQL" |
|
|
|
cwtriguns2002
Constraint Violating Yak Guru
272 Posts |
Posted - 2008-02-22 : 01:44:33
|
| I have traced the program and i found out that after the database has been created it does not create a table and initial data based on the script i have made.any guidance please....RON________________________________________________________________________________________________"I won't last a day without SQL" |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-22 : 01:47:04
|
| What's the script thats generated? can you post it? |
|
|
|
cwtriguns2002
Constraint Violating Yak Guru
272 Posts |
Posted - 2008-02-22 : 21:44:23
|
| Do i need to post here the script of the database?1. DATABASE(includes TABLES/STRUCTURES) - It is a script2. INITIALDATA3. PACKAGE(application)****UPON INSTALLATION****The DATABASE is the first thing to be created.InitialData(tables were converted into xml).Then the application will be installed...This is the process occured in the installation. I really don't why is it not creating a tables in some workstations.What would be the cause of this?Any help would be appreciated.RON________________________________________________________________________________________________"I won't last a day without SQL" |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-23 : 12:10:15
|
| Can you post 1) ?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
no tables created....