SEO

#1 (**permalink**) 04-16-2008, 01:02 AM

Hi Amadeo,

Try
Driver={postgresql};Server=localhost;Port=5432;Dat abase=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);Datab ase=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
>

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

#2 (**permalink**) 04-16-2008, 01:02 AM

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;Dat abase=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);Datab ase=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
>

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

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