[Zope] MS Access odbc connection string problem
Kelley, Sean
SKelley@ci.santa-rosa.ca.us
Mon, 16 Jun 2003 14:51:37 -0700
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C33451.7625F420
Content-Type: text/plain;
charset="iso-8859-1"
Tried both of these, share has same security as user that starts Zope
service. hmmm...
-----Original Message-----
From: Meilicke, Scott [mailto:scott.meilicke@intp.com]
Sent: Monday, June 16, 2003 11:54 AM
To: Kelley, Sean; 'zope@zope.org'
Subject: RE: [Zope] MS Access odbc connection string problem
I am just using the dsnname, no username or password. I also don't have a
username/password within the database itself.
Ensure the user that is running the zope service has access to the share
where the database lives.
Scott
-----Original Message-----
From: Kelley, Sean [ mailto:SKelley@ci.santa-rosa.ca.us
<mailto:SKelley@ci.santa-rosa.ca.us> ]
Sent: Monday, June 16, 2003 11:48 AM
To: 'zope@zope.org'
Subject: [Zope] MS Access odbc connection string problem
I am trying to setup an ODBC connection to an MS Access database which is
located on another network server (windows network). I have been successful
connecting to MS SQL but I cannot get me Access connection to work.
When setting up the ODBC connection in windows control panel on the zope
server I use the unc path \\\server\folders\mydb.mdb to get to the Access
file and create a system DSN. When I try to create the connection object in
zope and connect to this database I get an error Invalid connection string:
when using the dsnname username password format
Is there a problem creating or using a system DSN with the ZODBC connector
when the location of the database file is on another server other than the
zope server?
With SQL I use the sql user to authenticate in the connection string. With
Access does one use the windows user with rights to the file or the user
created in the Access file itself to connect? I have tried both so far.
Any help would be appreciated.
Sean
_______________________________________________
Zope maillist - Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
<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-announce>
http://mail.zope.org/mailman/listinfo/zope-dev
<http://mail.zope.org/mailman/listinfo/zope-dev> )
The information contained in this email message may be privileged and is
confidential information intended only for the use of the recipient or any
employee or agent responsible for delivering it to the intended recipient.
Any unauthorized use, distribution or copying of this information is
strictly prohibited and may be unlawful. If you have received this
communication in error, please notify the sender immediately and destroy the
original message and all attachments from your electronic files.
------_=_NextPart_001_01C33451.7625F420
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: [Zope] MS Access odbc connection string problem</TITLE>
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=372255021-16062003><FONT face=Arial color=#0000ff size=2>Tried
both of these, share has same security as user that starts Zope
service. hmmm...</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Meilicke, Scott
[mailto:scott.meilicke@intp.com]<BR><B>Sent:</B> Monday, June 16, 2003 11:54
AM<BR><B>To:</B> Kelley, Sean; 'zope@zope.org'<BR><B>Subject:</B> RE: [Zope]
MS Access odbc connection string problem<BR><BR></FONT></DIV>
<P><FONT size=2>I am just using the dsnname, no username or password. I
also don't have a username/password within the database itself.
</FONT></P>
<P><FONT size=2>Ensure the user that is running the zope service has access to
the share where the database lives.</FONT> </P>
<P><FONT size=2>Scott</FONT> </P>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From:
Kelley, Sean [<A
href="mailto:SKelley@ci.santa-rosa.ca.us">mailto:SKelley@ci.santa-rosa.ca.us</A>]</FONT>
<BR><FONT size=2>Sent: Monday, June 16, 2003 11:48 AM</FONT> <BR><FONT
size=2>To: 'zope@zope.org'</FONT> <BR><FONT size=2>Subject: [Zope] MS Access
odbc connection string problem</FONT> </P><BR>
<P><FONT size=2>I am trying to setup an ODBC connection to an MS Access
database which is</FONT> <BR><FONT size=2>located on another network server
(windows network). I have been successful</FONT> <BR><FONT
size=2>connecting to MS SQL but I cannot get me Access connection to
work.</FONT> </P>
<P><FONT size=2>When setting up the ODBC connection in windows control panel
on the zope</FONT> <BR><FONT size=2>server I use the unc path
\\\server\folders\mydb.mdb to get to the Access</FONT> <BR><FONT size=2>file
and create a system DSN. When I try to create the connection object
in</FONT> <BR><FONT size=2>zope and connect to this database I get an error
Invalid connection string:</FONT> <BR><FONT size=2>when using the dsnname
username password format</FONT> <BR><FONT size=2>Is there a problem creating
or using a system DSN with the ZODBC connector</FONT> <BR><FONT size=2>when
the location of the database file is on another server other than the</FONT>
<BR><FONT size=2>zope server?</FONT> <BR><FONT size=2>With SQL I use the sql
user to authenticate in the connection string. With</FONT> <BR><FONT
size=2>Access does one use the windows user with rights to the file or the
user</FONT> <BR><FONT size=2>created in the Access file itself to
connect? I have tried both so far.</FONT> </P>
<P><FONT size=2>Any help would be appreciated.</FONT> <BR><FONT
size=2>Sean</FONT> </P>
<P><FONT size=2>_______________________________________________</FONT>
<BR><FONT size=2>Zope maillist - Zope@zope.org</FONT> <BR><FONT
size=2><A href="http://mail.zope.org/mailman/listinfo/zope"
target=_blank>http://mail.zope.org/mailman/listinfo/zope</A></FONT> <BR><FONT
size=2>** No cross posts or HTML encoding! **</FONT>
<BR><FONT size=2>(Related lists - </FONT><BR><FONT size=2> <A
href="http://mail.zope.org/mailman/listinfo/zope-announce"
target=_blank>http://mail.zope.org/mailman/listinfo/zope-announce</A></FONT>
<BR><FONT size=2> <A
href="http://mail.zope.org/mailman/listinfo/zope-dev"
target=_blank>http://mail.zope.org/mailman/listinfo/zope-dev</A> )</FONT>
<BR><FONT size=2>The information contained in this email message may be
privileged and is confidential information intended only for the use of the
recipient or any employee or agent responsible for delivering it to the
intended recipient. Any unauthorized use, distribution or copying of
this information is strictly prohibited and may be unlawful. If you have
received this communication in error, please notify the sender immediately and
destroy the original message and all attachments from your electronic
files.</FONT></P></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C33451.7625F420--