every contact leaves a trace...

Back to homepage
View my guest book
Sign my guest book
Visit my blog
Send me a email
Visit my forum and start talking
Link | subglobal7 link | subglobal7 link | subglobal7 link | subglobal7 link | subglobal7 link | subglobal7 link
subglobal8 link | subglobal8 link | subglobal8 link | subglobal8 link | subglobal8 link | subglobal8 link | subglobal8 link

view guest book

 

Name:
#guestbook.msgname#

Homepage URL / Email Address:
#guestbook.url#

Message:
#guestbook.msg#



[allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => keku [ip] => webforumsuser@m [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 1 [islastshown] => [isfirstshown] => 1 [attachments] => [allattachments] => ) --> MS Access & ODBC problem. - Coldfusion Database Access

MS Access & ODBC problem. - Coldfusion Database Access

I recently sign on a coldfusion mx plan to host my small school project. I wrote my whole site with dreamweaver and configure all the necessary data coonection on my local machine. Everything is ok but when I upload to my hoster, I encounter error with all my dymanic pages. It's first stating data source not found, and the tech guy told me that it need 24 hours to update the DSN record in coldfusion. That's what he said. Today I again reload my page, this message welcome me. "[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Selected collating sequence not ...

  1. #1

    Default MS Access & ODBC problem.

    I recently sign on a coldfusion mx plan to host my small school project. I
    wrote my whole site with dreamweaver and configure all the necessary data
    coonection on my local machine. Everything is ok but when I upload to my
    hoster, I encounter error with all my dymanic pages. It's first stating data
    source not found, and the tech guy told me that it need 24 hours to update the
    DSN record in coldfusion. That's what he said.

    Today I again reload my page, this message welcome me.
    "[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
    Access Driver] Selected collating sequence not supported by the operating
    system"

    I may have error in my coding but I have been debugging when I do my test run
    on local server and it's fine.

    Anyway, this is the source of one of my page. thank you for your time,





    <cfquery name="guestbook" datasource="kelvina_data">
    SELECT *
    FROM message
    ORDER BY msgID DESC</cfquery>
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
    "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <!-- DW6 -->
    <head>
    <meta http-equiv="Content-Type" content="text/html; cht=utf-8">
    <title>View Guest Book</title>
    <link rel="stylesheet" href="image/emx_nav_right.css" type="text/css">
    <script type="text/javascript">
    <!--
    var time = 3000;
    var numofitems = 7;

    //menu constructor
    function menu(allitems,thisitem,startstate){
    callname= "gl"+thisitem;
    divname="subglobal"+thisitem;
    this.numberofmenuitems = 7;
    this.caller = doent.getElementById(callname);
    this.thediv = doent.getElementById(divname);
    this.thediv.style.visibility = startstate;
    }

    //menu methods
    function ehandler(event,theobj){
    for (var i=1; i<= theobj.numberofmenuitems; i++){
    var shutdiv =eval( "menuitem"+i+".thediv");
    shutdiv.style.visibility="hidden";
    }
    theobj.thediv.style.visibility="visible";
    }

    function closesubnav(event){
    if ((event.clientY <48)||(event.clientY > 107)){
    for (var i=1; i<= numofitems; i++){
    var shutdiv =eval('menuitem'+i+'.thediv');
    shutdiv.style.visibility='hidden';
    }
    }
    }
    // -->
    </script>
    <style type="text/css">
    <!--
    .style1 {font-size: 14px}
    -->
    </style>
    </head>
    <body onmousemove="closesubnav(event);">
    <div class="skipLinks">skip to: <a href="#content">page content</a> | <a
    href="pageNav">links on this page</a> | <a href="#globalNav">site
    navigation</a> | <a href="#siteInfo">footer (site information)</a> </div>
    <div id="masthead">
    <h1 id="siteName">every contact leaves a trace... </h1>
    <div id="globalNav">
    <img alt="" src="image/gblnav_left.gif" height="32" width="4" id="gnl">
    <img alt="" src="image/glbnav_right.gif" height="32" width="4" id="gnr">
    <div id="globalLink">
    <a href="index.htm
    " id="gl1" class="glink"
    onmouseover="ehandler(event,menuitem1);">home</a><a href="vguestbook.cfm"
    id="gl2" class="glink" onmouseover="ehandler(event,menuitem2);">view guest book
    </a><a href="sguestbook.cfm" id="gl3" class="glink"
    onmouseover="ehandler(event,menuitem3);">sign guest book</a><a href="#"
    id="gl4" class="glink" onmouseover="ehandler(event,menuitem4);">my blog </a><a
    href="contact.cfm" id="gl5" class="glink"
    onmouseover="ehandler(event,menuitem5);">contact me </a><a
    href="http://keku24.com/phpBB2/" id="gl6" class="glink"
    onmouseover="ehandler(event,menuitem6);">forum</a><a href="#" id="gl7"
    class="glink" onmouseover="ehandler(event,menuitem7);">other resources </a>
    </div>
    <!--end globalLinks-->
    </div>
    <!-- end globalNav -->
    <div id="subglobal1" class="subglobalNav style1">
    Back to homepage
    </div>
    <div id="subglobal2" class="subglobalNav style1">
    View my guest book
    </div>
    <div id="subglobal3" class="subglobalNav style1">
    Sign my guest book
    </div>
    <div id="subglobal4" class="subglobalNav style1">
    Visit my blog
    </div>
    <div id="subglobal5" class="subglobalNav style1">
    Send me a email
    </div>
    <div id="subglobal6" class="subglobalNav style1">
    Visit my forum and start talking
    </div>
    <div id="subglobal7" class="subglobalNav">
    <a href="#">Link</a> | <a href="#">subglobal7 link</a> | <a
    href="#">subglobal7
    link</a> | <a href="#">subglobal7 link</a> | <a href="#">subglobal7
    link</a> | <a href="#">subglobal7
    link</a> | <a href="#">subglobal7 link</a>
    </div>
    <div id="subglobal8" class="subglobalNav">
    <a href="#">subglobal8 link</a> | <a href="#">subglobal8 link</a> | <a
    href="#">subglobal8
    link</a> | <a href="#">subglobal8 link</a> | <a href="#">subglobal8
    link</a> | <a href="#">subglobal8
    link</a> | <a href="#">subglobal8 link</a>
    </div>
    </div>
    <!-- end masthead -->
    <div id="pagecell1">
    <!--pagecell1-->
    <img alt="" src="image/tl_curve_white.gif" height="6" width="6" id="tl">
    <img alt="" src="image/tr_curve_white.gif" height="6" width="6" id="tr">
    <div id="breadCrumb">
    / <a href="index.html">Homepage </a>/ <a href="vguestbook.cfm">View Guest
    Book / </a></div>
    <div id="pageName">
    <h2>view guest book</h2>
    <p>&nbsp;</p>
    <cfoutput query="guestbook">
    <p class="story">Name: <br />
    #guestbook.msgname#
    <p class="story">Homepage URL / Email Address: <br />
    #guestbook.url#
    <p class="story">Message: <br />
    #guestbook.msg#
    <hr>
    </cfoutput> </div>
    </div>
    <!--end pagecell1-->
    <br>
    <script type="text/javascript">
    <!--
    var menuitem1 = new menu(7,1,"hidden");
    var menuitem2 = new menu(7,2,"hidden");
    var menuitem3 = new menu(7,3,"hidden");
    var menuitem4 = new menu(7,4,"hidden");
    var menuitem5 = new menu(7,5,"hidden");
    var menuitem6 = new menu(7,6,"hidden");
    var menuitem7 = new menu(7,7,"hidden");
    // -->
    </script>
    </body>
    </html>

    keku Guest

  2. #2

    Default Re: MS Access & ODBC problem.

    Looks like the stated collation in your DSN is not installed on the host OS. Perhaps your application is in a different language from the host's?
    philh Guest

Similar Threads

  1. Problem with MS Access, ODBC and MySQL 5
    By Bernard Peek in forum MySQL
    Replies: 1
    Last Post: January 24th, 10:28 AM
  2. MS Access ODBC problem
    By Bruno in forum MySQL
    Replies: 1
    Last Post: November 24th, 03:37 AM
  3. DBI and DBD::ODBC and MS Access
    By ZafT in forum PERL Modules
    Replies: 0
    Last Post: November 29th, 07:56 AM
  4. [PHP] ODBC for MS Access
    By Jay Blanchard in forum PHP Development
    Replies: 0
    Last Post: September 18th, 12:02 PM
  5. ODBC for MS Access
    By Muhammad Fikri in forum PHP Development
    Replies: 0
    Last Post: September 18th, 11:51 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139