Re-Mssql question

[Code o mat]

Let's experiment, try this:

CString udata="use \"databasename\"";
//(databasename is like master ,use create database)
Qry=spSQLServer->ExecuteWithResults((_bstr_t)udata,(LONG)udata.GetLength());

> The problem with computers is that they do what you tell them to do and not what you want them to do. < > Sometimes you just have to hate coding to do it well. <

[MsmVc]

thanks ,i use code which is given by you.But i got error

Microsoft SQL-DMO (ODBC SQLState: 42000) Error: -2147221402 [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'databasename'. Invalid STDGMEDIUM structure

[CPallini]

Your database's name is

Database name

? :omg: in such a case, possibly you've to replace

MsmVc wrote:

CString udata="use 'databasename'";

with

CString udata="use 'Database name'";

:)

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]

[MsmVc]

i always use like this

CString udata="use 'Database name'";

But still i have problem same.

[PCuong1983]

uhm, I think: the USE keyword (in t-sql) follow by YourDBName (YourDBName without quote) like this USE YourBDName or USE [YourBDName]

[Code o mat]

How about CString udata="use databasename"; ? Btw do you know that -according to msdn- Microsoft recommends not using sql-dmo in newer products because it will be removed by them?

> The problem with computers is that they do what you tell them to do and not what you want them to do. < > Sometimes you just have to hate coding to do it well. <

[MsmVc]

thanks for information. So what i use?Plz help me

[MsmVc]

Thank But i test both case there is no effect in out put.Still same problem here.

[Code o mat]

This[^] is where i found that you should avoid using it, just to show you i didn't make that up. Otherwise, i don't know what else there is, i guess you should ask Microsoft (look around MSDN), or you could try using Oracle Database 10g client[^], i think it is an ODBC "interface" of somesort...

> The problem with computers is that they do what you tell them to do and not what you want them to do. < > Sometimes you just have to hate coding to do it well. <

[PCuong1983]

Did you put USE YourDBName query and select query in same connection session ? WHEN and WHERE did you use SELECT DB_NAME() AS DataBaseName ?

[MsmVc]

See as in first post first i make connection then i use

CString tr="USE tes";
//(tes is a database)
Qry1=spSQLServer->ExecuteWithResults((_bstr_t)tr);

this code. After that i use

SELECT DB_NAME() AS DataBaseName

If i am wrong then pls help me

[PCuong1983]

:( sorry This link: http://msdn.microsoft.com/en-us/library/ms131540.aspx[^] may help you.