oracle9i asp.net connection


what drivers, connection strings and variables do i need to install and specify to connect to Oracle9i database
i am working through the examples from Zak Ruvalcaba's book Build your own ASP.NET website using C# & VB.net. i like this book very much; was able to connect to Access, MSDE and mySql . Now i need to know how to connect to Oracle9i.
Posted On: Friday 26th of October 2012 07:25:08 AM Total Views:  392
View Complete with Replies

RELATED TOPICS OF ASP PROGRAMMING LANGUAGE




oracle9i asp.net connection

what drivers, connection strings and variables do i need to install and specify to connect to Oracle9i database i am working through the examples from Zak Ruvalcaba's book Build your own ASP.NET website using C# & VB.net. i like this book very much; was able to connect to Access, MSDE and mySql . Now i need to know how to connect to Oracle9i.
VIEWS ON THIS POST

119

Posted on:

Wednesday 29th August 2012
View Replies!

Dozens of SQL connections remain open on web server

I have a set of scripts that accesses a SQL2000 database on another server. After several days of investigating an extreme slow-down on my web server I did a netstat-a command and found DOZENS of connections to the SQL server still open. Here's just a small sample of this. TCP sjv-iis:3734 sjv-finance.stjosephsvilla.net:1571 TIME_WAIT TCP sjv-iis:3735 sjv-finance.stjosephsvilla.net:1571 TIME_WAIT TCP sjv-iis:3736 sjv-finance.stjosephsvilla.net:1571 TIME_WAIT TCP sjv-iis:3737 sjv-finance.stjosephsvilla.net:1571 TIME_WAIT TCP sjv-iis:3738 sjv-finance.stjosephsvilla.net:1571 TIME_WAIT TCP sjv-iis:3739 sjv-finance.stjosephsvilla.net:1571 TIME_WAIT TCP sjv-iis:3740 sjv-finance.stjosephsvilla.net:1571 TIME_WAIT TCP sjv-iis:3741 sjv-finance.stjosephsvilla.net:1571 TIME_WAIT I restarted the server just now and opend one of the pages, and suddenly there were 300 SQL connections... 1 PAGE!!! I don't understand how just opening one page could cause 300 seperate connections to the SQL server! I'm not sure why this is happening, at the end of every script is a connection.close statement to close the connection to the server (that is opened at the beginning of the script). If the connection is being closed in the script... why all of these connections still showing up in netstat Is this normal... does the connection just stay in time_wait for a long time even if it is closed in the script... or is there something else wrong. I'm thinking all of these connections is the problem with my web server being slow. I just don't know what to look for. I checked the bottom of every script and each has a connection close statement (conn.close) and a set conn = nothing. Do I need anything else beyond that... does the connection have to close before HTML output is finished Is it not even an ASP problem... any help would be great.
VIEWS ON THIS POST

201

Posted on:

Friday 26th October 2012
View Replies!

DNS less database connection trouble

I'm trying to use a banner ads .asp program called Admentor. My problem is that this uses DNS less connection and I can't get this working on both the pages showing the ads and the admin panel. I know it's the path to the database that causes this. If I change this to suite the webpages showing ads, it work's, and if I modify it to suite the admin panel it work's. But not both at the same time. Should'nt this path be relative to the sites root g_Admentor_strConnect = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="& Server.MapPath("../ads/admentor/ad97.mdb") when using this string, the webpages showing banners is working, but when clicking on these, the site calles a redirect .asp page that also uses this database connection. Then it fails, since this page is located in another folder in the site and therefore also gets another path to the database. How can I get this to be a relative path working on all pages not been worried about folders, subfolders and correct paths to the base \t Best regards Ketil Leinum Norway
VIEWS ON THIS POST

329

Posted on:

Friday 26th October 2012
View Replies!

got problem with connection to access database

... i run asp in my standalone pc, using access2003 as the database, like this: i hv 3 pages, 1st page, i open the database, extract data from database for display(closing the connection using "recordset.close" and "conn.close").... then i have form input for users to input some information...and post to 2nd page 2nd page, this page may load N times depending on the user input in first page...for each time loading, i hv form input for users to input the detailed information. and for 2nd to Nth loading, i will get previous page's form input information(request.form("xxx")), then insert into database ("conn.execute")and close it("conn.close")... last page, this page get Nth loading user input information for the 2nd page, then open database, insert into database("conn.execute") and close it("conn.close")... now the problem is like this...database can not store data correctly: it did not insert N rows into database....maybe N+1 or N+M...randomly...because same data is insert more than once, so some rows are just duplicated...it seemes that the connection just can not be closed and do insertion more than once during each time the 2nd page is loading or during the last page is loading... can anyone help me to find out the problem any suggestion
VIEWS ON THIS POST

264

Posted on:

Friday 26th October 2012
View Replies!

ASP SQL connection error

Hi im connecting to a sql server with asp but im getting the following error: Login failed for user 'academicoper'. Reason: Not associated with a trusted SQL Server connection my connection string is: adodb_conexiona.Open "DRIVER={SQL Server};SERVER=192.168.1.39;DATABASE=Academico;UID =academicoper;PWD=password" i check the security tab in the enterprise manager and authentication is set to Sql server and windows Any ideas
VIEWS ON THIS POST

144

Posted on:

Friday 26th October 2012
View Replies!

need help whit database connection

hi i have 2 problem and here they are: 1. i have a sign up page it work good when i try it it write the information in the database but if i rewrite the same thing it rewrite it in the database.i need a script that if the name already existe it cannot be recreated 2.i want to have a log on page but i dont know how to make the page got verify in the database for the username and password. i need the script for when they login to go get the info about the caracter but i need the script to make the user to stay connected like for there score in the game to be saved in there account. so this is it, if you don't uderstand just specify what you don't understand by the way my page is in asp and my database is in acess have a nice day, Max
VIEWS ON THIS POST

234

Posted on:

Friday 26th October 2012
View Replies!

Trouble with databse connection

I don't know what I'm doing wroung in my connection to my database. I keep geting this error. Microsoft OLE DB Provider for ODBC Driverserror '80004005'[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /login/login.asp, line 14 Can soom one help me with this problem. Code: strConnect = "Driver={driver}; Database=[db]; UID=[username]; PWD=[password]" strUserName = TRIM(REQUEST("username")) strPassword = TRIM(REQUEST("password")) strUser = "" SET Conn = SERVER.CREATEOBJECT("ADODB.Connection") Conn.open strConnect Set RS = SERVER.CREATEOBJECT("ADODB.Recordset") strSQL = "SELECT * FROM login " strSQL = strSQL & " WHERE username = '" & strUserName & "' " strSQL = strSQL & " AND password = '" & strPassword & "' " RS.OPEN strSQL, Conn
VIEWS ON THIS POST

186

Posted on:

Friday 26th October 2012
View Replies!

Urgent help - totally weird, works locally but not online? 'not a connection issue!'

I am having a real problem. Look at the code below, basically it allows me to add a time out of 30 mins and also notes the user who logged in and the time and date they logged in so ideally I must keep this, but for some reason outside of local host (local server) and live it does not work. Below is my code: 'SELECT A CASE 'Call the case when required throughout the code Select Case action Case "Login" Call adminLogin() Case "Logout" Call adminLogout() Case "Add" Call addArticle() Case "Amend" Call amendArticle() Case "Delete" Call deleteArticle() Case "Delete" Call deleteArticles() End Select 'ADMIN LOGIN 'Perform the login operation using SQL & Validation IF statements Sub adminLogin() 'Open Connection Object Response.Write (openConnection) Set objRS = Server.CreateObject("ADODB.Recordset") If Request.Form("Submit") = "Login" then strSQL = "SELECT * FROM tblAdmin WHERE adminUsername='" & Request.Form("username") & "'" objRS.Open strSQL, strConnect If objRS.EOF then strFailed="Your Username is Invalid!" Else If objRS("adminPassword") Request.Form("password") then strFailed="Your Password is Invalid!" Else Session("ValidUser") = "true" 'Additional data input 'This basically add the details for the last time the user logged into the system 'It also sets the session timout to 30 minutes from the time the user actually logged in. Session("ADID") = objRS("adminID") objConn.Execute("UPDATE tblAdmin SET adminLastLogged=now() WHERE adminID=" & Session("ADID")) Session.Timeout = 30 '30 = Minutes 'end of addition Response.Redirect "cms.asp" objRS.Close End If End If End If End Sub The login is just one of my select! but nevertheless there is an issue here I am not sure of. The error I get returned is as follows: HTTP: 500 - Internal Server Error So the login does not work due to this issue, there is no data connection problem, and if i coment out the areas related it works fine. But like I said I really need this! But not sure how to fix this problem. CAN anyone spot a problem that might happen when online and not locally, as locally it works fine. Kindest regards
VIEWS ON THIS POST

255

Posted on:

Friday 26th October 2012
View Replies!

connection, possible variable area?

Alright i'm trying to open the table, which is determined by a querystring variable console and from there I'm trying to select the field game which isn't a variable and I'm trying to choose the name of the field by the specified title which is also a query string variable Code: Set rsconsole = Server.CreateObject("ADODB.Recordset") rsconsole.open ""' & console & '" WHERE game Like "' & title & '"", gameconn, 3, 3 rsconsole("cheats")=rsconsole("cheats")+1 rsconsole.update
VIEWS ON THIS POST

218

Posted on:

Friday 26th October 2012
View Replies!

connection string not working

I'm pretty new at asp and am having problems connecting to my Access database. I've tried writing the string several ways and all get the same error: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. /search.asp, line 8 this is the relevant part of my code: I would appreciate any help anyone can offer me!!!
VIEWS ON THIS POST

188

Posted on:

Friday 26th October 2012
View Replies!

Checking for DB connection error

I have a basic ADO connectiion like this: strConn = "DSN=myDSN;uid=myUID;pwd=myPWD" Set oConn = Server.CreateObject("ADODB.Connection") oConn.ConnectionString = strConn oConn.Open I want to check for connection errors and if there is one, I want to print a message. How can I do this
VIEWS ON THIS POST

234

Posted on:

Friday 26th October 2012
View Replies!

ASP MYSQL ADODB.Recordset.1 error '800a0e7d' Invalid connection

I'm trying to connect to a MYSQL db using ASP and recieve the following error (response.write strSql included): Code: (SELECT * FROM tableFolio ORDER BY Id ASC;) ADODB.Recordset.1 error '800a0e7d' Invalid connection. /portfolio.asp, line 83 code (line 83 in red): Code:
VIEWS ON THIS POST

252

Posted on:

Friday 26th October 2012
View Replies!

(Urgent) Help me with database connection with acess in ASP? Code given. Thank You

Can someone please help me with this ASp script What i am tryiong to do Trying to connect to access database Is DSN set Yes Operationg System XP Prof DSN Name NW
VIEWS ON THIS POST

226

Posted on:

Friday 26th October 2012
View Replies!

Syntax and DB connection problem

Hi all, I'm trying to authinticate users and force a login using an Access DB and an include in all secured pages. I'm using a script from 4fromrolla.com however I can't get the connection string right, I've been having a go for about 3 days now and I just can't get it right. My path is d:\ftproot\shiv\data\ship-ahoy\captains_log.mdb and the table used for the user and password field is tableValidUsers the field names are as per the example. Could anyone please point me in the right direction,
VIEWS ON THIS POST

275

Posted on:

Friday 26th October 2012
View Replies!

connection query is asp

I am trying to change a connection in a script I am trying to understand from an Access Database located in the same folder as the file to a SQL 2000 connection. Can anyone tell me where I'm going wrong
VIEWS ON THIS POST

215

Posted on:

Friday 26th October 2012
View Replies!

ODBC connection problems...

I'm having problems getting my ASP form to have it's drop down list populate from an Access databse. Here is the ADO for the connection: It keeps erroring out on line 5: conncar.open "parking" My ODBC datasource is named parking. I set it up through administrative tools/ODBC data source/System DNS tab and connected the correct database to it with the Microsoft access driver. Am I missing something to connect to the db
VIEWS ON THIS POST

282

Posted on:

Friday 26th October 2012
View Replies!

This code right?(ADO connection)

Code: I this right I keep trying, but I keep getting 500 internal server errors. Please help.
VIEWS ON THIS POST

179

Posted on:

Friday 26th October 2012
View Replies!

Syntax and DB connection problem - Page 2

Try this Code:
VIEWS ON THIS POST

247

Posted on:

Friday 26th October 2012
View Replies!

Table list from an ADODB connection

Fellow ASPers,I have been struggling with this all day. I want to retrieve a collection of all the tables in an Access database. I want to do it without knowing the table names ahead of time. I have found mention of the "Database.TableDefs collection" that is the replacement for "Database.ListTables"But, I can't seem to figure out how to do it. MSDN has examples of it utilizining VBasice. but I can't find any ASP reference.I am running on Windows 2000 Server and Access 2000.There are two major reasons why I need this ability. The real important one is to determine if a table exists so I can use the correct "insert into..." SQL statement.Hopefully someone knows about this topic
VIEWS ON THIS POST

141

Posted on:

Friday 26th October 2012
View Replies!

database connection

, I have uploaded my database to my server, and now i am trying to connect to the database, but coming up with this error http://www.thephoenixgroupuk.com/selfdrive_hire1.asp
VIEWS ON THIS POST

240

Posted on:

Friday 26th October 2012
View Replies!