Re: [Zope] mxODBC config probs for MSSQL

2005-12-29 Thread Jens Vagelpohl


On 29 Dec 2005, at 01:20, Rob Jingle wrote:

Error message: ('IM003', 0, '[iODBC][Driver Manager]Specified driver
could not be loaded', 8222)


This does not look like a mxODBCZopeDA problem at all. You have  
problems in the layer underneath, the iODBC setup on that box.


I'm using the product with unixODBC and setting it up was easy using  
this howto:


http://www.unixodbc.org/doc/FreeTDS.html

After doing some research on which ODBC connection framework to use,  
iODBC or unixODBC, it became clear that unixODBC is better supported,  
and the unixODBC/FreeTDS packages that come with my distribution work  
without problems.


jens

___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
http://mail.zope.org/mailman/listinfo/zope-announce

http://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] mxODBC config probs for MSSQL

2005-12-28 Thread robert rottermann

Rob,
is the connection outside of Zope running. Can you connect to the SQL 
Server using Isql or a similar command line tool?


Robert

Rob Jingle wrote:
This is an issue regarding the egenix mxODBC drivers for Zope to 
communicate with MSSQL.Iam having problems configuring th emxODBC on 
Zope.Iam not being successfull in creating a connection to SQL server.
 
The error iam getting is:


*EGENIX .COM mxODBC Zope DA*
 
Problem connecting to the database

Connection string: Driver=SQL Server

Connection pool entry: 0

Error message: ('IM003', 0, '[iODBC][Driver Manager]Specified driver
could not be loaded', 8222)


  Any kind of help is appreciated.
Thank you,
Suhas


___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce

 http://mail.zope.org/mailman/listinfo/zope-dev )
  


___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
http://mail.zope.org/mailman/listinfo/zope-announce

http://mail.zope.org/mailman/listinfo/zope-dev )


[Zope] mxODBC config probs for MSSQL

2005-12-28 Thread Rob Jingle
This is an issue regarding the egenix mxODBC drivers for Zope to communicate with MSSQL.Iam having problems configuring th emxODBC on Zope.Iam not being successfull in creating a connection to SQL server. The error iam getting is:
EGENIX
.COM
mxODBC Zope DA
  
  
 
  
  

  Problem connecting to the database

  
  
 


  Connection string: Driver=SQL ServerConnection pool entry: 0Error message: ('IM003', 0, '[iODBC][Driver Manager]Specified driver could not be loaded', 8222)
  Any kind of help is appreciated.Thank you,Suhas
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )