Connect To Sql Express 2005 Through Code

Feb 1, 2007

Hi All:

I'm new to using sql express 2005 as the database, so I apologize if my question is very basic.

I can connect to db through sql mngmt studio, but I don't know how to connect through application code. The authentication mode is windows. I'm having trouble with the provider in the application code.

Can someone please tell me where I can find more detailed information on available providers for sql express?

Thanks for any help, as I'm against a tight deadline.

View 6 Replies


ADVERTISEMENT

Cannot Connect W/ Java App But Can Connect W/ .Net App - SQL Server Express 2005

Dec 12, 2006

I'm having a problem connecting with a Java application but I CAN connect using my .Net application - the user name and password are the same for both (using the same database on SQL Server Express 2005).

The error I get is: "com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "CORNERS" requested by the login. The login failed." An interesing note - I get the same message if the database is not running.

SQL Server Express 2005 is installed in mixed mode.

Here is my connection string in the .Net appplication: <add key="connectString" value="Server=(local);UID=sa;PWD=myPasswd;Database=CORNERS" />.

These are my values in my Java app web.xml -

<init-param>
<param-name>DBDriver</param-name>
<param-value>com.microsoft.sqlserver.jdbc.SQLServerDriver</param-value>
</init-param>
<init-param>
<param-name>DBURL</param-name> <param-value>jdbc:sqlserver://localhostsqlexpress:1055;databaseName=CORNERS</param-value>
</init-param>
<init-param>
<param-name>DBUser</param-name>
<param-value>sa</param-value>
</init-param>
<init-param>
<param-name>DBPwd</param-name>
<param-value>myPasswd</param-value>
</init-param>.

And yes, the port is 1055 - I checked to find it.

I am using Microsoft SQL Server 2005 JDBC Driver 1.0 (sqljdbc_1.0.809.102).

Does anyone have any idea what is wrong so that the login fails in the Java application but works in the .Net application?

View 7 Replies View Related

I Can No Longer Connect To My SQL Server Express 2005 From Manager Studio Express

Sep 28, 2006

Everything was working fine. I have been able to connect using windows authentication. Then, I went into the ODBC manager to add a data source and it failed to connect so I went back into the Server management studio to modify users. After doing this I now get an error when I try to conenct the management studio to the SQL server.

I wasn't modifying the login for my windows account that I normally use, I was modifying a different one, however I now get the message "An error has occured while establishing a connection to the SQL server. This kind of problem can ocure because the default behavior of the server does not support all connection methods" blah blah.

Does anyone know how I can attach to the server? Or, do I need to somehow remove the server and create a new one? How would I do that?

Thanks in advance for any input.

View 1 Replies View Related

Can't Connect To SQL 2005 Express With SQL Server Management Studio Express

Mar 10, 2006

I've seen the following error posted when people try to connect to their server via their applications but didn't see anyone having problems when trying to connect with SQL Server Management Studio Express. Am I missing something here? This is the error:<<An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)(Microsoft SQL Server, Error: 2)>>The server is not remote so I don't see why I need to enable remote connection. I am also using the default connection settings.

View 3 Replies View Related

Cannot Connect To SQL Server 2005 Express With Management Studio Express

Feb 24, 2007

On my home machine without permanent network connections enabled, I cannot get the Management Studio connect to the database server. Always get this error:



Cannot connect ot MPLIAMSQLEXPRESS

Additional Information:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, erro: 26 - Error Locating Server/Instance Specified)(Microsoft SQL Server)



I have used the SQL Surface Area Configuration Tool to reset the defaults to allow remote connections, stopped and restarted the server, but still get the same message.

Please help.

View 12 Replies View Related

Not Able To Connect To SQL Server Express From VWD 2005 Express

Jan 16, 2008


Hey all! I am new in this form and also new with the SQL serve. I have installed that free express edition of SQL server 2005 and when i am trying to connect to server from my C#.net application i am not able to do it and when i am trying to degug it gives me the error that is the user is not SQL thrusted user. I am able to connect directly thru SQL server using this userid and password but not thru VWD 2005 Express application.

I have read online that so many people are having that problem. so is it the problem of swl server Express edition or do i have to make some setting to connect to the application.

Please please please please someone guide me . I am stuck here in the beginning only. I would really appreciate it.

