database connection (unresolved sqlcxt) | Unix Linux Forums | UNIX for Advanced & Expert Users

  Go Back    


UNIX for Advanced & Expert Users Expert-to-Expert. Learn advanced UNIX, UNIX commands, Linux, Operating Systems, System Administration, Programming, Shell, Shell Scripts, Solaris, Linux, HP-UX, AIX, OS X, BSD.

database connection (unresolved sqlcxt)

UNIX for Advanced & Expert Users


Closed Thread    
 
Thread Tools Search this Thread Display Modes
    #1  
Old 03-01-2006
gfhgfnhhn gfhgfnhhn is offline
Registered User
 
Join Date: Mar 2006
Last Activity: 16 April 2007, 6:07 AM EDT
Posts: 77
Thanks: 0
Thanked 0 Times in 0 Posts
Error database connection (unresolved sqlcxt)

i have a little pro*c code (as shown below)
to connect an oracle database. (in unix solaris platform)
in the preprocessor compilation step everything is ok.
but when i try to compile the code using cc i get the
error below:

ld:
Unresolved:
sqlcxt

i think there is a problem while linking but
i cannot find out whats wrong and what should i do
for fixing.


additional information
(i dont have gcc compiler and i dont have demo folder under the
precomp folder)

(i dont have much knowledge about linking and compiling procedure)
i do the things as follow:
proc dat3.pc
cc dat3.c

here is the code :

EXEC SQL BEGIN DECLARE SECTION;
VARCHAR uid[30];
VARCHAR pwd[30];
EXEC SQL END DECLARE SECTION;

EXEC SQL INCLUDE SQLCA.H;

void main()
{

strcpy(uid.arr,"USER");
uid.len =strlen(uid.arr);
strcpy(pwd.arr,"PASSWD");
pwd.len = strlen(pwd.arr);

EXEC SQL WHENEVER SQLERROR GOTO errexit;
EXEC SQL CONNECT :uid IDENTIFIED BY wd;

printf("Connected to Oracle\n");

EXEC SQL COMMIT WORK RELEASE;
return;

errexit:
printf("Connection failed");
return;


} /* end of main */
Sponsored Links
    #2  
Old 03-01-2006
matrixmadhan matrixmadhan is offline Forum Advisor  
Technorati Master
 
Join Date: Mar 2005
Last Activity: 5 July 2014, 11:14 AM EDT
Location: classification algos
Posts: 3,203
Thanks: 19
Thanked 30 Times in 27 Posts
include the directories which contains the libraries for sqlext
mostly to be available under precomp


Code:
cc <sourcefile> -L <dir_include> -o <outputfile>

Sponsored Links
    #3  
Old 03-01-2006
gfhgfnhhn gfhgfnhhn is offline
Registered User
 
Join Date: Mar 2006
Last Activity: 16 April 2007, 6:07 AM EDT
Posts: 77
Thanks: 0
Thanked 0 Times in 0 Posts
sqlcxt error

thank you matrixmadhan,

but when i include the directory as follows

cc dat3.c -L /u01/app/oracle/product/10102/precomp -o outdat3

i got the following error:

Object file format error in: /u01/app/oracle/product/10102/precomp: read_cur_obj_info: File is not a regular file
    #4  
Old 09-20-2008
sravanadeepthi sravanadeepthi is offline
Registered User
 
Join Date: Sep 2008
Last Activity: 1 October 2008, 12:19 PM EDT
Location: HYDERABAD
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
hey,
Firstly,i don think thr is a linking problem...I had a similar problem not wid connect but i could solve it by using hese tips which u can try to solve...
1.Whenever u hav declared a char array..do initialize them by using memset like
memset(uid,'\0',sizeof(uid));
2.instead using strcpy use memcpy or sprintf.
Sponsored Links
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Database Connection snallusami Ubuntu 2 10-05-2011 01:19 AM
Database connection string agarwal Shell Programming and Scripting 1 06-20-2011 08:03 AM
Keep database connection opened! daniel1988 Shell Programming and Scripting 2 03-31-2011 04:11 AM
database connection ramneek Programming 0 10-18-2005 07:14 AM
Database connection whartoner Programming 2 01-15-2002 11:38 AM



All times are GMT -4. The time now is 05:50 AM.