Home » U++ Library support » U++ SQL » MSSQL, default DB, datetime
| MSSQL, default DB, datetime [message #35989] |
Mon, 16 April 2012 16:52  |
|
|
I have two questions:
1. I am connected to MS SQL 2008 under the user sa (administrator).
By default for this user is definedr "master" DB.
In case of connection with a string
cs = "Driver={SQL Server Native Client 10.0};Server=127.0.0.1;UID=sa;PWD=pswd;Database=Piramida2000;"
server makes connection, but all requests all the same go to a DB "master". I can't understand why requests go not to a DB "Piramida2000". if a default DB for user "sa" to change on "Piramida2000" all requests are executed correctly.
2. When I'm select:
Date sDate=GetSysDate();
Date eDate;
for(int j=0;j<=30;j++)
{
eDate=sDate+1;
sql.Execute("select count(value0) from data where data_date>='?' and data_date<'?' and parnumber=12 and object=?", sDate, eDate, code[i]);
sql.Fetch();
sDate=sDate-1;
dayCount=sql[0];
DUMP(dayCount);
}
than I see that in a dumping:
«select count(value0) from data where data_date>='04/11/2012' and data_date<'04/12/2012' and parnumber=12 and object=4369
ERROR [Microsoft][SQL Server Native Client 10.0]Attribute violation with restriction on data type(0): select count(value0) from data where data_date>='?' and data_date<'?' and parnumber=12 and object=?»
But in the SQL Management Studio this query ("select count(value0) from data where data_date>='04/11/2012' and data_date<'04/12/2012' and parnumber=12 and object=4369") is executed successfully
|
|
|
|
| Re: MSSQL, default DB, datetime [message #36066 is a reply to message #35989] |
Mon, 23 April 2012 17:36  |
|
|
| Assargadon wrote on Mon, 16 April 2012 18:52 |
2. When I'm select:
Date sDate=GetSysDate();
Date eDate;
for(int j=0;j<=30;j++)
{
eDate=sDate+1;
sql.Execute("select count(value0) from data where data_date>='?' and data_date<'?' and parnumber=12 and object=?", sDate, eDate, code[i]);
sql.Fetch();
sDate=sDate-1;
dayCount=sql[0];
DUMP(dayCount);
}
than I see that in a dumping:
«select count(value0) from data where data_date>='04/11/2012' and data_date<'04/12/2012' and parnumber=12 and object=4369
ERROR [Microsoft][SQL Server Native Client 10.0]Attribute violation with restriction on data type(0): select count(value0) from data where data_date>='?' and data_date<'?' and parnumber=12 and object=?»
But in the SQL Management Studio this query ("select count(value0) from data where data_date>='04/11/2012' and data_date<'04/12/2012' and parnumber=12 and object=4369") is executed successfully
|
The question 2 was solved so:
selQuery<<"select count(value0) from data where data_date>='"<<sDate<<"' and data_date<'"<<eDate<<"' and parnumber=12 and object="<<code[i];
sql.Execute(selQuery);
|
|
|
|
Goto Forum:
Current Time: Thu Apr 24 03:25:35 CEST 2025
Total time taken to generate the page: 0.02352 seconds
|
Members
Pages
Help
Register
Login
Home
