ODBC Problem

ODBC Problem

am 23.10.2010 02:48:26 von murillomarco

------=_20101022184826_47386
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello,

I'm a VFP - PostgreSQL Developer and I have the following problem when I
try to connect to my PostgreSQL Database:

ODBC Driver Version: psqlODBC_x64_8.3.4.0
PostgreSQL Version: 9.0.1-1
OS: Windows 7 Home Premium

The error reads something like this:
Error Message:1526
Connectivity Error:[Microsoft][Controller Administrator ODBC]
Data Source name not found and no predetermined controller was specified.

The string I'm sending to the server contains:
"DRIVER=3D{PostgreSQL
ANSI};SERVER=3Dlocalhost;port=3D5432:DATABASE=3Dcabletv;UID= 3Dcabletvusr;=
PWD=3Dpcabletvsuperg;"

That's pratically it, please help me out with this, I'm stucked wiht my
project.


Thanks in advance.



Marco Murillo.
------=_20101022184826_47386
Content-Type: application/octet-stream; name="mylog_6856.log"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="mylog_6856.log"

WzYwNjAtMC4wNDddQ0NfY29ubmVjdDogZW50ZXJpbmcuLi4KWzYwNjAtMC4w
NDddc3NsbW9kZT1kaXNhYmxlCls2MDYwLTAuMDQ3XW9yaWdpbmFsX0NDX2Nv
bm5lY3Q6IGVudGVyaW5nLi4uCls2MDYwLTAuMDYyXURyaXZlciBWZXJzaW9u
PScwOC4wMy4wNDAwLDIwMDgxMTA3MDAwMScgbGlua2luZyAxNDAwIGR5bmFt
aWMgTXVsdGl0aHJlYWQgbGlicmFyeQpbNjA2MC0wLjA2Ml1vcmlnaW5hbF9D
Q19jb25uZWN0OiBEU04gPSAnUG9zdGdyZVNRTDM1VycsIHNlcnZlciA9ICds
b2NhbGhvc3QnLCBwb3J0ID0gJzU0MzInLCBkYXRhYmFzZSA9ICdwb3N0Z3Jl
cycsIHVzZXJuYW1lID0gJ3Bvc3RncmVzJywgcGFzc3dvcmQ9J3h4eHh4Jwpb
NjA2MC0wLjA2Ml1jb25uZWN0aW5nIHRvIHRoZSBzZXJ2ZXIgc29ja2V0Li4u
Cls2MDYwLTAuMDc4XSgwKShudWxsKSBFUlJOTz0wCls2MDYwLTAuMDc4XWNv
bm5lY3Rpb24gdG8gdGhlIHNlcnZlciBzb2NrZXQgc3VjY2VlZGVkLgpbNjA2
MC0wLjA3OF1zaXplb2Ygc3RhcnR1cCBwYWNrZXQgPSA4MApbNjA2MC0wLjA3
OF1zZW50IHRoZSBhdXRoZW50aWNhdGlvbiBibG9jayBzdWNjZXNzZnVsbHku
Cls2MDYwLTAuMDc4XWdvbm5hIGRvIGF1dGhlbnRpY2F0aW9uCls2MDYwLTAu
MDc4XXJlYWQgLTEsIGdsb2JhbF9zb2NrZXRfYnVmZmVyc2l6ZT00MDk2Cls2
MDYwLTAuMDc4XUxhc3RlcnJvcj0xMDAzNQpbNjA2MC0wLjEyNV1yZWFkIDEz
LCBnbG9iYWxfc29ja2V0X2J1ZmZlcnNpemU9NDA5NgpbNjA2MC0wLjEyNV1h
dXRoIGdvdCAnUicKWzYwNjAtMC4xMjVdYXJlcSA9IDUgc2FsdD01ZDYwMjY4
NTAwCls2MDYwLTAuMTI1XWluIEFVVEhfUkVRX01ENQpbNjA2MC0wLjEyNV1y
ZWFkIC0xLCBnbG9iYWxfc29ja2V0X2J1ZmZlcnNpemU9NDA5NgpbNjA2MC0w
LjEyNV1MYXN0ZXJyb3I9MTAwMzUKWzYwNjAtMC4xMjVdcmVhZCAzMjMsIGds
b2JhbF9zb2NrZXRfYnVmZmVyc2l6ZT00MDk2Cls2MDYwLTAuMTI1XWF1dGgg
Z290ICdSJwpbNjA2MC0wLjEyNV1hcmVxID0gMCBzYWx0PTAwMDAwMDAwMDAK
WzYwNjAtMC4xMjVdYXV0aCBnb3QgJ1MnCls2MDYwLTAuMTI1XWF1dGggZ290
ICdTJwpbNjA2MC0wLjEyNV1hdXRoIGdvdCAnUycKWzYwNjAtMC4xMjVdYXV0
aCBnb3QgJ1MnCls2MDYwLTAuMTI1XWF1dGggZ290ICdTJwpbNjA2MC0wLjEy
NV1hdXRoIGdvdCAnUycKWzYwNjAtMC4xMjVdYXV0aCBnb3QgJ1MnCls2MDYw
LTAuMTI1XWF1dGggZ290ICdTJwpbNjA2MC0wLjEyNV1Hb3QgdGhlIFBvc3Rn
cmVTUUwgdmVyc2lvbiBzdHJpbmc6ICc5LjAuMScKWzYwNjAtMC4xMjVdRXh0
cmFjdGVkIFBvc3RncmVTUUwgdmVyc2lvbiBudW1iZXI6ICc5LjAnCls2MDYw
LTAuMTQwXWF1dGggZ290ICdTJwpbNjA2MC0wLjE0MF1hdXRoIGdvdCAnUycK
WzYwNjAtMC4xNDBdc3RhbmRhcmRfY29uZm9ybWluZ19zdHJpbmdzPW9mZgpb
NjA2MC0wLjE0MF1hdXRoIGdvdCAnUycKWzYwNjAtMC4xNDBdYXV0aCBnb3Qg
J0snCls2MDYwLTAuMTQwXWF1dGggZ290ICdaJwpbNjA2MC0wLjE0MF1DQ19z
ZW5kX3NldHRpbmdzOiBlbnRlcmluZy4uLgpbNjA2MC0wLjE0MF1QR0FQSV9B
bGxvY1N0bXQ6IGVudGVyaW5nLi4uCls2MDYwLTAuMTQwXSoqKiogUEdBUElf
QWxsb2NTdG10OiBoZGJjID0gMDAwMDAwMDAwMjBCNkZFMCwgc3RtdCA9IDAw
MDAwMDAwMDIwQkJDMjAKWzYwNjAtMC4xNDBdQ0NfYWRkX3N0YXRlbWVudDog
c2VsZj0wMDAwMDAwMDAyMEI2RkUwLCBzdG10PTAwMDAwMDAwMDIwQkJDMjAK
WzYwNjAtMC4xNDBdUEdBUElfRnJlZVN0bXQ6IGVudGVyaW5nLi4uaHN0bXQ9
MDAwMDAwMDAwMjBCQkMyMCwgZk9wdGlvbj0xCls2MDYwLTAuMTQwXVFSZXN1
bHQ6IGVudGVyIERFU1RSVUNUT1IKWzYwNjAtMC4xNDBdU0NfaW5pdF9SZXN1
bHQoMjBiYmMyMClbNjA2MC0wLjE0MF1TQ19EZXN0cnVjdG9yOiBzZWxmPTAw
MDAwMDAwMDIwQkJDMjAsIHNlbGYtPnJlc3VsdD0wMDAwMDAwMDAwMDAwMDAw
LCBzZWxmLT5oZGJjPTAwMDAwMDAwMDIwQjZGRTAKWzYwNjAtMC4xNDBdQVBE
X2ZyZWVfcGFyYW1zOiAgRU5URVIsIHNlbGY9MDAwMDAwMDAwMjBCQkRDOApb
NjA2MC0wLjE0MF1JUERfZnJlZV9wYXJhbXM6ICBFTlRFUiwgc2VsZj0wMDAw
MDAwMDAyMEJCRTM4Cls2MDYwLTAuMTQwXVBEQVRBX2ZyZWVfcGFyYW1zOiAg
RU5URVIsIHNlbGY9MDAwMDAwMDAwMjBCQkYwMApbNjA2MC0wLjE0MF1TQ19E
ZXN0cnVjdG9yOiBFWElUCls2MDYwLTAuMTQwXUNDX2xvb2t1cF9sbzogZW50
ZXJpbmcuLi4KWzYwNjAtMC4xNDBdQ0Nfc2VuZF9xdWVyeTogY29ubj0wMDAw
MDAwMDAyMEI2RkUwLCBxdWVyeT0nc2VsZWN0IG9pZCwgdHlwYmFzZXR5cGUg
ZnJvbSBwZ190eXBlIHdoZXJlIHR5cG5hbWUgPSAnbG8nJwpbNjA2MC0wLjE0
MF1zZW5kX3F1ZXJ5OiBkb25lIHNlbmRpbmcgcXVlcnkgNjNieXRlcyBmbHVz
aGVkCls2MDYwLTAuMTQwXWluIFFSX0NvbnN0cnVjdG9yCls2MDYwLTAuMTQw
XWV4aXQgUVJfQ29uc3RydWN0b3IKWzYwNjAtMC4xNDBdcmVhZCAtMSwgZ2xv
YmFsX3NvY2tldF9idWZmZXJzaXplPTQwOTYKWzYwNjAtMC4xNDBdTGFzdGVy
cm9yPTEwMDM1Cls2MDYwLTAuMTQwXXJlYWQgNzksIGdsb2JhbF9zb2NrZXRf
YnVmZmVyc2l6ZT00MDk2Cls2MDYwLTAuMTQwXXNlbmRfcXVlcnk6IGdvdCBp
ZCA9ICdUJwpbNjA2MC0wLjE0MF1RUl9mZXRjaF90dXBsZXM6IGN1cnNvciA9
ICcnLCBzZWxmLT5jdXJzb3I9MDAwMDAwMDAwMDAwMDAwMApbNjA2MC0wLjE0
MF1udW1fZmllbGRzID0gMgpbNjA2MC0wLjE0MF1SRUFESU5HIEFUVFRZUE1P
RApbNjA2MC0wLjE0MF1DSV9yZWFkX2ZpZWxkczogZmllbGRuYW1lPSdvaWQn
LCBhZHRpZD0yNiwgYWR0c2l6ZT00LCBhdHR0eXBtb2Q9LTEgKHJlbCxhdHQp
PSgxMjQ3LDY1NTM0KQpbNjA2MC0wLjE0MF1SRUFESU5HIEFUVFRZUE1PRApb
NjA2MC0wLjE0MF1DSV9yZWFkX2ZpZWxkczogZmllbGRuYW1lPSd0eXBiYXNl
dHlwZScsIGFkdGlkPTI2LCBhZHRzaXplPTQsIGF0dHR5cG1vZD0tMSAocmVs
LGF0dCk9KDEyNDcsMjQpCls2MDYwLTAuMTQwXVFSX2ZldGNoX3R1cGxlczog
cGFzdCBDSV9yZWFkX2ZpZWxkczogbnVtX2ZpZWxkcyA9IDIKWzYwNjAtMC4x
NDBdTUFMTE9DOiB0dXBsZV9zaXplID0gMTAwLCBzaXplID0gMzIwMApbNjA2
MC0wLjE0MF1RUl9uZXh0X3R1cGxlOiBpblR1cGxlcyA9IHRydWUsIGZhbGxp
bmcgdGhyb3VnaDogZmNvdW50ID0gMCwgZmV0Y2hfbnVtYmVyID0gMApbNjA2
MC0wLjE0MF1lbmQgb2YgdHVwbGUgbGlzdCAtLSBzZXR0aW5nIGluVXNlIHRv
IGZhbHNlOiB0aGlzID0gMDAwMDAwMDAwMjBCQkMyMCBTRUxFQ1QgMApbNjA2
MC0wLjE0MF1fUVJfbmV4dF90dXBsZTogJ0MnIGZldGNoX3RvdGFsID0gMCAm
IHRoaXNfZmV0Y2ggPSAwCls2MDYwLTAuMTQwXVFSX25leHRfdHVwbGU6IGJh
Y2tlbmRfcm93cyA8IENBQ0hFX1NJWkU6IGJyb3dzID0gMCwgY2FjaGVfc2l6
ZSA9IDAKWzYwNjAtMC4xNDBdUVJfbmV4dF90dXBsZTogcmVhY2hlZCBlb2Yg
bm93Cls2MDYwLTAuMTQwXV9RUl9uZXh0X3R1cGxlOiAnQyc6IERPTkUgKGZj
b3VudCA9PSAwKQpbNjA2MC0wLjE0MF1zZW5kX3F1ZXJ5OiBnb3QgaWQgPSAn
WicKWzYwNjAtMC4xNDBdUVJlc3VsdDogZW50ZXIgREVTVFJVQ1RPUgpbNjA2
MC0wLjE0MF1RUmVzdWx0OiBpbiBRUl9jbG9zZV9yZXN1bHQKWzYwNjAtMC4x
NDBdUVJlc3VsdDogZnJlZSBtZW1vcnkgaW4sIGZjb3VudD0wCls2MDYwLTAu
MTcyXVFSZXN1bHQ6IGZyZWUgbWVtb3J5IG91dApbNjA2MC0wLjE3Ml1RUmVz
dWx0OiBlbnRlciBERVNUUlVDVE9SCls2MDYwLTAuMTcyXVFSZXN1bHQ6IGV4
aXQgY2xvc2VfcmVzdWx0Cls2MDYwLTAuMTcyXVFSZXN1bHQ6IGV4aXQgREVT
VFJVQ1RPUgpbNjA2MC0wLjE3Ml1Hb3QgdGhlIGxhcmdlIG9iamVjdCBvaWQ6
IC05OTkKWzYwNjAtMC4xNzJdQ0NfbG9va3VwX2NoYXJhY3RlcnNldDogZW50
ZXJpbmcuLi4KWzYwNjAtMC4xNzJdY29ubi0+dW5pY29kZT0wCls2MDYwLTAu
MTcyXUNDX2Nvbm5lY3Q6IHJldHVybmluZy4uLjEKWzYwNjAtMC4wMDBdQ0Nf
Y29ubmVjdDogZW50ZXJpbmcuLi4KWzYwNjAtMC4wMDBdc3NsbW9kZT1kaXNh
YmxlCls2MDYwLTAuMDAwXW9yaWdpbmFsX0NDX2Nvbm5lY3Q6IGVudGVyaW5n
Li4uCls2MDYwLTAuMDAwXURyaXZlciBWZXJzaW9uPScwOC4wMy4wNDAwLDIw
MDgxMTA3MDAwMScgbGlua2luZyAxNDAwIGR5bmFtaWMgTXVsdGl0aHJlYWQg
bGlicmFyeQpbNjA2MC0wLjAwMF1vcmlnaW5hbF9DQ19jb25uZWN0OiBEU04g
PSAnUG9zdGdyZVNRTDM1VycsIHNlcnZlciA9ICdsb2NhbGhvc3QnLCBwb3J0
ID0gJzU0MzInLCBkYXRhYmFzZSA9ICdwb3N0Z3JlcycsIHVzZXJuYW1lID0g
J3Bvc3RncmVzJywgcGFzc3dvcmQ9J3h4eHh4JwpbNjA2MC0wLjAwMF1jb25u
ZWN0aW5nIHRvIHRoZSBzZXJ2ZXIgc29ja2V0Li4uCls2MDYwLTAuMDMxXSgw
KShudWxsKSBFUlJOTz0wCls2MDYwLTAuMDMxXWNvbm5lY3Rpb24gdG8gdGhl
IHNlcnZlciBzb2NrZXQgc3VjY2VlZGVkLgpbNjA2MC0wLjAzMV1zaXplb2Yg
c3RhcnR1cCBwYWNrZXQgPSA4MApbNjA2MC0wLjAzMV1zZW50IHRoZSBhdXRo
ZW50aWNhdGlvbiBibG9jayBzdWNjZXNzZnVsbHkuCls2MDYwLTAuMDMxXWdv
bm5hIGRvIGF1dGhlbnRpY2F0aW9uCls2MDYwLTAuMDMxXXJlYWQgLTEsIGds
b2JhbF9zb2NrZXRfYnVmZmVyc2l6ZT00MDk2Cls2MDYwLTAuMDMxXUxhc3Rl
cnJvcj0xMDAzNQpbNjA2MC0wLjA2Ml1yZWFkIDEzLCBnbG9iYWxfc29ja2V0
X2J1ZmZlcnNpemU9NDA5NgpbNjA2MC0wLjA2Ml1hdXRoIGdvdCAnUicKWzYw
NjAtMC4wNjJdYXJlcSA9IDUgc2FsdD1lNGY4MTZmOTAwCls2MDYwLTAuMDYy
XWluIEFVVEhfUkVRX01ENQpbNjA2MC0wLjA2Ml1yZWFkIC0xLCBnbG9iYWxf
c29ja2V0X2J1ZmZlcnNpemU9NDA5NgpbNjA2MC0wLjA2Ml1MYXN0ZXJyb3I9
MTAwMzUKWzYwNjAtMC4wNjJdcmVhZCAzMjMsIGdsb2JhbF9zb2NrZXRfYnVm
ZmVyc2l6ZT00MDk2Cls2MDYwLTAuMDYyXWF1dGggZ290ICdSJwpbNjA2MC0w
LjA2Ml1hcmVxID0gMCBzYWx0PTAwMDAwMDAwMDAKWzYwNjAtMC4wNjJdYXV0
aCBnb3QgJ1MnCls2MDYwLTAuMDYyXWF1dGggZ290ICdTJwpbNjA2MC0wLjA2
Ml1hdXRoIGdvdCAnUycKWzYwNjAtMC4wNjJdYXV0aCBnb3QgJ1MnCls2MDYw
LTAuMDYyXWF1dGggZ290ICdTJwpbNjA2MC0wLjA3OF1hdXRoIGdvdCAnUycK
WzYwNjAtMC4wNzhdYXV0aCBnb3QgJ1MnCls2MDYwLTAuMDc4XWF1dGggZ290
ICdTJwpbNjA2MC0wLjA3OF1Hb3QgdGhlIFBvc3RncmVTUUwgdmVyc2lvbiBz
dHJpbmc6ICc5LjAuMScKWzYwNjAtMC4wNzhdRXh0cmFjdGVkIFBvc3RncmVT
UUwgdmVyc2lvbiBudW1iZXI6ICc5LjAnCls2MDYwLTAuMDc4XWF1dGggZ290
ICdTJwpbNjA2MC0wLjA3OF1hdXRoIGdvdCAnUycKWzYwNjAtMC4wNzhdc3Rh
bmRhcmRfY29uZm9ybWluZ19zdHJpbmdzPW9mZgpbNjA2MC0wLjA3OF1hdXRo
IGdvdCAnUycKWzYwNjAtMC4wNzhdYXV0aCBnb3QgJ0snCls2MDYwLTAuMDc4
XWF1dGggZ290ICdaJwpbNjA2MC0wLjA3OF1DQ19zZW5kX3NldHRpbmdzOiBl
bnRlcmluZy4uLgpbNjA2MC0wLjA3OF1QR0FQSV9BbGxvY1N0bXQ6IGVudGVy
aW5nLi4uCls2MDYwLTAuMDc4XSoqKiogUEdBUElfQWxsb2NTdG10OiBoZGJj
ID0gMDAwMDAwMDAwMkYwNkZFMCwgc3RtdCA9IDAwMDAwMDAwMDJGMEM0MjAK
WzYwNjAtMC4wNzhdQ0NfYWRkX3N0YXRlbWVudDogc2VsZj0wMDAwMDAwMDAy
RjA2RkUwLCBzdG10PTAwMDAwMDAwMDJGMEM0MjAKWzYwNjAtMC4wNzhdUEdB
UElfRnJlZVN0bXQ6IGVudGVyaW5nLi4uaHN0bXQ9MDAwMDAwMDAwMkYwQzQy
MCwgZk9wdGlvbj0xCls2MDYwLTAuMDc4XVFSZXN1bHQ6IGVudGVyIERFU1RS
VUNUT1IKWzYwNjAtMC4wNzhdU0NfaW5pdF9SZXN1bHQoMmYwYzQyMClbNjA2
MC0wLjA3OF1TQ19EZXN0cnVjdG9yOiBzZWxmPTAwMDAwMDAwMDJGMEM0MjAs
IHNlbGYtPnJlc3VsdD0wMDAwMDAwMDAwMDAwMDAwLCBzZWxmLT5oZGJjPTAw
MDAwMDAwMDJGMDZGRTAKWzYwNjAtMC4wNzhdQVBEX2ZyZWVfcGFyYW1zOiAg
RU5URVIsIHNlbGY9MDAwMDAwMDAwMkYwQzVDOApbNjA2MC0wLjA3OF1JUERf
ZnJlZV9wYXJhbXM6ICBFTlRFUiwgc2VsZj0wMDAwMDAwMDAyRjBDNjM4Cls2
MDYwLTAuMDc4XVBEQVRBX2ZyZWVfcGFyYW1zOiAgRU5URVIsIHNlbGY9MDAw
MDAwMDAwMkYwQzcwMApbNjA2MC0wLjA3OF1TQ19EZXN0cnVjdG9yOiBFWElU
Cls2MDYwLTAuMDc4XUNDX2xvb2t1cF9sbzogZW50ZXJpbmcuLi4KWzYwNjAt
MC4wNzhdQ0Nfc2VuZF9xdWVyeTogY29ubj0wMDAwMDAwMDAyRjA2RkUwLCBx
dWVyeT0nc2VsZWN0IG9pZCwgdHlwYmFzZXR5cGUgZnJvbSBwZ190eXBlIHdo
ZXJlIHR5cG5hbWUgPSAnbG8nJwpbNjA2MC0wLjA3OF1zZW5kX3F1ZXJ5OiBk
b25lIHNlbmRpbmcgcXVlcnkgNjNieXRlcyBmbHVzaGVkCls2MDYwLTAuMDc4
XWluIFFSX0NvbnN0cnVjdG9yCls2MDYwLTAuMDc4XWV4aXQgUVJfQ29uc3Ry
dWN0b3IKWzYwNjAtMC4wNzhdcmVhZCAtMSwgZ2xvYmFsX3NvY2tldF9idWZm
ZXJzaXplPTQwOTYKWzYwNjAtMC4wNzhdTGFzdGVycm9yPTEwMDM1Cls2MDYw
LTAuMDc4XXJlYWQgNzksIGdsb2JhbF9zb2NrZXRfYnVmZmVyc2l6ZT00MDk2
Cls2MDYwLTAuMDc4XXNlbmRfcXVlcnk6IGdvdCBpZCA9ICdUJwpbNjA2MC0w
LjA3OF1RUl9mZXRjaF90dXBsZXM6IGN1cnNvciA9ICcnLCBzZWxmLT5jdXJz
b3I9MDAwMDAwMDAwMDAwMDAwMApbNjA2MC0wLjA3OF1udW1fZmllbGRzID0g
MgpbNjA2MC0wLjA3OF1SRUFESU5HIEFUVFRZUE1PRApbNjA2MC0wLjA3OF1D
SV9yZWFkX2ZpZWxkczogZmllbGRuYW1lPSdvaWQnLCBhZHRpZD0yNiwgYWR0
c2l6ZT00LCBhdHR0eXBtb2Q9LTEgKHJlbCxhdHQpPSgxMjQ3LDY1NTM0KQpb
NjA2MC0wLjA3OF1SRUFESU5HIEFUVFRZUE1PRApbNjA2MC0wLjA3OF1DSV9y
ZWFkX2ZpZWxkczogZmllbGRuYW1lPSd0eXBiYXNldHlwZScsIGFkdGlkPTI2
LCBhZHRzaXplPTQsIGF0dHR5cG1vZD0tMSAocmVsLGF0dCk9KDEyNDcsMjQp
Cls2MDYwLTAuMDc4XVFSX2ZldGNoX3R1cGxlczogcGFzdCBDSV9yZWFkX2Zp
ZWxkczogbnVtX2ZpZWxkcyA9IDIKWzYwNjAtMC4wNzhdTUFMTE9DOiB0dXBs
ZV9zaXplID0gMTAwLCBzaXplID0gMzIwMApbNjA2MC0wLjA3OF1RUl9uZXh0
X3R1cGxlOiBpblR1cGxlcyA9IHRydWUsIGZhbGxpbmcgdGhyb3VnaDogZmNv
dW50ID0gMCwgZmV0Y2hfbnVtYmVyID0gMApbNjA2MC0wLjA3OF1lbmQgb2Yg
dHVwbGUgbGlzdCAtLSBzZXR0aW5nIGluVXNlIHRvIGZhbHNlOiB0aGlzID0g
MDAwMDAwMDAwMjk2RkUxMCBTRUxFQ1QgMApbNjA2MC0wLjA3OF1fUVJfbmV4
dF90dXBsZTogJ0MnIGZldGNoX3RvdGFsID0gMCAmIHRoaXNfZmV0Y2ggPSAw
Cls2MDYwLTAuMDc4XVFSX25leHRfdHVwbGU6IGJhY2tlbmRfcm93cyA8IENB
Q0hFX1NJWkU6IGJyb3dzID0gMCwgY2FjaGVfc2l6ZSA9IDAKWzYwNjAtMC4w
NzhdUVJfbmV4dF90dXBsZTogcmVhY2hlZCBlb2Ygbm93Cls2MDYwLTAuMDc4
XV9RUl9uZXh0X3R1cGxlOiAnQyc6IERPTkUgKGZjb3VudCA9PSAwKQpbNjA2
MC0wLjA3OF1zZW5kX3F1ZXJ5OiBnb3QgaWQgPSAnWicKWzYwNjAtMC4wNzhd
UVJlc3VsdDogZW50ZXIgREVTVFJVQ1RPUgpbNjA2MC0wLjA3OF1RUmVzdWx0
OiBpbiBRUl9jbG9zZV9yZXN1bHQKWzYwNjAtMC4wNzhdUVJlc3VsdDogZnJl
ZSBtZW1vcnkgaW4sIGZjb3VudD0wCls2MDYwLTAuMDc4XVFSZXN1bHQ6IGZy
ZWUgbWVtb3J5IG91dApbNjA2MC0wLjA3OF1RUmVzdWx0OiBlbnRlciBERVNU
UlVDVE9SCls2MDYwLTAuMDc4XVFSZXN1bHQ6IGV4aXQgY2xvc2VfcmVzdWx0
Cls2MDYwLTAuMDc4XVFSZXN1bHQ6IGV4aXQgREVTVFJVQ1RPUgpbNjA2MC0w
LjA3OF1Hb3QgdGhlIGxhcmdlIG9iamVjdCBvaWQ6IC05OTkKWzYwNjAtMC4w
NzhdQ0NfbG9va3VwX2NoYXJhY3RlcnNldDogZW50ZXJpbmcuLi4KWzYwNjAt
MC4wNzhdY29ubi0+dW5pY29kZT0wCls2MDYwLTAuMDc4XUNDX2Nvbm5lY3Q6
IHJldHVybmluZy4uLjEKWzYwNjAtMS43MDddZW50ZXIgQ0NfRGVzdHJ1Y3Rv
ciwgc2VsZj0wMDAwMDAwMDAyRjA2RkUwCls2MDYwLTEuNzA3XWluIENDX0Ns
ZWFudXAsIHNlbGY9MDAwMDAwMDAwMkYwNkZFMApbNjA2MC0xLjcwN11hZnRl
ciBDQ19hYm9ydApbNjA2MC0xLjcwN11TT0NLX0Rlc3RydWN0b3IKWzYwNjAt
MS43MDddYWZ0ZXIgU09DSyBkZXN0cnVjdG9yCls2MDYwLTEuNzA3XWV4aXQg
Q0NfQ2xlYW51cApbNjA2MC0xLjcwN11hZnRlciBDQ19DbGVhbnVwCls2MDYw
LTEuNzA3XWFmdGVyIGZyZWUgc3RhdGVtZW50IGhvbGRlcnMKWzYwNjAtMS43
MDddZXhpdCBDQ19EZXN0cnVjdG9yCls2MDYwLTEuNzA3XWluIEVOX0Rlc3Ry
dWN0b3IsIHNlbGY9MDAwMDAwMDAwMjk2RTc5MApbNjA2MC0xLjcwN11jbGVh
cmluZyBjb25ucyBjb3VudD0xMjgKWzYwNjAtMS43MTddZXhpdCBFTl9EZXN0
cnVjdG9yOiBydiA9IDEKWzYwNjAtMi45NjJdREVUQUNISU5HIFBST0NFU1MK

