MSSQL

I have created a tool using vb.net,with mssql as backend.i need to
create the database and the table in the database using some scripts or
what ever relevent methods.How can we make the database while
installing the software.you could call the following from VB.NET:
osql.exe -Usa -Ppassword -i d:\dbr\create_database_script.sql -n
-oD:\DBR\OUTPUT\SQL_SCRIPT_LOGS\outputfile.txt
--
--
Sasan Saidi
Senior DBA
MSc in CS, MCSE4, IBM Certified MQ 5.3 Administrator
"I saw it work in a cartoon once so I am pretty sure I can do it."
"Armagadone" wrote:
> I have created a tool using vb.net,with mssql as backend.i need to
> create the database and the table in the database using some scripts or
> what ever relevent methods.How can we make the database while
> installing the software.
>

MSSQL

I have created a tool using vb.net,with mssql as backend.i need to
create the database and the table in the database using some scripts or
what ever relevent methods.How can we make the database while
installing the software.
you could call the following from VB.NET:
osql.exe -Usa -Ppassword -i d:\dbr\create_database_script.sql -n
-oD:\DBR\OUTPUT\SQL_SCRIPT_LOGS\outputfile.txt
--
Sasan Saidi
Senior DBA
MSc in CS, MCSE4, IBM Certified MQ 5.3 Administrator
"I saw it work in a cartoon once so I am pretty sure I can do it."
"Armagadone" wrote:

> I have created a tool using vb.net,with mssql as backend.i need to
> create the database and the table in the database using some scripts or
> what ever relevent methods.How can we make the database while
> installing the software.
>

MSSQL

I have created a tool using vb.net,with mssql as backend.i need to
create the database and the table in the database using some scripts or
what ever relevent methods.How can we make the database while
installing the software.you could call the following from VB.NET:
osql.exe -Usa -Ppassword -i d:\dbr\create_database_script.sql -n
- oD:\DBR\OUTPUT\SQL_SCRIPT_LOGS\outputfil
e.txt
--
Sasan Saidi
Senior DBA
MSc in CS, MCSE4, IBM Certified MQ 5.3 Administrator
"I saw it work in a cartoon once so I am pretty sure I can do it."
"Armagadone" wrote:

> I have created a tool using vb.net,with mssql as backend.i need to
> create the database and the table in the database using some scripts or
> what ever relevent methods.How can we make the database while
> installing the software.
>

msdtc config / sql server 2k cluster(sp4) / W2k3 sp1

I have an application that uses com components to connect to it's backend sql
server db. Right now the db is running on a W2k server (sp4)
(non-clustered). I've copied the dbs to the clustered environment that we
are migrating all of our databases to, and now the com components do not
connect. I've installed the Network DTC components and have configured the
MSDTC resource via Cluster Adminstrator and can see that the service starts
on each server in the node as I fail the cluster group between those nodes.
I've read and adhered to doc 301600 and it's sub article of 817064
(pre-reqs). Not sure what else may be wrong or that I need to validate. The
application returns the following error when the user tries to login via the
web portal: New transaction cannot enlist in the specified transaction
coordinator. The application runs on a W2k (sp4) server. Any guidance would
be greatly appreciated.
It isn't anything to do with the cluster. This would happen on a stand-alone
system anyway.
HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows Server
2003
http://support.microsoft.com/default...b;en-us;555017
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"LufkinTXDbajohn" <LufkinTXDbajohn@.discussions.microsoft.com> wrote in
message news:A0E2373E-5E90-45B2-B3EA-9BD32F6D4ABB@.microsoft.com...
>I have an application that uses com components to connect to it's backend
>sql
> server db. Right now the db is running on a W2k server (sp4)
> (non-clustered). I've copied the dbs to the clustered environment that we
> are migrating all of our databases to, and now the com components do not
> connect. I've installed the Network DTC components and have configured
> the
> MSDTC resource via Cluster Adminstrator and can see that the service
> starts
> on each server in the node as I fail the cluster group between those
> nodes.
> I've read and adhered to doc 301600 and it's sub article of 817064
> (pre-reqs). Not sure what else may be wrong or that I need to validate.
> The
> application returns the following error when the user tries to login via
> the
> web portal: New transaction cannot enlist in the specified transaction
> coordinator. The application runs on a W2k (sp4) server. Any guidance
> would
> be greatly appreciated.