I 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.
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"
I have problem on data connection to a SQL Server by Asp Statement. It's Very strange that my asp statement can connect to one remote SQL server but can't connect to other remote SQL server. The statement written like this :
Set DBLBX=Server.CreateObject("ADODB.Connection") DBLBX.Open "DSN=DBWEB;UID=opn;PWD=opn;"
It show the follows:
Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
In IIS 5, there's seem to be no ODBC loading under the log file format dropdown option. SO if i want to use ODBC enable database connection to store session data how shall i proceed? ODBC connection to store session data able to reduce data traffic on web server?
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?
Im 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?
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
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?
I 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:
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?
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.
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 currently have a Ms Access database stored at c:databasedb.mdb.how do i use Asp to connect to the database? how to access the database with and without using odbc.
I turn on the ODBC tracing from ODBC administrator and default the location to c:/sql.log. Then I run an asp and retrieve some data from Oracle via MS ODBC 2.5. I could not see any information logged to the file.
I have a data-driven website that allows users to enter records for sales leads. It all works perfectly. The only thing I want to do right now is prohibit users from entering the same lead twice.
I have a PK field in the MS Access database that, obviously, disallows duplicate records. However, when such an attempt is made, the browser redirects to some generic ODBC error page with some cryptic numbers and other information that will stymie the users. "It doesn't work", they will say. The text of that error indicates that they tried to add a record that violates the PK rule of disallowing duplicate records. But they probably won't read it and it's truly ugly anyway.
How can I redirect to a custom error page or trap the error before the ODBC error page is displayed and just display a msgbox or something telling the user they attempted to add a record that already exists?
