Thread: not possible to create a database

not possible to create a database

From
vincent.richomme@ratp.fr
Date:

Hi,

 

I have recently installed the PostGreSQl 8.0.1 on windows XP to migrate from MySQL.

With my old application before to store data in the base I check it exists and so I do the following :

 

m_strConn.Format("DRIVER={PostgreSQL};\

                  SERVER=127.0.0.1;\

                  PORT=5432;\

                  UID=root;\

                  PWD=123456");

 

 

// Try to open default database (dbBornes)

bRet = m_pDb.Open( m_strConn + _T( ";Database=dbBornes" ) );

 

//Database doesn’t exist so create it

if ( !bRet){

bRet = m_pDb.Open(m_strConn);if (!bRet) goto lblExitOnErr;   ß--------------- ERROR 80040e4e

      bRet = m_pDb.Execute( _T("CREATE DATABASE dbBornes;") );if (!bRet) goto lblExitOnErr;

}

 

This code works fine with MySQL and ACCESS but failed with PostGreSQL.

When

Any suggestions?

Re: not possible to create a database

From
Christof Glaser
Date:
Hi Vincent,

Am 04.02.2005 um 11:19 schrieb vincent.richomme@ratp.fr:

> With my old application before to store data in the base I check it
> exists and so I do the following :
>
> m_strConn.Format("DRIVER={PostgreSQL};\
>                   SERVER=127.0.0.1;\
>                   PORT=5432;\
>                   UID=root;\
>                   PWD=123456");
>
> // Try to open default database (dbBornes)
> bRet = m_pDb.Open( m_strConn + _T( ";Database=dbBornes" ) );
>
> //Database doesn’t exist so create it
> if ( !bRet){
>   bRet = m_pDb.Open(m_strConn);if (!bRet) goto lblExitOnErr;

You must connect with a database name. If you want to create a new
database, you should connect to 'template1'.

>   bRet = m_pDb.Execute( _T("CREATE DATABASE dbBornes;") );if (!bRet)
> goto lblExitOnErr;

Best regards,

Christof Glaser
--
--      gl.aser   .   software engineering  .   internet service
-- Doelitzer Strasse 37  .  D-04277 Leipzig   .   fon +49-341-303 20 51
-- http://gl.aser.de/ .  sms +49-177-779 28 43 . fax +49-0341-303 20 52