Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMicrosoft SQL Server

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old January 24th, 2003, 03:53 PM
eagle2097 eagle2097 is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2003
Posts: 1 eagle2097 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
updateable query error workaround

OK, i'm just a beginner at this SQL & ASP stuff, so bear with me.

I have uploaded a ms dbase to my server. Upon completion of the site, i noted that i could not update the database or add new records. I have read numerous pages on changing the IUSR user to have read/write/execute permissions. This does work because i designed another site, in which i requested that the permissions be changed, and everytyhing worked just fine. The problem this time is that the server admin will NOT change my permissions becuase it compromises security. Now I'm left trying to find a work around for this problem. My server has an ODBC function on their control panel, but I am unsure how to use it. I have just used an OLEDB with the JET engine to connect.

I'm using Dreamweaver MX.
Here is the exact "connect" file that dreamweaver generated based on my custom connection string to the dbase:

<%
// FileName="Connection_ado_conn_string.htm"
// Type="ADO"
// DesigntimeType="ADO"
// HTTP="true"
// Catalog=""
// Schema=""
var MM_dbs_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" +Server.MapPath("/cjm/updates/dbase.mdb")+";user id=; password=;"
%>

And here is the execute statement on the record update page.

// execute the update
var MM_editCmd = Server.CreateObject('ADODB.Command');
MM_editCmd.ActiveConnection = MM_editConnection;
MM_editCmd.CommandText = MM_editQuery;
MM_editCmd.Execute();
MM_editCmd.ActiveConnection.Close();

I get the error on the line corresponding to the "MM_edit.Cmd.Execute()" command.

Any assistance would be greatly appreciated!!

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft SQL Server > updateable query error workaround


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway
Stay green...Green IT