Is it possible to connect to SQL Server 2005 Database from Sun Studio C++
[106 byte] By [lrresto] at [2007-11-26 10:27:35] 
Is it possible to connect to SQL Server 2005 Database from a Sun Studio C++ application, if so how?
# 1
Use the database API. There is no special connection between C++ programs or compilers and a database application.clamage45 at 2007-7-7 2:32:04 >
# 2
I'm not aware of a database api. Can you give me a little more info on this? We have a program written in C++ that parses some binary files and converts the data to ascii. We need to take all of the ascii data and put it into a Microsoft SQL Server Database, no other choice. I've never done any database work on th eUnix side, only in Windows, so I am unfamiliar with how to connect to a database programmatically with C++ on Solaris and Insert the data into the approriate table.
lrresto at 2007-7-7 2:32:04 >
# 3
There are no special features in C++ or in Sun Studio that relate directly to database access or to connecting to remote database servers.
Your question would be for Microsoft: how to connect to their SQL server running on Windows from a program running on a Unix system. Maybe the server documentation covers that topic.
If you isolate the "how to connect to the server" part, the rest of the program should be the same on Unix as on Windows, using portable C++ code.
clamage45 at 2007-7-7 2:32:04 >
# 4
That is the next step, since we used generic C++ we will have to try to get the app to work under Microsoft Visual C++ in order to connect to SQL Server. I'd hoped that there was some library available on the Unix side that would allow connectivity.lrresto at 2007-7-7 2:32:04 >
# 5
First you have to find out how to connect. After that, the answer might be obvious.For example, if you can connect via remote procedure call, you can use the standard Unix RPC functionality. (Try "man rpc")clamage45 at 2007-7-7 2:32:04 >
# 6
1. As I remember MS SQL server was originated from Sybase SQL. So they client/server protocols are similar at least for some previous version of MS SQL.2. Try to google. Might be this article helps you: http://www.freetds.orgAtanasyan at 2007-7-7 2:32:04 >
Development Tools New Topic
- How to redirect to a page dynamic
- Challenge: Generically Setting UI Component Properties
- CVS branched Project not editable in JSC
- How to get textfield values from a tableRowGroup
- How to write a standalone JMS client ? => please help
- Blank Line After Blank Line aka Mozolla Composer
- Web service question
- Shared library performance on SUN.
Development Tools Hot Topic
- Linker problems in REL 2.4.21-4
- SunStudio 11 C++ std::stringstream stream pointer problem
- add html code
- Newbie frm Netbeans
- delete of functions and void * accepted without warning by compiler
- Sun 5.8 C++ errors
- 64 bit dbx consuming large amounts of memory on Ubuntu Linux (Dapper Drake)
- dbx: Unable to run with memory checking enabled
Development Tools
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding