| 3 |
Public Forum / General / Re: Installation Guide |
on: Aug 4th, 2007, 11:03pm |
| Started by devans | Last post by devans |
| Nope never got it running but will wait now for the new version appears and hound the roots till they make it newbie easy. Cant be long now! Thanks for your suggestions. |
 Reply  Quote  Notify of replies
|
| 8 |
Public Forum / General / Re: Still Active |
on: Apr 7th, 2007, 5:27pm |
| Started by bret.miller | Last post by devans |
A lot of work has been going on to get us to Version 2.0 and the development of a foundation to support the OEP in its wider development.
I understand 2.0 is well underway. |
|
Reply Quote Notify of replies
|
| 9 |
Public Forum / Development / parameter received with apostrophe |
on: Jan 31st, 2007, 3:11am |
| Started by biap | Last post by biap |
I'm trying to execute this stored procedure from a source code
CREATE PROCEDURE DB_RESTORE
@DBName varchar(60),
@BackName varchar(120),
@DataName varchar(60),
@DataFileName varchar(120),
@LogName varchar(60),
@LogFileName varchar(120)
AS
RESTORE DATABASE @DBName
FROM DISK = @BackName
WITH REPLACE, MOVE @DataName TO @DataFileName,
MOVE @LogName TO @LogFileName, STATS
GO
If I do it from query analyzer like this it works fine
RESTORE DATABASE Test1
FROM DISK = 'F:\Users\Bianca\Test.BAK'
WITH REPLACE, MOVE 'BD_Data' TO 'F:\USERS\DATABASE\BD_Data.MDF',
MOVE 'BD_Log' TO 'F:\USERS\DATABASE\BD_Data.LDF', STATS
The problem is when I try to execute it from the code source it takes Test1 between apostrophe like 'Test1' and that is not good.It works only if Test1 is between quotation marks.
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@DBName", OleDbType.VarChar, 60).Value = "Test1";
cmd.Parameters["@DBName"].Direction = ParameterDirection.Input;
cmd.ExecuteNonQuery();
if I trace it with SqlProfiler it looks like this during execution time:
exec[DB_RESTORE] 'Test1', 'F:\Users\Bianca\TEST.BAK', 'BD_Data', 'F:\USERS\DATABASE\BD_Data.MDF', 'BD_Log', 'F:\USERS\DATABASE\BD_Data.LDF'
How can I send Test1 to see it like "Test1" and not 'Test1'
|
|
Reply Quote Notify of replies
|
| 10 |
Public Forum / General / Import & export Option in Bugzilla |
on: Nov 30th, 2006, 2:04am |
| Started by smhemanth | Last post by smhemanth |
HI All,
I am woking as a test engg in RelQ Bangalore i had one quire in Bugzilla.
Bugzilla 2.22.1 was sucessfully installed & its working fine but i want the import & Export option in bugzilla but i failed to see the option on the screen can any body help me out in setting the import & export option in bugzilla
Regards
Hemanth |
|
Reply Quote Notify of replies
|
Return to the board index.
|
Home
Help
Search
Members
Login
Register