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 RepliesTheres a script that bypasses ODBC and connects directly to .mdb database for asp scripts , is anyone familiar with this? I dont even know if its a .asp script.
View Replies View RelatedThe example I am working from uses the following code which does not work:
RDS.Connect = "Provider='sqloledb';Integrated Security='SSPI';Initial
So I tried the following, but still no go. Code:
The example I am working from uses the following code which does not work:
RDS.Connect = "Provider='sqloledb';Integrated Security='SSPI';Initial
Code:
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?
I am getting:
Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: ''
/theborg/includes/dbconnect.asp, line 4
I can't figure it out. It worked fine while testing in access. Though there is no data in the SQL database yet. But when I try to populate the data I get the same result
dbconnect.asp:
Code:
<%
Dim objConn
objConn = Server.CreateObject("ADODB.CONNECTION")
objConn.Open "DSN=Assimalation"
%>
Homepage.asp
Code:
i have file and database on remote server, and i want to connect via DSN. i make DSN over there. and when call that dsn in code. it gives null user error.
if i pass user id and password with dsn it connect other wise error occurs
if i have a DSN then why i should pass it again.
how can i solve it.
I got read a lot of attachment about how to connect ASP to SQL server but i still got problem about it. either i use which ways(there are 2 ways connect it)... it always has this error.
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
May I know what is it mean? how to solve it
I have uploaded a *.mdb to a remote server. ive setup a dns there for the mdb, ive done a test on the mdb on the remote server- all is ok. But when i try to connect to the dns/mdb via the dreamweaver interface, i get this error message:
http://www.britanniacabinets.com/error.gif
I have an existing web app on a remote server that I want to manage as a web project on my local box with Visual InterDev. But when I create a new project in VID and connect to the web server, I cannot connect to the existing web app.
At the "Specify your web" dialog box I choose "connect to existing web on server" but the only option that shows up is <root web>. I cannot overwrite this option with the name of the web I want to connect to
I can see this web application in the IIS Manager on the remote server and it is configured as a web application. It accessible in a browser. Why won't it show up in Visual InterDEV?
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.
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:
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?
My asp application is connect to oracle database. However, when i try to open the default page, an error occurs and i receive this message:
- Error Type:
Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'MoveFirst'
The code that is causing this error is following:
Code:
<%
Dim objConn
Dim rsForums
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "dsn=ORCL9; uid=toy; pwd=yes;"
Set rsForums = Server.CreateObject("ADODB.Recordset")
rsForums = objConn.Execute ("SELECT * FROM Forums ORDER BY Forum ASC")
rsForums.MoveFirst
%>
<table width="100%" align="center" cellspacing="0" cellpadding="6" border="1">
<tr>
<td width="60%">
<p><b>Forums</b>
</tr>
<%
While Not rsForums.EOF
%>
<tr>
<td><a href="forum.asp?ForumID=<%= rsForums("ForumID") %>"><B><%= rsForums("Forum") %></B></a>
<BR>
<BLOCKQUOTE>
<%= rsForums ("Description")%><BR>
<SMALL>[Total Posts: <%= rsForums("Posts") %>] [Last Post on <%= rsForums("LastPost") %>]</SMALL>
</BLOCKQUOTE>
</tr>
<%
rsForums.MoveNext
Wend
rsForums.Close
The forums table in the oracle database has 2 lines of records, and it should not occur this error. Do you have any idea what is happenning?
I'm trying to create a connect string, but I might have a unique situtation. When connecting to Query Analyzer, I connect using RUNAS specifying domain and username. Is it possible to create a connect string given the above requirements? Here's what I'm trying to use:
<%
Set demoConn = Server.CreateObject("ADODB.Connection")
demoPath="DRIVER={SQL Server};" & _
"SERVER=myserver;UID=username;" & _
"PWD=pw;DATABASE=qdb"
demoConn.open demoPath
%>
I am trying to connect to my access DB. I am developing my site in Dreanweaver and I have the site hosted already. I want to use the hosts server as my testing server.
When I create a connection string to the DB I have to use the servers directories. ex: e:/hshome/site/something.mdb When I try to add a server behavior to a form it can't find the DB. What am I doing wrong ?
I am running a website on anintranet on one domain and trying to connect to a SQL database that is in another domain. The server that is running the website does not have SQL Server installed on it. I've looked at many different variations to set this up but none have been successful so far.
View Replies View Relatedi have 2 database server...........
i have a pages that need to get data from 2 server.......
so, i open connection when want to get data.....
but this page, i need to get data from 4 table in server1 and 3 table from server2......
table in server1 have relationship with table server2.....
so, i always open connection to server1 and get data..then close.....then open connection to server2 and close........
I have an access database that I need to put online for basic viewing. However, the database is also used by other people for updating and report printing. The web server and the access database are on two seperate servers. I cannot connect directly to the database cause if somebody has it open, the website will not work and for some reason I cannot connect to to database across servers. I tried a linked database, but asp will not recognise it.
I know that I could put all the reports and stuff online, but I have till next week
and I do not think that I can do it in this short a time. Any ideas will be helpful and if there is code that I need to manipulate I could try to do it. And also I do not have rights to configure the IIS option on the servers.
I'm having a hard time figuring out what type of database is used and where the file is located and how the script is even acessing it. From what I've done in the past with ASP a file was always used that had a DSN, username, and password.how this code is access the database without a username/password/DSN? I've tried using the login info in the line that is commented out (line 2) but it wouldn't let me in so I guess this isn't being used.
Code:
Set objDbConn = Server.CreateObject("ADODB.Connection")
'objDbConn.Open "driver={SQL Server};server=db1.host.com;database=databasename;uid=login;pwd=password;"
objDbConn.Open application.contents("strconn")
Set rsQuery = Server.CreateObject("ADODB.Recordset")
rsQuery.ActiveConnection = objDbConn
rsQuery.open "sp_MajorList"
Set rsetQuery = Server.CreateObject("ADODB.Recordset")
rsetQuery.ActiveConnection = objDbConn
i want to connect an ASP page to a dbf file(dbase III), but so far i have failed..., i found an example on internet and i tried to changed it to ajust my needs... this is the code:
View Replies View RelatedI have just installed PWS on my Win98 SE machine. Even though i change my internet connections to "Never dial a connection" it still tries to connect when i try to view my asp pages.
Presumably there is some simple option i need to change which will allow me to run my scripts without connecting to the internet.
I have seen 2 techniques to connect to database and was wondering which one is the best (i.e put less pressue on the database and time wise)
set getRecords = Server.CreateObject("ADODB.Recordset")
getRecords.ActiveConnection = mlConn
getRecords.Source = "SELECT * FROM myDB"
getRecords.CursorType = 1
getRecords.LockType = 3
getRecords.Open()
----OR----
set getRecords = mlConn.Execute("SELECT * FROM myDB")