Database

31-May-06 12:55

can you tell me please how can i attach a database to the server just with code ?? i use VS 2003

i have the two files Mdf & Ldf one & i want to attach them to the server just with code

thank you very much

try to be good if you can't be the best

albCode31-May-06 23:32

albCode

31-May-06 23:32

same command which is used in T-SQL to attach DataBase use in ur application.
It's pretty easy

Eric Dahlvang1-Jun-06 2:56

1-Jun-06 2:56

SQL Server Books Online

sp_attach_db
Attaches a database to a server.

Syntax
sp_attach_db [ @dbname = ] 'dbname'
, [ @filename1 = ] 'filename_n' [ ,...16 ]

Examples
This example attaches two files from pubs to the current server.

EXEC sp_attach_db @dbname = N'pubs',
@filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf',
@filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log.ldf'

----------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters

Mohammed Amine1-Jun-06 5:39

1-Jun-06 5:39

well , thanks but i see that you used a stored procedure actually i didn't understand very well can you add some explanation please ??

thank you

try to be good if you can't be the best

Eric Dahlvang1-Jun-06 7:07

1-Jun-06 7:07

using System.Data;
using System.Data.SqlClient;

SqlConnection conn = new  SqlConnection();
conn.ConnectionString = "Data Source=(local);Initial Catalog=master;Integrated Security=SSPI";
conn.Open();

SqlCommand myCommand = conn.CreateCommand();
myCommand.CommandText = "EXEC sp_attach_db @dbname = 'ATestDB',@filename1 = 'C:\\TestPath\\ATestDB_Data.MDF',@filename2 = 'C:\\TestPath\\ATestDB_Log.LDF'";
myCommand.ExecuteScalar();

----------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters

Mohammed Amine1-Jun-06 7:23

1-Jun-06 7:23

thanks but what i don't understand is that how the vb.net will understand this ?? there is no procedure named like that in ma data base & he won't know it

can you explain from where you brought this procedure & how it works

thank you for your help but i want to understand but i can't because i have no procedure called like that

thank you for helping again Smile | :)

try to be good if you can't be the best

Eric Dahlvang1-Jun-06 7:55

1-Jun-06 7:55

sp_attach_db is a system stored procedure that is in the SQL Server master database.
If you really don't want to use it, you can use what is below (which is all the sp_attach_db does).

Also, I put this in vb.net - the last thing I posted was C#.

Imports System.Data
Imports System.Data.SqlClient

Dim conn As New SqlConnection
Dim myCommand As SqlCommand

conn.ConnectionString = "Data Source=(local);Initial Catalog=master;Integrated Security=SSPI"
conn.Open()

myCommand = conn.CreateCommand()
myCommand.CommandText = "CREATE DATABASE [ATestDB] ON (FILENAME = 'C:\TestPath\ATestDB_Data.MDF'), (FILENAME = 'C:\TestPath\ATestDB_Log.LDF') FOR ATTACH"

myCommand.ExecuteScalar()

Just change the name of ATestDB to whatever yours is, and the paths and filenames too.

----------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters

-- modified at 13:55 Thursday 1st June, 2006

Mohammed Amine1-Jun-06 10:28

1-Jun-06 10:28

Hi , thank you very very much this last one worked thank you i don't know without you what i would do thnx again

now if you permit i want to ask you some other things abt this

well , first when i create this database with the way you told me it work

but now if i already have the database attached i have to change ma code to :

conn.ConnectionString = "Data Source=(local);InitialCatalog=MyDataBase;Integrated Security=SSPI"

& i have to delete this 4 lines from code :

conn.Open()myCommand = conn.CreateCommand()myCommand.CommandText = "CREATE DATABASE [ATestDB] ON (FILENAME = 'C:\TestPath\ATestDB_Data.MDF'), (FILENAME = 'C:\TestPath\ATestDB_Log.LDF') FOR ATTACH"myCommand.ExecuteScalar()

like this i will just extract records from the database this is first

second thing i want to detect the name of the server automatically

like this :

conn.ConnectionString = "Data Source= <big>Here i have to write the name of the server but i don't know what is it name so how can i know without asking the user ?? </big>;InitialCatalog=MyDataBase;Integrated Security=SSPI"

