PDA

View Full Version : Beginner VB PostgreSQL question {connection str}


BattleAngel444
07-22-2003, 10:49 AM
PostgreSQL is very new to me, and i am running into quite a few problems @ such an early stage of development. All i need to do is connect to a posgresql DB and query it from a VB app. the only problem is that, what sould be simple, is turning out to be arduous. Basically my connection string is apparently way off but i can t seem to find any helpful resources to get me goin on m project. this is where i am @ right now :

i get a run-time error:
"[Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified "

Below is my connection string:
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
cn.Open "DSN=<10.1.18.1;" & _
"UID=jregan;" & _
"PWD=;" & _
"Database=wps_jregan"
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Am i supposed to define some more parameters that are not demoted from Gborg ( http://gborg.postgresql.org/project...wto-visualbasic ) ???

DNAunion2000
07-23-2003, 09:54 PM
/*DNAunion*/ I don't know the answer to your question. But, can an IP address be used for a DSN? I've always seen preexisting ODBC DSNs used. If an IP address can't be used, that would explain the error message you are getting.

But, I have Windows XP Professional and just tried to setup a ODBC data source for "PostgresSQL" and there was no driver available (there were just ones for Access, Sybase, SQL Server, Visual FoxPro, Informix, Oracle, and Paradox databases)