473,326 Members | 2,126 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

SQL Server Questions

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.
Jul 18 '05 #1
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.

Jul 18 '05 #2
> 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.
Jul 18 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
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...
1
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...
1
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...
0
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...
2
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...
2
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...
0
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 ...
1
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>...
0
by: Free PDF | last post by:
..NET , SQL Server interview questions websites.... http://www.questpond.com http://www.geocities.com/dotnetinterviews/...
0
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...
0
isladogs
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...
0
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...
0
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...
1
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)...
1
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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
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....
0
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.