使用JavaScript 访问本地ODBC数据库
问：
Hi,
答:
Hi javidot
<HTML>
<HEAD>
<TITLE></TITLE>
<script language=javascript>
function connectDb()
{
var ConnDB = new ActiveXObject("ADODB.Connection");
ConnDB.ConnectionString="dsn=orc2;uid=webstat;pwd=khkj;";
ConnDB.Open();
var Rs = new ActiveXObject("ADODB.Recordset");
var tempstr="";
Rs.Open("select * from tab",ConnDB,1,3);
while(!Rs.EOF)
{
tempstr = tempstr + Rs("TNAME") + "<br>";
Rs.MoveNext;
}
test.innerHTML=tempstr;
}
</script>
</HEAD>
<BODY>
<P><div id=test> </div>
<P><INPUT id="button1" type="button" value="Run" name="button1" onclick="connectDb();"></P>
</BODY>
</HTML>
If I’ve misunderstood your problem, please feel free to let me know.
Thanks.
Hi,
I need to access a sql database through odbc using javascript. This database resides in the client PC
and the only way to connect to it is using the client PC ODBC. The asp.net application need to retreive
and update data to that database. I don't know how to do this so I need some help of you guys. My
experience is in c# and vb.net, not in javascript but I know that if I need to access the client PC resources
it has to be javascript or vbscript. If there's any other way to do this please let me know.
答:
Hi javidot
Just as HeartattacK said, it is no recommend because of security issue.
You can try the following code, hope this helps:
code from http://topic.csdn.net/t/20031028/12/2402598.html
<HTML> <HEAD> <TITLE></TITLE> <script language=javascript> 
function connectDb() { 
var ConnDB = new ActiveXObject("ADODB.Connection"); ConnDB.ConnectionString="dsn=orc2;uid=webstat;pwd=khkj;"; ConnDB.Open(); var Rs = new ActiveXObject("ADODB.Recordset"); var tempstr=""; Rs.Open("select * from tab",ConnDB,1,3); while(!Rs.EOF) { tempstr = tempstr + Rs("TNAME") + "<br>"; Rs.MoveNext; } test.innerHTML=tempstr; } </script> </HEAD> <BODY> <P><div id=test> </div> <P><INPUT id="button1" type="button" value="Run" name="button1" onclick="connectDb();"></P> </BODY> </HTML>
May be you will interesting in this:
ODBC Support for Javascript
http://www.freeswitch.org/node/44If I’ve misunderstood your problem, please feel free to let me know.
Thanks.
【推荐】国内首个AI IDE，深度理解中文开发场景，立即下载体验Trae
【推荐】编程新体验，更懂你的AI，立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包，你的智能百科全书，全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell：AI 加持，快人一步
· 如何编写易于单元测试的代码
· 10年+ .NET Coder 心语，封装的思维：从隐藏、稳定开始理解其本质意义
· .NET Core 中如何实现缓存的预热？
· 从 HTTP 原因短语缺失研究 HTTP/2 和 HTTP/3 的设计差异
· AI与.NET技术实操系列：向量存储与相似性搜索在 .NET 中的实现
· 周边上新：园子的第一款马克杯温暖上架
· Open-Sora 2.0 重磅开源！
· 分享 3 个 .NET 开源的文件压缩处理库，助力快速实现文件压缩解压功能！
· Ollama——大语言模型本地部署的极速利器
· [AI/GPT/综述] AI Agent的设计模式综述