asb中的数据库连接

MyUsername =" sa MyPassword =" password 设置objADODBConn = CreateObject（" ADODB.Connection" strConn =" DSN ="& MyODBC&" ;; UID ="& MyUsername&" ;; PWD ="& MyPassword&" ;; objADODBConn.Open（strConn 有什么建议吗？有什么我们想念的吗？任何人都可以给我们一个例子来在asb文件中建立ODBC连接 谢谢 cT HelloI 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 = "SQLODBCMyUsername = "saMyPassword = "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 fileThankscT 推荐答案 连接字符串 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 ChristiansonOwner/Lead Developer, DF-Software www.Darkfalz.com"JIM.H." <an*******@discussions.microsoft.com> wrote in messagenews: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 ofVBscript file to an asp code to help my frined. This part of code is workingif I run it as a vbscript on the command line, but we could not get it runin 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 exampleto 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 yousaving your files with a .asP extension? Ray at work "JIM.H." <an*******@discussions.microsoft.com> wrote in messagenews: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 ofVBscript file to an asp code to help my frined. This part of code is workingif I run it as a vbscript on the command line, but we could not get it runin 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 exampleto make a ODBC connection in an asb file? Thanks, cT. 你好 是的，有一个asp文件，我们正试图嵌入这个脚本在那里，我们不知道从哪里开始。我们把它放在< %%>之间在一个asp文件中，但它不起作用并给出连接错误，即使脚本在命令行上工作 谢谢 Jim HelloYes, 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 lineThanksJim 这篇关于asb中的数据库连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！