what is the best way to connection table.. i have a site that has alot of table connection. so.. i use that to connection
set rs = server.createObject("adodb.recordSet")
rssql = "select * from table where id=1"
rs.open rssql, database, 1, 3
is this the best way for performance ?
Is there any way to attain the names of the tables in a database from using
either ADO connection or ODBC or any other type of connection.
The reason I wish to do this is so that I can display all the information in
table (field names and values - this piece of code works) from a dynamic
SQL statement.
Here is what I am trying to do:
<%
Connect to my_table.
%>
<select>
<%
For each Table in My_table
response.write "option value='" & table.name& "'>" & table.name & "</option>
Next
%>
</select>
Is this possible?
I have an access database residing on one server that contains necessary data for this application, have sql database that also contains necessary data and resides on another server.
For two access databases I would just "link" the tables and be done with it, but when attempting to do this with ODBC connection to the SQL server I get
Microsoft JET Database Engine error '80004005'
ODBC--connection to 'databasename' failed. Code:
I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open
startdate=request("tarikh1")
enddate=request("tarikh2")
MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....
I am trying to display the content of a Table called
'Order Detail' directly from the database (e.g., Northwind.mdb). I have the following commands:
Set tableSet = Server.CreateObject("ADODB.Recordset")
tableSet.Open table_name, DB_name, adOpenForwardOnly, _
adLockOptimistic, adCmdTable
where, table_name = ''Order Detail" Or
table_name = 'Order Detail' Or different variations.
I always get error on the second command with the following message:
Syntax error in query. Incomplete query clause
which I believe because of space in the Table Name. How can I resolve this issue? (working with file or table name with space)?
1.
conn.ConnectionTimeout = 60
conn.Open connString
2.
conn.Open connString
conn.ConnectionTimeout = 60
Do both of them give different?
I have a table with many txt boxes which i have inside a form with a submit button to an update page which adds all the details to a db. The problem is i have a another table inside the first e.g. table 2. i want to be able to update table2 by clicking a second submit button that would update it. Is it possible to have a form within a form or how can i do it??
Also i need to update the entire table in one go. For exampple if i have 3 records in table2 i want to be able to update them all by clicking the one update button. Code:
I have the following code but this is inserting manually. I want to make a query from table 1 and automatically enter the records into table 2. What needs to be modified? Code:
View Replies View RelatedHave an app which dynamically creates table rows depending on records, these can be several hundred (don't ask). Hence a very long page at time. Each row includes a hyper link to a new page, and a link back to the original page.
Is there any method (maybe via js) where on leaving the second page l can redirect the browser to the table row the end user clicked on? Hence the bookmarking. Can do this via Visual Basic on the desktop app, but can't work it out on the web app.
I have a table produced with names across the top and services down the left hand side with boxes for numbers for people who recieve services then the info is written into a table in an access db. That works fine and here is that code:
View Replies View RelatedI have two tables. Table A has 20,000 records, Table B has 2,000 records. Table A is what needs to be updated from the data in Table B. Only some fields will be updated and of course, only some records - both tables have the same field as a ClientID so matching up records should be easy.
Anyways, been a while since I have used ASP to work on things like this but would like to work through this one. I understand the process I believe, it is just how to make it go on to the next record once it has finished updating the first.
Basically, I was thinking of having it set up to reaad the top record from Table B, update applicable data in Table A. Delete that record in Table B. Move on to the next.
I wanted to know wheather DSN is ok for the connection to a database or direct conection is better?
when i started my web project on dreamweaver i had to make a DSN connection as i have followed the books, but as now as i have also asked several questions on this site, i have aslo implemented a direct connection as well on some pages, now i am wondering
is this going to have any affects when i uplode the complete site on the server.
i have noticed that on my computer when i am testing the site and uploading new records on sections that have DSN connections you can see the new record but on sections that i have implemented direct connection i cannot see it coz it is linked to the local directory database not on the testing server.
i have also never experienced uploading to a IIS server with DB connection so its my first time with dynamic websites. so am i in trouble or its ok the way i have done my site..
Hello I have a page for registering users.
I am reciveing this error:
The following errors occured:
- An error occured. -2147217904 : No value given for one or more required parameters.
there are students and teachers. therefore I have 3 tables one for logins and one for staff and on for students.
I have a form designed to capeture the need information.
in the code I am runing an if and elseif statmetn to determin the tables. I then insert the userid and password into the login table.
then i enter the remaining information into ither the staff or student table. what i am trying to do is select the perimary number that is generated as the userid and passeword are enterd. and add this to the second table. Code:
I want MS Access 2000 database column of table 1 = column of table 2. This is what I was doing: Code:
View Replies View RelatedI am trying to create a web page that has a drop down menu in which it retrieves data from our SQL server. Maybe this is a bit more simple than I am making it but I am really pulling my hair out trying to get this right. Code:
View Replies View Relatedthis is my error:
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
here is my db connection string:
<%@Language=VBScript%>
<!--#include file="adovbs.inc"-->
<%
dim rs, cn
Set cn = Server.CreateObject("ADODB.Connection")
'with cn
' .Provider="Microsoft.jet.oledb.4.0"
' .ConnectionString=Server.MapPath("home/nfiweb.mdb")
' .Open
'end with
cn.open "nfijobs"
set rs = Server.CreateObject("ADODB.Recordset")
%>
When I click submit after updating the information all of my info gets deleted from the db so I'm guessing that the values that are being submitted are not getting picked up in the sql. I've tried changing the form names, etc, but still have the same prob. My code is below: Code:
View Replies View RelatedI am having trouble connecting to an Access db fro mmy asp page. I get the following error: The page cannot be displayed There is a problem with the page you are trying to reach and it cannot be displayed. Code:
I'm using an SQL2K backend and attempting to connect to it with the following code.
' -- Connection String Value
response.write "Setting strConnection"
strConnection = "DSN=tracktimedb"
' -- Our SQL Statement
response.write "Declaring SQL Statement"
strSQL = "SELECT * FROM TIMES"
' -- Populate our Recordset with data
Set objRS = GetRecordset(strConnection, strSQL)
I have done many searches but all the connection strings I've found seem to be using a DSN to an access DB. Currently I get this error when trying to connect.
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I can't seem to find the proper syntax to specify a db login (sa) and password in the connection string.
on 1 page i open
a connection to a database and build a recordset to check
username and password. there are other fields in the db
that i need to access on the next page. how do i reference that
connection and run a new sql query without having to reopen the connection?
i thought it would be as simple as NOT closing it, but thats not working.
I am having problem in my connection to database when running ASP.
It works fine for the first time but if I run it again without a gap of atleast a minute,
it gives me the following error message:
Error Type:
Provider (0x80004005)
Unspecified error
And the line it is showing error is where I am opening my database connection using conn.open.If I wait for couple of minutes and run again,it works fine.
I'm trying to maintain a permanent tcp/ip connection between two
computers using ASP. I need users accessing the ASP pages to be able
to send and receive messages using this connection. I know that I
can't use a Winsock control with ASP so I guess I'm looking at a third
party control. Even if I can get this working I'm not sure that I can
have different users accessing this one permanently open connection.
I've looked all over the Net for ideas on how to do this but I've had
no luck. Has anyone had to do anything like this?
I am trying to establish an ODBC conection to ORACLE 10g and have tried all the following. Please advise:
We are trying to connect to a 10 g server and nearly gone crazy after doing so. tried everythign, DSN, DSN less .... The bottom line the connection is successful when we try it form the control panel-> data source thing but not from ASP. We tried the following things: Code:
I created a master detail page using the wizard in Dreamweaver, however I need to create a DSN-less connection. How do I do that? I am assuming I need to edit this part of my code:
View Replies View RelatedCan anyone help me create a dsn less connection to the sql server 2005 db
from the connection.asp file below please,
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
Dim MM_TobiasNET_STRING
MM_TobiasNET_STRING = "dsn=TobiasNET;uid=sa;pwd=*******;"
%>
Need detailed explanation if poss or even better an example.
Need to implement an online payment facility, which requires SSL
encryption. I have bought the keys and they are installed on the server
(IIS5)
Can anyone point me in the right direction for help in activating the SSL
encryption using asp - tutorials or sample scripts etc?
I am getting 500 Internal Server Error. I have tried disabling the show
friendly error in IE and I have tried it on Firefox. It will not give me the
reason why it will not work, I only get 500 Internal Server Error.
I have tested the code up to the point of Set objConn and it works but when it gets
to the objConn.open dsn that's when I get the error. I wish to find out why
it is not allowing it to get pass this point. I have control of the server
where this is hosted and if there is anything I need to do, I can do it.
I am trying to create a web page on our company intranet.I am using Frontpage 2000.I need to be able to read from and write to databases in this project.I am starting slow since I am just learning, so for now I am trying to read from an existing SQL database on a network server. The server is running SQL Server 2000 and IIS.
I could create a database connection using the Database Results Wizard in FP. The connection would verify OK and I could select the columns from the table I wanted to display. When I published the page to the server, all I got was column headings, no data.
when I try to create a new db connection, it will verify, but it will not show up as an existing db connection.
need to connect DB2 tables on mainframe, using a ASP front end...But I do not know how to... what all things I should enquire & need in the system before doing the same. connection format to connect a databse on mainframe.
View Replies View RelatedMy client have a allready built database. and now need to access that database with asp.
How do i connct to a sql database through asp? Would like to use mapPath() in stead of a DSN. Could only find DNS examples on the net.
I just want to import this part of VBscript file to an asp code to help my frined. This part of code is working if I run it as a vbscript on the command line, but we could not get it run in a asb files.
MyODBC = "SQLODBC
MyUsername = "sa
MyPassword = "password
Set objADODBConn = CreateObject("ADODB.Connection"
strConn="DSN=" & MyODBC & ";UID=" & MyUsername & ";PWD=" & MyPassword & ";
objADODBConn.Open(strConn
Any suggestion? Is there anything we miss? Can anyone give us an example to make a ODBC connection in an asb file.
I have no idea of how to connect to my database (access) to my asp pages using DSN (ODBC). I've already upload my database file in the folder called db and I've already added DSN. Can you guys provide me some sample code?
View Replies View RelatedIam trying to connect to my database using dreamweaver but I am told that I do not need it ! I can't understand how am I supose to use my Database? I refere to DSN, user name and passoword, but I was told no need for it as I can just do some coding, so is there anyway I can code it ?
my host company cannot understand that I need a DSN connection and when I asked about the password they tell me...no need for it.