the code that i wrote is here:----

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{



protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

}

}
protected void Submit_Click(object sender, EventArgs e)

{

String querry;

SqlDataReader dbread;

try

{

SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["Conn1"]);

SqlCommand comm = new SqlCommand();

conn.Open();

querry = " Select password from login where userId='" + TxtUser.Text + "'";

comm.CommandText = querry;

comm.Connection = conn;

dbread = comm.ExecuteReader();

dbread = null;

if (dbread.HasRows)

{

while (dbread.Read())

{

if (dbread["password"].ToString() == Txtpwd.Text)

{

Response.Redirect("home.aspx");

}

}

Response.Write("Your Password Doesn't Match");

}

else

{

Response.Write("Your User Name Is Wrong");

}

conn.Close();

}

catch (Exception ex)

{

Response.Write(" This is an Error - " + ex.Message );

Response.End();

}



Thanks,
Komal

View 1 Replies View Related

Can't Connect To The Database Using C# Express And SQL 2005 Express

Jul 4, 2007

Hi

I'm trying to connect to the northwind database thats available online using c# and SQL 2005, both express editions. i used the following command



sqlcmd -S yourServerSQLExpress -E -iinstnwnd.sql



and it connects to the northwind database. but when it comes to the part where i have to select the data source, there are only 2 available - microsoft access database file, microsoft SQL server database file. but according to the microsoft books that i'm following, there should also be a "micosoft SQL server" in the data source list. because of this i cant connect to the database.

Please help...



thank you

View 3 Replies View Related

Insert Images In SQL 2005 Express DB, Using C# Code For Asp.net 2.0 (VS 2005)

Aug 31, 2006

Help!

I found about a dozen samples and articles in the net about inserting images in a sql database, but they were either using VB, or asp only or SQL 2000 and although I tried them all, none worked...
Can you help me by posting some code on how to insert images in SQL 2005, using C# in Visual Studio 2005 (asp.net 2.0)

Thanks.

View 11 Replies View Related

Cannot Open SQL Server 2005 Express From C#.Net 2005 (using Code)

Mar 15, 2008


can anybody help me.

I am getting an sql Server 2005 connection error from c#.net 2005.

following is the error
--------------------------------------------------------------------------------------------

{"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"}

---------------------------------------------------------------------------------------------


i have changed the default settings. local and remote connection are enabled.

following are the code i am using in C# .Net 2005
---------------------------------------------------------------------------------------------------------------
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;


SqlConnection conn = new SqlConnection("server=localhost; user id= sa; pwd =; Initial Catalog=testdb;");

---------------------------------------------------------------------------------------------------------------


when i connect through the c# wizard, everything is perfect.

thanks in advance
sam alex

View 10 Replies View Related

Visual Studio 2005 Unable To Connect To SQL Server Express 2005

May 26, 2008

Hi,
I have VS Pro 2005 and SQL Server Express 2005 installed on an XP Pro machine. When using VS 2005, in the 'Server Explorer' window I can see and attach to two SQL Server databases that I have set-up. But if I attempt to access the same databases from withn the 'Solution Explorer' window I get the following dialog box message,

"
Required Component Missing (Dialog box heading)

Connections to SQL Server Files (*.mdf) require SQL Server Express to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251
"

I have uninstalled and then reinstalled both VS 2005 and SQL Server Express twice but it has helped.

I don't understand why I'm getting this error because all of the server configuration tools and connection utilities seem to work fine but VS say's that SQL Server Express is not installed.


Thanks,

CLN

P.S.
I had another application that required MSDE 2000A to be installed. When I removed the other application I also removed MSDE 2000A and that's when the problem began.

View 3 Replies View Related

Can't Connect To Sql Server 2005 Database Using Vb 2005 Express

Nov 21, 2006

I've used Sql Server 2000 and Visual Studio 2003 for a few years. I've started a new position and they have access to Sql Server 2005 Standard and Visual Basic 2005 Express which I'd like to use for a new project. So I installed Sql Server 2005 and then VB 2005 Express on my workstation. I didn't choose the Sql Server option for VB Express because I already had Sql Server 2005 Standard installed with a simple database created. I created a simple vb project that justs connects to the database but I get the following error.


Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0000, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
I looked at permissions in the database and it looks ok. I'm the db owner and I'm using Windows Auth. My connection string is

