[Zope] Trying to establish connection to MS SQLServer 7
Andrew Elster
I4Veritas@hotmail.com
Tue, 1 Aug 2000 11:35:21 -0700
This is a multi-part message in MIME format.
------=_NextPart_000_0005_01BFFBAC.93933CB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I have read the following How-To by roberth =
http://www.zope.org/Members/roberth/ZMSSQLServer/index_html?pp=3D1
I must be missing something, because I am unable to establish a =
connection to my database. No matter what I try I receive an "Incorrect =
Connection String" error message.
My setup: =20
* Latest version of Zope
* MS SQL Server 7
* ZODBC adapter
I have configured the SQL server so that there are member logins which =
correspond to the zope super user and a normal user. =20
What do I use for the dsn in the connection string? I have tried =
LocalServer, MSSQLServer, as well as the name of the database.
Thank you for your help.
--Andrew
I4Veritas@hotmail.com
------=_NextPart_000_0005_01BFFBAC.93933CB0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3103.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I have read the following How-To by =
roberth <A=20
href=3D"http://www.zope.org/Members/roberth/ZMSSQLServer/index_html?pp=3D=
1">http://www.zope.org/Members/roberth/ZMSSQLServer/index_html?pp=3D1</A>=
</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I must be missing something, because I =
am unable to=20
establish a connection to my database. No matter what I try I =
receive an=20
"Incorrect Connection String" error message.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>My setup: </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>* Latest version of Zope</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>* MS SQL Server 7</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>* ZODBC adapter</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I have configured the SQL server so =
that there are=20
member logins which correspond to the zope super user and a =
normal=20
user. </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>What do I use for the dsn in the =
connection=20
string? I have tried LocalServer, MSSQLServer, as well as the name =
of the=20
database.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thank you for your help.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>--Andrew</FONT></DIV>
<DIV><FONT face=3DArial size=3D2><A=20
href=3D"mailto:I4Veritas@hotmail.com">I4Veritas@hotmail.com</A></FONT></D=
IV>
<DIV> </DIV>
<DIV> </DIV></BODY></HTML>
------=_NextPart_000_0005_01BFFBAC.93933CB0--