How to add record into SQL Server 2000?

How can I add the record into my company SQL Server 2000 database from the website register page?

This is my codes:
<%
Dim sql,rs

Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\InetPub\wwwroot\daly\fpdb\market.mdb"

sql="INSERT INTO testing (fname,lname)"
sql=sql & " VALUES "
sql=sql & "('Shawn', 'mike')"

objConn.Execute sql
objConn.close
%>

This is my error:
Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

/VITA_SHOW/test_VITAFormhandler.asp, line 137

Thank you very much!!!

Shawn
scn@.daly.comNot sure why you are getting that error, but a much better design strategy is to create a stored procedure that inserts the record based upon supplied parameters. You should avoid giving applications direct access to data tables.|||your problem might have been either...

1. you dont have the NT permissions for a file-based database or for the folder that contains the file
2. the file might have been exclusive
3. theres another thats still connected that needs to be closed

for more info on issuing this problem, goto MS white papers

http://support.microsoft.com/default.aspx?scid=kb;EN-US;306269|||What type of object is "testing"? I suspect it's not a table, but rather a query.|||You say that you are updating SQL Server 2000, but your code seems to be looking at a Microsoft Access database - the Jet engine and the .mdb extension both refer to Access.

Andy|||objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\InetPub\wwwroot\daly\fpdb\market.mdb"

First off, the database is Access, not SQL, as can be seen from the connection string above.

If you are trying to use access, then the reason for the error is that the IUSR_SERVERNAME (or the authenticated web user, if applicable) does not have write access to the folder and file at c:\InetPub\wwwroot\daly\fpdb\market.mdb. Make sure you set read/write privileges for IUSR_SERVERNAME or Everyone for both the MDB file and the folder in which it resides.

If you are in fact trying to connect to an MSSQL server, you will need to do one of the following:

a) If you have access to the ODBC configuration, set up a DSN, and use the following syntax:

objConn.Open "DSNNAME","USERNAME","PASSWORD"

b) If you don't have access to create a DSN, use the following syntax:

objConn.Open "Driver={SQL Server};UID=USERNAME;password=PASSWORD;database=DA TABASE_NAME;server=SERVER_NAME_OR_IP"

How to add a link in SRS home page

Hi all.
I was asked to add a link to the SRS home page, the link just takes the user
back to our company portal. I found the ReportManager/Pages/Folder.aspx
file, it contains info on what language it was written in. I have not found
the actual asp pages. Where are they ? Is this something that a non
programmer can do?
thanks ;)No, you really can't do this. The best you can do is to add a link at the
top of your report that does this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"darwin" <darwin@.discussions.microsoft.com> wrote in message
news:DC745AE0-54DC-49AA-A412-31B767F3F5C6@.microsoft.com...
> Hi all.
> I was asked to add a link to the SRS home page, the link just takes the
user
> back to our company portal. I found the ReportManager/Pages/Folder.aspx
> file, it contains info on what language it was written in. I have not
found
> the actual asp pages. Where are they ? Is this something that a non
> programmer can do?
> thanks ;)

how to add a image from database to page header

Hi,

I am having same issue, but the data is an image stored in database. actually its an company logo which i need to display on every page.

i have a doubt. if i user source as external and an URL in a image property, then my image will not appear if the Reporting Server and Application Server are on two different machines. if both are in one machine as my local machine(development machine) the image appears.

is this an known issue or how to solve this. due to this reason, we thought of putting images in database and pulling out, but it turned out to be an another problem.

You can follow the approach described in Books Online (scroll to "Adding a Databound Image to a Header or Footer"): http://msdn2.microsoft.com/en-us/library/ms159677.aspx

Note: if you are doing this on Reporting Services 2005, you should definitely first install SP1 (http://www.microsoft.com/sql/sp1.mspx) for both, the report server and the machines with BI Development Studio / Report Designer.

-- Robert

How to add a calcualted field in Matrix?

Hello.. I would like to know how this can be done in RS (SQL2000)...

In the dataset I have... sales, company, and year. What I want to display is such...

2005 2006 Growth

companyA $1,000,000 $500,000 100%

companyB $50,000 $100,000 -50%

How do I add a column in a Matrix to calculate the growth based on the sales? Thanks!

-Joseph

you would have to add growth to your dataset as a calculation in of the years. So for MDX you would add a calculated member to the time dimension and calculate growth in that.