Connecting To MySQL Database
I've tried a couple of strings, but it can't connect to my database.What's the connection string?
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Connecting To Mysql From ASP
I am trying to connect to MySQL from ASP. Yes, i downloaded the mysql odbc driver and installed it. I have also set up the dsn correctly. connection is successful but queries are not being successfully executed. here goes the code:
View Replies !
View Related
Connecting .asp Page To MySQL
I'm trying to get an asp page talking to MySQL, which i have working locally using the myodbc 3.51 driver installed, but its not working when i upload the page to the web server. (im using Dreamweaver). I have installed the myodbc 3.51 driver on my local machine, and am able to connect to the mysql db from a .asp page with DreamWeaver OK. The connection file needs to change obviously ....
View Replies !
View Related
Non-persistant Method Of Connecting To MySQL
I have currently got a web site hosted by a hosting company, but when say more than 15 people view it at the same time it crashed, my host company recommend me using non-persistant method of connecting to mySQL, now i dont really know what that means, and the only explanations i can find is in php and I have no idea about that either. Can someone please explain what non-persistant method of connecting to mySQL and have you got any example code i can loook at to change the coding I have.
View Replies !
View Related
Connecting To The Database...
I have moved my database from an sql2000 server to an SQL7 server I am trying to connect to the database using windows authentication (no need for username and password) but I keep getting this error: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified I have already created a DSN driver named "projects" to point at the server This is the code I have used: set con = Server.CreateObject("ADODB.connection") ' Use the object to open the inventory ODBC DSN con.Open ("dsn=projects,"",""") Can you please help me set it up?
View Replies !
View Related
Connecting To Database.
I have set my sitein the following directory "C:InetpupwwwrootShevi" In this I have all my html and asp files.I also have a database called "guest.mdb" I use this code to connect to my database and read and write..But it doesn't work..Sometimes it just shows the records in the databse but when I try to submit a new record (through a form) it gives me errors. set Conn = Server.CreateObject("ADODB.Connection") Conn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("sheviguest.mdb")) set rs=server.CreateObject("ADODB.Recordset") rs.CursorType = adOpenKeyset rs.open "SELECT * FROM Guestbook", Conn Is the part in blue correct? If not tell me how
View Replies !
View Related
Connecting To Database
I have a webpage on my Local Host Server - IP: 127.0.0.1.I have a Access Database called "database.mdb" hosted on a Second Server in a folder called "db" - IP: 134.67.23.5 The IP Address is only an example So the address of my database would for this example be http://134.67.23.5/db/database.mdb I am use to connect to a database like this: connect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("dbdatabase.mdb") & "" How do I create the connection from my local host webpage to my database on the second server?I have been battling with this for sum time now?
View Replies !
View Related
Connecting To A Database
I am trying to connect to my database using (the database is stored at D:InetPubmysitesdatabaseMYadmin.mdb): Const dbPath = "databaseMYadmin.mdb" But it returns the error: 'D:Inetpubmysiteswebsite1htdocsdatabaseMYadmin.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. Is there a way to define the root folder (say as 'D:Inetpubmysitesdatabase), or will I have to move the website to be outside of the /website1/htdocs/ folder?
View Replies !
View Related
Connecting To Database
I have started to recieve the following error after creating a new database and a DSN connection to this database Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
View Replies !
View Related
Connecting To A Database
I'm having trouble with a connection to my database. Which I think its the connect, because I can't see information from on database in my table. <%Dim connCCOL, strQueryString, rsBooks, intLoopCount%> <!-- create and open the database connection object --> <%Set connCCOL = Server.CreateObject("ADODB.Connection")%> <%connCCOL.Open "Driver={Microsoft Access Driver (*.mdb)};" & _ "DBQ=("../CCOL2.mdb")%> <!-- create querystring to retrieve books --> <% strQueryString = "SELECT Title, Aut_num, Publisher, ISBN " & _ "FROM Fiction " %> <% Set rsBooks = connCCOL.Execute(strQueryString) %>
View Replies !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
Global.asa Connecting To Database
what I am trying to do it set a logout time on a control panel for those times when a user forgets to hit "logout" button. Based on some examples I have been looking at I have done the following, can I just get your feedback in terms of whether this will work ok? Sub Session_OnEnd Application.Lock Application("visitors")=Application("visitors")-1 logoutcheck Application.UnLock End Sub sub logoutcheck....
View Replies !
View Related
Connecting To Database Puzzle
I have these two line of code Set obj = Server.CreateObject("ADODB.Connection") obj.Open "bmtb" Now I understand that "bmtb" can be a server-side include file and have information including a path to the database. The connection works fine, but for the life of me I can't seem to find the SSI anywhere in the project. By the way this is someone else's project I have become responsible for. where the file could be hidden? It's not under "bmtb". Is it possible bmtb is some kind of ASP keyword? (grasping at straws here).
View Replies !
View Related
Connecting To Access Database Over SSL
I've been setting up an off the shelf access website, in order to install SSL it requires me to copy over some checkout pages to a seperate SSL webserver on another domain. However those scripts need to connect back to the database on the non SSL server to pick up order and customer information. Its a DSN less connection; pDatabaseConnectionString = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" &server.MapPath("iis617domainsddomain.comuserhtdocsfolderd atabasedatabase.mdb")&";" This of course only works for scripts on the same server, is there a way of connecting to a database on another server? does it require a complicated path, or additional files or what not.
View Replies !
View Related
Connecting To Database From 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.
View Replies !
View Related
Connecting Relational Database
i have been thru a couple of books on ASP working with IIS 5.0 but still havent figured out how to connect to a MS Access database. the problem is with the SQL which i dont know well. My database has 6 related tables. It's for inventory control. The 1st table has the catagort the 2nd has the machines per category, the 3rd has machine parts per machine and so on. what I have been trying to do is to view the database for the latest updates per machine (which for now i am updating manually for the time being ) but the code dosent work and i get some errors one of which is " use an updateable qurrey" and others are related to SQl with every modification i make.
View Replies !
View Related
Problems Connecting The Access Database
I am trying to get my asp page to connect to my Access database. The first time I run a page, it loads fine. Every time after that I get the following error: Microsoft JET Database Engine (0x80004005) Could not use ''; file already in use. My code to connect to the database is as follows: Provider=Microsoft.JET.OLEDB.4.0; Data Source=C:Inetpubwwwrootwebdatabase.mdb; JET OLEDBatabase Password=password Set cmdRecordset= Server.CreateObject("ADODB.Command") cmdRecordset.ActiveConnection = strConnection Set rsRecordset = Server.CreateObject("ADODB.Recordset") What am I doing wrong?
View Replies !
View Related
Connecting To An Exclusive Access Database
After many hours trying I've found this to be an impossible task when the database is open by another user or is running as a service on a server.However, if you need to do this I've come up with a method.If you add some code to the exclusive database that exports the data to another database every hour then you can access the data that way. Fair enough, it's not live data but if you do it on the hour every hour then you know when it's been updated.I'm just about to work on the VBA for Access.
View Replies !
View Related
Connecting To SQL 2000 Database In Windows 2003 X64
I'm trying to connect to a SQL 2000 database on my Windows 2003 x64 Enterprise edition server, and so far I've got the error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified My ASP code is straight forward: Code:
View Replies !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
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 !
View Related
|
TRACKER