------=_20101022184826_47386
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable


--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

------=_20101022184826_47386--

Re: ODBC Problem

am 23.10.2010 05:03:17 von Richard Broersma

--Apple-Mail-1-258154760
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset=us-ascii





On Oct 22, 2010, at 5:48 PM, murillomarco@sigmahn.com wrote:

> The error reads something like this:
> Error Message:1526
> Connectivity Error:[Microsoft][Controller Administrator ODBC]
> Data Source name not found and no predetermined controller was specified.
>=20
> The string I'm sending to the server contains:
> "DRIVER=3D{PostgreSQL
> ANSI};SERVER=3Dlocalhost;port=3D5432:DATABASE=3Dcabletv;UID= 3Dcabletvusr;P=
WD=3Dpcabletvsuperg;"

I'm going to give my best guess. There were times when I upgraded the odbc d=
river where the driver name changes between versions. Applications like ms-=
access and excel will store odbc connection properties in the registry. Sin=
ce the driver names changed, all of existing data sources connections would f=
ail with an error message very similar to the one your getting.

By driver name I mean: DRIVER=3D{PostgreSQL ANSI};

To fix the problem, I needed to find the affected pre-existing registry entr=
ies to update the driver name to match the name of the newly installed drive=
r.

On a side note, why do you use the ANSI driver instead of the Unicode driver=
?

