Crystal reports XI ODBC error - Sun machine

system · May 4, 2007, 7:25pm

Can anybody provide a a solution, how to deploy the crystal reports connecting to SQL server using INFOVIEW portal.

The server is Sun Solaris, tried all possible ways, got exhausted.

The odbc.ini is located on /export1/home/boxir2/bobje on Sun machine.

Here is the odbc.ini entry for which I’m connecting to “test_sys_ss”

[ODBC Data Sources]
CRSQLServerWP=DataDirect 5.1 SQLServer Wire Protocol Driver
test_sys_ss=DataDirect 5.1 SQLServer Wire Protocol Driver
CRSybaseWP=DataDirect 5.1 Sybase Wire Protocol Driver
CRText=DataDirect 5.1 Text Driver
crystal_report_dcai1=Oracle in OraClient9i02 driver
crystal_report_ora=Oracle in OraClient9i02 driver

[test_sys_ss]
Driver=/export1/home/boxir2/bobje/enterprise115/solaris_sparc/odbc/lib/CRmsss21.so
Description=DataDirect 5.1 SQLServer Wire Protocol Driver
Database=DiskMonitor
Address=168.109.241.233,2431
QuotedId=No
AnsiNPW=Yes
LogonID=diskmon
Password=password

Any connection or anything that is missing, please let me know.

la_cool (BOB member since 2007-01-10)

system · May 7, 2007, 9:58pm

My dear friend,
You should not try connecting with ODBC connection. For SQL Server you have to create OLEDB connection and save it .
Now … see…

Thanks
Madhu@Cargill

remata (BOB member since 2006-04-19)

system · May 8, 2007, 2:56pm

Thanks remata! It is working now.

la_cool (BOB member since 2007-01-10)

system · May 22, 2007, 9:25pm

Your most welcome!

remata (BOB member since 2006-04-19)

system · July 12, 2007, 4:31am

Hi Remata

I am trying to create Crystal Reports to use on Infoview

But I dont know whether to use an ODBC or OLEDB connection to SQL Server

Can you let me know why OLEDB is preferable to ODBC for accessign SQL Server through Crystal Reports

Regards,
Ruchira

ruchiraw (BOB member since 2005-12-27)

system · July 12, 2007, 5:25pm

Yes. You have to use OLEDB connection for SQL Server database. You can
t use other connections.

Thanks
Remata.

remata (BOB member since 2006-04-19)

system · July 13, 2007, 8:42am

Thanks a lot Remata

Woudl you happen to know whether we have to use OLEDB for connecting to Oracle as well . I am planning to create reports which use both Oracle and SQL Server

Regards,
Ruchira

ruchiraw (BOB member since 2005-12-27)

system · July 13, 2007, 9:34pm

ODBC works fine for oracle. No need OLEDB.
Oracle has inbuilt futures for BO product.

remata (BOB member since 2006-04-19)

system · July 14, 2007, 5:00am

Thanks a lot Remata

ruchiraw (BOB member since 2005-12-27)

system · September 17, 2007, 1:51pm

Can anybody provide a a solution, how to deploy the crystal reports connecting to SQL server using INFOVIEW portal.

The server is Sun Solaris, tried all possible ways, got exhausted

srinivas_ch (BOB member since 2007-07-15)