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 Complete Forum Thread with Replies
Related Forum Messages:
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 !
How To Connect Mysql In ASP Java Script?
Currently, i am a student doing project about writing Directory Search Function for Cisco IP Phone Services. I know how to write ASP vb script to connect MySQL database.But i dont know how to connect in ASP java script. I read about Server side java script with Live Wire Application manager that can connect to mysql database.I am not sure ithat ASP java script can use this Live wire!Is there other way to connect mysql database?
View Replies !
I Am Trying To Connect With Database
I am trying to connect to my access DB. I am developing my site in Dreanweaver and I have the site hosted already. I want to use the hosts server as my testing server. When I create a connection string to the DB I have to use the servers directories. ex: e:/hshome/site/something.mdb When I try to add a server behavior to a form it can't find the DB. What am I doing wrong ?
View Replies !
Asp Connect To Database
I have an access database that I need to put online for basic viewing. However, the database is also used by other people for updating and report printing. The web server and the access database are on two seperate servers. I cannot connect directly to the database cause if somebody has it open, the website will not work and for some reason I cannot connect to to database across servers. I tried a linked database, but asp will not recognise it. I know that I could put all the reports and stuff online, but I have till next week and I do not think that I can do it in this short a time. Any ideas will be helpful and if there is code that I need to manipulate I could try to do it. And also I do not have rights to configure the IIS option on the servers.
View Replies !
Connect To Database
I'm having a hard time figuring out what type of database is used and where the file is located and how the script is even acessing it. From what I've done in the past with ASP a file was always used that had a DSN, username, and password.how this code is access the database without a username/password/DSN? I've tried using the login info in the line that is commented out (line 2) but it wouldn't let me in so I guess this isn't being used. Code: Set objDbConn = Server.CreateObject("ADODB.Connection") 'objDbConn.Open "driver={SQL Server};server=db1.host.com;database=databasename;uid=login;pwd=password;" objDbConn.Open application.contents("strconn") Set rsQuery = Server.CreateObject("ADODB.Recordset") rsQuery.ActiveConnection = objDbConn rsQuery.open "sp_MajorList" Set rsetQuery = Server.CreateObject("ADODB.Recordset") rsetQuery.ActiveConnection = objDbConn
View Replies !
Best Way To Connect To Database
I have seen 2 techniques to connect to database and was wondering which one is the best (i.e put less pressue on the database and time wise) set getRecords = Server.CreateObject("ADODB.Recordset") getRecords.ActiveConnection = mlConn getRecords.Source = "SELECT * FROM myDB" getRecords.CursorType = 1 getRecords.LockType = 3 getRecords.Open() ----OR---- set getRecords = mlConn.Execute("SELECT * FROM myDB")
View Replies !
Trying To Connect To A Database.
I am currently trying to get back into ASP and have begun looking at an old webpage I developed some years ago, it was fully functional back in 2002 and I had it up and running with no problems. I have just recently bought a new PC with Windows Vista Home Premium on it and installed IIS. When I try and connect to my data base I get the following error message retunred: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Disk or network error. /joynermorgan/take_registration.asp, line 50 Line 50 looks like this: writeDB.Open "joynerm" ....
View Replies !
Connect To The Database
What is the best way of connecting to a database? Is it creating an application level variable which is shared by all users ? Or is it a session level variable for each session ? Or is it a connection in each procedure ? Or Should it be like opening the connection when the database is accessed and closing it immediately which means multiple opening and closing in the same procedure.
View Replies !
Connect To A Ms Sql Database
I am learning asp and its going smoothly however I seemto not know how to connect to mssql. Can someone show me an example and where I output information from the database and do queries?
View Replies !
ASP.NET Database Connect
I am trying to connect to an Access database that I have setup through .NET. I have been able to do it with ASP by setting an ODBC connection and using ASP: <% strconn = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("access_databaselocalFinder.mdb") set strconn = server.createobject("adodb.connection") strconn.open "DSN=localfinder" %> .
View Replies !
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 !
Connect To Database In Dreamweaver
I've got a database on my web server and when I create the connection using a custom connection string within Dreamweaver, it connects with no problems. However, Dreamweaver then doesn't see the tables in the database. I know there's an issue with SP2 and Dreamweaver but I've installed the patch and it hasn't made any difference. Does anyone know of another work around?
View Replies !
Connect To Database Problem...
set conn = Server.CreateObject("ADODB.Connection") conn.Open ("DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=sportteam;") this is my connection to mysql..... but, when i use looping from market table........ then, get id from market to sum bet table..... is quick slow........ around 70-80 second..... why quick slow.........? my connection have problem?
View Replies !
Not Able To Connect The Web Pages To The Database
i am not able to connect the web pages to the database I am using the code as follows: <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open "d:/Inetpub/webdata/db1.mdb" set rs=Server.CreateObject("ADODB.recordset") rs.Open "Table1", conn %>
View Replies !
Connect To Access Database?
I am connecting to a microsoft access database using ASP. It works perfectly if i put all the code in every page i access a database with. However i have created a useDatabase.asp file which contains functions for connecting to the database. I use an include statement and call the function but seem to always receive an error which dissappears when i remove the function and paste the code. Code:
View Replies !
Connect To 2 Database With 1 Provider.
I am using the following to connect to SQL Server. How can connect to 2 database with this? strProvider = "Driver={SQL Server};SERVER=myserver;UID=user;PWD=password;DATA BASE=myDatabase;" I do not want to code the Database name and user in the query, as below: [database].[user].[table]
View Replies !
Connect To Your Database Oracle 9i
How do you connect to your database(oracle9i) upon clicking a button? Let's say I have a text box which ask for a specific date, then upon clicking the button, the script will connect to the database and extract records based on the input date.
View Replies !
Connect To Access Database Using ADO
Anyone have any idea what I am doing wrong. I have included the asp pages and the database, in hope that someone can tell what I am lost on. This page never loads when i try to open it in the browser.
View Replies !
Connect With Access Database
using XP pro with IIS to develop offline asp data access site. Suddenly, my DSNs and odbc drivers have disappeared - the only thing I can think of is that an XP auto update has done this in some way. Can anyone tell me how to get hold of and re-instal odbc drivers to allow me to connect with ACCESS data bases.
View Replies !
Cannot Remotely Connect To Access Database
I've been setting up an IVR server that needs to be able to directly update databases(remote data input from field reps). The database which I'm trying to get to is in fpdb of the ISS server. It is spewing this information at me: Code:
View Replies !
Front Page Connect With Database
i wanna connect front page forms with the database for searching and updation .. how can i do it.. in asp it ask to host the web it doesn't works on disk drive..any one help to solve this proplem..any alternative
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 !
Read The Data And Connect To The Database
how to connect to a mdb database and read from it. But how can i make a simple textarea that takes inout and writes it. all i want is a textarea with submit so i can write to my database only with a couple of words i dont have any code so fare apart from read the data and connect.
View Replies !
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?
View Replies !
Unable To Connect To Database From Frames Page
I have creaed a tree stucture using Frames. When selecting an option from the left side, an ASP page (Let us say page1.asp) opens. In the ASP page, I am getting inputs from the user. On clicking Submit, i am opening another ASP (Page2.asp) which has the connection tags. What happens now is, page1.asp gets loaded, when I click Submit, it says "Page cannot be displayed". 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 !
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 !
|
TRACKER
