|
They also provide one usename with full access on this mdb then it is possible to access or not ?
Manu
|
|
|
|
|
Yes, but if you can't actually access the network to get to the mdb file to try and login to the DB with the provided username, it's not really going to help you, is it?
|
|
|
|
|
Dudes,
I have a new project using SQL database. Here`s my scenario.
I have two database.
Database Name: PCON_A
Database Used: 2006/01 to 2006/12
Database Name: PCON_B
Database Used: 2007/01 to 2007/08
I want to copy the database PCON_A to PCON_B using sql script.
How to do that?
Thanks in advance,
Jeof;)
******************************
I just want to
know everything
|
|
|
|
|
|
link doesn`t work.
******************************
I just want to
know everything
|
|
|
|
|
Oops. Copy-and-paste error.
This link should work.
Paul
|
|
|
|
|
got it. this is very helpful.
thanks so much.
******************************
I just want to
know everything
|
|
|
|
|
<br />
<br />
INSERT PCON_B.dbo.TABLE1<br />
select * from PCON_A.dbo.TABLE1<br />
<br />
or even
<br />
<br />
truncate table PCON_A.dbo.TABLE1<br />
<br />
INSERT PCON_B.dbo.TABLE1<br />
select * from PCON_A.dbo.TABLE1<br />
<br />
|
|
|
|
|
Can i implement the same concept that google use when u press search and gives u did u mean...
For example if i put Camille and press search it gives me the following possiblilities:
1- Camile
2- Kamil
3- Kameel
I was thinking of comapring first 4 characters and last 4 characters if we have 2 or 3 charcters common it displays it.
|
|
|
|
|
You could consider storing a dictionary of words in your database and using the SOUNDEX function to test for phonetic similarity.
Information on SOUNDEX can be found here.
Paul
|
|
|
|
|
How to insert two tables in one gridview?and how to connect it and to navigate...tnx;)
sunshine
|
|
|
|
|
You could use a stored procedure with a temp table and use that
<br />
<br />
create proc myproc <br />
<br />
AS<br />
<br />
SELECT * INTO #TEMP<br />
FROM Table1<br />
<br />
<br />
SELECT * INTO #TEMP<br />
From * Table2 <br />
<br />
select * from #temp<br />
<br />
go<br />
<br />
or use a Union SELECT
<br />
<br />
SELECT * FROM TABLE1<br />
UNION ALL<br />
SELECT * FROM TABLE2<br />
<br />
You get the idea, use SQL to do it.
|
|
|
|
|
Dim con As New OleDbConnection("Provider=Microsoft.jet.oledb.4.0; Data Source = C:\Users\--Sunshine--\Documents\thesis\Database1.mdb")
con.Open()
Dim da As New OleDbDataAdapter(sql, con)
sql = "Select * from Supplier_Information union all Select * from Products"
da.Fill(ds, "Supplier_Information and Products")
dgvSupplier.DataSource = ds.Tables("Supplier_Information and Products").DefaultView
is this right?how will i assigned in my textboxes the table name?
txtsuppID.Text = ds.Tables("which tablename??").Rows(inc).Item(0)
tnx
|
|
|
|
|
I have a table that was created a few years ago (LIVE), but I need to change ANSI_NULLS from OFF to ON for this table. How can I do that without re-creating the table?
Thanks in advance!
|
|
|
|
|
Whats your database SQL Server ????????
You may have to change the value of any nulls in the table first
|
|
|
|
|
i want to know when i log into the sql server db whether i have connected successfully, using sql login via my appilication. is there any parametre the server passes back to the applicatioin.
|
|
|
|
|
According to connection object provide the property named state which denote the connection is establish or not.
Parwej Ahamad
g.parwez@gmail.com
|
|
|
|
|
hi all im using sql server reporting services, to do a report, but i want to disable or hide the print button of the report.... please somebody help me or tell me if is possible do that....
thanks
luis
|
|
|
|
|
Are you using the ReportViewer control to display the report? If so, set the value of its ShowPrintButton property to false.
Paul
|
|
|
|
|
|
You can modify the URL to hide all the toolbars.
|
|
|
|
|
|
hello friends i am third year engineering student i have created a database system using vb.net and mysql which is working fine on a standalone system but now i want this system to be on multiple machines and connected through lan network with one pc working as the server
.
I am non-geek in networking so please can any one help me on this regard.please
gautam karan singh
student
|
|
|
|
|
It depends on the database.
Access : needs a direct url path eg. \\server\share\db.mdb
ODBC: Need a SQL server connection string and a network compliant application
You question is a bit fluffy to answer.
|
|
|
|
|
Hi ..
thanks for all here ..
on my example .. I want to save the image of a PictureBox to the Sql server 2000 database ...
I know how cant save it from a file ...
but I want to know how save the PictureBoc's image ...
again .. any one will try
jooooo
|
|
|
|