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. 2 1175
Hello,
if you do MSSQL.connect('my_server', 'my_username', 'my_password', '[my
database]')
that will work
Ahmed
"Lindstrom Greg - glinds" <Gr************@acxiom.com> wrote in message
news:ma*************************************@pytho n.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.
> 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?
A little off topic for python, but I'm guessing your connection uses
an outlook profile to connect to the server. Starting with Outlook
2000 SP 2, you start getting warning dialogs about automated processes
trying to access your email system. This was done to stop some .vbs
worms from going crazy.
Fix 1: Install a version of Outlook before 2000 SP 2.
Fix 2: Track down the registry hack to disable the dialog. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: ani |
last post by:
I have a questionaire page , which basically has questions
with multiple choice answers. I need to accomplish paging
on this and there are few questions that are gender
specific. According the...
|
by: Stefan V. |
last post by:
Hello!
I am trying to convert a query written for SQL Server 2000 database
tables, to a MS Access query.
Here is what I have in SQL Server:
SELECT t2.*,
CASE WHEN t2.QType = '3' THEN...
|
by: Ani |
last post by:
I have a questionaire page , which basically has questions
with multiple choice answers. I need to accomplish paging
on this and there are few questions that are gender
specific. According the...
|
by: Jobs |
last post by:
Download the JAVA , .NET and SQL Server interview sheet and rate
yourself. This will help you judge yourself are you really worth of
attending interviews. If you own a company best way to judge if...
|
by: Jobs |
last post by:
Download the JAVA , .NET and SQL Server interview with answers
Download the JAVA , .NET and SQL Server interview sheet and rate
yourself. This will help you judge yourself are you really worth of...
|
by: freepdfforjobs |
last post by:
Full eBook with 4000 C#, JAVA,.NET and SQL Server Interview questions
http://www.questpond.com/SampleInterviewQuestionBook.zip
Download the JAVA , .NET and SQL Server interview sheet and rate...
|
by: Jobs |
last post by:
C# , SQL Server , Vista , Ajax Interview questions links
Full eBook with Vista , Ajax , SQL Server , UML and Architecture
interview questions
...
|
by: jfjavier |
last post by:
How do I import nested XML document to sql server 2000?
<Registrants>
<Member>
<ID>01</ID>
<LName>Dou</LName>
<FName>John</FName>
<Questions>...
|
by: Free PDF |
last post by:
..NET , SQL Server interview questions websites....
http://www.questpond.com
http://www.geocities.com/dotnetinterviews/...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |