Database Connection MS SQL Server
Im creating my first asp website and am wondering if asp (JS) works well with a MS SQL server. If so how do I connect to it.
View Complete Forum Thread with Replies
Related Forum Messages:
Database Connection String To MySQL-database On A Different Server
I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!! Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.
View Replies !
Connection From ASP To SQL Server
I have two servers: Webserver(WebServer) and Database server(DBServer). In Webserver, i asp to connect to sqlserver in dbserver. but i can not connect it, it show error "No Trust Connection" but the save connection string, when i used it in VB, it is ok. Also i can connect from webserver to dbserver by using Analy Query, it is ok "How to connect it". below is my asp code: <% set cnt=server.createobject("adodb.connection") cnt.open "Provider=SQLOLEDB.1;Data Source=Dbserver;Initial Catalog=MyDB;Uid=dbadmin;pwd=root"
View Replies !
SQL Server Connection
I'm using microsoft SQL server 2000 to create the database for my project.Below is the connection that connect to the SQL server :- set cn = Server.CreateObject("ADODB.connection") cn.Open = "Provider=SQLOLEDB;" & _ "server=SPCH2O;" &_ "Data Source=(Local);" & _ "Database=SPJRK;" & _ "User ID=guest;" & _ "Password=;" But there is an error that i don't understand why i failed to connect to the server.
View Replies !
Connection To SQL Server
I am having a problem connecting to my SQL Server with the following ASP set cn = server.createobject("adodb.connection") cn.connectionstring = "Provider=sqloledb; data source=midatlanticus; Integrated Security=SSPI" cn.open But, if I use the same connection string in a VB program, I connect successfully. The VB code that works successfully is as follows: Code:
View Replies !
SQL Server Connection
i have my sql server 2000 installed properly on the server. everything goes fine yersterday..i can create new database, tables and so on. but i couldn't connect to it since this morning. it keep on prompting the msg" cannot connect to the sql server because of incorrect logon " <something like this> in fact, i never set any passwod in order to connect to the sql server.
View Replies !
Database Connection
I am familiar with connecting asp pages to sql server when both servers are on a LAN. Can anyone advise on how to connect when the servers are remote from each other?
View Replies !
Database Connection
I was wondering if i can create an if/else statement that checks if my connection string that opens a database ie: cnnDB.Open Application.Contents.Item("CONNECTION_STRING" ) (the actuall connection string is in my global.asa file incase u were wondering) ...or if the database can't be found or opened, will run some other code... like a message? hope u get what i mean. this is just incase a user has the DB opened, or is in the process of overiting the DB or something, the page would not display that Microsoft JET Database Engineerror but display a message i set up in the if/else statement.
View Replies !
Database Connection
I have created a database called "myshop.mdb" Then I create a System DSN connected to that database called "OE1" The following code retrieves attributes and possible errors from the DSN Code:
View Replies !
Database Connection.
I have been trying to get an intranet search page to work that looks at an Access database. The database is called database.mdb, and lives in the root of the site, as does the .asp (security is not a problem at the moment). The code was taken from an asp website. I am running .net and Windows server 2000. Could someone look at the code and tell me if it looks OK for connecting to the database? Then at least I can rule out code as the problem I am having.(receiving error codes)
View Replies !
Database Connection
I am getting this error at all my ASP pages. A sample page which pulls the categories from the Northwind database is enclosed below where I get the error when I am trying to open a recordset with that SQL query and Connection. Code:
View Replies !
Database Connection Over LAN
I would be glad of some help being new to ASP. I manage my department information through an Access relational database and an http network model database. Naturally enough I want to combine them. We have an old NT driven LAN with pc's running Win 9x or XP pro. The file server is nearly up to capacity on storage and bandwidth, the new XP machines have plenty. The network is backed up daily. If possible I want to use the XP m/c as a web server. I want to use IIS and ASP from an XP m/c to read and write to databases on the file server but can't seem to get the connection string right, I have tried many, with and without DSN's. Having checked up on IIS (installed on XP pro) I suspect that it can only connect locally. Certainly everything runs on a test setup in C:/inetpub/wwwroot which can be accessed across the LAN and ASP runs fine.
View Replies !
Database Connection
i want to open a connection for password protected database but i don't want to write password in code as it can be seen by my host provider and misused is there any way I can read database password without writing it in my code. Set cN = Server.CreateObject ("ADODB.Connection") cN.Open "DRIVER={Microsoft Access Driver (*.mdb)}; password=joy; DBQ=" & Server.MapPath("db1.mdb") above example works fine but i dont want to write password in my code is there any way i can do it.
View Replies !
Database Connection
Is there any good reason why this shouldn't work?! All I get is the word "venue" and it doesn't display the relevent field value beside it. Set cn = Server.CreateObject("ADODB.Connection" ) strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("db/db1.mdb" ) cn.open strConn strSQL2 = "SELECT * from Events where ID = " & intEventID Set rs = cn.execute(strSQL2) response.write "venue" & rs("Venue" ) response.end
View Replies !
Database Connection
I have one database, but nine web sites all linking to this database for client input.hen I use the domain web site that the database is atored under, the ASP page updates the database as required. I have been using the following connection: "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:domainsmyweb site domain namedbmy database.mdb" Now I have saved this ASP page under one of my other domain names and have tried using an ODBC connection as follows: "DSN=ODBC Connection;Driver={Microsoft Access Driver (*.mdb)};Dbq=my web site database domaindbmy database.mdb;Uid=Admin;Pwd=;" Unfortunately when I complete the ASP page on this web site, and submit, the database is not being updated with the records.
View Replies !
Database Connection
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. 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 .
View Replies !
Database Connection
set rs=server.createobject("ADODB.recordset") sql ="SELECT company_name FROM contacts WHERE company_name =" & cStr(sField) If Len(sql)> 0 Then rs.open sql,conn,3,3 sql is defined above and conn is defined in another asp page. What I am wondering is what does the ,3,3 do? and Is it necessary to have this in the page?
View Replies !
Database Connection
i have built an Intranet using includes, which is about all the access of the IIS server I have. I really want to have database functionality so that I can use an Access database - but cannot and will not be able to use ASP to connect to it how I can do this without using ASP? Client-Side, or something similar? Or any other way..? All I have to play with is a standard business-wide build of IE, and a very limited IIS server.
View Replies !
Database Connection
Is it possible to connect to a database that sits on a webserver using a script that sits on a local machine ? If so, would the connection string look something like this : sConnString="PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & Server.MapPath("http://www.blah.cm/casinonewsxml.mdb") The reason I ask, is because I have a vbscript that uses windows scheduling service to run at different stages during the day to update a database on a live server. I was wondering if it was possible to put this script on a local machine and make changes to the connection string.
View Replies !
Broken Connection With Server
I am designing a site for a friend using dreamweaver and unfortunately my link has gone down to my test server. I use dreamweaver to generate most of my asp but since I can;t do this with a broken connection I wondered if anyone would be kind enough to help me with a very simple bit of code. I simply need an asp page. That reads the first record in a db (db.mdb). the record has two fields ID (whish is 1) and news (a memo field). This memo field then needs can then be updated via a simple html form. Essentially its just a page that allows the user to update the memo field in the first record of the database.
View Replies !
Server Can't Open Connection
I have a site on 1and1. The site has a simple login as well as other asp applications. This site uses an access DB. Last week all the scripts that accessed any database resulted in this error: Code:
View Replies !
Connection To SQL Server Express
I recently moved to Visual Web Developer Express. I need to create a simple page that connects to my Database.mdf and runs a stored procedure. I have tried a million times but i simply cannot create a connection. I need to create an ADODB connection as i need control over the CONNECTION TIMEOUT and the COMMANDTIMEOUT properties. I'm using the following string: Data Source=.SQLEXPRESS;AttachDbFileName=e:dataCusto mers.mdf;Integrated Security=True;User Instance=True
View Replies !
ODBC Connection To SQL Server
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 Is that the problem of my Sql server ?
View Replies !
Open Connection To Another Server
I would like to connect to another server and execute my query from my asp page. But how can I initiate the connection string to another server DB? For example Code: ConnString = "dsn=abc;uid=xyz;pwd=123" What will be the way to issue the connection string to another server? Using SQL Server 2000.
View Replies !
SQL Server Connection String
I ALWAYS forget this cause we ALWAYS turn our db connections into COM components. That said... I need one for this project . Here's my base Access one: DBPath ="C:datastoresmediacd.mdb" Set Con = Server.CreateObject( "ADODB.Connection" ) Con.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & DBPath I just don't quite remember the SQL Server variation.
View Replies !
Multiple Database Connection
I am trying to connect to two different database(Oracle and Access) in my ASP page. I keeps getting the following error message Error Type: Provider (0x80004005) Unspecified error What would be the best way to do the multiple database connection?
View Replies !
Database Connection With Acess In ASP?
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 <%set cnn = server.createobject("ADODB.Connection") cnn.open "DSN=NW"%> <% cnn.close set cnn= nothing %>
View Replies !
Multi Database Connection
I have written a asp application whihc uses a number of pages and each page connects to a sql database. Currently I have the connection script coded on each page however if i need to change the database I have to change every page. I have been told there is a way to have the connection on one page and each page to referance this one so I only need to change the one page
View Replies !
Database Connection Problem
I am trying to connect to a database in a folder called 'db' the database name is games.mdb . The File that is trying to open the database is called data.asp. This file is in a folder in a subdirectory of the parent directory of 'db'. The code seems to work up to here (it does not give me any errors): objRS.Open "names", objConn, adOpenForwardOnly, adLockReadOnly, adCmdTable At this line it gives me this message: error '80004005' /data.asp, line 24 All I am trying to do is open the names table and print out the Names in the table. Here is my code. Code:
View Replies !
Problem With Database Connection
I have 3 pages in my current setup: Login: Page for user to login Index: Page where user is directed to Test A test page The login oage works fine which directs the user to the index page. However the test page is a copy of the index page and when i link the 2 pages together i get the following error: Error Type: ADODB.Field (0x80020009) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
View Replies !
Access Database Connection
I am passing 3 hidden fields to another page using the method="post" Here is the next page - <% Dim fmMemberID, fmUsername, fmPassword fmMemberID = request.Form("memberID") fmUsername = request.Form("username") fmPassword = request.Form("password") %> <% Dim dbConn set dbConn = Server.CreateObject("ADODB.Connection") dbConn.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:inetpubcredencia.netfpdbmembers.mdb" dbConn.Open Dim rsMember Set rsMember = Server.CreateObject("ADODB.Recordset") rsMember.Open "SELECT * FROM Members WHERE MemberID=179", dbConn, %>
View Replies !
Database Connection Error
I have an unusual problem and am stuck trying to solve it. My code worked fine last week and hasnt been altered since. I now get the following error: Microsoft JET Database Engine error '80004005' Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt. /Cs_Jobs.asp, line 41 The code i am using to acces the DB is: Code:
View Replies !
Database Connection Question
Should I close the sessions I want open on every page or just the ones that are exclusive to that page? Like for the user session which I want on every page. Should I just leave it open?
View Replies !
Database Connection Error
My database is on another disk partition. When I try to run the following code to make a connection to my DB. I get an error message. "server.mappath must use a virtual path, physical path has been used" How can I fix it? strDataPath = server.MapPath("T:databaseTest.mdb") strConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;"_ + " Data Source= " & strDataPath & ";"_ + " Mode=Share Deny None;User Id=admin;PASSWORD=;"
View Replies !
Database Connection Problem
I'm using Win XP..and MS office XP & ASP. A database connection error occur during the compilation..the error looks like this: Microsoft OLEDB Provider for ODBC Drivers [Microsoft ODBC Microsoft Access Driver]General error unable to open registry key 'Temporary (volatile) Jet DSN for process 0x604 Thread 0xb2c DBc 0x132ofcJet
View Replies !
Connection To Access Database
I've got a question about connecting to a access database. I would like to "convert" the following code:Code: <% ' FileName="Connection_odbc_conn_dsn.htm" ' Type="ADO" ' HTTP="false" ' Catalog="" ' Schema="" ' MM_Test_STRING = "dsn=xxxx;uid=xxx;pwd=xx;" MM_Test_STRING = "dsn=robertjandb;" %> to code where a connection is being made without dsn. Could anybody help me?
View Replies !
Bypassing A Database Connection
I have a bit of code which executes an SQL statement.on my webpage. If the execution fails i do not want a standard error coming up that asp normally shows - instead i would like something like if (cnn.execute) = failed Then 'Do This End If
View Replies !
Slow ASP-SQL Database Connection
My ASP pages have very slow connections with SQL Server database, although eventually it will reach the page and get the results. The SQL Server database and IIS are in the same machine, I have no idea why it will cause the problem. I just put this connection string as SSI: strConnect="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MYDATABASE;Data Source=MYCOMPUTER"
View Replies !
Database Connection Method
what is more efficient, opening the database once in the beginning of the page then closing it at the end of the page, or opening the db connection each time you need it. for example: i have a page that executes 50 queries. is it better to open the db, execute the queries, then close it, or to open and close the db 50 times?
View Replies !
Verifying A Database Connection
I have a particular application that I want to verify if my database connection is available and, if so, display an appropriate message. Pretty simple I think but I can't seam to figure it out how to do it. I though maybe a simple "IF... THEN... ELSE..." maybe, such as IF my_database_connection is up_and_available THEN write "The Database is available" ELSE write "The Database is NOT available" END IF Does anyone know exactly what I need to write in order to do this? In case you need to know I'm connecting to a MS Access database.
View Replies !
Connection To Remote Database
Is there a way of making a connection to a database on a remote server? The intention is not to hack, but I have a customer who would like to perform a search in several identical databases on different web servers (with the owners permission) and show the result on the customers own web page. Could this be done? Of course there must be some level of security, the db owners will if necessary give permissions to our customer.
View Replies !
|
TRACKER
