reg connecting COBOL to MySQL via ODBC
I would like to connect MySQL to COBOL via ODBC, I have installed MyODBC 2.50 in my localhost and I can able to create the DSN for the MySQL Database in remote server. I am in need of an interface to connect MySQL to COBOL. Is there any provision already exists with MySQL? if so can you please explain me in detail those facilities. expecting your valuable reply... thanks regards Arunachalam. Yahoo! India Mobile: Download the latest polyphonic ringtones. Go to http://in.mobile.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
reg C API from MySQL
I am in a position to connect MySQL into COBOL. I have properly downloaded the MyODBC from your website. I have tried to Establish connection from COBOL through the C API it have. For that I have to link certain run time library for C API given by MySQL. like 'mysqlclient.lib', ... I want to clarify that What are all the Library files for the C API is provided? i.e., name of the files. from Where I can get download it from? expecting your immediate valuable reply thanks Arun. Yahoo! India Mobile: Download the latest polyphonic ringtones. Go to http://in.mobile.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: reg C API from MySQL
Hello Patrick! I am trying to connect COBOL to the MySQL Database. I have used the C API to establish the conection to MySQL. You have quoted that library file mysqlclient.lib is enough. But when I try to test the Connecton using VC++ editor by writing a simpe C Program, the linking of "libmysql.lib" only produce successdul connection. i.e., mysqlclient.lib not required here. But When I try to Link those two files into the Linker for my COBOL application it wouldn't recognize the methods inside the Libraray file (i.e, mysql_init, mysql_real_connect, mysql_error...) and shows linker errors. Is there any other Library files required the platform I have used is Windows 2k CA REALIA II Workbench 3.0.55 CA REALIA COBOL Compiler 6.0.45 Microsoft 32 Bit incremental compiler 6.00.8168 can you please suggest me... Is there any other library files need to be inluded... regards, Arun. --- Patrick Sherrill <[EMAIL PROTECTED]> wrote: > Statically linking using C API only you will need > mysqlclient.lib > > For odbc interface you'll need to make odbc calls in > your code and use > myodbc.dll (Install myodbc on the client). > > You can mix calls, but why would you. I have found > the C API to be the best > solution for us. We statically link for dll > avoidance. You can get the > source or pre-built client libraries from the MySQL > web site. > > I hope this helps. > > Pat... > > [EMAIL PROTECTED] > CocoNet Corporation > SW Florida's First ISP > 825 SE 47th Terrace > Cape Coral, FL 33904 > > > > > > - Original Message - > From: "P Arunachalam" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, December 11, 2003 4:31 AM > Subject: reg C API from MySQL > > Yahoo! India Mobile: Download the latest polyphonic ringtones. Go to http://in.mobile.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: reg C API from MySQL
Hello Patrick! I am trying to connect COBOL to the MySQL Database. I have used the C API to establish the conection to MySQL. You have quoted that library file mysqlclient.lib is enough. But when I try to test the Connecton using VC++ editor by writing a simpe C Program, the linking of "libmysql.lib" only produce successdul connection. i.e., mysqlclient.lib not required here. But When I try to Link those two files into the Linker for my COBOL application it wouldn't recognize the methods inside the Libraray file (i.e, mysql_init, mysql_real_connect, mysql_error...) and shows linker errors. Is there any other Library files required the platform I have used is Windows 2k CA REALIA II Workbench 3.0.55 CA REALIA COBOL Compiler 6.0.45 Microsoft 32 Bit incremental compiler 6.00.8168 can you please suggest me... Is there any other library files need to be inluded... regards, Arun. --- Patrick Sherrill <[EMAIL PROTECTED]> wrote: > Statically linking using C API only you will need > mysqlclient.lib > > For odbc interface you'll need to make odbc calls in > your code and use > myodbc.dll (Install myodbc on the client). > > You can mix calls, but why would you. I have found > the C API to be the best > solution for us. We statically link for dll > avoidance. You can get the > source or pre-built client libraries from the MySQL > web site. > > I hope this helps. > > Pat... > > [EMAIL PROTECTED] > CocoNet Corporation > SW Florida's First ISP > 825 SE 47th Terrace > Cape Coral, FL 33904 > > > > > > - Original Message - > From: "P Arunachalam" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, December 11, 2003 4:31 AM > Subject: reg C API from MySQL > > Yahoo! India Mobile: Download the latest polyphonic ringtones. Go to http://in.mobile.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Bug in mysql.h header file
:\mysql\include\mysql.h(267) : error C2143: syntax
error : missing ')' before '*'
c:\mysql\include\mysql.h(267) : error C2143: syntax
error : missing '{' before '*'
c:\mysql\include\mysql.h(267) : error C2059: syntax
error : ')'
c:\mysql\include\mysql.h(268) : error C2143: syntax
error : missing ')' before '*'
c:\mysql\include\mysql.h(268) : error C2143: syntax
error : missing '{' before '*'
c:\mysql\include\mysql.h(268) : error C2059: syntax
error : ')'
c:\mysql\include\mysql.h(269) : error C2143: syntax
error : missing ')' before '*'
c:\mysql\include\mysql.h(269) : error C2143: syntax
error : missing '{' before '*'
c:\mysql\include\mysql.h(270) : error C2059: syntax
error : 'type'
c:\mysql\include\mysql.h(270) : error C2059: syntax
error : ')'
c:\mysql\include\mysql.h(271) : error C2143: syntax
error : missing ')' before '*'
c:\mysql\include\mysql.h(271) : error C2143: syntax
error : missing '{' before '*'
c:\mysql\include\mysql.h(271) : error C2059: syntax
error : ')'
c:\mysql\include\mysql.h(272) : error C2143: syntax
error : missing ')' before '*'
c:\mysql\include\mysql.h(272) : error C2143: syntax
error : missing '{' before '*'
c:\mysql\include\mysql.h(272) : error C2059: syntax
error : ')'
c:\mysql\include\mysql.h(273) : error C2143: syntax
error : missing ')' before '*'
c:\mysql\include\mysql.h(273) : error C2143: syntax
error : missing '{' before '*'
c:\mysql\include\mysql.h(273) : error C2059: syntax
error : ')'
c:\mysql\include\mysql.h(275) : error C2143: syntax
error : missing ')' before '*'
c:\mysql\include\mysql.h(275) : error C2143: syntax
error : missing '{' before '*'
c:\mysql\include\mysql.h(275) : error C2059: syntax
error : ')'
c:\mysql\include\mysql.h(276) : error C2143: syntax
error : missing ')' before '*'
c:\mysql\include\mysql.h(276) : error C2143: syntax
error : missing '{' before '*'
c:\mysql\include\mysql.h(276) : error C2059: syntax
error : ')'
c:\mysql\include\mysql.h(277) : error C2143: syntax
error : missing ')' before '*'
c:\mysql\include\mysql.h(277) : error C2143: syntax
error : missing '{' before '*'
c:\mysql\include\mysql.h(277) : error C2059: syntax
error : ')'
c:\mysql\include\mysql.h(278) : error C2143: syntax
error : missing ')' before '*'
c:\mysql\include\mysql.h(278) : error C2143: syntax
error : missing '{' before '*'
c:\mysql\include\mysql.h(278) : error C2059: syntax
error : ')'
c:\mysql\include\mysql.h(279) : error C2143: syntax
error : missing ')' before '*'
c:\mysql\include\mysql.h(279) : error C2143: syntax
error : missing '{' before '*'
c:\mysql\include\mysql.h(279) : error C2059: syntax
error : ')'
c:\mysql\include\mysql.h(280) : error C2143: syntax
error : missing ')' before '*'
c:\mysql\include\mysql.h(280) : error C2143: syntax
error : missing '{' before '*'
c:\mysql\include\mysql.h(280) : error C2059: syntax
error : ')'
c:\mysql\include\mysql.h(281) : error C2143: syntax
error : missing ')' before '*'
c:\mysql\include\mysql.h(281) : error C2143: syntax
error : missing '{' before '*'
c:\mysql\include\mysql.h(281) : error C2059: syntax
error : ')'
c:\mysql\include\mysql.h(282) : error C2143: syntax
error : missing ')' before '*'
c:\mysql\include\mysql.h(282) : error C2143: syntax
error : missing '{' before '*'
c:\mysql\include\mysql.h(282) : error C2059: syntax
error : ')'
c:\mysql\include\mysql.h(284) : error C2143: syntax
error : missing '{' before '*'
c:\mysql\include\mysql.h(284) : error C2143: syntax
error : missing ')' before '*'
c:\mysql\include\mysql.h(284) : error C2143: syntax
error : missing '{' before '*'
c:\mysql\include\mysql.h(284) : error C2059: syntax
error : ')'
c:\mysql\include\mysql.h(285) : error C2143: syntax
error : missing ')' before '*'
c:\mysql\include\mysql.h(285) : error C2143: syntax
error : missing '{' before '*'
c:\mysql\include\mysql.h(285) : error C2059: syntax
error : 'type'
c:\mysql\include\mysql.h(287) : error C2059: syntax
error : ')'
c:\mysql\include\mysql.h(288) : error C2143: syntax
error : missing ')' before '*'
c:\mysql\include\mysql.h(288) : fatal error C1003:
error count exceeds 100; stopping compilation
Error executing cl.exe.
MYSQL.OBJ - 102 error(s), 1 warning(s)
I have corrected this errors by including "winsock.h"
header file into my program. After including winsock.h
my program work fine and produce my expected results.
Herewith I have included the Sample C Program too for
your reference...
Incase it is a bug you please produce the correct
version of mysql.h header file to me.
Thanks.
regards,
Arun.
--- Patrick Sherrill <[EMAIL PROTECTED]> wrote: >
Statically linking using C API only you will need
> mysqlclient.lib
>
> For odbc interface you'll need to make odbc calls in
> your code and use
> myodbc.dll (Install myodbc on the client).
>
> You can mix calls, but why would you. I have found
> the C API to be the best
> solution for us. We statically link for dll
> avoidance. You can get the
> source or pre-built client libraries from the MySQL
> web site.
>
> I hope this helps.
>
> Pat...
>
> [EMAIL PROTECTED]
> CocoNet Corporation
> SW Florida's First ISP
> 825 SE 47th Terrace
> Cape Coral, FL 33904
>
>
>
>
>
> - Original Message -
> From: "P Arunachalam" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, December 11, 2003 4:31 AM
> Subject: reg C API from MySQL
>
>
Yahoo! India Mobile: Download the latest polyphonic ringtones.
Go to http://in.mobile.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Bug in mysql.h header file
Hi, I have made all the changes suggested by you in VC++ 6.0 i.e., I have inluded the Library file wsock32.lib into the existing library list in 'Project Settings'(Alt-F7') and checked the path setting of mysql header file and library file in Tools -- Options menu's Directory tab. but still it need the inclusion of header file winsock.H into my C program... otherise it shows the list of errors. name of my C program file is 'mysql.c' Error executing cl.exe. MYSQL.OBJ - 102 error(s), 1 warning(s) So pls verify and give me details... arun. --- info <[EMAIL PROTECTED]> wrote: > This is not a bug, you need to set your > project/programming environment in > VC++ to include support for sockets. I haven't > written any non socket > programs in several years, so it's part of my > standard set-up. > > MySQL is client/server and uses sockets. You do need > to link with a socket > library. In the case of VC++ this is Winsock > (wsock32.lib). I normally > include support for sockets in my stdfx.h (#include > // MFC > socket extensions). This is included with your VC++ > installation and not > part of mysql source. Then, add wsock32.lib, > mysqlclient.lib and any other > external library you need to link with in your > 'Project Settings'(Alt-F7'). > These are added under the 'Link' tab in the 'Input' > category. Libraries are > added in the 'Object/library module' field separated > by spaces (e.g. > 'wsock32.lib mysqlclient.lib'). Don't forget to add > the path to the > mysqlclient library in the 'Additional library > path:' field. > > Pat... > > > - Original Message - > From: "P Arunachalam" <[EMAIL PROTECTED]> > To: "Patrick Sherrill" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Tuesday, December 16, 2003 6:36 AM > Subject: Bug in mysql.h header file > > > > I was trying to establish connection to MySQL > through > > a simple C program using it's C API mysqL_init(), > > mysql_reak_connect(), ... in VC++ Editor. It shows > > Errors ; > > > > Compiling... > > MYSQL.C > > c:\mysql\include\mysql_com.h(116) : error C2061: > > syntax error : identifier 'SOCKET' > > MYSQL.OBJ - 102 error(s), 1 warning(s) > > > > I have corrected this errors by including > "winsock.h" > > header file into my program. After including > winsock.h > > my program work fine and produce my expected > results. > > > > Herewith I have included the Sample C Program too > for > > your reference... > > > > Incase it is a bug you please produce the correct > > version of mysql.h header file to me. > > > > Thanks. > > > > regards, > > Arun. > > > > --- Patrick Sherrill <[EMAIL PROTECTED]> wrote: > > > > Statically linking using C API only you will need > > > mysqlclient.lib > > > > > > For odbc interface you'll need to make odbc > calls in > > > your code and use > > > myodbc.dll (Install myodbc on the client). > > > > > > You can mix calls, but why would you. I have > found > > > the C API to be the best > > > solution for us. We statically link for dll > > > avoidance. You can get the > > > source or pre-built client libraries from the > MySQL > > > web site. > > > > > > I hope this helps. > > > > > > Pat... > > > > > > [EMAIL PROTECTED] > > > CocoNet Corporation > > > SW Florida's First ISP > > > 825 SE 47th Terrace > > > Cape Coral, FL 33904 > > > > > > > > > > > > > > > > > > - Original Message - > > > From: "P Arunachalam" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Thursday, December 11, 2003 4:31 AM > > > Subject: reg C API from MySQL > > > > > > > > > > > > > Yahoo! India Mobile: Download the latest > polyphonic ringtones. > > Go to http://in.mobile.yahoo.com > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > Yahoo! India Mobile: Download the latest polyphonic ringtones. Go to http://in.mobile.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
