|
sorry, i the original didn't post my code...
<rewrites>
<add name="Rule1" virtualUrl="^~/(Article)/(.*).aspx" destinationUrl="~/Article.aspx" rewriteUrlParameter="ExcludeFromClientQueryString" ignoreCase="true"/>
<add name="Rule2" virtualUrl="^~/(\d+)/(.*).aspx" destinationUrl="~/Default.aspx?oid=$1&title=$2" rewriteUrlParameter="ExcludeFromClientQueryString" ignoreCase="true"/>
</rewrites>
|
|
|
|
|
You should probably repost this one in the Asp.net forum as it doesn't seem to have much to do with databases.
|
|
|
|
|
How to take database backup on online server ?
|
|
|
|
|
Start here[^].
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
Simple; you ask the database-administrator. He'll know which database-application is installed. Each manufacturer has it's own implementation, and you can find examples for all major vendors on the internet.
Happy searching 
Bastard Programmer from Hell 
|
|
|
|
|
I'm using VB2008 I created a MsAccess 2003 database connection to my project,and make my project exe application. and put it with database Access in one folder and it worked well.
Now I 'm working on the Ms sql server database. I created a DataBase called MyDBs and made connection with it with Vb2008.
My question is can I create Ms Sql database(MyDBs) movable,attachement . means as I did with database access, by put it with application exe in same folder.
I hope I'm clear.
|
|
|
|
|
Yes, by changing the connectionstring[^]. Look under the header "Attach a database file on connect to a local SQL Server Express instance". Your customers will still need to have Sql Server installed, regardless.
If your database is local to the app (say, in the same folder) then stick with Access, or go for SqlCe. If your database needs to support more than a single user, you use Sql Server - in a centralized place where everybody who needs to access the database, can access it.
Bastard Programmer from Hell
|
|
|
|
|
I made this for dtatbase: Script database as - CREATE TO - File
and took the file Of DataBase(MyDBs) and put it in Debug folder in my project.
then I tried this way but didn't succed with me.
Dim MyConnection As SqlConnection = New SqlConnection("Data Source=.\SQLExpress; Integrated Security=true; AttachDbFilename=|DataDirectory|\MyDBs.sql;")
Public Sub Load_DB()
Dim sql As String = " Select Name,Tel,Addr from Table1 "
Dim dp As New SqlDataAdapter(sql, MyConnection)
Dim Table1 As New DataTable
dp.Fill(Table1)
Form1.DataGridView1.DataSource = Table1
End Sub
|
|
|
|
|
Mangore75 wrote: then I tried this way but didn't succed with me.
HOW didn't is succeed? What EXACTLY happened so you know it didn't work?
|
|
|
|
|
it showed me this error;
An attempt to attach an auto-named database for file C:\Users\Nader\Desktop\OOP- CreatProject\OOP- CreatProject\bin\Debug\MyDBs.sql failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
|
|
|
|
|
Error seems to be specifically telling what the possible problems are.
|
|
|
|
|
Only one instance with the name of the database is allowed on the server. Detach the database that's connected, or use an other name.
Bastard Programmer from Hell 
|
|
|
|
|
Why did you expect it too succeed? 
Sql isn't the same beast as Access. You'll need to have a server installed, connect to that, and *hope* that you have sufficient rights to create a database on that server.
Is there a server installed? Can you connect to the master-database on "127.0.0.1\SqlExpress"?
Bastard Programmer from Hell
|
|
|
|
|
I ahve a server installed and it succedd with this conetion but the daabase doesn't in the folder debug. but I tried to use the same way as I did with access, by put the file i debug as I said in my first post.
Dim MyConnection As SqlConnection = New SqlConnection("Data Source=Name-PC\SQLEXPRESS;Integrated Security=true;Initial Catalog=MyDBs")
|
|
|
|
|
It's not Access - Sql databases aren't meant to be portable.
The user that the server is running under needs read/write access on that path. Your connection-string also doesn't mention which db-file to attach. I suggest you use the connection-string that I pointed to.
Bastard Programmer from Hell
|
|
|
|
|
Hi All,
I want to convert DTS Packages to SSIS 2008.
Please suggest me better way to conversion.
Regards,
Vishnu.
|
|
|
|
|
I have a problem of inserting a record which includes data type conversion. There are two databases with the same data structure. One database is ok to insert that record, but another is not ok for data type conversion. I've checked all the data fields.Please give me any suggestion to solve it.
|
|
|
|
|
What type is it you're trying to insert, and what type is the field?
What DB are you using?
|
|
|
|
|
I'm using MSSQL2005. Inserting includes code such as 'X001' which is varchar and it needs to be incremented automatically. So that I converted varchar to numeric. It's ok for one database, but it's not ok for another one. I've checked all the data fields. It's all the same. Any solution for this?
Thanks a lot.
|
|
|
|
|
Are both databases having the same globalization settings?
|
|
|
|
|
Do u mean same database property? Actually, the database is restored but some changes had been made. But any changes had not been made to that data table which I'm trying to insert a record.
Thanks for your help..
|
|
|
|
|
vanillaET wrote: There are two databases with the same data structure. One database is ok to insert that record, but another is not ok for data type conversion. I've checked all the data fields.Please give me any suggestion to solve it.
Check the data-fields again. You're inserting something that cannot be converted, might be a text in a bit or a datetime field. Try logging all values that are going to be inserted, and have the app mail the offending values using a try-catch block.
Next, simply try the offending values using your original insert-statement trough the Sql Management Studio.
Bastard Programmer from Hell
|
|
|
|
|
Hi friends. i have a table that has relation to it self. how can i write a select query that shows it's data sequentially from the most top parent to the last child? This table has n levels.
|
|
|
|
|
|
I am new to SQL Server, but not to Programming or Databases, and am stuck, though I have an inkling what is wrong and I don't know how to correct it !!! I'll describe things in detail below ...
I am running this software on a stand-alone PC with myself as the only user.
When I try to add a diagram to my Database I get a message telling me that "This database does not have a valid dbo user, or you do not have permissions to impersonate the dbo user, so database diagramming is not available. Do you want to make yourself the dbo of this database in order to use database diagramming ?"
If I then reply "Yes" it says "This server does not have one or more of the database objects required to use database diagramming. Do you wish to create them ?"
Again, I reply "Yes" and this is where I get the error, "Could not obtain information about Windows NT group/user 'Gary-PC\Gary', error code 0x534."
If I then try to do similar in MS SQL Server Management Studio I get a different message - "Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects."
Now, I think this is something to do with my PC being renamed, because it is called, and has been for ages, MeDesktop, but at one point I seem to recall it was called Gary-PC, so it could be that something just needs a pointer changed, but I don't know where or how to do that !!!
In MS SQL Server Management Studio, Object Explorer, the Connection Name is "MEDESKTOP (MEDESKTOP\Gary)", Display Name is "MEDESKTOP", Login Name is "MEDESKTOP\Gary" & Server Name is MEDESKTOP.
I have 4 System Databases, "master", "model", "msdb" & "tempdb", all of which have a Status of "Normal" and an Owner of "sa" ... I seem to remember something about "sa" from when I first installed this stuff, but it was a long time ago !!!
I then have my own new (and very small) database, called "myKADB" and this is where I have the problem. I can add and amend Tables & Columns, and I can access the database via my C# program, so most things appear to be working just fine, bar these error messages above. Now, if I look at the Properties of myKADB, I see that again the Status is "Normal", but the Owner is "Gary-PC\Gary", so I think this needs to be changed ... though I could of course be wrong !!!
In the Files option of Properties, there looks to be the option of amending the Owner, so I click on the little button with the 3 dots and I get a Window that says "Select Database Owner", The top button says "Object Types" and there is just the single option of "Logins", and then there is a Window that says "Enter the Object names to select", but this Window is empty. If I then click the Browse button, it says "7 objects were found matching the types you selected" and the 7 are, "##MS_PolicyEventProcessingLogin##", "##MS_PolicyTsqlExecutionLogin##", "Gary-PC\Gary", "NT AUTHORITY\SYSTEM", "NT SERVICE\MSSQLSERVER", "NT SERVICE\SQLSERVERAGENT" & "sa".
Hopefully this is everything I need to tell you, what do I need to do ?!?!?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
