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?ID=68cb337e-bf53-4d41-a768-a3518a49b7a6

http://www.vb-tips.com/default.aspx?ID=73eab21d-db5f-46b2-8eea-6680e677e994

Ken