im converting my access db to a mysql db.
having issues reading int (true/false) values out of the mysql db.
this is a snippet of the asp script Code:
If rslogin("Master_account") = True Then
Response.Write("master_account=true")
else
Response.Write("master_account=false")
in the access db the master account field was a true/false ( yes/no) field. in mysql its an int filed with a value of 0 or 1. Code:
I want to script real-time data FROM financial Web sites TO an MS Access db.
on a PC (no server issues).
Is this possible?If so what should I use ASP VBScript, ASP.NET VB or something else
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.
Not that much experience working with .asp, but I have managed to create a project.
This project currently has a DB in Access.
I'm moving it over to MySql.
Was able to ODBC import it and all data seems gtg.
Uploaded a test folder, and modified my connection so I can test the MySQL database before I change over. Code:
other then the connection string are there any diffrences when using mysql and not access?
i know mysql has more powerful tools but will the querying and searching and updating be the same syntax in asp?
I don't hv access to install ODBC drivers on the server so trying to use SqlConnection to connect to MySQL but so far no luck.
Been trying:
SqlConnection conn = new SqlConnection(
"Data Source=(66.79.180.140);Database
=testdb;User ID=test;Password=testing");
conn.Open();
And it fails on the conn.Open() call with the exception:
System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
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'.
Not that much experience working with .asp, but I have managed to create a project.
This project currently has a DB in Access.
I'm moving it over to MySql.
Was able to ODBC import it and all data seems gtg.
Uploaded a test folder, and modified my connection so I can test the MySQL database before I change over.
I try running the pages, and have been making changes to the code as I see errors come up.
All was moving forward until now.. where I just keep getting 500 errors, and can't get it to tell me what's wrong.
I use Option Explicit, and all my variables are posted.
Is there any other code I can put into my pages so that it will not just generate a 500 message when there is something wrong?
Or any Software programs I can get which will help me troubleshoot my code for MySQL?
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'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.
View Replies View RelatedI 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:
View Replies View Relatedhaving 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:
The script below does what it i supposed to on a remote server, but when run on my local host, it hangs endlessly. Do I need to do something on my computer to accommodate this ability to create folders?
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
folder = Server.mapPath("images/rentals") & "/" & Request("l_name")
objFSO.CreateFolder(folder)
Set objFSO = Nothing
I am trying to get a database working on my site but I am very New to ASP. what I want to do is if ther is a match in a database to automatically sent a msg to the user to say there is a match.
View Replies View RelatedI've got a freebie hosting mirror of my production personal website
(sounds kinda grandiose, doesn't it?) at http://journeys.webhostme.com/.
At the production website I was using Scripting.FileSystemObject to get
the date that the file was last modified and to read/write a counter
text file for the number of hits that the whole site had. The freebie
has a kind of half-ass*d FileSystemObject, but it has no GetFile method.
Is there any way I can accomplish the same things without using the
FileSystemObject, or by using the crippled one?
This ASP script below is sitting on a Windows 2000 IIS Server Box and the
fldr was pointing to Bradford2 emp which was a Windows 2000 server and
worked great, now I changed the fldr to point to Bradford7 emp which is a
Windows 2003 R2 server. After pointing to Windows 2003 R2 box the
FolderExists(fldr) no longer works. The directory is there and all the
permissions are the same from Bradford2 to Bradford7.
Dim fldr, fso
fldr = "radford7 emp"
Set fso = CreateObject("Scripting.FileSystemObject")
If NOT fso.FolderExists(fldr) Then
' Folder Found
Else
' Folder Not Found
End If
I have a form who's action is an ASP page used to verify the form data. If the data passes, it re-directs to a cgi script. Otherwise, it redirects back to the form page and shows the appropriate error messages. The problem, however, is that the data is lost once it goes thru the validation page. It doesn't get sent on to the cgi script, and it doesn't get sent back to the form page if the data validation fails.
What I need to know is how I can pass the values that were entered on to the cgi script or back to the form page after validation. Or, better yet, how to do the validation on the form page itself, and only proceeding to the cgi script (the form's action) if validation passes.
I have been "hitting the wall with my head" for couple of weeks now, what I need is a way to automatically generate ftp script that will be run when I click the download link on the site that is made using asp technology (not asp.net). How can I do that,can anyone give me some helpfull information ? I am using windows2003 server, with IIS and FTP server set up.
View Replies View RelatedI was reading up on ASP for a report and it talked about scripting languages. It also talked about using VBScript or Javascript as a scripting language? What exaclty is a scripting language and why do you have to use it?
View Replies View RelatedThe following HTML exists on a page in Internet Explorer v6:
<BODY>
<FORM action="x" method="post" name="Form1">
<INPUT type="hidden" name="key" />
<INPUT type="submit" value="Go" />
</FORM>
</BODY>
What would be the correct VBScript or JavaScript syntax to:
A. Set the value of the key field to "ABC"
B. Submit the form to the server
Does anyone know if the ASP scripting technology has a support lifecycle at
Microsoft? Is there any information on if/when ASP as an application platform
will no longer be supported by Microsoft? I have a customer that wants to
know if they stay w/ a mission critical ASP based application, will Microsoft
will still provide support (updates, security patches...) for the ASP
technology it is built on.
I use the RemoteScripting with the rsproxy.class within my asp pages.
I don't have problems except, when the Java console is not active in IE.
Is there a way to detect from asp, if the java console is active or not ?
or, how to do remote scripting without the rsproxy ?
Does anyone know where I can find any good documentation using ActiveX scripting with asp and vbscript? How is ActiveX scripting different than using ADO (ActiveX Data Objects)?
View Replies View RelatedI have a Web application that uses Remote Scripting to provide dynamic data to a web page.I am testing the application in Internet Explorer 6 SP1 running on Windows XP Professional.
When I use the Microsoft JVM,the application works without any problems.However, as a result of future withdrawal of support of the Microsoft JVM as a result of the settlement with Sun, I need to ensure that the application works okay with the Sun Java plug-in for Internet Explorer.
This component is no longer available,and clicking on the OK button only reiterates this message. When I click on the Cancel button instead, the Remote Scripting functionality fails to work.Is it possible for Remote Scripting to be configured to work with an alternative JVM, such as the Sun Java Plug-In, or is it entirely dependent on the Microsoft version?
I have written this code in ASP
Dim oFSO
Dim oTempFolder
Set oFSO = Server.CreateObject("Scripting.FileSystemObject")
Set oTempFolder = oFSO.GetSpecialFolder(TemporaryFolder)
Response.Write "<br>Temporary Folder Name is " & oTempFolder.Name
Response.Write "<br>Temporary Folder Path is " & oTempFolder.Path
It hangs forever on the line
Set oTempFolder = oFSO.GetSpecialFolder(TemporaryFolder)
However it works perfectly if I write the same code in VB Application. Can anybody tells me what's wrong in it.
Anyone can help me to create a Text Formating. AS I want that there is a object. I want to write some text in a textbox on Run time. and it displays on the object and if i want to change his font,size or color.
so tell me how its possible. can i get tha code from anybody or from anysite or anyone plz me to do this in Flash with Action Scripting.
I've some problems with "Scripting.FileSystemObject" object. If I try to create a new text file with the function myfile.CreateTextFile I have two differents result:
If I execute the script client-side there are no problems, but if I execute the script server-side the process stops when I call this function (I think that the process is in loop because I must close iexplore to stop the application).
This page, http://pjshimmer.tripod.com/movies3.html, contains info of my movie collection. I have the title and year in one table cell, as in Lord of the Rings (2001). I intend to put all the info in an Access database, but I would like to have separate fields for Title and Year.
The pseudocode can work like this:
1. Find open parenthesis "(" in field -Table-
2. select everything after "("
3. move the selection to the new field -Year-
I'm trying to use the Scripting.Dictionary. However the item I'm adding to the dictionary is an array. An example is
Set objD = CreateObject("Scripting.Dictionary")
objD.Add "Key1", Array(1,2,3,4,5)
I know for sure the array always has 5 items. In VBScript, I can access the item like this:
objD.item("Key1")(1) to objD.item("Key1")(5)
I would use the Scripting.FileSystemObject to find a file in a server, which
I connect with a VPN connection.
I'm not sure that the Scripting.FileSystemObject works with a folder, which
is in another server, using an ASP page which is on my server.
im trying to make a delete function to delete usernames from my database, for my website but how I do rewrite the line (username) with a blank? Code:
View Replies View Related