.NETGURU
  Search:  
NamespacesDiscussions.NET v1.1Dot Net Guru's BlogIT Certification
Accessing Sql Server 6.5
Messages   Related Types
This message was discovered on ASPFriends.com 'ngfx-oledb' list.


James Avery
I am working on a project where I need to access Sql Server 6.5 through
ADO.net and I am using the oledb provider. I have moving this project
from asp to asp.net, but I am having some major speed issues with
asp.net. When running this with asp the speed was fine, no problems
there, now it is extremely slow. It is bad enough that it times out if
more than 6 items are returned. I set up a trace on the server and
when I run the asp version the entries just fly by, with the asp.net
version it is extremely slow and the entries only sporadically appear
during the other processes. What can I troubleshoot here and has anyone
else had issues with accessing 6.5 with ado.net??

Here is my connection string with pwd and username omitted:
OleDbConnection oOleConn = new
OleDbConnection("Provider=sqloledb;Network Library=DBMSSOCN;Data
Source=192.168.31.5,1433;Initial Catalog=Deluxe1;User ID=;Password=;");

I have tried using CommandType's StoredProcedure and Text. Any ideas or
suggestions would be greatly appreciated.
Reply to this message...
 
    
James Avery
Ignore this email, I traced the slowdown to another area of code.

Thanks,
James

-----Original Message-----
From: James Avery [mailto:Click here to reveal e-mail address]
Sent: Tuesday, July 09, 2002 4:07 PM
To: ngfx-oledb
Subject: [ngfx-oledb] Accessing Sql Server 6.5

I am working on a project where I need to access Sql Server 6.5 through
ADO.net and I am using the oledb provider. I have moving this project
from asp to asp.net, but I am having some major speed issues with
asp.net. When running this with asp the speed was fine, no problems
there, now it is extremely slow. It is bad enough that it times out if
more than 6 items are returned. I set up a trace on the server and
when I run the asp version the entries just fly by, with the asp.net
version it is extremely slow and the entries only sporadically appear
during the other processes. What can I troubleshoot here and has anyone
else had issues with accessing 6.5 with ado.net??

Here is my connection string with pwd and username omitted:
OleDbConnection oOleConn = new
OleDbConnection("Provider=sqloledb;Network Library=DBMSSOCN;Data
Source=192.168.31.5,1433;Initial Catalog=Deluxe1;User ID=;Password=;");

I have tried using CommandType's StoredProcedure and Text. Any ideas or
suggestions would be greatly appreciated.
| [ngfx-oledb] member Click here to reveal e-mail address = YOUR ID |
http://www.aspfriends.com/aspfriends/ngfx-oledb.asp = JOIN/QUIT
Reply to this message...
 
    
Wally McClure
MessageI have not used the oledb data adapter against SQL Server 6.5, but I would suggest using the ODBC data adapter instead. The Odbc driver for Sql Server is somewhere between 5 & 20% faster than the OleDb driver for Sql Server with Sql2000, and I would assume that this holds true with Sql 6.5.

Wally
----- Original Message -----
From: James Avery
To: ngfx-oledb
Sent: Tuesday, July 09, 2002 4:07 PM
Subject: [ngfx-oledb] Accessing Sql Server 6.5

I am working on a project where I need to access Sql Server 6.5 through ADO.net and I am using the oledb provider. I have moving this project from asp to asp.net, but I am having some major speed issues with asp.net. When running this with asp the speed was fine, no problems there, now it is extremely slow. It is bad enough that it times out if more than 6 items are returned. I set up a trace on the server and when I run the asp version the entries just fly by, with the asp.net version it is extremely slow and the entries only sporadically appear during the other processes. What can I troubleshoot here and has anyone else had issues with accessing 6.5 with ado.net??

Here is my connection string with pwd and username omitted:
OleDbConnection oOleConn = new OleDbConnection("Provider=sqloledb;Network Library=DBMSSOCN;Data Source=192.168.31.5,1433;Initial Catalog=Deluxe1;User ID=;Password=;");

I have tried using CommandType's StoredProcedure and Text. Any ideas or suggestions would be greatly appreciated.
| [ngfx-oledb] member Click here to reveal e-mail address = YOUR ID | http://www.aspfriends.com/aspfriends/ngfx-oledb.asp = JOIN/QUIT
Reply to this message...
 
 
System.Data.CommandType
System.Data.OleDb.OleDbConnection




ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
Ad


Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews
.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT
Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project
FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.
Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials
 
ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
 Copyright © ExamGuru, Inc. 2001-2006
Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification