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

Re: Connection string problems

From: Chris Gamache <cgg007(at)yahoo(dot)com>
To: Gary Doades <gpd(at)gpdnet(dot)co(dot)uk>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: Connection string problems
Date: 2004-02-09 20:07:49
Message-ID: 20040209200749.95637.qmail@web13808.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Quick question: Why aren't you using the .NET data provider?

If you're set on using ODBC, try using the Microsoft data link properties:

1. Create a file, call it postgresql.udl (make sure its NOT postgresql.udl.txt)
2. Double click on it.
3. Set your connection options.
4. Click OK.
5. Open with Notepad. There you'll find a connection string.

HTH

--- Gary Doades <gpd(at)gpdnet(dot)co(dot)uk> wrote:
> I seem to have a problem forming a suitable connect string for the PostgreSQL
> ODBC 
> driver. I am using Windows XP and visual studio.net 2003 with C#.
> 
> If I have a connection string as:
> 
> string strConnect = "DSN=PostgreSQL30;UID=postgres;SERVER=192.168.1.102; 
> Port=5432;";
> 
> And I have defined the database to connec to in the DSN then everything works
> fine. 
> What I want to do however is not have to define a DSN for every database that
> I have or 
> when new ones are created. Normally (with MS SQLServer etc.) I would specify
> the 
> driver name and database in the connection string itself. So I use:
> 
> string strConnect = "DRIVER={PostgreSQL};UID=postgres;SERVER=192.168.1.102; 
> Port=5432; Database=webroster";
> 
> I get an exception (OdbcException) thrown in C# that has NO error information
> at all in it 
> and the connection fails.
> 
> I get this same problem if I specify the DSN but the DSN definition itself
> does not specify 
> a database. Am I using the right keywords in the connection string? I have
> tried to look 
> around for definitions of the keywords that the ODBC driver accepts, but I
> can only find 
> various examples like the one I am using.
> 
> If I specify a DSN in the connect string and the DSN specifies a database
> then the 
> connection and all other functions work just fine. Any ODBC exceptions thrown
> at any 
> other point in my code have all the correct error information in them.
> 
> Any suggestions appreciated.
> 
> Thanks
> Gary.
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org


__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html

In response to

Responses

pgsql-odbc by date

Next:From: Derek ShawDate: 2004-02-09 20:30:18
Subject: BLOB issue(s) & questions
Previous:From: Gary DoadesDate: 2004-02-09 19:25:25
Subject: Connection string problems

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