"Data Source=MySystem;initial catalog=AdventureWorks;integrated security=true;"

I thought I'd look at the starter kit to get some ideas about what the problem is, but when I started the movie starter kit project, it was upset that I didn't have Sql Server 2005 EXPRESS installed. Yea, but I do have Sql Server 2005 Standard installed.
Any help will be greatly appreciated. Thanks.

View 6 Replies View Related

How To Use SQL Svr 2005 Express In Excel 2003 VBA Code?

Jun 23, 2006

Hello,

how can I use SQL Svr 2005 Express as database engine in background through VBA code in Excel 2003?

I want to CREATE and DELETE tables and SELECT, INSERT and UPDATE data. Is it possible to use ADO or other database objects to get in contact with SQL Svr 2005 Express?

Thanks a lot.

Christian

View 4 Replies View Related

Can't Connect To SQL Express 2005

Apr 14, 2006

I have a web app running on a laptop (for demo purposes) with the following connect string:

"datasource=<machine name>SQLExpress;initial catalog=BlueTarp;User ID=sa;Password=xxx"

I can connect to this instance using both oSQL or sqlcmd and can select from the tables within BlueTarp, but my web app won't connect, and I can't figure out why!!

When I installed SQL Express, I used a named instance, called "SQLExpress".

I'm using mixed mode authentication.

One strange thing is that I can connect to either SQLExpress or MSSQLSERVER instances, but they appear to be the same instance -- I can use bluetarp in both.

when I use SQLExpress for instance name in web.config I get "SQL Server does not exist or access denied"

when I use MSSQLServer for instance name in web.config I get "Invalid connection"

And in fiddling with the web.config, I somehow did something to get a machine.config error, something like "machine.config couldn't be loaded because of an unloaded appdomain".

It's driving me nuts because I've spent a good 40 hours on this stupid problem, throwing the whole margin down the toilet.



Does anyone have any ideas?

Thank you,

Aarron









View 3 Replies View Related

Cannot Connect To The SQL 2005 Express

Oct 12, 2006

I created test project and want to use SQL 2005 database inside.

1. I created Test database with DEFAULT rights

2. I go into server explorer, press Add Connection. Shows message box for connecting to the server: <PCNAME> using windows authntification.



