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.
New SQL Express Installation
Hot Topic
- Installing SQL Server 2005 Standard on 2nd HD
- Upgrading 32 bit SQL 2000 SP4 Ent running on 64 bit Windows 2003 Enterprise to SQL2005 64 bit in place
- IE Script error (print rss report)
- BCP Handling
- Doubt in Select query
- credentials type - service credentials missing
- Snapshotting AS Cube
- Can I install sql server april ctp with sql server express already installed
- import from binary file
- Another question about Login failed, but with Windows NT Integrated security for SQL 2005
SQL Server
- replmerg.exe
- Limit in connections
- Webservice Task Input
- Error creating view from DB2 Linked Server if table has large number of rows.
- creating users in sql eypress
- Error grouping in Pivot table with OLEDB for Analysis Servises 9.0
- 2000 - Add New Report wizard blows up
- SQL Express: Deploy reports on customer side
- Management Studio Express CTP regular express replace bug?
- Timeout Report Model Wizard
New SQL Express Installation
tenorwoody85
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
Mydotnet
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
nictan