DB2 Express - cannot create database!

Sue

I just installed the free DB2 Express. I am going through the wizard
and I am unable to create a database. I keep getting the error "create
database path does not exist". The log file says "An attempt is made
to create a database on a path without first enabling this feature
using db2_create_db_o n_path registry variable. Please enable this
first and try again. When I tried to set this to yes, I get another
error message "no database connection exists".

Help please, I've tried everything and nothing works. I have used DB2
UDB Workgroup edition before and did not have any such problems.

Thank you very much.

Apr 25 '07 #1

Subscribe Reply

8969

Serge Rielau

Sue wrote:

I just installed the free DB2 Express. I am going through the wizard
and I am unable to create a database. I keep getting the error "create
database path does not exist". The log file says "An attempt is made
to create a database on a path without first enabling this feature
using db2_create_db_o n_path registry variable. Please enable this
first and try again. When I tried to set this to yes, I get another
error message "no database connection exists".

Help please, I've tried everything and nothing works. I have used DB2
UDB Workgroup edition before and did not have any such problems.

Thank you very much.

Does any of this help?

---------------
DB2_CREATE_DB_O N_PATH

* Operating system: Windows
* Default=null, Values: YES, or NO
* Set this registry variable to YES to enable support for the
use of a path (as well as a drive) as a database path. The setting of
DB2_CREATE_DB_O N_PATH is checked when a database is created, when the
database manager configuration parameter DFTDBPATH is set, and when a
database is restored. The fully qualified database path can be up to 215
characters in length.

If DB2_CREATE_DB_O N_PATH is not set (or is set to NO) and you
specify a path for the database path when creating or restoring a
database, error SQL1052N is returned.

If DB2_CREATE_DB_O N_PATH is not set (or is set to NO) and you
update the DFTDBPATH database manager configuration parameter, error
SQL5136N is returned.
CAUTION:
If path support is used to create new databases, applications
written prior to Version 9.1 using the db2DbDirGetNext Entry() API or an
older version of it, might not work correctly. Please refer to
http://www.ibm.com/software/data/db2/udb/support/ for details on various
scenarios and the proper course of action.

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Apr 26 '07 #2

Similar topics

2028

Visual Studio 2003 And SQL Server Express

by: Belee | last post by:

1. I am using sql server express and visual studio 2003. I have been able to create the connection to the database in server explorer but cannot update table definitions. It gives an error that I may need a patch or changes would not be saved. So I have to do the table changes in SQL Express Management studio. 2. When I modify a stored procedure in the management studio of sql express, it does not update but rather saves it the...

C# / C Sharp

1560

Access versus MSDE versus SQL Server Express

by: Paul H | last post by:

I have never used the MSDE as a backend for a database but I am considering dipping my foot in the SQL waters and trying out SQL Server Express. I remember that the MSDE had certain limitations (limited users?) that stopped me from using it. Does SQL Server Express have similar limitations that would deter me from using it as a backend and maybe eventually getting my head around Visual Studio Express with a view to moving away from Access...

Microsoft Access / VBA

3787

Why choose SQL Express over Access?

by: ljh | last post by:

Why would you choose SQL Express (which requires an installed application to work) over the simplicity of an Access database which has no dependencies?

.NET Framework

2437

SQL Express or MDB - opinions please

by: Miro | last post by:

Ok I have been slowely - and ever so slowely teaching myself VB.net Currently I have created an MDB file by code, and added fields to the MDB file by code. I like this solution because, ( im assuming ) if I create an EXE and I load an MDB file, I can see if certain fields are there, and if not add them. Kinda like an Update that is imbeded into the EXE, so you dont always have to create an Install shield.

Visual Basic .NET

5795

VB Express SQL Express Remote Connection

by: cleo | last post by:

I am migrating from VB6/Access to Visual Basic and SQL Express. I have success writing test code on my local machine and am now setting up tests for deployment to a server. I have installed SQL Express on a Windows 2003 Server. I can connect and create databases on the Remote Server from my local machine using SQL Management Express, so I know Remote Access is working. However, I am unable to connect using a connection string within...

Visual Basic .NET

14433

Problem with "locked" SQL Server Express database files - Please help!

by: Glen Buell | last post by:

Hi all, I have a major problem with my ASP.NET website and it's SQL Server 2005 Express database, and I'm wondering if anyone could help me out with it. This site is on a webhost (WebHost4Life) and was running fine and dandy, until I decided I needed to add some additional stored procedures to the database.

ASP.NET

6225

Permission to access dB problem in SQL Server 2005 Express from inside VS2005

by: raylopez99 | last post by:

I am trying to program a database from inside C++.NET via Visual Studio 2005 using the ADO.NET set of classes, but this I believe is a SQL Server 2005 Express permissions question under Windows XP Professional OS. In another thread, http://tinyurl.com/373lzx, I was able to open a database successfully using VS2005 (thanks to a suggestion by Erland Sommarskog). But subsequent to this I played around with the local policy permissons...

.NET Framework

2965

by: RichGK | last post by:

How do I actually setup what users have access in SQL Express? Please note that I am a SQL Server administrator so am comfortable with creating id's etc in the full product. I cannot however find out how to do this with Express. In my windows application I have created the SQLE database and it's settings are as the following. Integrated security = true;

C# / C Sharp

1538

Cannot connect to database using VB 2005 Express

by: ramaswamynanda | last post by:

Hello, I am developing a windows application in Vb 2005 Express and Sql Server express I have created a database in sqlserver called "mydb" I want to connect the desktop VB application to this and create two screens, say employees and projects This seems to be very non-intuitive I need a design time connection as I am using DataGridViews, in my application My screens are not updatting data in the main database. VB keeps asking me, if...

Visual Basic 4 / 5 / 6

8838

Changing the language in Windows 10

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,...

Windows Server

9339

The easy way to turn off automatic updates for Windows 10/11

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,...

Windows Server

9256

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

8260

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6081

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4713

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

4887

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3322

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2225

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General