How to get OleDbConnection DataSource?

  • Thread starter Thread starter Mika M
  • Start date Start date
M

Mika M

Hello!

How can I get DataSource-property of the OleDbConnection correctly? I tried
to check it using Immediate Window, and got the following ...

?cn
{System.Data.OleDb.OleDbConnection}
ConnectionString:
"Provider=sqloledb;DataSource=MyComputerName;Database=MyDatabase;Integrated
Security=SSPI;Connect Timeout=30"
ConnectionTimeout: 30
Container: Nothing
Database: "MyDatabase"
DataSource: ""
Provider: "sqloledb"
ServerVersion: "08.00.0760"
Site: Nothing
State: Open

.... and trying

?cn.DataSource
.... retrieves ""

Why not 'MyComputerName' in this case?
 
¤ Hello!
¤
¤ How can I get DataSource-property of the OleDbConnection correctly? I tried
¤ to check it using Immediate Window, and got the following ...
¤
¤ ?cn
¤ {System.Data.OleDb.OleDbConnection}
¤ ConnectionString:
¤ "Provider=sqloledb;DataSource=MyComputerName;Database=MyDatabase;Integrated
¤ Security=SSPI;Connect Timeout=30"
¤ ConnectionTimeout: 30
¤ Container: Nothing
¤ Database: "MyDatabase"
¤ DataSource: ""
¤ Provider: "sqloledb"
¤ ServerVersion: "08.00.0760"
¤ Site: Nothing
¤ State: Open
¤
¤ ... and trying
¤
¤ ?cn.DataSource
¤ ... retrieves ""
¤
¤ Why not 'MyComputerName' in this case?


What version of Visual Studio.NET are you working with?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
What version of Visual Studio.NET are you working with?
Click to expand...

Visual Studio .NET 2003 (updated earlier from VS.NET 2002) and making VB
..NET Windows Forms application.
 
¤
¤ > What version of Visual Studio.NET are you working with?
¤
¤ Visual Studio .NET 2003 (updated earlier from VS.NET 2002) and making VB
¤ .NET Windows Forms application.

Hmm. Don't seem to be able to reproduce the problem. I'm testing with a local server and it returns
the DataSource properly.

Is there any difference if you specify the Initial Catalog argument (database) in your connection
string?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top