Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  Programatically create SQL Server datasource

Author  Topic  GJackM Starting Member 1 Post Posted - 2009-05-05 : 15:09:22 Hi, I want to programatically create a datasource and add tables using OLE DB in C++. I want to use SQL Server 2005 Express as the provider. All the code examples I've seen so far prompt the user for connections data, but I just want to create a database if it doesn't exist and connect to that, so the user doesn't have to worry about setup. Can anyone show me some code to do this? Many thanks, Jack