Connecting To SQLServer In VB6 (using ADODB) Works Fine Within VB Appliction But Not From ASP Page
I'm have a VB function that connect to SQL SERVER , get's information
and returns the relavant string.
using this function within VB application (say cmdbutton) works great,
but when trying to activate the function from asp page, i'm getting
nothing. Code:
View Replies
ADVERTISEMENT
Below is the generated source for an ASP page that posts a value called 'album' to another ASP page. The other page retrieves the value with Request.Form('album'); On Firefox this works fine every time. On IE6, I always get nothing. I'm pretty sure it's the posting side that is at fault, so that's what I've shown here. Oh, I tried Request.QueryString too and again, fine on Firefox, nothing on IE6....
View Replies
View Related
I have a page which works fine testing locally on my win XP PC, using an access database file. When I place it on the server (all code and database file being the same)... it gives an SQL error :
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2
The SQL statement is as follows: Code:
View Replies
View Related
If an ASP page works locally on your system but doesn't work remotely on the web hosts server and your only alteration to the page before uploading is your connection string to make it point in the right direction on their server then surely the fault has to be the path to the servers database doesn't it?
Or is there another possibility why the page would show up an error page.
View Replies
View Related
My requirement is to run a code snippet (at WebServer) on session start of an ASP.NET application. The problem is that this code snippet has lots of MessageBox.Show() events, which on being hit show an obvious error:
"It is invalid to show a modal dialog or form when the application is not running in UserInteractive mode. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application"
My problem is that I cant change the code, so i need a work around. Is there a way to run the code, by getting by these Message Alerts, which can keep popping at the WebServer end ??
View Replies
View Related
we are developing a system that we want to connect the Command Prompt to an ASP page simultaneously. like that on VB. can it be possible?
View Replies
View Related
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
I am trying to establish a connection in Dreamweaver MX 2004 and an Access database for a log in ASP page, but keep getting an error. I am trying to establish "Custom Connection String" and here's what I type into the boxes that pop up:
1) CONNECTION NAME: ConnectToMyDB (I know, here I can put anything)
2) CONNECTION STING: Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:Documents_and_SettingsJohn_SmithMy_Doc umentsJohnsSitedbJohnsWeb.mdb;
(tried with and without quotes around this)
3) Dreamweaver should connect: Using driver on Testing server
4) When I hit "TEST" I get an error "An unidentified error has occurred"
I am using Windows 2000. The database is in a db folder in the my defined site (moved it there). Is it the path I am typing in Dweaver or my Win2000 settings?
Hope someone can tell me what I am doing wrong. Is it my path to the database?
View Replies
View Related
I have a Response.ContentType = "application/vnd.ms-excel" and I want the output cells to have a 0 in them if there is no other integer in the database.Is this something that I can dictate in my sub ?
View Replies
View Related
We're looking at logging on to SQLServer using Windows Authentication from an ASP app, and trying to figure out what will work.
The following connection string works with Basic Authentication:
driver={SQL
Server};SERVER=MyServer;Database=MyDB;Trusted_Conn ection=yes;
Is there a way to do this with IIS security set to Integrated Windows authentication?This is an existing app where currently each user has a database login. We want to get away from that. Another option would be tocreate a database user for the app, so we may do that.
View Replies
View Related
Can you tell me the code for pagination in asp where the database is Sql Server ?
View Replies
View Related
I am trying to fine tune my XLS report and for some reason I can't wrap my head around why my cells are not where I want them... another head needed for objective please.
Here is a picture of the report that is generated. I need the fields that have formulas to be where the arrow is pointing. I obviously can't figure out why I have too many cells. Code:
View Replies
View Related
i want to convert MS SQL Server 2000 database into MS-Access and Excel.How can i do this using ASP.Is there any possible ways,if any. the solution.If any related URLS also.
View Replies
View Related
I am not sure if this is the correct place to ask this question but it is close...
IN MSAccess I can create a select statment that filters on a calculated field:
SELECT xxx, len(yyy) as zzz FROM TblAAA having (len(yyy) = 5);
I am trying to create the same type of statment in an ASP that uses VBSCRIPT to access a SQL Server table.
I can not seem to figure out what the VBScript version of the Access statmen... or even if it is possible?
View Replies
View Related
I have developed an extranet system, that is not recognizing any named anchors in IE. The top drop down on the page should be jumping the user to each section. It works beautifully in Firefox, but not in IE. Has anyone encountered this before? Any insights?
View Replies
View Related
I am trying to improve the robustness and elegance of my parametized sql
statements in ASP 3.0 as they get passed to the sql server SP.
Could anyone tell me if there are weaknessess in the way I have written the
following code? I have included both the asp code and the sql stored
proceducre to tie things togoether....I appreciate any advice on this. It
basically is a application to manage static news stories on our site by
tracking and organising the meta data in a table. Code:
View Replies
View Related
i would like to get last value entered in an autoincrement field in sqlserver 2000 from asp.
View Replies
View Related
Is there a way to draw charts from SQL Server Data using ASP.? Is itpossible to use the SQL Reporting Services using ASP.
View Replies
View Related
We're moving an asp site onto our fedora redhat server and I am fairly sure that I have installed all the proper modules to get apache to read the site properly, but when I bring the site up in Firefox it displays the actual asp code as text. I would assume this means that something is wrong somewhere along the way, and yet when I display the page in ie the site shows up fine? How could this happen?
Looking at it in firefox displays code and ie displays the site (with some errors, but it still displays)I'm a php/mysql personally so I have no experience with this, but as far as I can tell we have apache-asp support installed properly and the site should be showing up.
View Replies
View Related
I have built a site completely with ASP.I am searching for free web host which works with ASP.give me a list web links of fre asp hosters.and i have used drive letters to access my database, how can i remove those drive letters (ex. "c:m.mdb").
View Replies
View Related
I am trying use the IP works ftp component to send a directory full of files to an ftp server, and all that is in the help for this is the methods with no example code for anything other than how to list a directory which works fine! But when it comes to uploading files I seem to not be having any success.
View Replies
View Related
I am retrieving data from database through asp code.It works fine for IE 6.0 browser.The same code does'nt work for Mozilla Browser.what are the changes that i need to do to make the code work for mozilla browser.
View Replies
View Related
I Finally Got this admin_SubscribedCust_email_processor.asp working so it sends emails to everyone in my database but ONLY WHEN THE EMAIL IS something @homeland.am so within the network... anything else it came with error message.. CDO.Message.1 error '80040213' is this out of my hands, as it is the ipowerweb server related or can i do something to fix this problem and how?? please help asap as i have been working on this problem for a while now and i also have another email admin section on my site that the admin can send emails to the customers on the database manually and it also is the same problem!
View Replies
View Related
CDONTS works with all sites hosted on my test server bar one (which surely
rules out a miscomputation of the Default SMTP server in IIS). I have tried
uploading the file with make up the site in which CDONTS to one of the IIS
"sites" which is known to work with CDONTS, and still, no email received.
The bad mail dir gets three files each time, the error is:
Unable to deliver this message because the follow error was encountered:
"Error is processing file in pickup directory.".
The specific error code was 0xC00402CE.
The solutions offered in various responses I found after a quick search all
assumed that the SMTP service was configured wrong, but how can mine be when
other sites can use the CDONTS/SMTP components fine. Code:
View Replies
View Related
i have a very smal asp programm with mail functionality, which works and i send mail with it! The Problemis when i' use wireless lan in my company i get error. At home, where i have a static IP-Adress it works as i said! I know that it is a question of dynamic IP (in WLAN of my company i get a dynamic IP from the server)....
View Replies
View Related
I'm an ASP beginner and did an application here locally on my IIS under W2000 Prof (SP4). Runs here completely great.
Now I wanted to place this application under a W2003 server online. Now always get the message:
Runtime error in Microsoft VBScript error '800a01a8'
object required: 'Application(...)'
/globalfunctions.asp, LINE 18
Funny, that line 18 in my globalfunctions.asp is empty. However I use the Application()-object in this file and the coputer seem not to find it. I read that it could have to do something with global.asa. I then created a global.asa and created the subs for the events but put no code inside. It changes however absolutely nothing.
What could I have still forgotten and why run it here locally? Possibly a rights problem?
View Replies
View Related
Just to explain what's going on briefly... I've added an include to the top of all files on our site (this code is pasted below) to check IP address, and then some pages will display slightly different content for our Canadian or US customers.
This works fine in Firefox. However, in IE, when a Canadian visitor comes it doesn't display canadian content on the http version of any page. Once they go to a https page, it works just fine. After that, if they go back to an http page it still displays properly. Code:
View Replies
View Related
I am using a GUID in asp e.g
i_GUID=(left(createObject("scriptlet.typelib")).guid,38)
and need to find out how reliable it is and how it generates a unique ID.
an example of the unique ID is {FEE7EECD-2E70-4E95-8EE1-C887B34EBB3E}
can anyone point me in the right direction for documentation on how this is generated.
View Replies
View Related
Can someone please explain to me what server side validation is and how this works, also where do you put this, and in which programming language do you write this. Some examples are also welkom.I've never used this but I want to learn how.
View Replies
View Related
I'm looking for an ASP component that manage USER PROFILE, that works similar to facebook or myspace The features that I would like are: Code:
View Replies
View Related
I have an old ASP web site that runs since 1998 (IIS3, 4,5). It use DataEnviroment stuff . Now on IIS6 after a couple of hours of use this line get in error:
DE.Init(Application("DE"))
Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument
/test.asp, line 25
All the rights, connection, global.asa, dataenvinroment.asa, etc are ok. If you hit after the error F5 maybe it runs ok or maybe it goes still in error After an IISRESET things get better, but after few hours it comes again.
View Replies
View Related
I have the following query:
Update properties set Last_Change=#8-Mar-2006# Where properties.fdref='h3c000';
which works fine when I run it on my desktop under MS Access, but when I run it as an ASP page, I get the following error message:
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
I am using the same database bot online and offline so field names etc are exactly the same.
View Replies
View Related
I have a simple form on a page in my website in which a user can enter
an email address to be added to a mailing list.
The following ASP script works the first time a user submits his or
her email address. However, if the same user tries to submit another
email, the browser hangs and times out. If the user clears the
browser's cache, this script works fine. Could someone please explain
this behaviour and how I can resolve it?
<%
Set myMail=CreateObject("CDO.Message")
myMail.Subject= "MAILING LIST ADDITION"
myMail.From= Request.Form.Item(1)
myMail.To="user@domain.com"
myMail.TextBody= "Please add the following person to the mailing list:
" & VbCrLf & VbCrLf & Request.Form.Item(1)
myMail.Send
set myMail=nothing
Response.Redirect "http://www.domain.com"
%>
View Replies
View Related