Skip site navigation (1) Skip section navigation (2)

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

From: George Weaver <gweaver(at)shaw(dot)ca>
To: Amadeo Garcia <amadeogarciaserrano(at)gmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Error connecting a visual studio .NET "app" and PostgreSQL
Date: 2005-01-25 20:30:10
Message-ID: 010601c5031c$af3f5c60$6400a8c0@Dell4500 (view raw or flat)
Thread:
Lists: pgsql-odbc
You're very welcome.

----- Original Message ----- 
From: "Amadeo Garcia" <amadeogarciaserrano(at)gmail(dot)com>
To: "George Weaver" <gweaver(at)shaw(dot)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(at)shaw(dot)ca> wrote:
>> Hi Amadeo,
>>
>> Try
>> Driver={postgresql};Server=localhost;Port=5432;Database=libroteca;Uid=tapanez;Pwd=****;"
>>                                                                  ^^^^^^^^
>> Regards,
>> George
>>
>> ----- Original Message -----
>> From: "Amadeo Garcia" <amadeogarciaserrano(at)gmail(dot)com>
>> To: <pgsql-odbc(at)postgresql(dot)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(at)postgresql(dot)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
> 



In response to

pgsql-odbc by date

Next:From: Michael FuhrDate: 2005-01-25 21:46:48
Subject: Re: [HACKERS] RQ: Prepared statements used by multiple connections
Previous:From: lothar.behrensDate: 2005-01-25 20:24:56
Subject: Re: ODBC (win32) X PostgreSQL(Linux)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group