|Subject||Re: [firebird-support] Re: Database already exist when testing example - api1.c|
|Author||Yu Ang Tan|
My bad, The dpb_length parameter was set to 0, hence the problem.
if (isc_attach_database(status, 0, new_dbname, &newdb, 0, dpb))
if (isc_attach_database(status, 0, new_dbname, &newdb, dpb_length, dpb))
Have a nice day.
On Wed, Nov 5, 2014 at 1:00 AM, Yu Ang Tan <yuang86@...> wrote: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;char *loc_username;char *loc_password;short dpb_length;/* 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;isc_expand_dpb(&dpb, &dpb_length,isc_dpb_user_name, user,isc_dpb_password, password,NULL);/** Connect to the new database and create a sample table.*//* newdb will be set to null on success */isc_detach_database(status, &newdb);if (isc_attach_database(status, 0, new_dbname, &newdb, 0, dpb))if (pr_error(status, "attach database"))return 1;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.SQLCODE:-902]I don't think my sysdba login is undefined, since I have set the password using# dpkg-reconfigure firebird2.5-superclassicAny help at this stage would be greatly appreciated, as I am not sure how to move on from here.Thanks in advance.Ang