thank you very much for help Smile | :)

try to be good if you can't be the best

Eric Dahlvang1-Jun-06 11:13

Reporting Services with ODP.Net

1-Jun-06 11:13

(local) will work if the server is on the local machine (the same machine the application is running on).

If it isn't local, there might be numerous instances of SQL Server running on the user's network. If you don't know the name of their server, how would you know which one to connect to without asking the user? You could present them with a dialog box that allows them to choose one of those available, then save what they chose somewhere (registry, file, whatever) so you don't have to ask them again. Or, make this a part of your installation process. There are various ways of handling this issue.

----------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters

Code/Decode Password

MohamadJaber31-May-06 10:40

MohamadJaber

31-May-06 10:40

hi I need to know how can I code and decode password in Sql server 2005
(secure)
Thanks

dadax

Re: Code/Decode Password

r.stropek4-Jun-06 6:22

r.stropek

4-Jun-06 6:22

Hi dadax!

Check my blog article at http://www.cubido.at/Blog/tabid/176/EntryID/34/Default.aspx. It describes how to do that using SQL Server's new encryption/decryption feature.

Regards,
Rainer.

Rainer Stropek
cubido business solutions gmbh
Email r.stropek@cubido.at
Visit my blog at http://www.cubido.at/Blog/tabid/176/BlogID/4/Default.aspx

RoadieGS31-May-06 8:57

RoadieGS

31-May-06 8:57

Can the Oralce ODP.Net driver be used with Reporting Services 2000? If so, how do you set up the connection? Thanks.

ADO - SELECT statment

antonaras31-May-06 0:25

antonaras

31-May-06 0:25

Hi buddies i have a relativly simple question

i whant to exececute a select statment in c++
but for the WHERE part of the statment i want to read it from a variable of type string
Let me be more precise.

string token;
token="SomeName"

pCommand->CommandText = "SELECT * FROM Table1 WHERE Name=?";//WHERE Name=token

Any ideas pls help
Thanks again

Re: ADO - SELECT statment

sathish s31-May-06 2:08

sathish s

31-May-06 2:08

Like this

pCommand->CommandText = "SELECT * FROM Table1 WHERE Name='"
& token & "'" ;//WHERE Name=token

Re: ADO - SELECT statment

sathish s31-May-06 2:11

sathish s

31-May-06 2:11

string strsql;
sprintf(strsql, "SELECT * FROM Table1 WHERE Name='%s'", token);
pCommand->CommandText =strsql;

Binding Radio Button to datasource

mamathy30-May-06 19:45

mamathy

30-May-06 19:45

Hello,
I m new to vb.net. I dont know how to connect the Radiobutton with Datasource.

Can anybody help me with example

Regards
Preetha

Re: Binding Radio Button to datasource

Paddy Boyd31-May-06 0:18

Paddy Boyd

31-May-06 0:18

.net 2.0 or 1.1?

For basic code behind binding, you need a datareader, or dataset and then set

myRadio.DataSource = myDataSource
myRadio.DataTextField = "TextFieldInSource"
myRadio.DataValueField = "ValueFieldInSource"
myRadio.DataBind()

Re: Binding Radio Button to datasource

postmaster@programmingknowledge.com1-Jun-06 11:00

postmaster@programmingknowledge.com

1-Jun-06 11:00

Preetha,

You may want to visit http://www.programmingknowledge.com/dataControl.aspx[^]
for an example.

Blob in 60 seconds [modified]

BeerFizz30-May-06 15:34

30-May-06 15:34

configuration:

server:
MySql 5.0.15-nt via tcp/ip
Client:
MySql Client Version 5.0.11
Operating system:
XP
Startup Variables:
Max Packet Size 1mb
Net Buffer Length 16k

I am using Inodb and the c/c++ api

Let me know if you need additional config info.

OK.

I have an app which scans documents and then stores them as a blob. The typical size of an image is around 22k.

During storage, the app batches about 100 of these images along with other information in structures in memory and then initiates a transaction and stores all 100, committing when finished.

This works as expected and the time to do this commit is a couple of seconds, anyway, it is fast enough that it is not an issue.

My problem is this:

When I go to retrieve a single image, it can take as long as 60 seconds. I've played around with this quite a lot and when monitoring the network, to see when the image is downloaded, the image appears to come down right away and then the statement hangs/waits for a timeout before returning... as long as 60 seconds.

The statement which hangs is the:
imageRes_set = mysql_store_result(m_mysqlConn);

QStr.Format("select Image from docimages where BatchNum = %s and ItemId = %s and Side = \"%c\"", BatchNum, ItemId, 'F'); 

mysql_query(m_mysqlConn, LPCSTR(QStr)); 
int ret = mysql_errno(m_mysqlConn); 
if (mysql_errno(m_mysqlConn) != 0) { 
str.Format("Error doing Preset Query 51 - %s\nFailure to do Select on Image", mysql_error(m_mysqlConn)); 
AfxMessageBox(str); 
Close_Database_Connection(); 
return(false); 
} 


imageRes_set = mysql_store_result(m_mysqlConn); 
row = mysql_fetch_row(imageRes_set); 
if (row == NULL) { 
// Does not exist -- So inform and leave 
Mess1.Format("************ The Image, in batch num (%s) does not exist in the Data Base ************\n\n ", BatchNum); 
Mess2 = "\tIt is not possible to View and Key an non existing Image\n"; 
AfxMessageBox (Mess1 + Mess2, MB_OK | MB_APPLMODAL | MB_ICONQUESTION, 0 ); 
Close_Database_Connection(); 
return(false); 
}

-- modified at 23:19 Tuesday 30th May, 2006

BeerFizz31-May-06 1:54

31-May-06 1:54

Anyone any ideas?

Eric Dahlvang31-May-06 3:19

31-May-06 3:19

Have you considered mysql_use_result() rather than mysql_store_result()?

DOCUMENTATION
There are two ways for a client to process result sets. One way is to retrieve the entire result set all at once by calling mysql_store_result(). This function acquires from the server all the rows returned by the query and stores them in the client. The second way is for the client to initiate a row-by-row result set retrieval by calling mysql_use_result(). This function initializes the retrieval, but does not actually get any rows from the server.

In both cases, you access rows by calling mysql_fetch_row(). With mysql_store_result(), mysql_fetch_row() accesses rows that have already been fetched from the server. With mysql_use_result(), mysql_fetch_row() actually retrieves the row from the server. Information about the size of the data in each row is available by calling mysql_fetch_lengths().

After you are done with a result set, call mysql_free_result() to free the memory used for it.

The two retrieval mechanisms are complementary. Client programs should choose the approach that is most appropriate for their requirements. In practice, clients tend to use mysql_store_result() more commonly.

An advantage of mysql_store_result() is that because the rows have all been fetched to the client, you not only can access rows sequentially, you can move back and forth in the result set using mysql_data_seek() or mysql_row_seek() to change the current row position within the result set. You can also find out how many rows there are by calling mysql_num_rows(). On the other hand, the memory requirements for mysql_store_result() may be very high for large result sets and you are more likely to encounter out-of-memory conditions.

An advantage of mysql_use_result() is that the client requires less memory for the result set because it maintains only one row at a time (and because there is less allocation overhead, mysql_use_result() can be faster). Disadvantages are that you must process each row quickly to avoid tying up the server, you don't have random access to rows within the result set (you can only access rows sequentially), and you don't know how many rows are in the result set until you have retrieved them all. Furthermore, you must retrieve all the rows even if you determine in mid-retrieval that you've found the information you were looking for.

----------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters

BeerFizz31-May-06 3:46

31-May-06 3:46

Thanks for the response Eric...

Yes, I have tried both mysql_use_result() and mysql_store_result() with the same outcome, it hangs for about 60 seconds.

I have also checked the rows and fields and when it does return (correctly by the way and with the image) there is exactly 1 field and 1 row as would be expected.

Anything you think I might try or look at?

Eric Dahlvang31-May-06 5:08

31-May-06 5:08

Try disabling your virus scanning software.

----------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters

BeerFizz31-May-06 5:30