Thread: not possible to create a database
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?
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