But NO database allowed to view :(.

Which setting should be set for SQL server database to i could connect and work with it?

View 8 Replies View Related

Cannot Connect Ot SQL 2005 Express

Sep 27, 2006

Hallo,

i developed a little web-application.
I'm using a SQL 2005 Express edition db but i cannot connect.

i tried the connection strings from connectionstrings.com but unfortunately they dont list connectionstrings for SQL Express 2005.

Thats the one i guess it should work with:

Provider=SQLOLEDB;Data Source=SQLServerNameSQLEXPRESS;Initial Catalog=Lizenzportal;Integrated Security=true

I always receive following error:

No error information available: DB_E_ERRORSOCCURRED(0x80040E21)

Hope you can help me with this issue.

View 4 Replies View Related

Can't Connect To SQL Express Or SQL 2005 From C# Web App And IIS

Sep 18, 2007

Hi all,
I'm new to this forum and haven't worked with SQL Server for a couple of years. Now it seems I'm getting back into it. I have SQL Express and SQL 2005 installed on an XP sp2 machine with IIS 5.1. I have a C#/ASP.NET web app in Visual Studio 2005 that keeps getting an error on attempting to connect (SqlConnection object). It's a generic error saying a probable cause is SQL Express default setup not allowing remote connections. Remote connections are turned on for both TCP and UDP. I can connect from within a small C# windows application using the same uid and pwd, so I suspect it's something related to IIS talking to SQLExpress. I would appreciate any help on other things to check. I am also fairly new to using IIS in the development environment.
Thanks

View 5 Replies View Related

Can't Connect To Sql Express 2005

Nov 29, 2006

I have an very big application written in vb6 running on msde 2000. I tried to change it to sql express 2005 and I cannot connect to the database. I wrote a sample app in vb6 using adodc and it works fine. From the other app I get no connection. I copied the same connection string!. I do not use the adodc control.I connect with a connection object.I have enabled pipes and tcp/ip. Any ideas or suggestions more than welcome.

View 10 Replies View Related

VS 2005 Cannot Connect To SQL Server 2005 Express

Feb 9, 2007

I've installed, with default settings, VS 2005 and Server 2005 Express and cannot get VS2005 to connect. This is the error:

Unable to open the physical file "..path...mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process."

I shutdown Server 2005 but that didn't change anything. Any ideas?

Thanks.

View 4 Replies View Related

Cannot Connect SQL Server 2005 Express With VWD 2005

Feb 16, 2007

I have installed MS Visual Web Developer 2005 Express Edition on my Notebook (WinXP Pro SP2). And it's working fine. Then I tried installed SQL Server 2005 Express Edition SP1. There is no error during installation and it seems to be working as I can see the SQL Server (MSSQLServer) service is running. As SQL server configulation manager., the protocal shared memory , named Pipes and TCP/IP are enabled.

But when I want to add connection using VWD 2005 by pointing to datasource (MS SQL Server database file and selecing file from .mdf file from SQL sample database file. Then test connection, I got a error that
"An error has occurred while establishing a conneciton to the server. when connecting to SQL server 2005, this failure may be casued the the fact that under the default settings SQL server does not allow remote connections. (provider: SQL Interfaces, error: 26- Error locating server/instance specified)

Can you please advise what the missing part of my configulation ?

Thanks

View 4 Replies View Related

Connect To SQL Express 2005 By IP Address

Aug 31, 2007

Hi,

I am trying to connect to SQL Server Express 2005 from a remote connection through the internet using an IP address in a string like this;

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

the error I am getting is this

A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)


anyone have any suggestions or maybe another way to achieve this type of connection?

Thanks,

Razzle

View 1 Replies View Related

Can't Connect To SQL Server(SQL Express) In VS 2005

Feb 9, 2007

In SQL Server Configuration Manager I apparently have a server namedSQL Server(SQL Express) running - however, in VS 2005 when I try to'add connection' (right click in server explorer) I cant see it- Iwould like to see it so I can create a new SQL server database.Any help much appreciated- trying to learn web programming usingvb.net, asp, html, vbscript and SQL server.D

View 2 Replies View Related

Can't Connect To SQL Server 2005 Express

May 9, 2007

PLEASE HELP ME



I ran the upsize wizard on one of my databases to SQL Server 2005 Express. I can connect to it just fine. I have 3 test users and they cannot. They get the following:

Connection failed:

SQL State: '01000'

SQL Server Error: 11004

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connt()).

Connection failed:

SQL State: '08001'

SQL Server Error: 6

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.



I tried adding the SQL Server to 1 users System DSN, but I got this message:

Connection failed:

SQL State: '01000'

SQL Server Error: 53

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connt()).

Connection failed:

SQL State: '08001'

SQL Server Error: 17

[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.



What am I doing wrong???

View 3 Replies View Related

Cannot Connect With JDBC To Express 2005

Feb 7, 2007

Hi all,

I try to connect with a java application to a freshly download SQL server express 2005, but I cannot anything I do.

If I try with the following string "10.0.0.82:1433;databaseName=flavio;user=f.palumbo;" I get this message :

java.sql.SQLException: Impossibile eseguire l'accesso per l'utente 'f.palumbo'. L'utente non è associato a una connessione SQL Server trusted.

If I try with this string "localhost:1433/flavio" I get this message :

com.microsoft.sqlserver.jdbc.SQLServerException: Il numero di porta 1433/flavio non è valido.

So I'm getting crazy to find out a solution ... can somebody help me?

Thanks a lot

Flavio

View 3 Replies View Related

Can't Connect To MySQL 2005 Express

Jun 30, 2006

I'm trying to upsize an Access database to SQL 2005 Express. When I follow the wizard and I've tried all ways of connecting to the database I get the following error

Connection failed
SQL State '01000'
SQL Server Error 53
[Microsoft] [ODBC SQL Server Driver][DBNETLIB] ConnectionOpen()).
Connection failed
SQL State '08001'
SQL Server Error 17
[Microsoft] [ODBC SQL Server Driver][DBNETLIB] SQL Server does not exist or access denied

I've tried using local host and typing the exact server connection string from the SQL Express Management tool and nothing is working

