SQL Server Database Structure
I want to know the structure of SQL server database table using ASP.Is it possible to know?I want know the exact datatypes also.
View Replies
ADVERTISEMENT
IF Structure
What i have so far is: Code:
if(if something in search field){
do all this
}
else{
display all because first time run
}
As you see when People first run the program i wish for all books to be displayed which is taking place in the else{ } because the searchfield is undefined! however if then people click search with nothing in the search field i dont want all books to show but an error as they are searching for nothing. See where the above would trigger and show all.
its also important people can press "return" to submit as well and clicking the button so seeing if the the button is undefined is not an option! as if return is pressed it dont value the button being pressed. What are my options ?
Directory Structure
I'm developing a website for a software company. They want to publish news, tip/tricks and other articles on company's news section. I would like to get advice on how to name the individual article files? (There will be 1000s of them) . how to let the user query it? (i.e. news/index.asp?articleID=234544 or what?). I preffered a standard way to do all this. Pointer to any sample or tutorial on this.
View Replies View RelatedNavigational Structure
I've been trying to update the web-site for the local orphanage (www.bedaya.org.my) via FP2002. This whole project started on my humble Win98 and FP2000, then I've upgraded to an XP and FP2002. Without reading any on-line docs, I've simply reloaded the website from HD (via C:Inetpubxxx) into FP2002. It seemed OK.
Did various changes, and tried to update the web-site version (via 'Publish web'), and kaBoom! My shared borders (top, left and bottom) all now contain the page's text! So now there are 4 main text repeated, thrice in the borders, and once where it should be.
I thought maybe FP2002 did a terrible job at merging the navigational structure (NS), so I tried 'publishing' EVERYTHING all over again and asked it to 'overwrite' the existing NS. Took well over 4 hours on a slow 56Kconnection, and the result was the same.
Multilingual Asp Web Site Structure
We are devloping an b2b site that is in eglish. the site is working for about a year till now and we have decided to add a new local arabic version. it was developed using asp and sql and we have some kind big dbase.
1- the site offer products and services that are stored in the dbase. the user will switch between languages and should find all information in the choosen language. that means the dbase will contain 2 versions of the data with the same id so we display the inofrmation related to the language.
2- the layout will be in both languages. keep in mind that we almost have more than 1000 file of codes so any changes or enhancement should be minimum. 3-i am posting right now to find out the best way to make the work time minimum for now and future
here is the options i have in mind
1- create a folder for arabic and copy all files in it then modify them
2- add the language to the same files and choose between them by passing parameter then use the code for the paramter i am looking for the best way to create the arabic version and any comments are welcome.
URL Pointing And Directory Structure
I'm fresh out of the box when it comes to .asp, I've basically had a website thrown at me with the instruction "make that work". So, I have been given a cd with a site on it that I know works, (albeit on a different server) and I have uploaded it to my 1and1 server. I have been given the registered url, but dont know where to point it within the servers directory structure....which looks like this;
URL
I'm ok with HTML and some JAVA but all this ASP leaves me behind.
Collapsible Directory Structure Tree
I want to create a Expandable and Collapsible Directory Structure Tree. So that it looks at a folder from a path i give it and shows all directories and files underneath it.
This sub directories needs to be expandable and collapsable and when i click on on of the options it will bring a select box up by the side of this giving options. ie edit page.is this clear?
Input Form For Creating Hierarchy Structure
I'm trying to create an input screen that allows users to create a hierarchical structure as the one below, but have no clue where to start or how to construct it. Code:
Database Connection String To MySQL-database On A Different Server
I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!!
Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.
How Do I Export Data Fom Local Database To Server Database?
I'm current working on a project which need to upload local data to
live server database.
Meanings that, i'm current having a server in my local mechine. I need
upload data from local database to live database which host at oversea
company. But i really have no idea how to do this in asp.
Server, Database Server
I'm new to ASP, I just started learning last week at an internship and I am taking interest to it.But at home I don't have a server to practice on.
My question is do I need to download a server and a database server, or are they both the same thing?Also, what is the best to download?
Database On Different Server
We have a server for our intranet and one that has this MS Access mdb database we need to use.So basicly we want our intranet asp page to show data from a database located on another computer in the same lan.
For some reason we can not use the database from the intranet computer.
We've tried so far:
-Direct approach with mapped drive
-Direct lan address.
-Linked access database on the intranet computer.
-Modifying user rights.
When one of these solutions are viewed on the intranet server, they work fine. When tried from client computers trough the intranet, we get error of thiskind:
Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file 'M:TSTOITProject databasedata.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
/intra/db.asp, line 24
Connecting To SQL Server Database
my company is having me design a website for them and I did it in ASP (Classic), with the backend database being SQL Server 2000. I open the connection just fine, and everything seems to work but there's just one problem:
It only connects to the database when I'm logged in as Administrator on the machine (or from a remote machine); if I use my own username/password, I get a 500 Internal Server Error. What's funnier is that if I set IIS to allow anonymous access, it won't let ANYONE connect to it.
Any ideas what's the problem? I think it's something with the connection string (I told it to use a Trusted Connection because otherwise it was saying "[Username] is not associated with a trusted SQL Connection), but since I haven't used SQL Server in the past it might be something with that, as well.
ASP Database Connectivity Using SQL Server
I'm trying to add records from the ASP web page to the database using SQL Server..but i'm not able to do it..Can anyone send me the codes related to the database connectivity..
View Replies View RelatedDatabase On Remote Server
I try to get data from a database which is on an other server. I can view the files on this server via the directory "t:" from the machine the ASP pages are on.
Constring:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=t:database.mdb"
Error:
't:Database.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
SQL Server 2000 Database
I just started learning ASP.NET and i need to learn to use the database for SQL Server 2000 quickly. First, (forgive me for my ignorance) what is a database? Do you guys know any good sites that teach you how to access the database for SQL Server 2000? and have tutorials, and sample code?
View Replies View RelatedPutting Database On Server
My database and ASPs are currently on my local server and now I want to put it on the company's server.
Any pointers how can I do that? Do I need to keep both the ASP's as well as the database on the server?
Excel To SQL Server Database
I have an application where I have to import data from excel to SQL Server using ASP. If someone can please give me some piece of code it would be of great help to me as I am new to ASP.
View Replies View RelatedConnecting To The Server Database
To connect to the database I need to use the following string
myConnection.open "Maximum", "User", "limit"
where Maximum is the DSN
Instead of using that I have used the config.inc include file to connect to the database
Config.inc contains the script below ...
Database Connection MS SQL Server
Im creating my first asp website and am wondering if asp (JS) works well with a MS SQL server. If so how do I connect to it.
View Replies View RelatedMoved Database To A Different Server
I suspect this is a rather easy one however. I recently moved a web site developed by MS Front Page and a SQL Server database to a different computer. Now when I "Submit" field data, it no longer populates the database.
I've checked the main index.asp file and the global.asa file to find out how to repoint the form to the database and I can't figure it out. Can anyone give me any pointers?
Asp.net Connecting To Mysql Database At Ftp Server
currently i m working on a web-based project using asp.net and mysql database. i using MySQL Connector/Net to connect my asp.net page to the to MySQL database server. My database is stored in the ftp server. In short, i m trying to connect my asp.net page to the ftp database server. Code:
View Replies View RelatedConnect To A Database On A Remote Server
I have my access database on a xp workstation setup as a web server using IIS. I am trying to access the mdb from another web server, but when I run my code below I keep getting :
Microsoft ADO/RDS error '800a20ff'
Internet Server Error. Code:
Upload Files In SQL Server Database
I have attached the file upoading system in this thread.
It is working fine with MS Access Database but when i change the database to MS Sql Server then its upload not works i think its security problem, or the problem is that when i import the MS Access table into MS SQL server it change the field datatype from oleobject to image.
Open A Database Connect From One Server To Another
I have two servers is it possible to open a database connect on one server to access the database on the other. If so can anyone give me an example of the path.
View Replies View RelatedSecure ASP And MySQL Database Server
How to secure MySQL Data with encript, any data to encript have ''' and MySQL send Error, how to protect ASP Data o encript the code ?
View Replies View RelatedCross Server Database Communication
I am trying to find a way to make an asp page on one computer access a database stored on a different computer and perform numerous operations on it. I am unsure if this is possible as up til now I've always used a database in the same folder as my .asp pages. Can anyone provide some insight into this?
View Replies View RelatedServer-Side Database Editor
Are there any free ASP scripts that emulate a database editor, which are server-side?
I just want to edit my database like I can with access, but without having to manually download the database, update it, the upload it again.
Can Connect To A Database On A Remote Server But With An Error
I eventually managed to create a connection between my IIS LocalHost ASP WebPages and my database located on a website on the net. Here is the solution:
Dim conn, connect
set conn=server.CreateObject ("adodb.connection")
connect = "Provider=MS Remote; Remote Server=http://www.example.com; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & server.mappath("database_filedatabase.mdb") & ";"
conn.Open connect
When I point my connection to my database on the net like in the code above I get the following error:
Error Type:
Microsoft ADO/RDS (0x800A2011)
Internet Server Error: Object/module not found.
Any Suggestions?
Upload File To Server And Store Name In Database
I want to be able to upload a image to a directory called 'images' on my server and also save the file name in a database. is there anything out there that does this without a COM?
View Replies View RelatedError Connecting To MS SQL Server 2005 Database
My Active Server Pages Application is unable to connect to MS SQL Server 2005 Database while the existing application works fine connecting to SQL Server 2000.
View Replies View RelatedQuestion About Access Database From The Server Through Asp Website?
I've published my asp file to the website. I've uploaded all the asp files including access database and it works fine. But the record is not updated until i upload the latest database.
Actually the updated database stored in the my local server. Is it possible to access the database on my local server? It means, user can access all the updated directly.
Database Calls, Server Transfers, Sessions, And Cookies
Any body know of a resource that compares/benchmarks the expense (in terms of milli seconds, or server load) of using various programing options?
I know a lot of articles and forum posts reccomend best practices between functions and programming options, but I would be interested in some type of definitive benchmark to decide between various prgramming options, depending on the need.
For example, I can call a Recordset and quickly write it into an array, so that the connection can be closed even before I write the data to the HTML page. This would save conection time and server resources, but I'd like to be able to judge the worth when considering coding it.
Every time I do a Server.Transfer how expensive is it to the server? How much am I loading the server with Session varaibles? If I store some info in a cookie, but have to call it, how long will that take? Am I using up server resources by creating large arrays?