使用DSN和DSN-less（Jet） 连接之间是否有性能差异？ 我有一个购物车应用程序使用DSN-less 连接时出现问题，一旦我更改为DSN，问题就会消失。 如果它有助于显示脚本..我想我可以复制并粘贴它，但 只是觉得有人可能会对此有所了解。 谢谢
解决方案有什么问题？ 显示两个连接字符串。 - Mark Schupp 开发负责人 诚信电子学习 www.ielearning " Alistair" < forget_it>在消息中写道 新闻：10 ************* @ corp.supernews ... 是否有性能差异使用DSN和DSN-less（Jet）连接？ 我有一个购物车应用程序，在使用DSN-less 连接时出现问题当我改为DSN时，问题就消失了。 如果它有助于显示脚本..我想我可以复制并粘贴它，但只是觉得有人可能会知道一点点更多关于这一点。 感谢
" Mark Schupp" < MS ***** @ ielearning>在留言中写道 新闻：％2 **************** @ TK2MSFTNGP09.phx.gbl ... 什么是问题？ 显示两个连接字符串。 - Mark Schupp 开发主管完整性电子学习 www.ielearning " Alistair" < forget_it>在消息中写道新闻：10 ************* @ corp.supernews ... 使用DSN之间是否存在性能差异一个DSN-less （Jet）连接？ 我有一个购物车应用程序在使用无DSN连接时遇到问题，一改为一个DSN，问题就消失了。 如果它有助于显示脚本..我想我可以复制并粘贴它，但只是觉得有人可能会对此有所了解。 感谢
''Jet Oledb连接 ''DatabaseConnectionString = "提供商= Microsoft.Jet.OLEDB.4.0;" &安培; 数据 Source ="& server.mappath（" ../ database / 155ads1q.mdb"） ''DSN连接， ''DatabaseConnectionString =" DSN = 155ads1q.dsn" 有问题的文件执行INSERT进入数据库，然后回读 ID是auto字段。 mySQL =" INSERT INTO客户（姓名，姓名，客户公司，电子邮件，城市， countryCode，电话，地址，邮编，密码， state，stateCode， idCustomerType，active，user1，user2，user3，bonusPoints）VALUES（''"& pName& "''，''" ;& pLastName&"''，''"& pCustomerCompany&"''，''"& pEmail&"''，''"& pCity&"''， ''"& pCountryCode&"''，''"& pPhone&"''，''"& pAddress&"''，''" & pZip&"''，''" & pPassword&"''，''"& pState&"''，''"& pStateCode& ;"''，1，-1，''"& pUser1&"''，''" & pUser2&"''，''"& ; pUser3&"''，0）" 调用updateDatabase（mySQL，rsTemp，" customerRegistrationExec"） ''获取新记录的idCustomer mySQL =" SELECT idCustomer FROM customers WHERE email =''" & pEmail&"''" 但新记录从未插入，所以选择idcustomer位 失败.. 直到我更改为DSN连接..然后一切正常。 DSN-less连接用于从dbase读取产品， 并修改它们，并更新它们......这只是新客户 注册失败。
"阿利斯泰尔" < forget_it>在消息中写道 新闻：10 ************* @ corp.supernews ...
是否有性能差异使用DSN和DSN-less（Jet）连接？ DSN-less连接更好。有关详细信息，请参阅此文章： http：// www .aspfaq / show.asp？id = 2126 我有一个购物车应用程序在使用无DSN连接时出现问题，一旦我换成DSN，问题就会消失。 如果它有助于显示脚本..我想我可以复制并粘贴它，但只是觉得有人可能知道更多关于这一点。不知道问题是什么是或看到代码，很难 提供任何有用的反馈。 问候， Peter Foti
is there a performance difference between using a DSN and a DSN-less (Jet) connection? I have a shopping cart app that has a problem when working with a DSN-less connection, as soon as I change to a DSN, problem disappears. if it would help to show the script..I think I can copy and paste it, but just thought someone might know a little bit more about this. thanks
解决方案 What is the problem? Show both connection strings. -- Mark Schupp Head of Development Integrity eLearning www.ielearning "Alistair" <forget_it> wrote in message news:10*************@corp.supernews... is there a performance difference between using a DSN and a DSN-less (Jet) connection? I have a shopping cart app that has a problem when working with a DSN-less connection, as soon as I change to a DSN, problem disappears. if it would help to show the script..I think I can copy and paste it, but just thought someone might know a little bit more about this. thanks "Mark Schupp" <ms*****@ielearning> wrote in message news:%2****************@TK2MSFTNGP09.phx.gbl... What is the problem? Show both connection strings. -- Mark Schupp Head of Development Integrity eLearning www.ielearning "Alistair" <forget_it> wrote in message news:10*************@corp.supernews... is there a performance difference between using a DSN and a DSN-less (Jet) connection? I have a shopping cart app that has a problem when working with a DSN-less connection, as soon as I change to a DSN, problem disappears. if it would help to show the script..I think I can copy and paste it, but just thought someone might know a little bit more about this. thanks'' Jet Oledb connection '' DatabaseConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source="&server.mappath("../database/155ads1q.mdb") '' DSN connection, '' DatabaseConnectionString = "DSN=155ads1q.dsn" The file in question carries out an INSERT into the DB, then reads back the ID which is an "auto" field. mySQL="INSERT INTO customers (name, lastName, customerCompany, email, city, countryCode, phone, address, zip, password, state, stateCode, idCustomerType, active, user1, user2, user3, bonusPoints) VALUES (''" &pName& "'',''" &pLastName& "'',''" &pCustomerCompany& "'',''" &pEmail& "'',''" &pCity& "'', ''" &pCountryCode& "'',''" &pPhone& "'',''" &pAddress& "'',''" &pZip& "'',''" &pPassword& "'',''" &pState& "'',''" &pStateCode& "'',1,-1,''" &pUser1& "'',''" &pUser2& "'',''" &pUser3& "'',0)" call updateDatabase(mySQL, rsTemp, "customerRegistrationExec") '' obtain the idCustomer of the new record mySQL="SELECT idCustomer FROM customers WHERE email=''" &pEmail&"''" but the new record is never inserted and so the select idcustomer bit fails.. until I change to a DSN connection..then everything works perfectly. The DSN-less connection works fron for reading the products from the dbase, and modifying them , and updating them etc...it''s just that the new customer registration fails.
"Alistair" <forget_it> wrote in message news:10*************@corp.supernews... is there a performance difference between using a DSN and a DSN-less (Jet) connection? DSN-less connections are better. See this article for more details: www.aspfaq/show.asp?id=2126 I have a shopping cart app that has a problem when working with a DSN-less connection, as soon as I change to a DSN, problem disappears. if it would help to show the script..I think I can copy and paste it, but just thought someone might know a little bit more about this.Without knowing what the "problem" is or seeing the code, it''s hard to provide any useful feedback. Regards, Peter Foti
更多推荐
DSN和DSN之间的性能差异？
发布评论