How come I can't do this? Everyone says this is easy and straight forward -- not for me.


View 1 Replies View Related

Visual C# Cannot Connect To SQL 2005 Express

May 2, 2006

Hi,

In Visual C# Express, I right click on my solution and select Add, new item, and then choose an SQL database. I get the error:

Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251

I completely uninstalled all of the beta Express products I had and reinstalled SQL Server 2005 Express first, which seems to have installed ok. Then I reinstalled Visual C# Express, but still have the same problem.

This is happening on my home pc running Windows XP Home sp2. I successfully got sql working with VC# Express at work on my WinXP Pro system.

Thanks a bunch!

Ron

View 5 Replies View Related

Is It Possible To Execute The T-Sql Code Of Common Table Expressions In VB 2005 Express?

Jan 2, 2008

Hi all,
I have the following T-SQL code of Common Table Express (CTE) that works in the SQL Server Management Studio Express (SSMSE):

--CTE.sql--

USE ChemAveRpd

GO

WITH PivotedLabTests AS

(

SELECT LT.AnalyteName, LT.Unit,

Prim = MIN(CASE S.SampleType WHEN 'Primary' THEN LT.Result END),

Dupl = MIN(CASE S.SampleType WHEN 'Duplicate' THEN LT.Result END),

QA = MIN(CASE S.SampleType WHEN 'QA' THEN LT.Result END)

FROM LabTests LT

JOIN Samples S ON LT.SampleID = S.SampleID

GROUP BY LT.AnalyteName, LT.Unit

)

SELECT AnalyteName, Unit, avg1 = (abs(Prim + Dupl)) / 2,

avg2 = (abs(Prim + QA)) / 2,

avg3 = (abs(Dupl + QA)) / 2,

RPD1 = (abs(Prim - Dupl) / abs(Prim + Dupl)) * 2,

RPD2 = (abs(Prim - QA) / abs(Prim + QA)) * 2,

RPD3 = (abs(Dupl - QA) / abs(Dupl + QA)) * 2

FROM PivotedLabTests

GO

===========================================
How can I execute this set of the CTE.sql code in the VB 2005 Express via the Stored Procedure programming?

Please help and respond.

Thanks in advance,
Scott Chang

View 1 Replies View Related

Finding SQL 2005 Standard Edition Code Which Will Break In Express

Feb 11, 2008

Hi,

We're currently developing an application against SQL Server 2005 Standard Edition. Recently, we've started to consider deploying certain installations against SQL Server Express. We're particularly worried about some stored procedures we've written taking advantages of features which will not be available in SQL Server Express, is there a simple compliance tool or such that we can scan our existing tables/functions/stored procedures/etc with to identify potential pitfalls when running on SQL Server Express?

Thanks,
Jeremy

View 4 Replies View Related

How To Get A Web Application To Connect To SQL Server 2005 Express

Dec 12, 2006

All,
I'm a newbie here so forgive me if I have missed something completely obvious.
 I have bought a shopping cart script of a well known company (Evolve Merchant 5) and I wish to set it up locally on my development server, I created a virtual directory, set the web application up and get the asp pages to display perfectly. However, in the configuration file (global.asa & web.config) for the application it reguests information to be provided: <add key="DBName" value="Database name" />
<add key="DBServer" value="IP address of server" />
<add key="DBUserName" value="User name" />
<add key="DBPassword" value="password" />
<add key="AltPassword" value="password" />


 What I can't determine is what the SQL Server 2005's IP address is? the pages of this application show when I type http://localhost/catalogue into IE, so I presumed the server address would be the IP of localhost, when typed ping localhost into command promt it gives me 127.0.0.1, but when I enter this into the config file and try to load the application it just hangs and then eventually says:
"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied./catalogue/global.asa, line 54"
I have created a new database in SQL Express called: merchant509 and restored the tables to it as the manufactures help files state, I created a new login called shop which uses SQl authentication, so as I can provide a password. So the settings should look like this:
  <add key="DBName" value="Database name" />
<add key="DBServer" value="127.0.0.1" />
<add key="DBUserName" value="shop" />
<add key="DBPassword" value="1684" />
<add key="AltPassword" value="1684" />
 
