While I know within visual studio express 2005 it's easy enough to test and connect to SQL Express 2005 database's I ask can standard ASP connect to this also? I will be attempting from localhost IIS as obviously visual stuido does not host ASP sites.
View RepliesI recently moved to Visual Web Developer Express. I need to create a simple page that connects to my Database.mdf and runs a stored procedure. I have tried a million times but i simply cannot create a connection. I need to create an ADODB connection as i need control over the CONNECTION TIMEOUT and the COMMANDTIMEOUT properties.
I'm using the following string:
Data Source=.SQLEXPRESS;AttachDbFileName=e:dataCusto mers.mdf;Integrated Security=True;User Instance=True
I have a reg exp pattern as below works fine for the string : <param name="url" value="contents/cf_intro.htm" valuetype="ref">
mObjRegExp.pattern="<param.+?value=""([^""]+)""
But the same is not working for
<param name="url" valuetype="ref" value="../fmmain/fmindex.htm"
note that, i want to capture the url that comes after value=". if the value=" comes in the second place in the html tag it works. but if it comes in the 3rd position, then it doesn't work.
I am using the following to try to connect to the database, but it does not seem to be working.
Dim sConnString
sConnString = "Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=MediaDB;Data Source=MEDIAMACHINESQLEXPRESS"
Connection.Open sConnString
Dim Recordset
Set Recordset=Server.CreateObject("ADODB.Recordset")
Can someone tell me the correct syntax? The original syntax (which worked) for an Access DB was as follows:
sConnString="PROVIDER=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" &
Server.MapPath("/Music/DB/MediaDB.mdb")
How may I make Visual Web Developer 2005 Express as editor/debugger in place
of Visual InterDEV for ASP and HTML pages?
I'm working on XP IIS5.1 in classic ASP 3.0. After the installation of the 2005 Express Suite and the beta .net2 framework that ships with it(http://lab.msdn.microsoft.com/express/vwd/) the debugging with classic ASP has an odd behaviour.
I use option explicit on all pages. When the parser finds an undeclared var or function or there is some error in a stored procedure (not in the ASP page but in the SP itself)
I receive no error reporting. The page simply renders till that point and stops.
All the other errors are reported as usual.
1.
conn.ConnectionTimeout = 60
conn.Open connString
2.
conn.Open connString
conn.ConnectionTimeout = 60
Do both of them give different?
Is there anyway I can get the information about a file on the local machine of a user that is reading pages from my web site? Scripting.FileSystemObject does not have permission to do this, and I want to check the size of a file before I try to get it uploaded.
View Replies View RelatedAn application runs on server, and is used for Hour-registration. Now I want to run the application local, I use SQL Server 2005, and managed to fix connection changes.
But now, I get this error everytime I run the application:
Microsoft VBScript runtime error
Error Code :0x800A01CA
Error source :
Error Description :Variable uses an Automation type not supported in VBScript
Any solution please?
The webserver I'm using (which I can't make any changes to) has a
Dutch-localsettings. When doing simple calculations the decimal-symbol in
ASP is a , (komma). Is it possible to force IIS to use a . as decimal symbol
by code? (IIS5)
I would like to evaluate some shopping cart software to use on my next project. I am new to asp and as yet my hosting does not support it. Before I go ahead and upgrade my hosting I wanted to see how the various packages work.
I am running XP Pro SP2 and have installed IIS. The folders seem to be where they should be and I have access to the settings through the Administrative Tools.
When I put a htm file in the wwwroot folder it loads fine if I type http://localhost but the asp files are either downloaded or opened in dreamweaver.
Do I need to do something special to enable asp files to open on my local machine??
I'm not a networking/IT guy, but I was put in charge of figuring out how to use ASP to tap into an Oracle db for my office. I am using a windows 2000 laptop, and I want to be able to run ASP code on my local desktop (without being plugged into a network).
I need a lot of help here. I know I have to turn my computer into a webserver, but I'm not certain what I need to do with the IIS. What do I need to do in general to make my computer a webserver? In addition, I will be using a local Oracle database. So I wasn't sure what I would need to do to make that db available for querying with ASP. What is the best way to make that connection?
Anyone who can point me to useful documentation.
I am running this code on my local IIS and everything works fine. The code detects the file I select using the INPUT TYPE=FILE. The problem is that when I move this code up to my host’s web server, it never works as in it never finds the file. It is the exact same code so why is it working on my local IIS but not on the web server? It is ASP code.
Code:
set fso = createobject("Scripting.FileSystemObject")
If fso.FileExists (strValue) then
'File exists continue with code
Else
Response.Redirect("aspError.asp")
End if
I need to setup my home computer to view ASP files like I veiw PHP files through Apache2Triad or some other similar installer package.
I'm using Windows XP Home,is this possible?
I am trying to set up an internet page on our intranet that contains logoff/shutdown and restart buttons.This needs to work in a remote desktop situation which rules out various options.
Next stage is to call this .exe from a webpage...which I'm struggling with. My test code (to test a reboot) is below but doesn't seem to work. Can anyone help remembering this needs .exe needs to run on the local machine and not the server.
I have a computer running Windows XP home edition and i would like to have a local web server for testing my classic asp pages.
View Replies View RelatedHow do I execute a users program from a web page? When a user goes to a webpage - I want a link on that page that will execute a program on the users local hard drive - like say...notepad.exe . Everything I have tried will only execute it on the server.
View Replies View Relatedhave an SQL DB which clients access via asp pages through the internet, in the case of a power outage I need to write that data automatically in the background to a txt file on their local machine, I would imagine it would involve a script of some kind.
View Replies View Relatedis anybody know how to capture lan id(localhost id ) address in lan. u can check the same under dos using command ipconfig. but i am not geting the same id using bewlo code
<% Response.Write Request.ServerVariables("REMOTE_ADDR") %>
how to get TimeZoneId for Local TimeZone.
View Replies View Relatedi'd like to know if it is possible with asp to launch a local application (exe file like word or any else).
View Replies View RelatedI am wondering if their is a strategy or tool for syncing a local
database with a web-based database? Specifically I have an application
where orders are entered via a web form and the data emailed to my
client who processes the orders. I extract the order information and
update a local "order tracking" database. There are several order
processing steps.
I want to update a web database to reflect the status
of the order as it flows through the local tracking application. I will
send an email to the "orderer" at the major steps, but my client wants
to have a web-based report shows the status of all orders for a company
that has pending orders. In other words a company will enter multiple
orders and will be able to track the status of the orders by signing on
to the web site.
This status report gets its data from the
web-database.....which I must update from the local tracking database.
A pretty long winded explation which I hope mades sense. Has anyone
found a solution to this problem? Any reference or tools you can
suggest?
I'd like to create a series of variables created dynamically, example such
as this...
For i = 1 to 5
TheVariable & i = "blah"
Next
This would during the first loop create a variable called 'TheVariable1'
with a value of 'blah'. Is this possible as so far I'm getting syntax
errors?
1. I need to convert the local-time of the server on which I run my website
to UTC and I don't want to rely on the server local time and timezone (i.e.
I don't want to hardcode the timezone information), is there a generic way
to do this?
2. Is there a general for converting time between timezones in ASP?
Am I now setup to view .asp on my local machine, or do I have to "upload" the pages to IIS? If the latter, how do I do this?
View Replies View RelatedHow do I allow users to browse their local machine and upload a file to the server? I'm looking for the pop up window that allows the user to search for a file in their local machine. Also, once the file is in the server and the user needs to delete it, how do I do that?
View Replies View RelatedI have been teaching myself ASP for several months now and seem to have a pretty good handle on it. All along, I have been uploading changed files directly to the website and refreshing to test.
However, today I will be at a location with no internet access and would still like to be able to work and test my programming. How do I go about testing ASP pages on my local computer without an internet connection?
For now I am not worried about testing any databases or anything, just layout and design.
If it is useful, I am running Windows XP Home edition and I use Dreamweaver to write the ASP.
I made a image upload a while ago, but too many people submits too large images (this is no problem, since ASP Upload won't upload too large images) but people gets frustrated when their images are not uploaded!I want to do so that you can't submit the form if the pictures are too large. I was thinking of doing a asp functions to check the file size and then pass the result to a javascript function, which will then alert the user and denie him to submit the images.I know how to do the javascript part, but I don't know how to check a local file's size with asp? I'd appreciate if someone could help me! Thanks.
View Replies View RelatedI copied one of our websites to a CD and wanted to run the website off of the CD. However, it won't run the index.asp on Windows XP machine. Do I need to install some dll's or something?
View Replies View RelatedWhat is the best way to set up a server with MSSQL on your local machine. I have IIS set up, and am wondering if there is some way to get MSSQL for testing purposes for a reduced cost? From what I understand, a typical MSSQL license is around $8,000, am I right
View Replies View RelatedI took over an ASP site and am having trouble uploading pics through the user interface. I get the following message:
Microsoft VBScript runtime error '800a01ad'
ActiveX component can't create object: 'SoftArtisans.FileUp'
/admin/UPLImage.asp, line 15
The line refered to by the message states:
upl.Path = "d:htmlusersusernamewebsite.comImagespages"
i am developing an intranet area where my boss says he wants the logon to be related to the local accounts,if no local account exist then they will be refused access, i am a little lost with this.
View Replies View RelatedI am using Windows XP Pro, and since I updated to Internet Explorer 7 I am having problems getting web sites to work on my PC in Internet Explorer using the local IIS web server. These web sites are using ASP and Access databases.
The two errors I get are:
Operation must use an updateable query or Cannot modify the design of table 'TABLE_NAME'. It is in a read-only database.
Does anyone know how I can get this working so I can test my web sites locally before uploading them to the live sites?