This is a discussion on Re: not possible to create a database within the pgsql Interfaces odbc forums, part of the PostgreSQL category; --> Hi Vincent, Am 04.02.2005 um 11:19 schrieb vincent.richomme@ratp.fr : > With my old application before to store data in ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org |