Hi everyone,
i am trying to create a table with a query, but, after it ran, nothing happens: the table is not created and no error message is thrown.
The same query done with SQL Server Management Studio instead have successful ending (ie the table is created)
The problem occours with both pymssql and _mssql.
What could be the problem?
I'm running Python 2.5 under Windows Vista Business with SQL Server Express 2008.
Thanks in advance to everyone who will help
Marcello
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
It worked for me. Had to ensure create table permissions were granted for the user in the database. Try running your SQL from Query Analyzer or sqlcmd to verify it is correct. Also, use semicolons, not "go" as command delimiters.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi everyone,
i am trying to create a table with a query, but, after it ran, nothing happens: the table is not created and no error message is thrown.
The same query done with SQL Server Management Studio instead have successful ending (ie the table is created)
The problem occours with both pymssql and _mssql.
What could be the problem?
I'm running Python 2.5 under Windows Vista Business with SQL Server Express 2008.
Thanks in advance to everyone who will help
Marcello
It worked for me. Had to ensure create table permissions were granted for the user in the database. Try running your SQL from Query Analyzer or sqlcmd to verify it is correct. Also, use semicolons, not "go" as command delimiters.