-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello guys, I have a computer running W2k and Zope 2.4.1. However when I try to access a VFP7 database through ZODBCDA, I get the error message: Invalid connection string. But the System DSN works!! I've tested it with Excel. With zope I can connect to an Excel sheet through an appropriate DSN, too. The id of the DSN and the DSN in zope is the same. The connection does not work, even when I try to create a new ODBC connection object. So what's wrong? Greetings Florian - -- - ----------------------------------------------------------------------- | Florian Reiser PGP-Key:0x5368CF3F | | PGP-Fingerprint: 84C7 24BC F3A4 487F CBC7 692C 05DB 6E11 5368 CF3F | - ----------------------------------------------------------------------- -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE71b1jBdtuEVNozz8RAnSIAKCVuICSf0kzYgbbVgf/GfgmbmncNQCfferv OsbkfWQRaZYqfrsL+mLOi3U= =Tgt9 -----END PGP SIGNATURE-----
I have seen the Zope adapter require a different form of connection string from the ODBC driver. It was for either Interbase or mySQL, I forget which. Read the docs for the adapter very carefully and hope someone else has the answer, because I don't remember anymore what worked in my case,and that may be different from yours. For example, you might have to specify a host for the database server. [florian reiser] I have a computer running W2k and Zope 2.4.1. However when I try to access a VFP7 database through ZODBCDA, I get the error message: Invalid connection string. But the System DSN works!! I've tested it with Excel. With zope I can connect to an Excel sheet through an appropriate DSN, too. The id of the DSN and the DSN in zope is the same. The connection does not work, even when I try to create a new ODBC connection object. So what's wrong?
I have seen the Zope adapter require a different form of connection string
Its: DSN/user/pwd Cheers. -- Andy McKay. ----- Original Message ----- From: "Thomas B. Passin" <tpassin@mitretek.org> To: <zope@zope.org> Sent: Tuesday, October 23, 2001 12:18 PM Subject: Re: [Zope] ZODBCDA and W2k
I have seen the Zope adapter require a different form of connection string from the ODBC driver. It was for either Interbase or mySQL, I forget which. Read the docs for the adapter very carefully and hope someone else has the answer, because I don't remember anymore what worked in my case,and that may be different from yours. For example, you might have to specify a host for the database server.
[florian reiser]
I have a computer running W2k and Zope 2.4.1. However when I try to access a VFP7 database through ZODBCDA, I get the error message: Invalid connection string.
But the System DSN works!! I've tested it with Excel. With zope I can connect to an Excel sheet through an appropriate DSN, too. The id of the DSN and the DSN in zope is the same. The connection does not work, even when I try to create a new ODBC connection object.
So what's wrong?
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
participants (3)
-
Andy McKay -
florian reiser -
Thomas B. Passin