Remote connection to SQL server in VC++
-
Hiya, I want to basically perform a bulk copy to a SQL server remotely via VC++ client. Just dont know what library to pull in,maybe sqlncli.msi and use the sqlncli.dll (sql 2008 native client). I wanted to build an MFC application to use this dll. I'm not sure if this is what I want and how to use it. Guidance is needed on this and a steady hand. Much appreciated if somebody can shed some light on how to do this in VC++? Thanks, garyc
-
Hiya, I want to basically perform a bulk copy to a SQL server remotely via VC++ client. Just dont know what library to pull in,maybe sqlncli.msi and use the sqlncli.dll (sql 2008 native client). I wanted to build an MFC application to use this dll. I'm not sure if this is what I want and how to use it. Guidance is needed on this and a steady hand. Much appreciated if somebody can shed some light on how to do this in VC++? Thanks, garyc
Sql native client should do, install it and look for examples. OLEDB and ODBC providers are good as well, look here http://msdn.microsoft.com/en-us/library/ms130809.aspx