Sent from my iPod=

--Apple-Mail-1-258154760
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
charset=utf-8





On Oct 22, 2=
010, at 5:48 PM, murillomarco@si=
gmahn.com
wrote:

=
The error reads something like this:
Error Message:152=
6

Connectivity Error:[Microsoft][Controller Administrator OD=
BC]

Data Source name not found and no predetermined controll=
er was specified.


The string I'm sending to=
the server contains:

"DRIVER=3D{PostgreSQL
=
ANSI};SERVER=3Dlocalhost;port=3D5432:DATABASE=3Dcabletv;UID= 3Dcabletvusr;PWD=
=3Dpcabletvsuperg;"
>
=

I'm going to give my best guess.  There wer=
e times when I upgraded the odbc driver where the driver name changes betwee=
n versions.  Applications like ms-access and excel will store odbc conn=
ection properties in the registry.  Since the driver names changed, all=
of existing data sources connections would fail with an error message very s=
imilar to the one your getting.

By driver name I mean:&nb=
sp; ba(26, 26, 26, 0.296875); -webkit-composition-fill-color: rgba(175, 192, 227=
, 0.230469); -webkit-composition-frame-color: rgba(77, 128, 180, 0.230469); "=
>DRIVER=3D{PostgreSQL ANSI};

To fix the=
problem, I needed to find the affected pre-existing registry entries to upd=
ate the driver name to match the name of the newly installed driver.
iv>
On a side note, why do you use the ANSI driver instead of t=
he Unicode driver?

"-webkit-tap-highlight-color: rgba(26, 26, 26, 0.296875); -webkit-compositio=
n-fill-color: rgba(175, 192, 227, 0.230469); -webkit-composition-frame-color=
: rgba(77, 128, 180, 0.230469); ">Sent from my iPod
>=

--Apple-Mail-1-258154760--