[ psqlodbc-Bugs-1000478 ] Cannot create DNS using odbcconf.exe utility in Windows

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1000478 ] Cannot create DNS using odbcconf.exe utility in Windows
Date: 2005-12-09 14:51:10
Message-ID: 20051209145110.6BFE51125074@pgfoundry.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Bugs item #1000478, was opened at 2005-12-09 14:51
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000478&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: Cannot create DNS using odbcconf.exe utility in Windows

Initial Comment:
odbcconf.exe /Ld "dsn_llxatnf.txt" /A {CONFIGSYSDSN "PostgreSQL Unicode" "DSN=test1;SERVER=testowy;PORT=5432;DATABASE=testdb;UID=postgres;PWD=postgres;Protocol=6.4;UseServerSidePrepare=1;TextAsLongVarchar=1;ByteaAsLongVarBinary=1;ReadOnly=0;"} /A {CONFIGDSN "PostgreSQL Unicode" "DSN=test2;SERVER=testowy;PORT=5432;DATABASE=testdb;UID=postgres;PWD=postgres;Protocol=6.4;UseServerSidePrepare=1;TextAsLongVarchar=1;ByteaAsLongVarBinary=1;ReadOnly=0;"}

Returns code 0xC0000005.
dsn_llxatnf.txt file:

==========================================================================

ODBCConf called with arguments: '/Ld "F:\PCCorsacSQL\dsn_llxatnf.txt" /A {CONFIGSYSDSN "PostgreSQL Unicode" "DSN=test1;SERVER=testowy;PORT=5432;DATABASE=testdb;UID=postgres;PWD=postgres;Protocol=6.4;UseServerSidePrepare=1;TextAsLongVarchar=1;ByteaAsLongVarBinary=1;ReadOnly=0;"} /A {CONFIGDSN "PostgreSQL Unicode" "DSN=test2;SERVER=testowy;PORT=5432;DATABASE=testdb;UID=postgres;PWD=postgres;Protocol=6.4;UseServerSidePrepare=1;TextAsLongVarchar=1;ByteaAsLongVarBinary=1;ReadOnly=0;"}'
Data Struct:
Reboot First : 0
Use Response File : 0
Response File : '(null)'
Erase Response File: 0
Silent : 0
Continue on Error : 0
Log Mode : 3
Log File : 'F:\PCCorsacSQL\dsn_llxatnf.txt'
Actions:
4, 'CONFIGSYSDSN', 'PostgreSQL Unicode', 'DSN=test1;SERVER=testowy;PORT=5432;DATABASE=testdb;UID=postgres;PWD=postgres;Protocol=6.4;UseServerSidePrepare=1;TextAsLongVarchar=1;ByteaAsLongVarBinary=1;ReadOnly=0;', '"PostgreSQL Unicode" "DSN=test1;SERVER=testowy;PORT=5432;DATABASE=testdb;UID=postgres;PWD=postgres;Protocol=6.4;UseServerSidePrepare=1;TextAsLongVarchar=1;ByteaAsLongVarBinary=1;ReadOnly=0;"'
2, 'CONFIGDSN', 'PostgreSQL Unicode', 'DSN=test2;SERVER=testowy;PORT=5432;DATABASE=testdb;UID=postgres;PWD=postgres;Protocol=6.4;UseServerSidePrepare=1;TextAsLongVarchar=1;ByteaAsLongVarBinary=1;ReadOnly=0;', '"PostgreSQL Unicode" "DSN=test2;SERVER=testowy;PORT=5432;DATABASE=testdb;UID=postgres;PWD=postgres;Protocol=6.4;UseServerSidePrepare=1;TextAsLongVarchar=1;ByteaAsLongVarBinary=1;ReadOnly=0;"'
EXECUTING ACTIONS

Executing Action: CONFIGSYSDSN
arg1: 'PostgreSQL Unicode'
arg2: 'DSN=test1;SERVER=testowy;PORT=5432;DATABASE=testdb;UID=postgres;PWD=postgres;Protocol=6.4;UseServerSidePrepare=1;TextAsLongVarchar=1;ByteaAsLongVarBinary=1;ReadOnly=0;'
args: '"PostgreSQL Unicode" "DSN=test1;SERVER=testowy;PORT=5432;DATABASE=testdb;UID=postgres;PWD=postgres;Protocol=6.4;UseServerSidePrepare=1;TextAsLongVarchar=1;ByteaAsLongVarBinary=1;ReadOnly=0;"'
CONFIGSYSDSN About to Load the ODBC Control Panel (odbccp32.dll)
CONFIGSYSDSN ODBC Control panel (odbccp32.dll) HINSTANCE: 1609039872
CONFIGSYSDSN SQLConfigDataSource ProcAddress: 1609118722

==========================================================================

There's nothing wrong but this simply not work. I don't have any idea why.

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000478&group_id=1000125

Browse pgsql-odbc by date

  From Date Subject
Next Message Johann ROTURIER 2005-12-09 21:46:32 build psqlodbc-08.00.0102' with pgsql 8.0.4
Previous Message noreply 2005-12-09 14:39:52 [ psqlodbc-Bugs-1000477 ] Long parameters are not parsed from initialization string and unitialized options