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 Complete Forum Thread with Replies
Related Forum Messages:
Request.Form(var) Empty With IE, Works Fine With Firefox.
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 !
Asp/access Sql Page Works In Xp But Not In Server 2000?
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 !
Need To Run A Code,which Pops Messagebox.show(),on SessionStart Of ASP.NET Appliction
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 !
Connecting .asp Page To MySQL
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 !
Error Connecting Access Db To Dreamweaver (ASP Page)
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 !
Fine Tuning My Response
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 !
SQLServer Login
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 !
Creating An XLS Report...fine Tuning
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 !
Access SQL To SQLServer / VBscript SQL
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 !
Fine-tune/improve Parametized Query In Asp?
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 !
Asp Site Works
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 !
Web Servers Works With ASP
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 !
IP Works FTP Component
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 !
Code Works
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 !
Mail Only Works When Its Within My Own Domain Name?
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 !
CDONTS Works Intermitantly
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 !
Send Email Works But Not In Wlan
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 !
Script Works On W2000, But Not On W2003?
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 !
Code Works On IE Https But Not Http?
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 !
How Server Side Validation Works
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 !
DE.Init On IIS6 Works Intermittently
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 !
Update Query Works In Access, Not In ASP
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 !
ASP CDO Mail Only Works When Browser Cache Is Cleared
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 !
MSXML2.ServerXMLHTTP Works Only With Text Files?
I'm trying to remotely get a pdf file - http://remoteServer/file.pdf - in order to store it into another server, maybe with Scripting.FileSystemObject However the following code doesn't work properly: ------------ url = "http://remoteServer/file.pdf" set xmlhttp = CreateObject("MSXML2.ServerXMLHTTP") xmlhttp.open "GET", url, false xmlhttp.send "" ------------ as xmlhttp.responseText does not contain the whole file textStream, but only a part of it.
View Replies !
LDAP Query Works On Localhost But Not Other Web Server
I am using classic asp and making a connection to LDAP server using SQL code under IIS 5 on my localhost and it works great. I have a form and form fields that pull from active directory. Now, once I get the web team to deploy these files to the webserver where all users will be able to run this app.(this server is using IIS 6), my form fields show up blank. For the life of me I cannot see what is wrong or different except the IIS version. Also, I have gotten the IIS logs and they don't tell me anything. Code:
View Replies !
Client-side Validation Works, But Form Still Submits...
I've got a form that is activated by an external .asp page. I've finally got the validation of the form working, the javascript alert pops-up and correctly identifies the mistakes, but when I click OK on the js pop-up, the form submits and I get a data mismatch error. I can't seem to figure out how to get the form to wait for the right data... Code:
View Replies !
ADSI - Trying To Enable A User - The User Add Works Very Well
I have written an ASP.NET 2.0 application that uses Active Directory or ADAM to manage account users - the site has a page that allows people to create an account (much like any site). The page populates the AD with all the information and the user account but I am unable to enable the account. Microsoft has information on how to do that here --> http://msdn.microsoft.com/library/d...ting_a_user.asp (the sample is for Visual Basic) - and I am unable to complete the bottom portion of the script. Can some one point me in the right direction - or can you tell me how I can add a snippet of VBscript code to an ASP.NET page. I am using the Active DS Type library - not sure why there are multiple ones (System.DirectoryServices) but it is rather confusing - I seem to accomplish one thing with one and another with the other (they did have trouble co-existing however). Anyway my script works very well but I am not able to access the properties required to enable the account. Here is a simple version (no error checking) of the code.....
View Replies !
Connecting Name To ID
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?
View Replies !
Connecting To Db
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
View Replies !
Connecting Asp
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.
View Replies !
Connecting To SQL DB
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:
View Replies !
Connecting To DB
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 ...
View Replies !
Connecting To DB Using DW
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?
View Replies !
Connecting > Anyone
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?
View Replies !
Connecting Db To Asp
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:
View Replies !
Connecting ASP To SQL Server
I don't know why I am getting this Error 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
View Replies !
Connecting To The Database...
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,"",""") Can you please help me set it up?
View Replies !
Connecting To An Access DB
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:
View Replies !
Connecting To Database.
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 Is the part in blue correct? If not tell me how
View Replies !
|
TRACKER