But it doesn't work, does anyone know what i have done wrong?? the SQL server is runnign on the same computer as I am trying to access it from, it is set to accept all forms of comunication i.e. TCP/IP etc.. in the server configuration manager the IP address part of TCP/IP in protocols shows IP1 as 192.168.2.2 active yes enabled yes, and IP2 as 127.0.0.1 active yes and enables yes, I have tried the 192.168.2.2 and this gives the same errors, this is my registed IP on my home network.
 I'm now stumped, I haven't a clue what else I can try, I would be very greatfull if anyone has any ideas.
Regards,
Daniel Coates
 
 
 
 

View 1 Replies View Related

[Express 2005] Unable To Connect To Datasource

Aug 21, 2006

I've never used SQL Server before. I installed VB 2005 Express (I've been working with VB since I was 16), and SQL Server 2005 Express.

I installed the server with all the default settings and created a small database to handle customer information (a remake of some Access and Oracle databases I've made before).

I'm told, however, each time I try to connect to the database via VB, that SQL Server isn't accepting remote connections...

Remote? It's on a local computer. So is VB...what is going on here? Is there a setting I've missed?

Warren Ayen
IBM

View 12 Replies View Related

Cant Connect To MSSQL Server Express 2005

Nov 6, 2006

Hi,

i have installed MS SQL Server Express 2005 on my local machine. Also the managment Studio. I can connect to the MS SQL Server Express 2005 with my c# programm and with the mangament studio.

I have in Windows/system32 the file ntwdblib.dll version 2000.80.2039.0. The TCP/IP and Ip Protocl are active. But i cant connect with php to the local MS SQL Server Express 2005.

My php code is:

mssql_connect('192.168.0.2,1433', 'martin', '');

I get the return code Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 192.168.0.2,1433 in c:InetpubwwwrootProjekteSkriptemssql_connection.php on line 2


Does anyone know what i made wrong or i have forgotten?

mfg martin

View 5 Replies View Related

Cannot Connect To Locally SQL Server In C#.net 2005 Express

Aug 30, 2006

I am trying to do the Chapter 1 project of Getting Started with ADO.net 2.0 Step by Step (microsoft press)...



I enter the data source configuration wizard and select database, and press next.

I then press the new connection button, and the Choose data source screen appears.

In the List are only 2 options:

Microsoft Access Database File

Microsoft SQL Server Database File.



The option they want me to choose does not appear in the list.

Microsoft SQL Server sqlclient



I tried following the instructions in this thread [http://forums.microsoft.com/msdn/showpost.aspx?postid=85686&siteid=1] where a user had a similar problem, but had no success.

I have reinstalled C#, reinstalled SQL Server Express 2005 with Advanced Tools, but neither helped.

Any help would be greatly appriciated.

sao123

View 1 Replies View Related

Connect To Sql Server 2005 Express From Coldfusion Mx 7

Jun 12, 2007

webacadie hit the nail on the head.Thanks a bunch.Finally I got coldfusion administrator to talk to Northwind database in sql server 2005 express.Basically all I did was look for TCP dynamic port under IPALL.Made a note of the number and enter it in the administrator.Also used 127.0.0.1 instead of localhost.Works like a charm.

View 3 Replies View Related

Can't Connect To SQL Server 2005 Express Through Visual C# App

Jun 11, 2006

I've installed SQL server 2005 Express and set up a database called StockData. I'm running the following code in a visual C# windows app to test the connection:

System.Data.Sql.SqlDataSourceEnumerator instance = System.Data.Sql.SqlDataSourceEnumerator.Instance;

DataTable tblSource = instance.GetDataSources();

string strSource = tblSource.Rows[0][0].ToString() + "/" + tblSource.Rows[0][1].ToString();

SqlConnection sqlConn = new SqlConnection();

sqlConn.ConnectionString = "Data Source=(local);Initial Catalog=StockData;Integrated Security=true";

sqlConn.Open();

I have verified that the SQLEXPRESS service is up and running. The strSource variable shows the machine and SQLEXPRESS instance name when I step through, so I know that the application is recognizing the service. But when I get to the "sqlConn.Open()" line, I get the following error message:

Message="An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
Source=".Net SqlClient Data Provider"
ErrorCode=-2146232060

Can anyone tell me what I'm doing wrong here? This is driving me nuts. Thanks.


View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved