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 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 !
New Database Call
My 1st page calls a 2nd that uses same data from a database. What is the best way to get the data in the second: a new call to the database or passing array through session variable?? I seems to me that avoiding a new call will speed up things but my concerne is that I have read many posts with caution messages againts session vars.
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 !
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 !
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 !
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 !
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 !
How To Call Dll In ASP?
I want to write a dll using VB6/VC6 and used by ASP. Questions are: 1. what special requirements for the dll used by ASP? 2. after built dll, how to use it in ASP? Where I should save the dll? Do I need to register the dll? Any article/link related to my question? the sample code?
View Replies !
Can I Call A WSH From ASP?
I want to have a single script for sending emails, accessible from both ASP pages in any virtual directory in our websites (all on the one server), plus accessible from a number of WSH (windows scripting host vbscript files) which are triggered by the web servers Scheduled tasks. The script formats text and checks emails and so on. Is this a candidate for a web service? if so, how would i write it? Is a web service available from WSH?
View Replies !
Call A Dll In ASP
We have a C++ DLL that we call from VB6 program. This is how we declare the DLL in VB6: Declare Function RefSearch Lib "csearch32.dll" (ByVal path As String, ByVal findword As String, ByVal CaseSensitive As Integer) As Integer This is how we call the DLL in VB6: hit = RefSearch(path, SearchStr1, ChkValue). Can I call this DLL in ASP and how ?
View Replies !
How To Call A .asp Page?
I have two .asp pages running under different IIS authentication methods.. The first page uses Windows Authentication and gets the Logged on User from Request.ServerVariables("User_Logon") The second page runs under different Domain credentials and can access the ldap directory... so I want to call it like so.. user = request.servervariables("User_Logon") then something like -- <% call page2.asp?theuser=" & user" %> where page2 runs as 'anonymous' credentials... (and Logon_User is Null) ------- If this can't be done can I write the information to a cookie and then read it from the other asp? How would I do that?
View Replies !
Using An Input To Call A Sub R.
I have a bummer here. I have 3 sub R. that I need to call from a input button. I set up the following line, but the script just calls them with out having the button pressed. OOOO! Any ideas? <form method="submit" name="nreg" onsubmit="(this)" action="call readitme, call saveitme, call reduce" > I have also used method="POST" same darn thing, script just runs the sub R. with out being pushed or cliked. UUUGGG
View Replies !
Call ASP Function
I have a form which checks email addresses. On submitting the form i have some JavaScript checking the format of the email address, once this has been completed successfully I would like my asp function to run. On successful completion of that I would like my form to be submitted to another page. Is this possible?
View Replies !
Call Report
This may be in the wrong forum, but I'm going to give it a shot anyways. Here goes. I have a conference report that has 24 phone lines that are available for booking. Each call can take between 1-24 lines, you can have any number of calls as long as the number of lines they take up does not go over 24. I graphiclly represent this in a horizontal bar graph that displays the number of lines that are taken up for a particular half hour. Problem is when a meeting takes more than a half an hour, the meeting bar fills up for that whole time without any information on the meeting. What I would like to do is have each meeting when assigned in the DB or through an array be assigned a color and then that color appears on the graph under the time the meeting is. If there are multiple meetings (there almost always are), then the meeting that has been active the longest will be the first color bar on the graph. To make a way too long story short. I want to have a stacked bar chart that moves colors to the front as other's leave every half hour and move new ones to the back. If you want to look at what we have now visit URL.
View Replies !
How Do I Call The Last ID In A Column
Ok i'm self taught with regards to ASP so not great etc, so sorry if this is a really basic question.. On the last line here i'm trying to some how get it to call the last ID entry... ImageID = Request("ID") If (Len(ImageID) = 0) then ImageID = "1" If Not IsNumeric(ImageID) Then ImageID = "1" If ImageID = "0" then ImageID = "1" If ImageID>3 then ImageID = max(Len(ImageID)) This is basically for some max min links for a online comic here's what it links to <a href="default.asp?id=<%=ImageID-1%>">< Backwards</a> - <a href="default.asp?id=<%=ImageID+1%>">Forward ></a> - Code:
View Replies !
Call Funtion Of A Dll From Asp
Can i call function from dll from an asp page (not COM)? The problem is that i want the asp page to call function from dll which will be in the same folder. I could have created a com dll but it means that the web hosting company must register it on their server and they wont.
View Replies !
Call Application
How can I execute a console application (smsbr-con.exe) in the server from asp, insert the parameter (-c, -m, -n, etc.) and get a returned values.
View Replies !
Call To Server
I've built an application in VB6 does some processing - it's not really important what it does. The application consists of a single DLL which does all the hard work, and a simple EXE which acts as the front-end. I designed it this way in the hope that I could also build an intranet app that controls the same component (DLL). I'm building the intranet page now, but I get this error when I try to instantiate the component. Rather than fiddle aimlessly with the permissions, I thought I'd post here and find out what I am missing. What permissions do I need to set up and where?
View Replies !
Call Iframe
I have 2 web pages which is a.asp and b.asp. I using iframe to call b.asp in a.asp like below:- Code: <iframe src="content_wallpaper.jsp" id="myiframe" scrolling="no" frameborder="0" width="355" height="120" marginwidth="0" marginheight="0" align="center" allowTransparency="false" background-color="transparent"></iframe> The problem is, i need to call the iframe in b.asp like below (because i just want to refresh this portion of the page) Code: <a href="javascript:myiframe.document.location.reload()" class="blue_11"><%=tmpCatName%></a> The error occur as "myiframe" is in a.asp and i need to call it in b.asp and i can't find the solution for that too.?anyone know how to pass value from a.asp to b.asp in above?
View Replies !
Asp Call Dll Problem
I have registered a dll in my server using regsvr32 dll_name.dll and it prompt me the dll is registered succssfully however, when my asp code want to create that object, the page prompt me that Server object error 'ASP 0177 : 8007045a' Server.CreateObject Failed 8007045a Any idea??
View Replies !
How To Call Win32 DLL?
turnOnString = "/scripts/openagent_HTTP.dll?TurnOn&" & ascii(turnOnParameter) Response.Write " window.open(turnOnString, ""TurnOnWindow"", ""locationbar=no, width=20, top=350, left=350, HEIGHT=20, toolbar=no, resizable=no"")" & vbCr DLL name: openagent_HTTP.dll Function name: TurnOn The above coding works fine, i run the above script in button on click, it can pass the value to the dll, but evertime it prompts for each click, because i use the window open, What i need to do is, instead of calling my dll through Internet explorer, Is there is any way i call my dll straight and pass the value without window open?, pls help almost struggle for a week...
View Replies !
Best Way To Call Functions?
I have written a very complex web app for intranet use. It allows users to search a large database and then returns formatted results. I am currently employing a method as below: Code:
View Replies !
How To Call Another Asp Page?
I have an asp page accepting input from users Lets say this is form A, form A passes data to another form (say form B) to validate the data, if its valid then I want to open up another asp form (say form C) that does some queries based on data sent by form B. I need help in opening the form without user intervention meaning, users should not have to press any key.
View Replies !
Call Another Program
With .asp,how do I call another program?I would like to have my .asp script make a call to a PERL script, wait for the PERL script to finish, and then continue with what is/isn't returned from PERL. I know in PERL this is simply done: system(theASPprog.asp). No fork is created, so the PERL prog waits for the .asp to finish.How do I do this with ASP?
View Replies !
Call A Page
I want to syndicate some content to other users. (no RSS).Anybody should be able to publish some information from my server/database by placing some javascript like: <script language="JavaScript" src="http://www.myserver.com/mypage.asp?param1=loremipsum¶m2=dolorsit"></script> How can I code an ASP-page (on my server) so it returns and inserts information into a location in an existing webpage (other servers).
View Replies !
Call ASP Function
I'm trying to call asp function just simply by clicking a button But could i do this method? or how could i pass the function and values.It should be something like this: <script LANGUAGE='VBSCRIPT'> <!-- function btnClick_onclick Dim strID Dim strName strID = document.form.txtID.value strName = document.form.txtName.value <%saveData(strID, strName)%> End Function --> </script>
View Replies !
Executing An API Call
I have a VB DLL which I've created that I call from an ASP page I also created. The DLL makes a call to the API (FindWindow), but always returns 0 instead of an HWND. I'm guessing that IIS is designed to disallow its own processes from discerning any information about outside (non-IIS) processes (for security reasons). i read into low, medium, and high "security" settings (ie. being created as an IIS process, pooled, or an outside process), but that didn't seem to help. Any suggestions as to how I can make this API call succeed (and/or any similar API calls?
View Replies !
|
TRACKER
