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?
I have been tasked to manage an internal support web based system currently connecting to a local web server based MDB. I want to move this backend to a SQL DB on another server and use that instead as i plan on this support system growing fairly large, also trying to standardise on DB locations. Code:
I am loading up a site for my boss to look through, I want to put it in my templates folder so they can surf it just like they would if it was loaded in the www page. The problem I am having is with my asp pages interaction with my database. I put my database in a folder called test in my templates folder (/templates/test/db)Now when I run the query I get this back:
Microsoft JET Database Engine error '80004005' Operation must use an updateable query.
/templates/insertit.asp, line 22
I checked the folder and it is rw-rw-rw. If I load this page is the www folder and adjust the map path it works excellent. Does anyone know what could be wrong? Here is my code:
I Have a form, and in that form I have a check box, I wish to say " If Checkbox is checked Then variable = true Else Variable = false". Here is what I have as far as code goes...
Thus far the variable is always false, leading me to believe that my syntax is wrong. All the SQL part of this is tested as working (Included to give a perspective on what I am trying to do) so you can for the most part ignore it. It is the form part that has a problem. Code:
I'm having a problem whenever i enter 2 response.redirects() in one funcion.. it's weird. What i'm trying to do is to display a simple error message underneath a login. But i'm trying to do it by sending the user back to the SAME page (not sure if that's even possible!) and passing a variable, notLogged, to test against. I hope this makes sense! Code:
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.
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.
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
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.
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..
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.
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.
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?
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.
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:
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 :
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.
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.
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?
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.
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?
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.
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.
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?
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Can't allocate space for object 'Syslogs' in database 'grdb' because the 'logsegment' segment is full. If you ran out of space in Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment.