|
Hi all
I am using Ms SQL Server 2005.I try to get all databases names of MSSQL.I am able to connect with mssql through this code.
#import ".\sqldmo.dll" no_namespace
#include "afxwin.h"
_SQLServer2Ptr spSQLServer;
CString str1="",str2="",str3="",m_MHOST="";
LPWSTR HOST;
HRESULT hr;
if SUCCEEDED(hr = CoInitialize(NULL))
{
try
{
if (SUCCEEDED(spSQLServer.CreateInstance(__uuidof(SQLServer2))))
{
try
{
HOST=(_bstr_t)m_MHOST;
spSQLServer->LoginSecure = TRUE;
spSQLServer->Connect((_bstr_t)m_MHOST);
str1.Format(_T("Connected to %s"), (LPTSTR) spSQLServer->Name);
}
catch(_com_error pCE)
{
str2.Format(_T("%s"),(TCHAR*)pCE.Description());
MessageBox(str2,"Message");
return ;
}
}
else
{
str3.Format(_T("Unable to create the SQL Server object.\n"));
}
}
catch(_com_error pCE)
{
str2.Format(_T("\n%s Error: %ld\r\n%s\r\n%s\r\n"),
(TCHAR*)pCE.Source(),
pCE.Error(),
(TCHAR*)pCE.Description(),
(TCHAR*)pCE.ErrorMessage());
AfxMessageBox(str2);
return;
}
}
else
{
str2.Format(_T("Call to CoInitialize failed.\n"));
}
i try to get database name through this way.
QueryResultsPtr Qry;
CString dbs="SELECT * FROM SYS.DATABASES";
Qry=spSQLServer->ExecuteWithResults((_bstr_t)dbs);
but i am not able to get database name.Please help me
|
|
|
|
|
Hi,
Before executing the query "SELECT * FROM SYS.DATABASES", execute this query "USE master" and try ur select query.
I think it will work.
|
|
|
|
|
see my problem is not using master.My problem is how i fetch mssql all database in listbox.
|
|
|
|
|
That what i am saying. If u want to query any sys databases. First we have to switch to master user and then only we can fetch the records from the sysdatabases. From the ordinary user u cant execute the query.
|
|
|
|
|
ok can you give me some line of example to fetch MSSQL Database?
|
|
|
|
|
Hello can you give some line of code?
|
|
|
|
|
Give me some time. I dont have sql server now to write sample. will send it by tomorrow.
|
|
|
|
|
ok i am waiting for your example..
|
|
|
|
|
hi durga
i have solve problem to show database through this code
spDatabases = spSQLServer->Databases;
for(int i=1;i<=spDatabases->Count;i++) {
spDatabase = spDatabases->Item(i);
_bstr_t db_name(spDatabase->GetName());
CString s((LPCSTR)db_name);
m_lsmssqldatabase.AddString(s);
}
Can you give me idea how to show Table Name of particullar database.Plz help me
|
|
|
|
|
Cool yaar!
What's the mistake have u done?
The query for fetching the table name is "select name from sysobjects where type = 'U'".
This query will display the table name that is created by user.
Before executing this, run the query "use <ur db="" name="">".
|
|
|
|
|
i am having a list control.The data in the list control is continiuosly updating.when the data increases i.e wen the scroll bar is usd i cant see the data, i.e wen iam scrolling it dwn, it is gng up since it is continuosly updating data. Is there any method
|
|
|
|
|
|
You may gather and store data, updating the list only when needed (i.e. after user - you may notify to the user that new data is available - request or periodically).
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
[My articles]
|
|
|
|
|
Hi Guys,
Im working now on a project related to Noise Test for an Op-AMP. i am to make use of the digitizer which requires me to use FFT commands to digitize the time domain signal of the Noise that i am going to measure. Does anybody know FFT commands that ic an use to see the noise signal on tiem domain? my frequency of interests are 1Khz and 10Hz, i need the commands on C language. Ideas would be greatly appreciated.
you could mail me at rchua07@yahoo.com.
|
|
|
|
|
Fast Fourier Transforms? Google the Fastest Fourier Transform in the West.
|
|
|
|
|
Hi.
Suppose i have a function that takes an array and its length.
That function should search the entire array for each element and return a result.
example:
<br />
<br />
int rec(int arr[], int length)<br />
{<br />
if(length == 0)<br />
return 0;<br />
<br />
searchingarr(arr,length -1);<br />
<br />
rec(arr[],length - 1);<br />
}<br />
Now . i cant use loops(while or for), no static variables. only one function inside the rec and use only recursive. i cant put a sign in the array that points to the end either.
the problem here is that i want that each time im calling "searchingarr" i paste him the length of the array. here, the length is substracted by 1 each time i call rec.
|
|
|
|
|
Could you restate your question exactly?
What is the function looking for? What is it supposed to return?
|
|
|
|
|
the function(searcharr) should take an element and check if there is a sequence of summed elements that is equal to the index of that element.
example arr{ 1 , 3, 2 , 0 , 0 , 3}
arr[2] = 3.
because 2(i=2) + 0(i=3) + 0(i=4) gives us the value 3 that is the length of the sequence that when summed gives us the value of the index(2).
|
|
|
|
|
|
arr{ 1 , 3, 2 , 0 , 0 , 3}
the index 2 in the array have a value that is equal to the sequence of 3 elements(2 , 0 , 0) thus the returning value is 3.
|
|
|
|
|
So what is your algorithm?
Can you write the algorithm in words?
|
|
|
|
|
|
It looks like homework.
Regards.
--------
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
“The First Rule of Program Optimization: Don't do it. The Second Rule of Program Optimization (for experts only!): Don't do it yet.” - Michael A. Jackson
Rating helpfull answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
I'm attempting (and failing horribly) to put a function that draws multiple circles into an array.
I will be using flags to turn the circles on and off, and I need to initialize it in my main function so the random generator won't run every time the screen refreshes. This is what I have so far in putting my circles in an array:
I get an error on this first line here saying : c:26: error: expected identifier or ‘(’ before ‘[’ token
I've no idea why, it looks like it's set up right to me
struct Row1[15] = {drawCircleRow1()}
int drawCircleRow1()
{
for
(o=0; o<15; o++)
{
random_generator(0,3);
glPushMatrix();
glTranslatef((o+1.9)*28,455,1);
if (randomValue == 0)
{
glColor3f(0,.5,0);
}
else if (randomValue == 1)
{
glColor3f(.5,0,0);
}
else
{
glColor3f(0,0,.5);
}
glLineWidth(1.0);
drawCircle(14,200);
glPopMatrix();
}
}
int main(int argc, char* argv[])
{
glutInit(&argc, argv);
ballPhysics();
glutInitDisplayMode(GLUT_DOUBLE|GLUT_RGBA);
glutInitWindowSize(WIDTH, HEIGHT);
glutCreateWindow("Bubble Buster");
glutDisplayFunc(displayFunction);
glutSpecialFunc(functionSpecial);
glutKeyboardFunc(keyboardFunction);
glutTimerFunc(1,timerFunction,0);
gluOrtho2D(0, WIDTH, 0, HEIGHT);
glClearColor(1, 1, 1, 0);
glutMainLoop();
return 0;
}
|
|
|
|
|
"o" is by far the worst identifier one could possibly choose for a variable as it is short (OK, so are "i" and "n"), and easily confused with "0".
|
|
|
|