Ask a Question related to Coldfusion Database Access, Design and Development.
-
keku #1
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; charset=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 = document.getElementById(callname);
this.thediv = document.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> </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
-
Problem with MS Access, ODBC and MySQL 5
I have, almost, successfully replaced SQL Server with a MySQL back end for my database. I used the migration tool and copied the database... -
MS Access ODBC problem
I need to link some tables from a remote MySql server (ver. 4.1.12) to a MS Access 2003 db. I can succesfully connect using both MySql... -
DBI and DBD::ODBC and MS Access
Using Perl and DBI:ODBC with an MS Access database on Windows XP running IIS (Just a getting started guide) Creating the access database: a..... -
[PHP] ODBC for MS Access
I use Linux box + PHP installed on it and want to connect/access MS Access database installed on Windows box. Below are my Questions: 1 What... -
ODBC for MS Access
Dear All, I use Linux box + PHP installed on it and want to connect/access MS Access database installed on Windows box. Below are my Questions:... -
philh #2 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
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
