VB.net 2005 and database

[Maileen]

Hi,

I've created a small application which should create a DB in different
plaftforms like MS SQL 2000 and PostgreSQL.

First i perform a simple test to see if user enter correct connection
string.
if it works, so i have a simple SQL statement like "create database DBTest;"

so, i create a command, using odbcCommand.
and after i connect this command to my odbcconnection.
so i open connection, use odbcCommand.ExecuteNONQuery and close
connection....
but when application arrives on line where is ExecuteNonQuery, it freeze
and timeout is overpass.

So, where can be the problem ?
does someone have an example ?
thanks a lot,
Maileen

[Ken Tucker [MVP]]

Hi,

I would have to guess that the problem is with connection string but
I guess it is possible the user does not have permissions to create a
database. Here is some examples of creating a database.

http://www.vb-tips.com/default.aspx?...8-a3518a49b7a6

http://www.vb-tips.com/default.aspx?...a-6680e677e994

Ken
----------------
"Maileen" <no*****@nospam.com> wrote in message
news:eM**************@TK2MSFTNGP15.phx.gbl...

Hi,

I've created a small application which should create a DB in different
plaftforms like MS SQL 2000 and PostgreSQL.

First i perform a simple test to see if user enter correct connection
string.
if it works, so i have a simple SQL statement like "create database
DBTest;"

so, i create a command, using odbcCommand.
and after i connect this command to my odbcconnection.
so i open connection, use odbcCommand.ExecuteNONQuery and close
connection....
but when application arrives on line where is ExecuteNonQuery, it freeze
and timeout is overpass.

So, where can be the problem ?
does someone have an example ?
thanks a lot,
Maileen