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.
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:
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 ....
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 a db table with 3 rows (ID, date, points). How can I in my script tell that ID 1=Mike and ID 2=Thomas and ID 3=William without making a new field in my table?
I am trying to connect to remote mySQL db and getting "Data source name not found and no default driver specified" My connection string looks like this -
Conn.Open "Driver={mySQL ODBC 2.50 Driver}; Server=Station1; Port=3306; Option=4; Database=cds; Uid=andy" Is there anything wrong with it? I can't figure it out
how to fetch values from a specific record from access in asp.and how to compare data entered in a form with data in record and if comparison returns true then how to open desired page.
I have a form that submits the information to a SQL database. The form has a two radiobuttons name="Cheese" with value="yes" OR value="no" and then collects contact info.
The form submits to the SQL DB and I want to create a display page that will show the form and sort the form based on the name="Cheese" yes or no.
All yes values will display form info under the yes column.
All no values will display form info under the no column.
So there are two columns displaying the information based the results of the SQL row name=Cheese. How do I connect to the DB and "sort" the info based on this value and dynamically show this information on my site? Code:
I have just purchased my domain name, and subscribed to a hosting service that supports ASP. I tried to copy my asp files over to my new domain, and I get the following error:
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.
The line that is referenced is:
MyConnection.Open DSNName
..here is the code I've been using on DomainDLX (free) to connect to the database ...
I am using a DSN connection created using Dreamweaver and an ASP page. The connection works fine on the local computer (i click the "test" button) but when I upload the files to my server I get the following error:
"Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/mkoenig/survey.asp, line 120
and the line that it is referring to:
MM_editCmd.ActiveConnection = MM_editConnection
my editConnection is set to QUERY which is a DSN variable pointing to the database on my hdd?
is there a way i can map or find out the driver that the server i am on is using? and what is a 500 internal error of here is another question. i just upgraded to an NT server, i want to use ASP and databases etc,, what info do i need from my host to get this done?
Im using abyss web sever to run asp. Now Ive downloaded a specialst software called activehtml which will help run asp- my questions are not based upon this but are far simpler.
Im using frontpage to code asp and trying to connect a access database to it. Both the web server and database are on my laptop. My questions are as follows:
1) As the access database is on my laptop i.e. in a folder, how do I connect it to the asp page that I am coding? I do realise some sort of code such as Code:
I have downloaded the DiscIDCalc program from CDDB. I've used it a lot because I've written my own application for my CD collections (keeping track of the track information of each CD, track duration etc). I've already got all my CDs into the application, I'm now just going through each of the disc again just to add in the DiscID information. I do it by running the DiscIDCalc program, generating the DiscID, and then then copying and pasting this DiscID into my application and then save it. if anyone has successfully generated the DiscID within an asp page? Now I have to have my browser up and this DiscIDCalc program up. Just want to know if there's a way to incorporate the two together (even if it means I'm not using the DiscIDCalc anymore.). This DiscIDCalc has a documentation for its DiscIDCalcDLL.dll but it's not something that I can CreateObject with, so I'm quite clueless... I don't want to use VB to write APIs for that
I use query string to search for records by using GET method. This method will generate querystring automatically by using the form name. Using search field together with drop down is fine but the problem is when i didn't enter any keyword or left the search field blank it won't display any result.
Unless I put "%" in the search field. How do I make the querystring change to "%" whenever the field is blank so that all records will be displayed.
Microsoft OLE DB Provider for SQL Server (0x80004005) [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. The Code I have used is Dim cnDB ' As ADODB.Connection Set cnDB = Server.CreateObject("ADODB.Connection") cnDB.ConnectionString = _ "Provider=SQLOLEDB;" _ & "Data Source=ENTERPRISE;" _ & "Initial Catalog=SchQry;" _ & "User ID=3453;" _ & "Password=aw33;" cnDB.Open
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,"",""")
I know absolutely nothing about connecting Access databases. However, I know a tad bit of VB.NET (my site is written in ASP, though). I need some help connecting to the DB. Here's the script I'm currently using (I removed the database, account name and site name for security): Code:
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
In our office we use RMS (Residential Management System) and they use an MSSQL database to store all the data. we can access this database using access and have made several...several queries to pull out info, save it to another access database, then upload it to the web and pull data from it.
the server that houses the MSSQL database is online and i was wondering if it is possible to connect to it and pull out information. we wouldnt want to change anything, just view.
Im using dream weaver to connect to my database. I hav e made my connection successfully, added my recordset succesfully....however when i insert my dynamic text.....
I've created a MySQL database and i'm trying to connect to it to retrieve data using MyODBC and ASP.. I tested it on IIS 5.0 but it keeps saying that it couldn't connect to the database..
I have got a scenario where an asp script needs to request via xmlhttp a file sitting on the same server. The code all works find on my local machine. However, on the hosting server, it does not. The problem is that I am on a shared server and the server can't "see itself", i.e. it's probably blocked by the host to receive request from itself. The problems comes in as the server will hold multiple sites and use host headers to channel request. I thought of using "localhost" and some kind of header sending scenario to get the server to go to the correct subfolder/virtual host. However, googling has not brought up much.
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
I'm using VB with ASP and need to access a database, was going to use Access or Oracle access more then likely. I don't know how to do this does anyone have a simple example?
I'm having some issues with a dll I've created to return an ADOConnection back to an ASP script. I successfully open my object:
mytest = Server.CreateObject("mydll.database") I then attempt to use the connection: myConnection = mytest.getConnection
This is where the script breaks down with an "Object required" error. I am able to access other methods in the dll, it just doesn't seem to be returning the database connnection successfully.
