Hi!
I have a text file in which I have data which I'd like to import into an SQL Server database. DTS seems to offer limited options so I'd like to write a program in C which reads this text file and parses the file and stores the values read from this file into the database.
Also, I need to export the database into a text file in a predefined format that is different from the default export provided by DTS.
So my question is: Is there a simple way to write a C/C++ program that accesses the SQL Server database and can read from and write to the database? In other words, how do I access the SQL Server database from within a C/C++ program. Is there an equivalent of Pro*C for SQL Server?
Can anyone point me in the right direction?
Thanks,
Sashi
I have a text file in which I have data which I'd like to import into an SQL Server database. DTS seems to offer limited options so I'd like to write a program in C which reads this text file and parses the file and stores the values read from this file into the database.
Also, I need to export the database into a text file in a predefined format that is different from the default export provided by DTS.
So my question is: Is there a simple way to write a C/C++ program that accesses the SQL Server database and can read from and write to the database? In other words, how do I access the SQL Server database from within a C/C++ program. Is there an equivalent of Pro*C for SQL Server?
Can anyone point me in the right direction?
Thanks,
Sashi