PostgeSQL ODBC - script to create DB under VB.net 2005 and ODBC

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

script to create DB under VB.net 2005 and ODBC

P.M

2005-11-13, 8:23 pm

Hi,

I'm able without any trouble to test if postgreSQL
connectionstring is correct via a simple connection
open and close.

However, now i want to write a script (a simple txt
file) that will create from scratch my new DB.

the first command i want to test is "CREATE DATABASE
myDBtest;"

so i use normal odbcConnection and odbcCommand class
under VB.net 2005 for this.

it works perfectly under MS SQL 2000, but not under
PostgreSQL 8.0.4.

I tried to find if my ExecuteNonQuery command is wrong
but everything is ok...

So, i would appreciate some help if someone knows how
to solve this issue.

thanks a lot,
Maileen

____________________
______________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Sponsored Links