I'm trying to integrate amfPHP on IIS 5 and searching ways to communicate with Microsoft SQL Server 7. I can't find any documentation documentation about this issue, so I'm wondering if there r some fokes with any experience and/or with any form of documentation..
View RepliesI am trying to find more information on "Integrating XML and relational databases such as Oracle".I found articles that show the heavy process of entire mapping process like this one :-
http://www.rpbourret.com/xml/XMLAndDatabases.htm
I also found lighter articles like the one where it shows how easy it is to write XML from a database. After filling up the dataset, use its method to write to a XML document. I am confused - which one to use and Why? can someone could explain what does it mean and its benefits.
i need to edit Word-documents that are on a remote server and still be able to save them on the same remote server.Usually the computer downloads a copy of the Word file on the local harddisc, and after you have edited it, it will also be saved on your local computer.Is it possible to direct edit and save Word-documents on a remote server?
View Replies View RelatedI have a problem of integrating an SDK with my ASP code. AS such i am working on a mortgage site in ASP and my client wants that the forms filled up online should be transferred to the software residing on client side now i have got the API regarding the software how would i be able to integrate it in my asp code.
View Replies View RelatedI just started playing around with WebDAV. The basic configuration is done
and works. For example I am able to open a document via HTTP from within
Word and save it.
What I am really looking for is a way to integrate WebDAV into an ASP
application. Initially I tought, that if WebDAV is enabled, a link such as
http://server/app/test.doc would automatically open the document as a WebDAV
document. However, this is not so. The document is opened in Word inside the
browser (as without WebDAV), but it cannot be saved remotely.
So question is: can an ASP application make a document be opened as a WebDAV
document?
I am trying to load a dropdown select on an HTML form with the user's current selection based on previous user input that they put into a database. I am trying to use JavaScript to have the user's choice selected when the page loads. Here is my javascript function:
(Assume the database connection code is already in place and functional)
<script language = "Javascript">
function chosen(dropdown){
combobox.option.selected = '<%=rs.fields("State")%>';
return true;
}
</script>
I want 2 know whether a JAVA applet & asp can be integrated?
Ok, here's the example scenario:-
I make an applet in JAVA which is a login form. Now when I click the login button, I should be able 2 login given that I m using asp & ms-access at backend.
is it possible? I know it can be done with JSP and Servlet at backend but how about in asp?
Im running a select statement to a database and wish to display the relevant records into a table. For some reason, its not liking this - can someone see why, and or tell me an easier way to produce an 'automatically generating' table of results.
<% @language="vbscript" %>
<% Option Explicit %>
<% Response.Buffer=True %>
<html>
<head>
<title>Search Results</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<!-- #include file="dbConn.asp" -->
<!-- #include file="adovbs.inc"-->
<h1>Your search results returned the following popup messages:</h1>
<% Dim msgtype, title, message, url
msgtype=request.form("type")
title=request.form("title")
message=request.form("msg")
url=request.form("URL")
Dim adoDB, adors, strSQL
set adoDB = Server.CreateObject("ADODB.Connection")
adoDB.Open strConnection
set adoRS = Server.CreateObject("ADODB.RecordSet")
strSQL="SELECT PID,P_TITLE,P_MSG,P_URL,P_TYPE FROM POPUP WHERE ("
If msgtype <> "" then
strSQL=strSQL & "P_TYPE='" & msgtype & "' "
If title <> "" then
strSQL=strSQL & "OR P_TITLE LIKE '%" & title & "%' "
If message <> "" then
strSQL=strSQL & "OR P_MSG LIKE '%" & message & "%' "
If url <> "" then
strSQL=strSQL & "OR P_URL LIKE '%" & url & "%' "
End if
strSQL=strSQL & ")"
'DEBUG ONLY!!
'response.write strSQL
'response.end
adoRS.Open strSQL, adoDB
' Loop through the recordset to display the records
Do While Not adoRS.EOF
& " <tr> " &
& " <td> " & Response.Write adoRS.Fields("PID").Value & " </td> "
& " <td> " & Response.Write adoRS.Fields("P_TYPE").Value & " </td>"
& " <td> " & Response.Write adoRS.Fields("P_TITLE").Value & "</td>"
& " <td> " & Response.Write adoRS.Fields("P_MSG").Value & "</td>"
& " <td> " & Response.Write adoRS.Fields("P_URL").Value & "</td></tr>"
adoRS.MoveNext
Loop
& " </table> " &
' Tidy up afterwards
adoRS.Close
Set adoRS = Nothing
adoDB.Close
Set adoDB = Nothing
%>
</body>
</html>
in all the books and tutorials i have seen it says that you have to specify a Provider like "Microsoft .Jet.OLEDB.3.51;"
but if i have already created the ODBC connection on my server in administrative tools, ODBC, then isn't there a way that i could just tell ASP which ODBC DSN to use and it could get the provider information from there?
i have an asp application im trying to copy from one server to another, and the application has no reference to a username or password to a database - can this info be stored in the DSN itself?
the only reference i have is
Application ("Application_DB") = "foo"
I take it foo is the DSN.
How can I "connect" and run queries on an ODBC DSN without ADO?
View Replies View RelatedIm using IIS 5.1 web server on Windows XP on my local computer, I am using the following connection string:
<%
DIM objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Student.mdb")
%>
Now what is it im actually using? is it odbc, or ole db provider for odbc? If im using the 1st method, how do i get a provider, or does it come with IIS 5.0? if so how do i know what the provider is and how do i connect to it?
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Got error 127 from storage engine
/koun/MA_Report.asp, line 67
i have this error when i run my coding.......
On executing the following code , I am getting the error:
Quote:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '<'.
/Airtel2/outgoing/operator/Circle/newc.asp, line 75
Code:
Code:
Sql_Insert="INSERT INTO Customer(devices,handset_id,cust_name,address,mobi le,email,Gender,locid,otherBrand,otherModel,fax,cu st_connection,landlineno,cust_connecting,alt_mobil e,company_name,os,simno,priority,UsingInternet,tra ns_date,Trans_Type,Trans_UserID,InsertedByArea) "&_
"VALUES
I move my db (microsoft access) to network drive. Then i
create new ODBC but it doesnt work. it shows this error
"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides."
but should I do. Is there any configuratiojn setting to be done at the folder?
Despite trying the codes given, I am still not getting it right!
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xf14 Thread 0x4a4 DBC 0x10bbfcc Jet'.
/sanbookshop/searchtest.asp, line 22
Microsoft ODBC Driver 2.573 to retrieve Oracle Data, it is slow. How to tune this?
View Replies View RelatedI am trying to grab some data from odbc (sage) in my asp page I have the following code
<%
dim sSQL
Set Conn = Server.CreateObject("ADODB.Connection")
Set rst = Server.CreateObject("ADODB.RecordSet")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open dsn="Test", "DTest", "help"
it gets an error on line 5 -Data source name not found and no default driver specified. I have a odbc dsn set up pointing to the correct drives etc and the odbc drivers installed.
Can I connect to a desktop SQL from my ASP application via ODBC? We have a web-based product using SQL; we want to collaborate with a developer of a PC desktop application (using Access). Can I access their PC-based db via ODBC somehow?
View Replies View RelatedI am working with Dreamweaver MX, IIS, and MS Access. All I am doing is testing another person's instructions and making sure they work for me. Everything was working fine until I load the dynamic pages and get the following error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.
/admin/editnews.asp, line 8
This same error is happening with another file. I checked the other person's code and they match. So it must be something on the ODBC side. Here are the lines it is referring to (from two different file): Code:
What is the meaning of this error?
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Incentive ODBC Driver]Incentive ODBC driver operation terminated. An error occurred Security Administration initialization. Code:
I'm getting Internal Server Error in one of my pages. The server's error log says: ODBC driver does not support the requested properties. there was recently a hosting change but there is no way to find out the configuration of the previous hosting. The current hosting is on win server 2003-IIS , mssql 2000.
My connection string is
Application("ConnString") = "Driver={SQL Server};Server=*****;UID=*****;Password=*****;Database=*****"
After some tries in isolating the code that causes the error i believe that the error occures when this:
Server.CreateObject ("ADODB.Command") is executed.
I have had an ODBC link between Access and Oracle at work for some time now which has worked without problem. The other day, one of our technicians came to change the name of my machine. Despite my best efforts, I could not keep him off my machine and sure enough, my ODBC linking to Oracle is now incredibly slow.
I've tried deleting the Microsoft Oracle ODBC DSN, but to no avail. I know this is the inetserver.asp group but the only results for a machine name change came up.
in this group, I am presuming the principal is the same. Can anyone tell me the full procedure to re-establish my working link?
I'm trying to update data to a mysql db, and this is the error that I get
Microsoft OLE DB Provider for ODBC Driverserror '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. /systemnotes/updatenota.asp, line 116
I don't know if in this part of the code is te problem
objNotas.Open SQL, DBConn, 1, 3
i got weird problem i cant figure out with my db connection
this is the way i had before i changed things :
i had folder named secure where the ntfs rights wer thus.
administrator - Full Rights
GOWadmin - Full Rights
Everyone - Read Only
in this folder i have all my admin pages including my DB
and this works fine no problem there
now i changed things to this.
NTFS rights on the folder
administrator - Full Rights
Everyone - Full Rights
IUSR_(IIS user ) - Full rights
With these changes all my delete record pages wont delete the records it given it gives me this error Code:
Anyone know how to establish an ODBC connection
using .asp?
I am struck with an error , please visit this url and lemme know what might be the cause of this error.
I am basically connecting to a remote mysql server via asp.
Code:
http://mcatva.com/testing/conn2.asp
We have an asp script on an NT system that is trying to access a
database on an XP server. When it gets to setting up odbc, it gives an
error on that line in a particular function but doesn't give details.
I can map the network drive by providing username, but I can't use the
odbc to access the info. Any ideas? I set up security to make sure
that I can access it.
I used following line to connect DB and get following ODBC driver issue
oConn.Open "UID=user1;PWD=abcd;DRIVER={Microsoft ODBC for Oracle};SERVER=server1;"
Error message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
I am using a piece of code to check for the existence of a username - password combination
within an Access DB, for a LogIn feature on my web page. Although this code appears to work fine on Windows 98, i keep getting the 'Too Few Paramaters' Error when i try running it on Windows XP.
Will Show you the code:
I have an intranet site that uses basic authentication to allow users to view and update information from an Oracle DB (ver 8.1.6 -- ancient, I know). Anyway, the site worked fine as long as the machine accessing the ASP page was running Win 2k but when an XP machine tried to view the page, the client got an error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Oracle][ODBC][Ora]ORA-12640: Authentication adapter initilization
failed
I tried googling the error and ran across a post that suggested using the Microsoft ODBC driver for Oracle rather than the Oracle ODBC driver. I made the change and things are working fine now. I guess my question is why did this happen? If it was really an ODBC driver problem it would seem to have occured regardless or the OS of the requesting machine. (After all, this is requested through HTTP)
I recieve the following error
Microsoft[odbc driver manager] data source name not found and no default driver specified
my code is as follows and works fine in excel . I have a user dsn set up called Sage and a system dsn called sage so don't think thats the problem
any help will be well appreciated
Dim sSQL
dim conn,rst
Set Conn = Server.CreateObject("ADODB.Connection")
Set rst = Server.CreateObject("ADODB.RecordSet")
//get error on next line
Conn.Open dsn="Sage", "TestUser", "correctpassword"
I am using WIN XP, IIS 5.1 and MS Access as database support. I set up the file security to include IUSR_MYNAME on the permissions list for all my web files, DB and scripts.
I set up and ODBC connection (system) and linked it to my Access database file.
I am however getting the same error when I try to load any ASP page on the line where I command the script to open the connection. Are there any local security issues I am forgetting?
Set conn= Server.Createobject("ADODB.Recordset")
Conn.Open "MyAlias"
that's where I get the error.
"Error type:
Provider(0x80004005)
Unspecified Error"