A DOS Question! (about Aspnet_regsql.exe With Paramaters)
May 10, 2007
I need to setup some asp security databases and I have seen several sets of instructions. Some say "Navigate to C:WINDOWSMicrosoft.NETFrameworkv2.0.50727" and some say at the "asp command box". I do know that the directory & file exists on my machine. I have run aspnet_regsql.exe to configure my local server. I now need to run it to configure my web host SQL Server 2005 and that requires some paramaters like "aspnet_regsql.exe -S [DB Server Name] -U [DB login] -P [Password] -A all -d [Database name]". I am old and started before windows. I know DOS. But obviously not well enough.
How do you "Navigate to C:WINDOWSMicrosoft.NETFrameworkv2.0.50727"?
If I say "CDWINDOWS", it works.
When I am at the "C:WINDOWS>" prompt and say "CD Microsoft.NET" it says "invalid directory"
When I am at the "C:>" prompt and say "CDWINDOWSMicrosoft.NET" it says "invalid directory"
When I am at the "C:>" prompt and say "CDWINDOWSMicros~1" it says "invalid directory"
Thanks for your help. John Brown
View 1 Replies
ADVERTISEMENT
Aug 14, 2006
I'm having trouble using paramaters in a full-text search with FormsOf(INFLECTIONAL:DECLARE @SearchWord nvarchar(4000)
SET @SearchWord = 'tax'
SELECT listing_id, RANK, name, address, city, zip, heading, phone
FROM listings a,
FREETEXTTABLE(listings, *, 'FormsOf(INFLECTIONAL, @SearchWord')
WHERE [KEY] = a.listing_id
ORDER BY RANK DESC, name
This returns no results. It treats the paramater as a NULL value. But this...
SELECT listing_id, RANK, name, address, city, zip, heading, phone
FROM listings a,
FREETEXTTABLE(listings, *, 'FormsOf(INFLECTIONAL, tax')
WHERE [KEY] = a.listing_id
ORDER BY RANK DESC, name
returns over 500 results. I've been banging my head against this for 2+hours. Google has been no help as every example shows the result hard-coded in like the second example.PLEASE HELP!!!!!!
????????
View 4 Replies
View Related
Dec 18, 2007
Hi, Just wondering if I could make sure that "hackers" don't tamper with my querystring - which is a parameter for a SQL query. i.e... Dim ListOfValues as string = request.querystring("listOfValues")
'Output would be this: 324234,5445,554654,45632,SQL command : Delete From table where product_id IN (@ListOfValues)
cmd.paramaters.addwithvalue("@ListOfValues", ListOfValues )
How can I validate it so that hackers can't add any characters other than 'numbers' and ' , ' to the sql parameter? I have tried to tryparse the 'ListOfValues ' as an integer - by replacing "," with "" but an integer overflow occured. Any questions or ideas? Thanks
View 6 Replies
View Related
Jan 17, 2007
I'm writing a search query in TSQL for MS SQL. Here is my code:
SELECT a.*, b.username, c.categoryname FROM
video a
inner join
user b
on
a.userid = b.userid
inner join
video_category c
on
a.categoryId = c.categoryid
where
a.videotitle like '%@SearchText%'
OR
a.description like '%@SearchText%'
This returns no results, but wheN I replace the '%@SearchText%' with my search text inplace of the @SearchText it returns retuls. I have a feelign I am passing the params to the LIKE clause incorrectly. Any suggestions?
Thanks,
-- shawn
View 5 Replies
View Related
May 24, 2006
Hi,
Does anyone know how i go about writing a search query using paramaters, ive been using this as my template:
Select Distinct Recipedata.Name, Ingredients.Ingredient, Directions.Directions
from Recipedata,Ingredients,Directions
Where Ingredients.Ingredient Like '%Chicken%' and
RecipeData.RecipeID = Ingredients.RecipeID and Ingredients.RecipeID = Directions.RecipeID;
Problem is now that i want to use paramters instead of hard coded values as this is for a user. How do i go about this? This database has a VB2k5 front end for the desktop and PDA(and no the target PDA is not web enabled so web servcies arent available to me).
Thanks Much
View 6 Replies
View Related
Dec 21, 2007
I want to do some error checking on the parameters found in a SQLDataSource before I run the insert. The problem is these are ControlParameters and I want to do this dynamically so I can't just call the Control.Text property and grab its value. So how can I get access to what the ControlParameter evaluates to?
Secondly, is there a way to access what the update parameters evaluate to in order to check them before they're inserted - if so how do I get access to these?
Here's an example of one of the data sources i'm using:<asp:SqlDataSource ID="sqlContact" runat="server" ConnectionString="<%$ ConnectionStrings:strConn %>"
SelectCommand="SELECT [ContactID], [FirstName], [LastName], , [Address], [Phone], [Grade], [Contacted], [ListServe] FROM [Contact]"
UpdateCommand="UPDATE Contact SET FirstName = @FirstName, LastName = @LastName, Email = @Email, Address = @Address, Phone = @Phone, Grade = @Grade WHERE ContactID = @ContactID"
DeleteCommand="DELETE FROM [Contact] WHERE ContactID = @ContactID"
InsertCommand="INSERT INTO [Contact] ([FirstName],[LastName],,[Address],[Phone],[Grade],[Contacted],[ListServe]) VALUES (@FirstName,@LastName,@Email,@Address,@Phone,@Grade,0,0)">
<UpdateParameters>
<asp:Parameter Name="FirstName" Type="String" />
<asp:Parameter Name="LastName" Type="String" />
<asp:Parameter Name="Email" Type="String" />
<asp:Parameter Name="Address" Type="String" />
<asp:Parameter Name="Phone" Type="String" />
<asp:Parameter Name="Grade" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:ControlParameter Name="FirstName" Type="String" ControlID="txtContactFirst" PropertyName="Text" />
<asp:ControlParameter Name="LastName" Type="String" ControlID="txtContactLast" PropertyName="Text" />
<asp:ControlParameter Name="Email" Type="String" ControlID="txtContactEmail" PropertyName="Text" />
<asp:ControlParameter Name="Address" Type="String" ControlID="txtContactAddress" PropertyName="Text" />
<asp:ControlParameter Name="Phone" Type="String" ControlID="txtContactPhone" PropertyName="Text" />
<asp:ControlParameter Name="Grade" Type="String" ControlID="ddlContactGrade" PropertyName="SelectedValue" />
</InsertParameters>
</asp:SqlDataSource>
An Event is fired when I click add on a button which looks similar to this:
//Add btnAddContact_Clickprotected void btnAddContact_Click(object sender, EventArgs e)
{
InsertRow(sqlContact);
}The InsertRow() function is then what i'm using to evaluate the values... So how can get the values those controlparameters actually are in order to evaluate them before I actually insert. Or is there a better way to do it?
View 4 Replies
View Related
Aug 16, 2006
Where's the sql script to generate "aspnet_regsql" application services database stored? Thanks.
View 2 Replies
View Related
Jan 23, 2007
hi...
I want to Create an Application Service Database for SQL Server, SqlWebEventProvider, and i am trying to write in command line:
c:>C:WINDOWSMicrosoft.NETFrameworkv2.0.50727aspnet_regsql.exe -U user -P pass -S sqlserversqltest -A w
i get the following error:
The argument 'sqlserversqltest' is invalid.
why is that?
do i have to use the following flags:
-ssadd -sstype t ?
and, how is the right way to do this...?
thank you...
View 1 Replies
View Related
Jun 5, 2007
Hi, It seems everytime I create a new project, I have to run aspnet_regsql to map the database to my application, otherwise, there'll be errors when trying to connect to SQL in my application. My question is, is this a norm? To be executing this procedure everytime I create a web application?
View 2 Replies
View Related
Feb 6, 2008
I'm using aspnet_regsql to run the ASP.NET SQL Server Setup Wizard. On the page titled "Select the Server and Database", there is a drop-down list of database names I have used. Is there a way to delete the names in that list that I no longer want?
View 4 Replies
View Related
Jun 21, 2006
Where is the sql generated by aspnet_regsql.exe saved?
View 2 Replies
View Related
Jul 17, 2006
I have been having some trouble. I am new to this and am having issues when I am running aspnet_regsql always getting the error:System.Web.HttpException: Unable to connect to SQL Server database. ---> System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)...my question is how do I change the default settings to allow it to run?Regards,Patrick
View 4 Replies
View Related
Apr 6, 2008
I am trying to run aspnet_regsql to set up the membership tables on this SQL 2005 server. It’s a new installation of SQL 2005, using "SQL Server and Windows Authentication mode" Security.
I followed the directions at http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277 to enable remote connections, enabling the browser service, and opening the firewall. Under SQL Server Configuration manager, I see the protocols for Shared Memory, Named Pipes, and TCP/IP are enabled. Also the Services SQL Server, Server Agent, and Server Browser are automatically running.
But when I run aspnet_regsql I get the error: Unable to connect to SQL Server database (because of error 40 – could not open a connection to SQL Server).
What else could be needed to allow this connection?
View 2 Replies
View Related
Aug 12, 2007
I have been reading on aspnet_regsql.exe tool and still haven't found my answer. So here we go... I am using VWD Express and I have already made many pages in many dbs within the app folder. My question is how do I use the aspnet_regsql.exe tool to know what DB that I want the tool to know AND how do I put in the name of the DB on my sql hosting server? For instance:Let say in my app folder I have a DB named testDB.mdf and my hosting sql server is named sqlHostingServer... so if I use the command line entry in accordance with the documentation, it should look like this (in the dos prompt):aspnet_regsql.exe -E -S localhost -d testdb.mdf -A all -sqlexportonly c:output.sqlbut it seems that for the DB name I can put anything I want and still gives me output... wtfark... any help? I don't work at Microsoft so please simple documentation or something like that.Thanks,MR
View 4 Replies
View Related
Dec 16, 2005
Hi!
How can configure a SQL2005 Express database file (.mdf) for application services (memberships, role management ...)? aspnet_regsql accepts only databases, but not with individual database files.
It would be important for me to have all data of a single application be stored in a separate file, hereby it would be easier to copy data to a remote host.
Currently I copy ASPNETDB.mdf to the host, but it contains (membership and role management) data for every application created on my machine.
Szabolcs
View 5 Replies
View Related
Mar 27, 2006
Does anyone know what aspnet_regsql.exe requires to run stand-alone? I have to apply the .NET 2.0 Management/Role API to a sql2000 database on a machine that does not have the .net 2.0 framework installed.
View 3 Replies
View Related
Apr 20, 2006
Hi,
I want to bring in Database Cache Dependency for my WebApplication. For that, I learned that the first step is settingup database for notifications when database/tables change. And I see it explained to use Aspnet_regsql.
But I do not have it in my C:WindowsMicrosoft.NETFrameworkv1.1.4322 folder.
Any help ?
Thanks in advance.
View 1 Replies
View Related
May 14, 2008
Hi,
I am having problems with a visual studio project and I was advised to run Aspnet_regsql.exe.
After running it I select windows athentication and when I click on the drop down to select the database I get this error:
Link to Image :
I Have no problems accessing the databases with management studio express with windows authentication.
Anyone know what I am doing wrong?
View 3 Replies
View Related
Oct 20, 2006
Im trying to setup a SQL server 2000 database to use membership & roles. Running aspnet_regsql.exe gives me the following errorsSetup failed.Exception:An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 515 and the SqlException message is: Cannot insert the value NULL into column 'Column', table 'tempdb.dbo.#aspnet_Permissions_________________________________________________________________________________________________000000008000'; column does not allow nulls. INSERT fails.Warning: Null value is eliminated by an aggregate or other SET operation.The statement has been terminated.----------------------------------------Details of failure----------------------------------------SQL Server: Database: [AddressVerification]SQL file loaded:InstallCommon.sqlCommands failed:CREATE TABLE #aspnet_Permissions( Owner sysname, Object sysname, Grantee sysname, Grantor sysname, ProtectType char(10), [Action] varchar(20), [Column] sysname)INSERT INTO #aspnet_PermissionsEXEC sp_helprotectIF (EXISTS (SELECT name FROM sysobjects WHERE (name = N'aspnet_Setup_RestorePermissions') AND (type = 'P')))DROP PROCEDURE [dbo].aspnet_Setup_RestorePermissionsSQL Exception:System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'Column', table 'tempdb.dbo.#aspnet_Permissions_________________________________________________________________________________________________000000008000'; column does not allow nulls. INSERT fails.Warning: Null value is eliminated by an aggregate or other SET operation.The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at System.Web.Management.SqlServices.ExecuteFile(String file, String server, String database, String dbFileName, SqlConnection connection, Boolean sessionState, Boolean isInstall, SessionStateType sessionStatetype)Ive run this many times on other servers and have never come across this problem before. Has anyone else ? Does anyone know the cause and if there is a fix ??** I am logged in with full admin privaliges tiaMark.
View 3 Replies
View Related
Jan 19, 2007
I've been using SQL Serer 2000 or SQL Server 2005 (external) for my website and I have it configured through the aspnet_regsql tool. The hosting company doesn't offer access to SQL Server to configure the database. So I thought I'd use SQL Express. Only problem is now I can use the exe to set up this db.
Does anyone know of a good way to configure this database for my website?
Thanks!
View 3 Replies
View Related
Sep 15, 2007
i already ran aspnet_regsql but i still get below...anyone know why? thanks in advance
Could not establish a connection to the database. If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.
View 4 Replies
View Related
Nov 21, 2007
I just ran the utility without any commands ant the wizard has come up. This is all independent of my web application.I am guessing this is going to install the database tables to my existing database. UPDATE: They have been createdWill I then connect my web app to this database schema that is created?How do I change the membership/roles users in my web app to point to the database tables?
View 6 Replies
View Related
Jan 2, 2008
I installed ASPNETDB with the standard script, but then learned it was possible to integrate this membership db into my existing db (haven't done this yet, but will tomorrow then I'll delete the auto-created ASPNETDB for clarity).That's Great. Now.....I'm not sure the best way to tie this information into with my existing data. I assume I should use the UserID field but how should I do it? Should I update my existing customers table with a copy of the UserID value upon creation? If so, how do I do that? I can create the relations between whichever tables, but I am curious as to your recommended method.Thanks for your help.jb
View 5 Replies
View Related
Nov 13, 2006
Hi,When I attempt to add the membership functionality to a database created within VWD Express, by using the aspnet_regsql.exe application (connecting to ./SQLEXPRESS using Windows authentication), the database I've created within VWD Express doesn't appear within the list of accessible databases. I have the same problem when attempting to access the same database within Management Studio Express.Does this mean that databases created from within VWD Express don't use the same storage mechanism or paradigm as those already available within Management Studio Express? Or perhaps I need to somehow register the database using Management Studio Express? As a side note, I'm not sure if the "File/Open File" menu option within Management Studio Express holds the answer to my problems, but rather bizarrely, it crashes Management Studio Express when I select it.Apologies for the rambling - in essence my question is "How can I make databases created within VWD Express appear within aspnet_regsql.exe and/or Management Studio Express?"Many thanks,Jon
View 6 Replies
View Related