Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - SQL server vs Access
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

SQL server vs Access

 Post Reply Post Reply
Author
Angel464 View Drop Down
Newbie
Newbie
Avatar

Joined: 11 August 2006
Status: Offline
Points: 10
Post Options Post Options   Thanks (0) Thanks(0)   Quote Angel464 Quote  Post ReplyReply Direct Link To This Post Topic: SQL server vs Access
    Posted: 27 February 2012 at 8:53am
Hi All,

I have a code that is run by Acces db and want to change to SQL server 2000. But it is not work, pls help to point out errors:
<%
If NOT InStr(f1.Name, "tn-") > 0 Then

Set SyncConn = Server.CreateObject("ADODB.Connection")
Set cRS = Server.CreateObject("ADODB.Recordset")
SyncConn.Open strConnect
Set cRS.ActiveConnection = SyncConn
cRS.CursorType = 3

cSQL = "SELECT ID, imagename, folder, title, description, dateadded, lasttime, lastdate, total FROM Descriptions WHERE imagename='"&strimage1&"' AND folder='"&Replace(strfolder1,"'","''")&"'"
cRS.Open cSQL,,,&H0002
'Response.Write(cSQL)
If cRS.recordcount = 0 Then
cRS.AddNew
cRS("imagename")     = strimage1
cRS("folder")         = strfolder1
cRS("dateadded")     = strdate1
End If
cRS.Update
cRS.Close
SyncConn.Close

End If

Next
%>

Thanks,


Edited by Angel464 - 01 March 2012 at 9:10am
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.07
Copyright ©2001-2024 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2024 Web Wiz Ltd. All rights reserved.