473,848 Members | 1,559 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MSDE 2000 Connection String

Hi,

I have a simple asp.net application running ok on my WinXP development
server with SQL Server Express 2005 installed locally. After moving to
the live server (Win 2000 server with MSDE 2000 installed locally),
it's giving me the 'SQL Network Interface Error (error 25): connection
string is not valid'.

So far, i've tried using the following connection string in my
web.config file:

connectionStrin g="Data
Source=.\SQLEXP RESS;AttachDbFi lename=|DataDir ectory|\registr ation.mdf;Integ rated
Security=True;U ser Instance=True" providerName="S ystem.Data.SqlC lient"
(this works fine on the development server)

connectionStrin g="Data Source=(local); Initial
Catalog=registr ation;Integrate d Security=SSPI"

Does anyone know how to solve this issue? Or is it just not possible to
use Sql Server .NET Data Provider (System.Data.Sq lClient) that I used
in the development server to connect to a MSDE 2000 database on the
live server? Originally I wanted to use SQL Server Express 2005 on the
live server, but I didn't enough memory on it, so I figured I tried
MSDE 2000 first to see if I can get the right connection string.

Any help would be appreciated.

THanks,

hfk0

Mar 15 '06 #1
2 4238
The connection string will depend on what type of authentication you are using.

See :
http://www.codeproject.com/cs/databa..._in_csharp.asp

http://support.microsoft.com/default...b;en-us;321698

http://www.functionx.com/csharp/adonet/Lesson02.htm

Basically, the same connection strings valid for SQL Server are good for MSDE.

Check http://www.connectionstrings.com for SQL Server and MSDE connection strings.


--
Juan T. Llibre, asp.net MVP
aspnetfaq.com : http://www.aspnetfaq.com/
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
=============== =============== =====
"hfk0" <he**@infoventu res.com> wrote in message
news:11******** **************@ i40g2000cwc.goo glegroups.com.. .
Hi,

I have a simple asp.net application running ok on my WinXP development
server with SQL Server Express 2005 installed locally. After moving to
the live server (Win 2000 server with MSDE 2000 installed locally),
it's giving me the 'SQL Network Interface Error (error 25): connection
string is not valid'.

So far, i've tried using the following connection string in my
web.config file:

connectionStrin g="Data
Source=.\SQLEXP RESS;AttachDbFi lename=|DataDir ectory|\registr ation.mdf;Integ rated
Security=True;U ser Instance=True" providerName="S ystem.Data.SqlC lient"
(this works fine on the development server)

connectionStrin g="Data Source=(local); Initial
Catalog=registr ation;Integrate d Security=SSPI"

Does anyone know how to solve this issue? Or is it just not possible to
use Sql Server .NET Data Provider (System.Data.Sq lClient) that I used
in the development server to connect to a MSDE 2000 database on the
live server? Originally I wanted to use SQL Server Express 2005 on the
live server, but I didn't enough memory on it, so I figured I tried
MSDE 2000 first to see if I can get the right connection string.

Any help would be appreciated.

THanks,

hfk0

Mar 15 '06 #2
Try http://www.connectionstring.com for your answer
Mar 15 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
5500
by: Nathan Sokalski | last post by:
I recently downloaded and installed (hopefully correctly) MSDE 2000 Release A. I previously, and still do, have the version of IIS that comes with XP Professional installed on my computer. I wanted MSDE 2000 Release A so that I could do database access using ASP from my websites, which are on my computer. When I went to my first test website, I recieved the following error: Error Type: Microsoft OLE DB Provider for ODBC Drivers...
10
3860
by: noname | last post by:
MSDE 2000 Release A installed under windows 2000 pro will not communicate with SQL Server Manager nor MS Access on peer computer. Can someone help? Have set DISABLENETWORKPROTOCOLS=0 at install time. Install log shows installation successful.. Control Panel> Admin Tools> Services section shows SQL server instance running.
3
6127
by: *no spam* | last post by:
I want to move my Access 2K database into MSDE. The Access Upsizing Wizard crashes (a known bug wi A2K), so I'm using the following suggested method: Access --> New --> Project (Existing Database) This asks for the name of the .adp file to create and then launches into the Data Link Properties dialog box (so far so good) I select my MSDE server from the drop-down, enter the sa account & passwd, attach a database file and try to...
1
1498
by: farqua | last post by:
I've finally got MSDE 2000 sp3a to install on my PC by turning on the "Server" service. Duh! Unfortunately, I can't get it to connect to the server when I try to upsize a tables in an mdb database file. The SQL Server Manager icon is running and I am able to start the SQL server. I get a dialog box message about unknown procedure or something like that. I am running a stand alone PC with a DSL connection. I am trying to run the server...
12
2328
by: Dan V. | last post by:
Since an ASP.NET/ADO.NET website is run on the server by a single "asp_net worker process", therefore doesn't that mean that even 50 simultaneous human users of the website would appear to the database backend as a single user. Therefore, wouldn't switching our Access (actually Jet 4.0 OLEDB) database backend on our ASP.NET/ADO.NET website to an MSDE backend be an advantageous change to make while NOT limiting the number of simultaneous web...
4
1556
by: Jesus Carmona | last post by:
Good day everyone; I'm having a program for a PocketPC that was working great, this program connects to a database (MSDE) but when I updated the MSDE to SP3a everything blew-up... There is no way I can connect to my database anymore. The funny part is that if I connect to a full MS-SQL Server the program works just fine. Do I need to change anything in my connection string so I can connect to MSDE SP3a? Any Ideas of how I can solve this...
3
1349
by: David Lozzi | last post by:
Howdy! I have a question for all you smarties... I have a ASP.Net application running on Windows 2000 Professional and MSDE, same box. While running the application, users will randomly receive a too many connections error or even a simple Page cannot be displayed. I know some of the limitations of MSDE and have managed to fudge my way around them, but what about Win2kPro IIS? I'm thinking it won't let me a host an active application on...
1
1760
by: RobOfTage | last post by:
Hi, I've recently downloaded MSDE and have tried to create a small app to test the connection. It fails at the Connections Open() method with an error indicating an invalid server version. I'm running on a standalone PC with Windows XP and the .NET 2003 Standard edition. The connection string I used was :- Dim objConnection As SqlConnection = New SqlConnection("server=(local);database=C:\SQL Server 2000 Sample Databases\pubs;user...
11
6256
by: HC | last post by:
I posted this in one of the VB forums but I'm starting to think it might be more appropriate to have it here, since it really seems to be a SQL server (MSDE/Express 2005) problem: Hey, all, I have a problem with queries against a SQL server instance that I just found and is causing me fits. I hope someone can point me in the right direction, please. TIA. Basically, I got a Vista OS machine to test my VB6 app on it as some
0
9892
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9735
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10661
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10718
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10347
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7889
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5731
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
4134
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3172
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.