Thread: Error connecting a visual studio .NET "app" and PostgreSQL

ODBC Driver Version: 07_03_0200
PostgreSQL 8.0
SO: Windows XP with Service Pack 2
Visual Studio .NET with Framework 1.1

Hi, this is my visual basic code, very very simple, i'm first trying
to connect with the database, no success at this moment.

        Dim cadenaConexion =
"Driver={postgresql};Server=(localhost:5432);Database=libroteca;Uid=tapanez;Pwd=****;"
        Dim conexion As Microsoft.Data.Odbc.OdbcConnection = New
OdbcConnection(cadenaConexion)
        Dim comando As String = "INSERT INTO LIB_AUTORES VALUES (2,
'Ken Follet')"
        Dim cmd As Microsoft.Data.Odbc.OdbcCommand = New
OdbcCommand(comando, conexion)
        Try
            MsgBox("Abriendo conexion")
            cmd.Connection.Open()
            Console.WriteLine("Abriendo conexion2")
            cmd.ExecuteNonQuery()
            cmd.Connection.Close()
        Catch ex As Exception
            MsgBox(ex.ToString)
        End Try

Hi Amadeo,

Try
Driver={postgresql};Server=localhost;Port=5432;Database=libroteca;Uid=tapanez;Pwd=****;"
                                                                 ^^^^^^^^
Regards,
George

----- Original Message -----
From: "Amadeo Garcia" <amadeogarciaserrano@gmail.com>
To: <pgsql-odbc@postgresql.org>
Sent: Saturday, January 22, 2005 11:07 AM
Subject: [ODBC] Error connecting a visual studio .NET "app" and PostgreSQL


> ODBC Driver Version: 07_03_0200
> PostgreSQL 8.0
> SO: Windows XP with Service Pack 2
> Visual Studio .NET with Framework 1.1
>
> Hi, this is my visual basic code, very very simple, i'm first trying
> to connect with the database, no success at this moment.
>
>        Dim cadenaConexion =
> "Driver={postgresql};Server=(localhost:5432);Database=libroteca;Uid=tapanez;Pwd=****;"
>        Dim conexion As Microsoft.Data.Odbc.OdbcConnection = New
> OdbcConnection(cadenaConexion)
>        Dim comando As String = "INSERT INTO LIB_AUTORES VALUES (2,
> 'Ken Follet')"
>        Dim cmd As Microsoft.Data.Odbc.OdbcCommand = New
> OdbcCommand(comando, conexion)
>        Try
>            MsgBox("Abriendo conexion")
>            cmd.Connection.Open()
>            Console.WriteLine("Abriendo conexion2")
>            cmd.ExecuteNonQuery()
>            cmd.Connection.Close()
>        Catch ex As Exception
>            MsgBox(ex.ToString)
>        End Try
>


--------------------------------------------------------------------------------


>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo@postgresql.org so that your
>      message can get through to the mailing list cleanly
>

You're very welcome.

----- Original Message -----
From: "Amadeo Garcia" <amadeogarciaserrano@gmail.com>
To: "George Weaver" <gweaver@shaw.ca>
Sent: Tuesday, January 25, 2005 2:07 PM
Subject: Re: [ODBC] Error connecting a visual studio .NET "app" and
PostgreSQL


> THANK YOU VERY VERY MUCH, it worked perfectly.
>
>
> On Tue, 25 Jan 2005 13:29:56 -0600, George Weaver <gweaver@shaw.ca> wrote:
>> Hi Amadeo,
>>
>> Try
>> Driver={postgresql};Server=localhost;Port=5432;Database=libroteca;Uid=tapanez;Pwd=****;"
>>                                                                  ^^^^^^^^
>> Regards,
>> George
>>
>> ----- Original Message -----
>> From: "Amadeo Garcia" <amadeogarciaserrano@gmail.com>
>> To: <pgsql-odbc@postgresql.org>
>> Sent: Saturday, January 22, 2005 11:07 AM
>> Subject: [ODBC] Error connecting a visual studio .NET "app" and
>> PostgreSQL
>>
>> > ODBC Driver Version: 07_03_0200
>> > PostgreSQL 8.0
>> > SO: Windows XP with Service Pack 2
>> > Visual Studio .NET with Framework 1.1
>> >
>> > Hi, this is my visual basic code, very very simple, i'm first trying
>> > to connect with the database, no success at this moment.
>> >
>> >        Dim cadenaConexion =
>> > "Driver={postgresql};Server=(localhost:5432);Database=libroteca;Uid=tapanez;Pwd=****;"
>> >        Dim conexion As Microsoft.Data.Odbc.OdbcConnection = New
>> > OdbcConnection(cadenaConexion)
>> >        Dim comando As String = "INSERT INTO LIB_AUTORES VALUES (2,
>> > 'Ken Follet')"
>> >        Dim cmd As Microsoft.Data.Odbc.OdbcCommand = New
>> > OdbcCommand(comando, conexion)
>> >        Try
>> >            MsgBox("Abriendo conexion")
>> >            cmd.Connection.Open()
>> >            Console.WriteLine("Abriendo conexion2")
>> >            cmd.ExecuteNonQuery()
>> >            cmd.Connection.Close()
>> >        Catch ex As Exception
>> >            MsgBox(ex.ToString)
>> >        End Try
>> >
>>
>> --------------------------------------------------------------------------------
>>
>> >
>> > ---------------------------(end of
>> > broadcast)---------------------------
>> > TIP 3: if posting/reading through Usenet, please send an appropriate
>> >      subscribe-nomail command to majordomo@postgresql.org so that your
>> >      message can get through to the mailing list cleanly
>> >
>>
>>
>
>
> --
> Carry on my sons forever
> Carry On when I am gone
> Carry On when the day is long
> Forever Carry On
> For as long as we're together then
> Forever Carry On
>