hi nidhi,

it was nice talking with you too.

I'l try to remain in touch.

take care
regards
Gourav

Hi Gaurav,
How are you doing?

I am again stuckup with the things .

Now i want to access mysql database which is on linux server but in the same program.

I installed myodbc driver also and created a dsn.Checked the connectivity with isql and i am able to connect to mysql.But in C++ program after compliation it gives following error:

"[FreeTDS][SQL Server]Unable to connect to data source
"

do i need to recompile freetds so that it support mysql?

Thanks,
Nidhi

hi nidhi,

why are you using freetds for mysql?
you can use the myodbc driver.
please show me odbc.ini and odbcinst.ini for mysql data source?

regards
Gourav

Hi Gaurav,

Iinstalled myodbc-3.51.10 on linux.

odbc.ini file is

[FIAT]
Driver = TDS
Description = ODBC connection via FreeTDS
Trace = Yes
TraceFile = /tmp/sql.log
ServerName = MYFIAT
Database = anylinux
Port = 1433

[MySql65]
Driver = MYTDS
Description = ODBC connection via FreeTDS
Trace = Yes
TraceFile = /tmp/mysql.log
ServerName = 65.182.161.193
Database = agent
Port = 3306
o

odbcisnt.ini


[TDS]
Description = FreeTDS
Driver = /usr/local/lib/libtdsodbc.so
Setup = /usr/local/lib/libtdsS.so.1
UsageCount = 1
[MYTDS]
Description = ODBC Driver for MySQL
Driver = /usr/local/lib/libmyodbc3.so
Setup = /usr/local/lib/libodbcmyS.so
FileUsage = 1

~

I want to use both the database in one program.I think otlv4.h prvide support for both type of database.

Thanks,
Nidhi

hi nidhi,

In odbc.ini instead of Servername use Server as shown below.

odbc.ini..
.............
.....
[MySql65]
Driver = MYTDS
Description = ODBC connection via FreeTDS
Trace = Yes
TraceFile = /tmp/mysql.log
Server = 65.182.161.193
Database = agent
Port = 3306
User = add valid username here


Nidhi, FreeTDS is a set of libraries for Unix and Linux that allows your programs to natively talk to Microsoft SQL Server and Sybase databases. http://www.freetds.org


and also while compiling link odbc library not tdsodbc.
Ex: gcc -I<whatever_path> your_program.cpp -o your_program -L<lib_path> -lodbc


try this and let me know.

regards
Gourav

Hi Gaurav,

Thanks its working now, i am able to connect both the database in one progrm.

Hurray!!!!!!!!!!!!!!!

Thanks a lot.
Take care,
Nidhi

hi Gaurav,

how are you doing?

Have u ever tried executing the mssql stored procedure in C++.

i am able to access the stored procedure with passing the constan values inside parameters but when ever i tried to pass variables inside stored procedure it fails.

I am pasting one example here:

suppose j is the object of otlstream class then:

Case 1: (it works)
j<<"5412293"<<"2004-08-30 00:00:00"<<"2004-08-30 23:59:59";

Case 2: (not working)
j<<proc_account<<start_date<<end_date;

All the parameters are of string type.


Thanks,
Nidhi