asb中的数据库连接 [英] DB connection in asb

问题描述

你好

我对asb一无所知，但我只是想将这部分VBscript文件导入到asp代码中来帮助我。如果我在命令行上将其作为vbscript运行，那么这段代码就可以工作了，但我们无法在asb文件中运行它。


MyODBC =" SQLODBC
MyUsername =" sa

MyPassword =" password


设置objADODBConn = CreateObject（" ADODB.Connection"

strConn =" DSN ="& MyODBC&" ;; UID ="& MyUsername&" ;; PWD ="& MyPassword&" ;;

objADODBConn.Open（strConn


有什么建议吗？有什么我们想念的吗？任何人都可以给我们一个例子来在asb文件中建立ODBC连接

谢谢

cT

Hello
I do not know anything about asb but I just want to import this part of VBscript file to an asp code to help my frined. This part of code is working if I run it as a vbscript on the command line, but we could not get it run in a asb files.

MyODBC = "SQLODBC
MyUsername = "sa
MyPassword = "password

Set objADODBConn = CreateObject("ADODB.Connection"
strConn="DSN=" & MyODBC & ";UID=" & MyUsername & ";PWD=" & MyPassword & ";
objADODBConn.Open(strConn

Any suggestion? Is there anything we miss? Can anyone give us an example to make a ODBC connection in an asb file
Thanks
cT

推荐答案

连接字符串 http://www.darkfalz.com/1059


-

Curt Christianson

所有者/首席开发人员，DF-Software
www.Darkfalz.com

JIM.H. <一个******* @ discussions.microsoft.com>在消息中写道

news：50 ********************************** @ microsof t.com ...

Connection Strings http://www.darkfalz.com/1059

--
Curt Christianson
Owner/Lead Developer, DF-Software
www.Darkfalz.com
"JIM.H." <an*******@discussions.microsoft.com> wrote in message
news:50**********************************@microsof t.com...

您好，
我对asb一无所知，但我只想将这部分
VBscript文件导入到asp代码中帮助我的朋友。如果我在命令行上将其作为vbscript运行，那么这部分代码正在工作

，但是我们无法在asb文件中运行

。
MyODBC =" SQLODBC"
MyUsername =" sa"
MyPassword =" password"

设置objADODBConn = CreateObject（" ADODB.Connection"）
创建失败= QUOT; DSN = QUOT; &安培; MyODBC&英寸; UID =" &安培;我的用户名和英寸; PWD =" &安培; MyPassword&
" ;;" objADODBConn.Open（strConn）

有什么建议吗？我们想念什么吗？任何人都可以给我们一个示例
在asb文件中建立ODBC连接？谢谢，
cT。

Hello,
I do not know anything about asb but I just want to import this part of VBscript file to an asp code to help my frined. This part of code is working
if I run it as a vbscript on the command line, but we could not get it run
in a asb files.
MyODBC = "SQLODBC"
MyUsername = "sa"
MyPassword = "password"

Set objADODBConn = CreateObject("ADODB.Connection")
strConn="DSN=" & MyODBC & ";UID=" & MyUsername & ";PWD=" & MyPassword & ";" objADODBConn.Open(strConn)

Any suggestion? Is there anything we miss? Can anyone give us an example to make a ODBC connection in an asb file? Thanks,
cT.

您是否收到某种错误？还有一个愚蠢的问题，但是你是

用.asP扩展名保存你的文件吗？


雷在工作


JIM.H. <一个******* @ discussions.microsoft.com>在消息中写道

news：50 ********************************** @ microsof t.com ...

Are you getting an error of some sort? And dumb question, but are you
saving your files with a .asP extension?

Ray at work

"JIM.H." <an*******@discussions.microsoft.com> wrote in message
news:50**********************************@microsof t.com...

您好，
我对asb一无所知，但我只想将这部分
VBscript文件导入到asp代码中帮助我的朋友。如果我在命令行上将其作为vbscript运行，那么这部分代码正在工作

，但是我们无法在asb文件中运行

。
MyODBC =" SQLODBC"
MyUsername =" sa"
MyPassword =" password"

设置objADODBConn = CreateObject（" ADODB.Connection"）
创建失败= QUOT; DSN = QUOT; &安培; MyODBC&英寸; UID =" &安培;我的用户名和英寸; PWD =" &安培; MyPassword&
" ;;" objADODBConn.Open（strConn）

有什么建议吗？我们想念什么吗？任何人都可以给我们一个示例
在asb文件中建立ODBC连接？谢谢，
cT。

Hello,
I do not know anything about asb but I just want to import this part of VBscript file to an asp code to help my frined. This part of code is working
if I run it as a vbscript on the command line, but we could not get it run
in a asb files.
MyODBC = "SQLODBC"
MyUsername = "sa"
MyPassword = "password"

Set objADODBConn = CreateObject("ADODB.Connection")
strConn="DSN=" & MyODBC & ";UID=" & MyUsername & ";PWD=" & MyPassword & ";" objADODBConn.Open(strConn)

Any suggestion? Is there anything we miss? Can anyone give us an example to make a ODBC connection in an asb file? Thanks,
cT.

你好

是的，有一个asp文件，我们正试图嵌入这个脚本在那里，我们不知道从哪里开始。我们把它放在< %%>之间在一个asp文件中，但它不起作用并给出连接错误，即使脚本在命令行上工作

谢谢

Jim

Hello
Yes, there is a asp file and we are trying to embed this script there, we do not know where to start. We put it between <% %> in an asp file, but it does not work and give connection error, even if the script works on the command line
Thanks
Jim

这篇关于asb中的数据库连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！