Re: Question on VC++ and SQL - Database Discussion Boards

ensger9-Feb-07 5:44

9-Feb-07 5:44

I have to make questions like this:

CString abfrage;
abfrage = "SELECT kstnr, kststamm.Bezeichnung, karnr, KarBezeichnung, buchungen.ktrnr, KtrBezeichnung, betrag, datum, datenart, belsymbol,\
belnr, text FROM buchungen LEFT OUTER JOIN karstamm ON buchungen.karnr = karstamm.Nummer ";
abfrage = abfrage + "LEFT OUTER JOIN kststamm ON buchungen.kstnr = kststamm.Nummer ";
abfrage = abfrage + " LEFT OUTER JOIN ktrstamm ON buchungen.ktrnr = ktrstamm.KtrNr WHERE datum >= ";
abfrage = abfrage + "'" + kstvon.c_str() + "' AND datum <= '" + kstbis.c_str() + "'";
if (kstnr != "") abfrage = abfrage + " AND kstnr = '" + kstnr.c_str() + "'";
if (koarnr != "") abfrage = abfrage + " AND karnr = '" + koarnr.c_str() + "'";
if (datenart != "") abfrage = abfrage + " AND datenart = '" + datenart.c_str() + "'";
rs->Close();
rs->Open(CRecordset::snapshot, abfrage);

Is there an easier way to make a Select in VC++??

I made this question in the Longe, unforounatly - and my question was even deleted (what's right, wrong click;))

But can anyone help here???

Thanks, Gerhard

Re: Question on VC++ and SQL

Hamid_RT9-Feb-07 6:27

Hamid_RT

9-Feb-07 6:27

Your question is not 100% on this forum again;)
anyway I forgot sql server but I think its possible can you create a view on your database and use of it on the VC++?and also you can use of CString::Insert instead abfrage = abfrage + ...;)

WhiteSky

Re: Question on VC++ and SQL

ensger9-Feb-07 10:53

ensger

9-Feb-07 10:53

Tahnks,

Seems to be a good idea.

Can you tell me, what would be the right forum for a question like this. Lounge was a fault, of course Blush | :O

- sorry.

Gerhard

Re: Question on VC++ and SQL

Hamid_RT10-Feb-07 1:21

Hamid_RT

10-Feb-07 1:21

Your're welcome
Well Lounge was 100% fault.No programming questions please (on the Lounge);)
Why you cant find MFC forum (Visual C++ / MFC) Visual C++ / MFC[^]

WhiteSky

Re: Question on VC++ and SQL

ensger12-Feb-07 3:36

ensger

12-Feb-07 3:36

Becouse I opened the menue-point 'Message Boards' and searched there. And there it's called Visual C++ only.

But I already found, thanks

Re: Question on VC++ and SQL

Hamid_RT12-Feb-07 6:42

Hamid_RT

12-Feb-07 6:42

Not problem maybe you are new here(codeproject),but I am ready to help people Wink | ;)

WhiteSky

Re: Question on VC++ and SQL

John M. Drescher9-Feb-07 10:38

John M. Drescher

9-Feb-07 10:38

Try the CString::Format member.

Here is what with ADO and MFC:

CString tempStr;

try {
   tempStr.Format("SELECT * "
		    "FROM CAD_Info "
		    "WHERE ( ([SessionNumber] = %d) "
		    "AND ([SiteID] = %d) "
		    "AND ([SeqNumber] = %d) )",
			nSession,nSiteID,nSeqNum);
			
      CMainDataBase::TESTHR(pRst.CreateInstance(__uuidof(Recordset)));
			
      CADORecordSetEx rst(m_pDB,pRst);
      rst.Open(tempStr,m_cursorType,m_lockType, adCmdText); 

     // Do something with the recordset...
}
catch(CException* e)
{
// Do something with the error 
}
catch (...)
{

}

I know you are using CRecordSet and DAO but the syntax should be similar.

John

Re: Question on VC++ and SQL

ensger9-Feb-07 10:51

ensger

9-Feb-07 10:51

Thanks for the answer,

Unfortunatly I have no experience with ADO, but I have some books to learn it. Maybe I have to do so now;)

BTW, the statemant above ment, this is not the rigth forum too. What would be the right one. In the Lounge ( Blush | :O

sorry again), you said, I should try in the MFC-forum, but I can't find.

Thanks, Gerhard

Re: Question on VC++ and SQL

S Douglas11-Feb-07 20:32

S Douglas

11-Feb-07 20:32

ensger wrote:
this is not the rigth forum too. What would be the right one.

1: Querying the database in the manor you are, your exposing the database to SQL injection attacks. See this article for help distinguishing these attacks.
SQL Injection Attacks[^]

2: Looks like you where suggested to ask this question in the MFC forum was because it’s all string manipulation. Which falls under the purview of MFC CString, although for the purposes here it’s really fine in either forum.

ensger wrote:
I should try in the MFC-forum, but I can't find.

Visual C++ / MFC[^]

Good Luck

I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:

Re: Question on VC++ and SQL

ensger12-Feb-07 3:48

ensger

12-Feb-07 3:48

Seems to be a very interesting article.

Thaks, Gerhard

Re: Question on VC++ and SQL

John M. Drescher13-Feb-07 4:03

John M. Drescher

13-Feb-07 4:03

ensger wrote:
nfortunatly I have no experience with ADO, but I have some books to learn it.

I recommend ADO if you plan on writing SQL code for connecting to a MS SQL server (or the free version of that) as it is much better at that task and it works well with multithreading which with DAO you have to be very careful.

Although I do not use this code I recommend this class for connecting to ADO databases:
http://www.codeproject.com/database/caaadoclass1.asp[^]

John

Is John M. Drscher here

ensger9-Feb-07 5:38

ensger

9-Feb-07 5:38

Re: Is John M. Drscher here

John M. Drescher9-Feb-07 10:44

John M. Drescher

9-Feb-07 10:44

Sorry. I was very busy at work. I had 2 doctors in and I had to demo my software to them and I also interviewed someone for a programming position all this while rebuilding a raid array on a linux box.

John

Re: Is John M. Drscher here

ensger9-Feb-07 13:10

ensger

9-Feb-07 13:10

Thank you for your answer above.

My posting was realy just a question - not a reminder;)

And sometimes I forget, that when I'm working, you may sleep and when I'm sleeping, you may work. That's a problem of internet - you don't recognice the time of others you are speeking to.

Thanks again, Gerhard

Check if Database exists

Aaron VanWieren9-Feb-07 4:08

Aaron VanWieren

9-Feb-07 4:08

I know this solution is out there somewhere but I have not been able to track it down so here is the situation. I am creating a database and tables dynamically at runtime and I need to verify that the database and table do not already exist on the SqlServer2005 database.

Any takers

_____________________________________________________________________

Our developers never release
code. Rather, it tends to escape, pillaging the countryside all around.

The Enlightenment Project (paraphrased comment)

Visit Me at GISDevCafe

Re: Check if Database exists

Colin Angus Mackay9-Feb-07 4:28

Colin Angus Mackay

9-Feb-07 4:28

Connect to the master database (which always exists) and check the sysdatabases table (Actually, that might have changed in 2005)

[ADDITIONAL]

It does exist, but as a backwards compatibility option for SQL Server 2000.

The new way is to use the sys.databases view

[/ADDITIONAL]

Upcoming events:
* Glasgow Geek Dinner (5th March)
* Glasgow: Tell us what you want to see in 2007

My: Website | Blog | Photos

Re: Check if Database exists

Aaron VanWieren9-Feb-07 5:07

Aaron VanWieren

9-Feb-07 5:07

From what I have read connecting to the sysdatabases is bad practice as these can change. After a little more research I discovered that in 2.0 there is a connection.getschema method that will return a datatable of the schema of the server. Furthermore, this takes various parameters and to get the database I just have to pass it a string "Databases" to get a table of database names. Rather nifty, maybe Ill write an article.
Aaron

Re: Check if Database exists

Blue_Boy9-Feb-07 4:38

Blue_Boy

9-Feb-07 4:38

USE master<br />
SELECT * FROM sysdatabases WHERE name='DatabaseName'

Re: Check if Database exists

Colin Angus Mackay9-Feb-07 4:50

Colin Angus Mackay

9-Feb-07 4:50

Except that way is deprecated in SQL Server 2005 and exists for compatibility with SQL Server 2000.

Upcoming events:
* Glasgow Geek Dinner (5th March)
* Glasgow: Tell us what you want to see in 2007

My: Website | Blog | Photos

Re: Check if Database exists

Aaron VanWieren9-Feb-07 5:04

Aaron VanWieren

9-Feb-07 5:04

Figured it out. With 2005 and .net 2.0 there is a nifty little getSchema method that belongs to the connection property. I can pass it in the parameter "Databases" and it will return a list of databases. Actually rather handy as there are all sorts of information that can be converted to a datatable and iterated through.

Thanks

Connection Prob

Kunal P8-Feb-07 5:59

Kunal P

8-Feb-07 5:59

I am developing a web application in c# using visual web developer express.
my database is in SQL server 2000

i created a connection string

<connectionStrings>
<add name="diag" connectionString="Data Source=local;Initial Catalog=diag;Integrated Security=SSPI"/>

</connectionStrings>

then to retrieve in the .cs file i wrote

string connString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["diag"].ConnectionString;

SqlConnection conn = new SqlConnection(connString);

but on compilation i get an error.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Kunal Piyush

Re: Connection Prob

gauthee8-Feb-07 17:53

gauthee

8-Feb-07 17:53

are we not supposed to mention the uid and pwd too i the connection string???

Gautham

Re: Connection Prob

Kunal P8-Feb-07 18:48

Kunal P

8-Feb-07 18:48

where shud i incorporate the user id and the password.. i checked the machine.config file and cud not find any parameter for the same

moreover the error it is showing is related to sql server 2005.. i am using sql server 2000

Kunal Piyush

Re: Connection Prob

gauthee8-Feb-07 19:33

gauthee

8-Feb-07 19:33

try out by stopping sql 2005 services, may be its because you have both versions installed in your comp??

Gautham

Connection Prob

Kunal P10-Feb-07 2:35

Kunal P

10-Feb-07 2:35

i m dead sure that i do not have sql 2005 on my comp.. i never installed it.. and double checked it with the control panel..

i only have sql server 2000..now how do i configure to use it with sql 2000

Kunal

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.