DSN和DSN之间的性能差异？ [英] performance difference between DSN and DSN-less?
问题描述
使用DSN和DSN-less（Jet）
连接之间是否有性能差异？
我有一个购物车应用程序使用DSN-less
连接时出现问题，一旦我更改为DSN，问题就会消失。
如果它有助于显示脚本..我想我可以复制并粘贴它，但
只是觉得有人可能会对此有所了解。
谢谢
有什么问题？
显示两个连接字符串。
-
Mark Schupp
开发负责人
诚信电子学习
www.ielearning.com
" Alistair" < forget_it>在消息中写道
新闻：10 ************* @ corp.supernews.com ...是否有性能差异使用DSN和DSN-less（Jet）
连接？
我有一个购物车应用程序，在使用DSN-less
连接时出现问题当我改为DSN时，问题就消失了。
如果它有助于显示脚本..我想我可以复制并粘贴它，但
只是觉得有人可能会知道一点点更多关于这一点。
感谢
" Mark Schupp" < MS ***** @ ielearning.com>在留言中写道
新闻：％2 **************** @ TK2MSFTNGP09.phx.gbl ...什么是问题？
显示两个连接字符串。
-
Mark Schupp
开发主管
完整性电子学习
< a rel =nofollowhref =http://www.ielearning.comtarget =_ blank> www.ielearning.com
" Alistair" < forget_it>在消息中写道
新闻：10 ************* @ corp.supernews.com ...使用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.com ...是否有性能差异使用DSN和DSN-less（Jet）
连接？
DSN-less连接更好。有关详细信息，请参阅此文章：
http：// www .aspfaq.com / 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.com
"Alistair" <forget_it> wrote in message
news:10*************@corp.supernews.com...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.com> 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.com
"Alistair" <forget_it> wrote in message
news:10*************@corp.supernews.com...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.com...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:
http://www.aspfaq.com/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之间的性能差异？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
