New SQL Express Installation

I just installed SQL Express in my workstation but when I try to create and ODBC connection, the new server does not show in the drop down. Do you have any tips...? Thanks.

If you are using down-level clients through MDAC, you'll need to enable TCP/IP in order to connect to SQL Express, even on the local computer. If you're additionally trying to connect from a remote computer, you'll need to consider turning on SQL Browser and open up your Firewall.

Check out http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx for information about this.

Mike

|||

Why ODBC out of curiousity?

Why not connect with ADO 2.8? or ADO.net using the new sql native client?

Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=myDatabaseName;Data Source=.\Sqlexpress

|||If the server is not the default instance (if you installed it as named instance) you may have to type in the instance name manually.