I added a database to my project, it has post & pre-deployment script on it.
on the post deployment I added a folder named tableScripts.
it appears in the solution like this:
>>>>user.sql //the script I want to run
+Script.PostDeployment.sql //the script calling the user.sql script
inside the Script.PostDeployment.sql:
All scripts are running, it is even building and deployed (although no effect in the database table) as sucess but when I try to just execute the post-deployment script it keeps on giving me error:
Please note that when i execute the sql as one line, it does affect the table and inserts data...same with the User.sql, the script is inserting data and all
A fatal error occurred.
The following file could not be read because an error occurred: Could not find a part of the path 'C:\ProjectName\tableScripts\User.sql'.
the path displayed above is not even correct but they say that the error is not in the script..but where is it??!
any clue? suggestion?? I looked and checked the database and the user I am using is correct, I even made a UDL file and tested the connection and it says success...please help.
let me just add that it was working before, suddenly it is not! I was able to install it with no problem and use the scripts w/ no hassle..it stopped working when i added another database project using the same user in teh databse(not really sure though if it is related coz i did not try building the orignal script before adding a new one)..what could I have I done wrong?
This post has been edited by cs_starter: 10 August 2009 - 03:23 AM