ExamGuru IT/.Net Guru : how to get database list? on microsoft.public.dotnet.framework.adonet

.NETGURU

how to get database list?

Messages

Related Types

This message was discovered on microsoft.public.dotnet.framework.adonet.

Lloyd Dupont

I have some connection problem and wonder if I do everything correctly.

I'm trying:
I created a SqlConnection with the ConnectionString:
Address=myIp,myPort;User ID=sa;Pwd=password

and with this connection i "PLAN" to run sp_databases stored procedures.
However when I open the connection I get:
SqlException: SQL Server does not exist or access denied.

Although I checked
myDatabase->property->security->Autentication (which is mixed mode SQL
Server & Windows)
and I also check the user sa (who is admin) and its passwrod.

Any idea what I've done wrong ?

Cheers mates!
Lloyd

Reply to this message...

Miha Markic [MVP C#]

Hi Lloyd,

To create a correct connection string (if this is a problem), go to server
explorer window within vs.net, add a database server entry and drag&drop it
on the form - it will create a connection with correct string for you (you
might copy it where you need it).

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Lloyd Dupont" <Click here to reveal e-mail address> wrote in message
news:%2398Q9%Click here to reveal e-mail address...
[Original message clipped]

Reply to this message...

Lloyd Dupont

Hi Miha!

While it's a good idea, it doesn't work.
The server explorer let me only drag table whereas I would like to drag just
the server!

My purpose it to have a DB wizard to connect to the server.
It as IP/port user & pwd of the db, then there is a button to choose the
database and a button to choose the tables....

I have problem with the database finder button....
Any tip on how to implement it?

I will revert to my previous code (Database=; ...) but it will be nice tyo
know how to do that cleanly...

"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:Click here to reveal e-mail address...
[Original message clipped]

Reply to this message...

Miha Markic [MVP C#]

Lloyd,

Check out sp_databases stored procedure, or or
OleDbConnection.GetOleDbSchemaTable table.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Lloyd Dupont" <Click here to reveal e-mail address> wrote in message
news:Click here to reveal e-mail address...
[Original message clipped]

Reply to this message...

	System.Data.OleDb.OleDbConnection
	System.Data.SqlClient.SqlConnection
	System.Data.SqlClient.SqlException

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

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

	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