Secure 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 Complete Forum Thread with Replies
Related Forum Messages:
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.
View Replies !
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 !
Secure A Database
I have set up an asp script which writes the output of a form to a database.I have achieved my database connection like this:Code: DIM objConn Set objConn = Server.CreateObject("ADODB.Connection") objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ Server.MapPath ("contact-2000.mdb") & ";User ID=admin" objConn.Open How do i go about making the database secure? at the moment anyone could view the source of the asp script and download the database.Which folder should the database be stored in? iv heard of using the root folder? at present the database is located in the same folder as my asp file.is there a way of setting up a password on the databas ein access and passing the password from my asp script to the database. the password would have to be encrypted though.
View Replies !
CDO Email From SSL Secure Server
I've built a survey and tested everything is working fine - except fo one problem, that i have been told MUST be fixed I am using CDO.Message to send email message to the respondants of the survey - a lovely thank you message. It is sending the emails fine to all email address i have tested, except for email address here where I work, and I have been unable to find a reason for this the web scripts are running on a secure server (SSL certificate) and all is working great except the email issue. the actual code that is sending the emails works perfectly on non-secure server, and seems to be fina on the secure server except for the most important(apparently) email addresses. Does anyone have any ideas why the scripts would not send to one set of email addresses, but seems to work for all other when on SSL, but works for ALL email address when not on SSL.
View Replies !
Connecting To Secure Server
Maybe I'm doing something wrong, but I'm having troubles with connecting using SSL. I have a website at http://www.*****.com I have a login form directly on that index page. When you click sign in it directs to https://www.hostingcompany.com/******. However, it fails the first time, then it works the second time. The second time I am on the https://www.hostingcompany.com/****** page.
View Replies !
Are Server Variables Secure?
I'm working on a shopping cart page. In page A (checkout) the user enters their credit card information. On postback, if everything is correct, it sends the user to page B (confirmation). My question is, can I (or should I) use server variables to send CC information to page B? My boss doesn't want me to store this information in the SQL database we're using. Obviously cookies are out of the question and so is passing info through request.querystring, so I was thinking on using session variables for this, but not sure if it's safe. What should I do?
View Replies !
Regular Uploading To Secure Server Using Asp
I have a directory (folder) in ISS 6.0 Web server. I need to upload to a secure server over an HTTPS connection. What is the best method to upload from this directory to a secure sever. To access the server via a browser i have to type a password and username. The file are Cxml files and need to be uploaded on a secure connection.(HTTPS) I would need to run a schedule task every 2 minutes to check the directory for any files that are there. What script or method should i use. Is there any particular sample script such as (ASP) i could use. I am sure this can be done in ASP...but does anyone know how.
View Replies !
SQL Server To MySQL
is there a way to convert a SQLServer DB to MySQL, I want a duplicate of the SQLServer in MySQL. I did not find a free tool to do this, so I was wondering is there a way to do this by asp code?
View Replies !
From PHP/MySQL To ASP/SQL Server Or Access
I have always used PHP and MySQL to do anything database related on the web, however I find myself in a new situation. I've been handed the daunting task of creating a (relatively) simple, partially database driven website for my company's intranet. The one problem I have is that all of our servers are Windows 2000 based because all of the in-house software we have works off of SQL Server... and I've never touched a windows based server, SQL Server, or ASP in my life. Searching through the forums, I've been able to find a few ASP tutorial sites, but everything I've found seems to be either all technical info and no basics or a basic tutorial written for people who are already familiar with Visual Basic, C, or another type of windows programming 'thing'.
View Replies !
Access, SQL Server Or MySQL?
I've been using URL asp shopping cart (free version) for a while with an access database and it worked perfectly. My store is very popular now (more than 200 simultaneous users) and I need to migrate to a professional database. Comersus is compatible with SQL Server and mySQL. Which one do you recommend? My idea was to use mySQL since in that case I can purchase Power Pack Medium ($239) instead of Premium (.$370)
View Replies !
Can't Connect To MySQL Server
I recently got an error message from the Java release: j2rel.4.2_05 regarding c:program filesjavaj2rel.4.2_05injpiexp32.dll This message came in a .log file to my desktop, and since then, every once in a while I get this following error while trying access my pages in which I am creating. Code:
View Replies !
Database Retrieval Mysql And Asp
I have an sql statement like this executed with asp and mysql. select * from table1, table2, table3 How can I read a specific field from a table when tables have same fieldnames. So for example table1 and table2 have both a field named content. What I would like to do is: contenttable1 = recordset("table1.content") contenttable2 = recordset("table2.content") But then I get an error like item not found in recordset. If i do this it works but i don't know which field I read from: contenttable? = recordset("content") I know that it works with Access but I can't get it working with MySQL.
View Replies !
Query MySQL Database Using ASP.
I wish draw data from a MySQL Database using ASP. The Code I have so far: <% dim adoConn, adoRS set adoConn = Server.CreateObject("ADODB.Connection") set adoRS = Server.CreateObject("ADODB.Recordset") adoConn.Open "driver={SQL Server};server=SERVER-WEB;database=testing;uid=products;pwd=starmart" adoRS.ActiveConnection = adoConn %> and in the asp page code: 116. <%=rsDaySummary.fields("PageViews")%> This is obviously wrong as it returns this error: Microsoft VBScript runtime error '800a01a8' Object required: '' /stats.asp, line 116 Any pointers would be appreciated.
View Replies !
Call Php/mysql Database From ASP
First I'll answer "why". Because, while SQL Server is available, it is also "expensive". MySQL is CHEAP and a lot more robust than Access. Is there a way to add, update, retrieve, and delete data from a MySQL DB via php (or ASP for that matter) back into ASP? Could someone create a basic script to look at so I could see how? I hope there is a way to do this. Wouldn't it be advantageous for MS to do this or to make it easy to do so to be more competitive?
View Replies !
Graphing From A MySQL Database
I have seen several free graphing solutions using PHP, but does anyone know of something in ASP? I am wanting to create some simple bar, line, and pie graphs from a mySQL database. Everything I've found is in PHP (which I don't know). Is there an ASP solution?
View Replies !
Connect To MySQL Database
I'm a PHP developer and i've been asked to do some development for a site which is on a web server which only supports ASP. I had planned to have a bash at writing an ASP program (first time) on this server which will interact with a MySQL database on another web server (my company's web space). Would this be possible, or should I try and set up the database on the same server as the ASP pages (this may cost money, which is why i'm hoping the first option will be possible)?
View Replies !
MySQL Database Records
i post a while back on how to page thru database records. i dont really understand the ASPFAQ one. Its not well commented. This is how i learn anything, is if its commented on what does what. Can someone please help me. i have a datbase of about 90 records so far, that i would like to page thru.
View Replies !
Export MySql Database
I have a client that wants to export their database to excel from their admin section on their website. Is it possible to export a MySql database using asp code?If so is there sample code that i can look at? I haven't found anything on the net that works or is usefull in any way.
View Replies !
MySQL Database Upload
Code: Dim sConnection sConnection = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=" "; UID="";PASSWORD=""; OPTION=3" using this code(connection), how can i upload the mySQL Database? you see, i can't install mySQL online..
View Replies !
Grabbing From MySQL Database In ASP
I'm doing a website in PHP/MySQL but its an IIS server - THUS no sendmail. I've used CDONTS to send email in ASP before but this time its a little different I have a MySQL table called 'emails' in a database called 'db'. The table has Key IDs from 1 to about 50 that correspond with different email addresses. I want to use CDONTS to Grab the email addresses from the MySQL database one by one and in 15 second intervals send out the same email to each address. I know this sounds a bit 'spammy', but it's a band website with a mailing list. Only about 50 or so entries. I'm trying to set up a mailing list manager and the only missing piece is this damn emailing script.
View Replies !
Restore MySQL Database
I am moving my site from one host to another. I got all the scripts moved over but now I need to import my MySQL database. My previous host has a tool to create a .sql database dump. However, my current host limits the size a database dump can be for using phpMySQL to import the database. Is there any way I can FTP the .sql file to the webserver and run an ASP script that points to that file and executes all the commands? The .sql is 300,000 lines.
View Replies !
Line Graph From Mysql Database
I have a very simple database called "Tests" with a table called "Results" and the followint fields ID = Auto Test_Date = Date Test = Text Results = Int(11) I would like to have three line graphs based on the type of test. Line graph one where test = abc, the next graph would be where test = lmn and the third graph where test = xyz. The graph would show the past 12 months data.
View Replies !
Chat Room Using Mysql Database
I am working on developing a chat room using mysql database. the chat room has two frames one for the display text and the second frame for submit text from the user. the two frames are: display.asp send.asp what I need help with is when the user send a message how can I update the data with the new entry. Code:
View Replies !
How To Check The Return Value Of MySQL Database?
Now i got problem in my ASP page using VBScript that is implemented for IP Phone Service.I am trying to do directory service in IP Phone.So user key in the first name or last name. According to user input, it will go n look for the name in MySQL database.If the name is not found,it will return the error.My VBscript programming is bad.I cant check it out how i check the return for Record set from database. Code:
View Replies !
MySQL And Access Database Link
Is it possible to call fields from a MySQL Database and an Access Database on the same asp web page? If so, can someone please point me in the direction of a good guide/article/post on how to do this.
View Replies !
Search MySQL Database Query
I'm creating a database search page and the table I want to search has fields linked to other tables in the database. For example, the job table has a number of fields, 2 of which are area and job type which are tables in the database. My search page has option for searching by job title, job type and job area (via dynamic drop-down). Do I need to create a recordset for each referenced for the dynamic drop-downs to work?
View Replies !
Display Tables In MySQL Database
i need to display all my tables from the mySQL database in a table on an ASP/Javascript page, each as a link, so that when clicked, it wil open the selected table for editing. unable to do it as dreamweaver MX is not accepting 'show tables' as a valid query. how can i go about doing this? i'm relatively new to ASP, working on it for only 2 months now.
View Replies !
Asp Connection To Godaddy Mysql Server Problems
I've got a UAPortal (asp freeware intranet) on a godaddy hosting package that comes with a free mysql database. I can't connect the asp site to the godaddy sql server. They give me the connection strings, but don't tell me where or how to use them! Support does no good, they tell me that is programming, get an expert. UAPortal comes with an Access database, so when installed it works fine, but its only Access. I want to use the mysql database which is faster, larger and more useful. I opened the Common.asp file and added the info from the connection strings, but now I get an error message: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [MySQL][ODBC 3.51 Driver]Access denied for user: 'jwyss@winhostecn82.prod.mesa1.secureserver.net' (Using password: NO) /Common.asp, line 34 Does anyone know how to do this?
View Replies !
Connection String For A MySQL Database Needed
I'm trying to get asp to conect to a MySQL database, I've tried copying a few examples online that I found [there doesn't seem to be many!!] and I always get a 500 error with the code below. what am i doing wrong? any examples of a working connection string anyone could show me would be fantastic.
View Replies !
ADO Streams And Binary Data Held In A MySQL Database Blob Field
Has anyone else found a memory leak using ADO streams to access binary data held in a database. I have searched through this forum and have not come across anyone else, so maybe it is just me. The scenario is as follows: Windows 2000 SP3 MDAC 2.7 SP1 IIS5 MySQL 3.23 MyODBC 2.50 If I query the database and do a response.binarywrite everything works fine and no memory leak. eg. response.binarywrite myrecordset("blobfield") If I read the very same BLOB field into a ADOstream I then get a memory leak in DLLHOST.EXE of how big that binary field was. ie If the picture is 140k in size DLLHOST.EXE increases its memory size by 140k. This keeps on happening until DLLHOST.EXE is something like 250 MBytes in size at which point it stops working. Quick restart of the IIS Web service and I get all my memory back. The command I am using to get the data into the ADOstream is picturestream.write myrecordset("blobfield") I have also tried putting the binary data into a variable first before inserting it into the stream: set x=myrecordset("blobfield") picturestream.write x The stream is closed and set to nothing at the end of processing. Everything is cleanly shut down. Through testing I know the memory leak occurs once the data has been written into the stream. The stream is correctly created as type binary. The stream problem I am encountering does not seem to be limited to ASP, I tried it using Visual Basic to create a COM component to do the same job and still got a memory leak. So the questions are: 1. Has anyone come across this before or fixed it? 2. Is there another way of getting binary data out of MySQL, something like the opposite of LoadFile? I have wasted so much time on this problem but cannot find, having searched Microsoft's knowledge base and the rest of the web, any reference to the problem.
View Replies !
Secure And Non Secure Data
i have an ecommerce site that is split across two domains, a secure space that retains cc details and the main site where contact information and order details are held. I need to be able to produce a report that displays both sets of info in a printable document. aside from using iframes is there a better way of doing this?
View Replies !
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?
View Replies !
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
View Replies !
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.
View Replies !
Database 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.
View Replies !
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 !
Putting 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?
View Replies !
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 !
Connecting 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 ...
View Replies !
Moved 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?
View Replies !
Connect 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:
View Replies !
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.
View Replies !
|
TRACKER
