Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
database connection dsn vs. odc
Hello all,
using Excel '03. A question on database connection: I use Excel to import data from an Oracle database. I've setup two connections to the database server -- a .dsn connection and a .odc connection. E.g., (SERVERNAME.dsn), (SERVERNAME.odc) I'm inquiring if anyone knows the main difference between the two; e.g., speed, performance, etc. I established both connections with Access (I've never been able to do it with just Excel). Both connections use a Microsoft ODBC driver. Thanks for any response. alex |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
database connection dsn vs. odc
On Wed, 28 May 2008 05:16:38 -0700 (PDT), alex wrote:
Hello all, using Excel '03. A question on database connection: I use Excel to import data from an Oracle database. I've setup two connections to the database server -- a .dsn connection and a .odc connection. E.g., (SERVERNAME.dsn), (SERVERNAME.odc) I'm inquiring if anyone knows the main difference between the two; e.g., speed, performance, etc. I established both connections with Access (I've never been able to do it with just Excel). Both connections use a Microsoft ODBC driver. Alex: I don't know the answer, but I suspect that if they both use ODBC then they have exactly the same performance. If you didn't know odc = office database connection. I didn't see anything on the web discussing why MS even created this instead of just using DSN. If you're having peformance problems, you might consider using OLE, which replaced ODBC. I don't know if it's faster, but it would be worth a try. http://www.oracle.com/technology/sof..._db/index.html http://www.simongibson.com/intranet/adooledb/#oracle -- Dick Kusleika Microsoft MVP-Excel http://www.dailydoseofexcel.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
database connection dsn vs. odc
On May 29, 4:50*pm, Dick Kusleika wrote:
On Wed, 28 May 2008 05:16:38 -0700 (PDT), alex wrote: Hello all, using Excel '03. A question ondatabaseconnection: I use Excel to import data from an Oracledatabase. *I've setup two connections to thedatabaseserver -- a .dsnconnectionand a .odc connection. *E.g., (SERVERNAME.dsn), (SERVERNAME.odc) I'm inquiring if anyone knows the main difference between the two; e.g., speed, performance, etc. I established both connections with Access (I've never been able to do it with just Excel). Both connections use a Microsoft ODBC driver. Alex: *I don't know the answer, but I suspect that if they both use ODBC then they have exactly the same performance. *If you didn't know odc = officedatabaseconnection. *I didn't see anything on the web discussing why MS even created this instead of just using DSN. If you're having peformance problems, you might consider using OLE, which replaced ODBC. *I don't know if it's faster, but it would be worth a try.. http://www.oracle.com/technology/sof...ooledb/#oracle -- Dick Kusleika Microsoft MVP-Excelhttp://www.dailydoseofexcel.com- Hide quoted text - - Show quoted text - Thanks Dick, I appreciate you taking the time to provide a response. alex |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Database Connection | Excel Programming | |||
Database Connection | Excel Programming | |||
Database Connection | Excel Programming | |||
Database Connection from Excel | Excel Programming | |||
DataBase Connection | Excel Programming |