deploying ms sql application
-
Hello, I wrote an sql client application using VS2008 and ODBC driver.I am using sql express 2008 as server. I want to prepare installer application to install it. How can I create ODBC and configure it for my application? I am doing it manually using administrative tools. And I have database creation scripts and running them within managment studio of sql server. How can i install and run scripts automaticly during installtion?Any links or tutorials .. Regards
-
Hello, I wrote an sql client application using VS2008 and ODBC driver.I am using sql express 2008 as server. I want to prepare installer application to install it. How can I create ODBC and configure it for my application? I am doing it manually using administrative tools. And I have database creation scripts and running them within managment studio of sql server. How can i install and run scripts automaticly during installtion?Any links or tutorials .. Regards
-
And this should be on the C++ forum because?
It is a crappy thing, but it's life -^ Carlo Pallini
You're right, OP indeed forgot: "send me C++ codez, sir, plz, plz, urgentz". :)
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[My articles] -
You're right, OP indeed forgot: "send me C++ codez, sir, plz, plz, urgentz". :)
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[My articles]Hello, Sorry for my mistake first. I never keep my words OP.I always write my own code and never request code. If it is not the right forum , you should only point me to correct forum. You sholud at least be polite and without pre-judgment. Regards
-
Hello, Sorry for my mistake first. I never keep my words OP.I always write my own code and never request code. If it is not the right forum , you should only point me to correct forum. You sholud at least be polite and without pre-judgment. Regards
Well, I was just kidding with my good friend Rajesh and in fact you're right, no code request came from you. (You know kidding often implies a big stretch of reality: I was just mocking some typical requests you may find in this forum). I'm sorry if my words hurted you. BTW from your post it's difficult to understand what is the most appropriate forum. :)
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[My articles] -
Hello, I wrote an sql client application using VS2008 and ODBC driver.I am using sql express 2008 as server. I want to prepare installer application to install it. How can I create ODBC and configure it for my application? I am doing it manually using administrative tools. And I have database creation scripts and running them within managment studio of sql server. How can i install and run scripts automaticly during installtion?Any links or tutorials .. Regards
Bilge Kaan wrote:
How can i install and run scripts automaticly during installtion?Any links or tutorials
For installing SQL Express I think I remember seeing some deployment documentation on MSDN for SQL Express. I imagine there is a MSI for it. For investigating things in Windows Installer I always start with InstallSite.org[^]
-
Hello, I wrote an sql client application using VS2008 and ODBC driver.I am using sql express 2008 as server. I want to prepare installer application to install it. How can I create ODBC and configure it for my application? I am doing it manually using administrative tools. And I have database creation scripts and running them within managment studio of sql server. How can i install and run scripts automaticly during installtion?Any links or tutorials .. Regards
To create an ODBC data source. 1.You might create a file DSN in designated directory. It's a ".ini" like text file. You can examine it for an analogy. Default directory is "Program Files\Common Files\ODBC\Data Sources". 2.You might create registry keys for User or System DSNs, respectively under the keys below. You can also examine them. HKCU\Software\ODBC\ODBC.INI HKLM\SOFTWARE\ODBC\ODBC.INI BTW, I'm speaking mostly for XP OS because the others may somewhat differ. Additionally, you don't have to create any kind of DSN, you can open your connection on the fly in your code by a proper connection string like below. "DRIVER=SQL Server;SERVER=%s;DATABASE=%s;UID=%s;PWD=%s" You may need to use "DRIVER=SQL Native Client" for 2008. You can also execute DDL scripts to create your schema using CDatabase::ExecuteSQL(). To do this, you can open your database connection using string below with an administrator user/password. "DRIVER=SQL Server;SERVER=%s;DATABASE=master;UID=sa;PWD=%s"
