hello,
With the DAL I created tables in an MSSQL database, which I can access as long
as I login as the
same user.
I created the table with a windows login on my own machine, like this
Database_Name = r'mssql://NKCV2'
My_DB = DAL ( Database_Name, folder = folder )
Now I'm on anther machine, I can not use the windows login, so I use a MSSQL
login
( I found the syntax by trial and error)
* Database_Name = r'mssql://NKCV2;UID=MY_SQL_LOGIN;PWD=MY_PASSWORD'
* My_DB = DAL ( Database_Name, folder = folder )
The login works, I can contact de database,
with the DAL is trying to create new tables (which I'm not allowed, and as far
as know, I don't need
to because they are already there)
File "P:\Python26\lib\site-packages\gluon\sql.py", line 1100, in <lambda>
self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
ProgrammingError: ('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL
Server]CREATE TABLE
permission denied in database 'NKCV2'. (262) (SQLExecDirectW)")
Could this be caused, by the DAL creating other filenames to store the table
information ?
Any suggestions to solve this problem ?
thanks,
Stef Mientki
