|Subject||Re: [firebird-support] Re: Database already exist when testing example - api1.c|
|Author||Yu Ang Tan|
Thanks for the reply,
I had to make sure, because I didn't know that I have to modify the examples before trying them.
It seems like I have difficulty with the isc_attach_database() as well. Here is my test code:
char user = "sysdba";
char password = "pass123";
* Create DPB
char dpb_buffer, *dpb, *p;
/* Construct the database parameter buffer. */
dpb = dpb_buffer;
*dpb++ = isc_dpb_version1;
*dpb++ = isc_dpb_num_buffers;
*dpb++ = 1;
*dpb++ = 90;
dpb_length = dpb - dpb_buffer;
* Connect to the new database and create a sample table.
/* newdb will be set to null on success */
if (isc_attach_database(status, 0, new_dbname, &newdb, 0, dpb))
if (pr_error(status, "attach database"))
and I am getting this error:
PROBLEM ON "attach database".
Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
I don't think my sysdba login is undefined, since I have set the password using
# dpkg-reconfigure firebird2.5-superclassic
Any help at this stage would be greatly appreciated, as I am not sure how to move on from here.
Thanks in advance.