I've got a query that works fine when used in mySQL but completely fails
when I try to apply it to MS Access, weird thing is that it is just a copy
of a stored procedure that works fine in the same copy (with the
Request.QueryString replaced by a fixed value) ! Any explaination would be
great, ID is a number BTW :
SELECT page_title,ID,page_content FROM content WHERE ID='" &
Request.QueryString("ID") & "' '
Had a look at aspfaq.com but couldn't find anything that applys.
I have a Fedora Core 4 server with cPanel which is my master server shall I say. And 2 days ago, cPanel did an update which brutally murdered my MySQL 4.0.25 on the system, so I was forced to upgrade to 4.1.18. So we did that, and all is working now...
Now, my business has satelite servers that revolve around the master server. It allows people to remotely start and stop services on those satelites, and it uses ASP to remotely connect from the satelite, to the MySQL database on the master server to retrieve information regarding the users.
So yesterday, after the upgrade, my satelites seemingly connect to the MySQL server (it does not give an error), but it does not perform a correct query, thus no users on the network can start or stop their services. It just says "Invalid user or server". Now, the MySQL connection is working, because I have other software that authenticates thru the Master Server MySQL database that is working perfectly... I just think it is something wrong with the code on this Activ Serv... I had the program custom written about 2 years ago..
I have tried upgrading the MyODBC driver from 3.51.10 to 3.51.12 and that did nothing to help.
I have the entire code which is right here. Of course it uses a executable on the server to start/stop services and collect process ID information. But the queries are not working correctly so the executable never even runs... Code:
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?
Ok so after ironing the bumps out of connecting to my MySQL database in ASP, I now want to run a query. So far it's working perfectly, BUT, it only returns with one result. Code:
My code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.
I'm getting an error when I'm retreaving from a "text field" in the database and it has no data in it. I'm using MYSQL version 3.23.58-nt. I have the same script running a different system and I don't get this error. It justs output nothing and continues with the loop.
This has to be an ASP problem when retrieving data from the database. I've change the Field for Message to "varchar(252)" vice "text" in the database and stoped giving me error. But I still need to use the type "text" in the database since my "Message" will be longer then 252 caracter. Code:
According to �Beginning Active Server Pages 3.0� from Wrox, Data Source Names �are a largely outdated method of specifying connection details, mainly because they use ODBC drivers instead of OLE-DB providers to handle the data. We include them here only because you may come across DSNs when working with legacy systems.�
Which is better: using ODBC with a mySql database or not using ODBC with this type of database?
Also, based on the model below, how do you create a connection to a mySql database (using myODBC and not using myODBC)? Please note that I will be testing the database on my PC but it will also be used on a website. Code:
I have my site hosted with uplinkearth.com which supports MySQL; they say: "We have set up your MySQL database for you." (i.e. it is ready for me to work on it). My site is a classifieds page that is small(not much code at all) but gets a lot of traffic and I want to switch from Access to MySQL.
I know that some conventions are different, but on a more general note, what is the process of conversion? I have someone who will be working with the ASP code, I just need to know the basic procedure, i.e. how do I make changes to my database, etc. How will it be different than working with Access? I've heard "MySQL Front" is a good program to edit the DB.
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'.
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)
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.
I have ASP project uses Access DB .. I need to convert the site into Mysql. But I keep getting some Runtime Error ( Mismatch ) and I don't know what the problem .. Code:
having issues submitting dates to a mysql db, ive converted the database from access to mysql and im having issues submitting dates. this is what i have when submitting to access Code:
What is this all about? Generally I run against SQL Server but now I have to use access. The query I want to run is a simple double join
SELECT tblArtists.*,tblGenres.name AS genreName,tblPages.pageId FROM (tblArtists INNER JOIN tblGenres ON tblArtists.genreId = tblGenres.genreId) LEFT JOIN tblPages ON tblArtists.artistId = tblPages.artistId ORDER BY surName ASC, firstName ASC
Now If I run this question in access against the database it accurateley returns two posts. BUT When I paste the same query into an asp document and runs it with a fileDSN against the same database it returns nothing!? Is this some kind of joke from Microsoft?
I'm trying to run an access query with one parameter that is a string. I can call a query that has no parameters. I can also call a query that has one parameter that is an integer. But the one that has a string parameter isn't working.
I've tried using a command object and it did the same thing. Is there any other way I can get my query to return the records. Running it in access works.
I have a Acces query which creates a table using manipulated data from another table. I want my asp page to run this query after doing an update to the database.
Is it possible to write an SQL statement that reads from an Access Query instead of an Access Table. If so is the syntax the same as for reading a Table.
I have a field called store, I have more than 1 row with the same store name in the store field.
I need to coolect all the stores from the store field, remove any duplicates, like I might have buy.com twice and only need it to show once in the drop down. And sort ascending (by store name).
Summary. Database is called: tracker The table (and the only table) is called merchants I only want to pull data from the field store, remove duplicate store names, sort ascending.
I can figure out how to plug the required htm around the asp code, to auto populate the drop down.
I am trying to query an Access database using the like operation; however, when I test the query in the browser all records from the database are displayed. Here is my code:
I'm attempting to limit a query which is being ordered by a date field to 10 records. The date field contains duplicate values, which are sorted from most recent, back. However their suggestion of sorting by a secondary field is not providing acceptable results (it returns all the rows in the database). Does anyone have any suggestions of another way around this?
What is the best way to create new queries and/or modify existing tables within an online access database. At the moment, I am periodically downloading the db and making alterations. But, I have heard others on the list say they use a query analayzer built on a <form> where they execute SQL statements. Is this the correct way to go?
