Connection string problems
От | Gary Doades |
---|---|
Тема | Connection string problems |
Дата | |
Msg-id | 4027DEA5.5176.425EF09A@localhost обсуждение исходный текст |
Ответы |
Re: Connection string problems
|
Список | pgsql-odbc |
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.
В списке pgsql-odbc по дате отправления: