SQL Server Questions

From: Lindstrom Greg - glinds (Greg.Lindstrom_at_acxiom.com)
Date: 12/19/03 

Date: Fri, 19 Dec 2003 08:09:32 -0600
To: "'python-list@python.org'" <python-list@python.org>

Hello-
I am connecting to a Microsoft SQL Server (6.0) via Python 2.3 using the
MSSQL package and have a question about the database name. This particular
database was designed with a two-word name (i.e. "My Database"). When I
try to connect using the MSSQL.connect method, I get a syntax error:

        MSSQL.connect('my_server', 'my_username', 'my_password', 'my
database')

I get an "Incorrect syntax near My" error. I can't change the name of the
database; too many applications are feeding into it. What do I do?

Also, I'm connecting to a Microsoft Exchange Mail server using the methods
described in Mark Hammond and Andy Robinson's Book "Python Programming on
Win 32". My problem is that when I connect to the Exchange Server, a dialog
box pops up to verify the connection. Since I'm writing a utility script,
I'd just like to connect without a user having to get involved. Is this
possible?

Thanks for your help
--greg

**********************************************************************
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

Relevant Pages

  • Horrible (8x) Client-Server Performance
    ... App Server- 8 logical xeon 2.8ghz cpu, ... Fibre Channel SAN housing the database ... the Application server connecting to the DB server via client-server ... We have eliminated network to be the constraint by connecting both ...
    (comp.databases.progress)
  • RE: Secure Database Communication
    ... We use that to communicate from the MySQL ... client on our Snort sensors to the remote MySQL server. ... Subject: Secure Database Communication ...
    (Security-Basics)
  • Re: Split a database
    ... it has little to do with connecting. ... the current database, and launch a upgrade program that copies the FE..and ... Those FE's link to a back end on the server. ... zero chance that users will not be able to download your new FE. ...
    (microsoft.public.access.modulesdaovba)
  • Working with a remote server
    ... Access 2000 database to and from my ISP's server? ... My problem comes with moving the project to my ISP's server. ... references to my local machine's C:/Inetpub/wwwroot folder are not ... connecting via the Frontpage server extensions. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How do I Exchange data with web server
    ... the csv file on the server side. ... However, really, connecting to the ... to the database is not an option because the web site requires the IP ... The ID that I'm trying to get back from the server is so when I send the ...
    (microsoft.public.access.forms)