Database

manuo56-Sep-07 23:28

6-Sep-07 23:28

Problem is that website host in another server .so we donot know physical path of mdb .

pmarfleet6-Sep-07 23:32

6-Sep-07 23:32

I don't think there is an easy solution to your problem.

You should probably consider migrating your database to SQL Server or something similar.

Paul

manuo56-Sep-07 23:45

6-Sep-07 23:45

Thanks but web Aplication running now so it is not possible .

Manu

Paddy Boyd7-Sep-07 0:28

Paddy Boyd

7-Sep-07 0:28

How come you don't know the physical path to the webserver? Is it not on your network?

Do you need access to all the data in this database file? If you only need a small subset, you could create a couple of webservices to return the data you require, although this becomes very cumbersome for more than a couple of queries.

manuo57-Sep-07 1:50

7-Sep-07 1:50

Thanks for reply
it is not on your network ,it is another server not on my network.I know Ip of this server only and name of mdb file . we want to fetch subset of all tables userwise data .

Paddy Boyd7-Sep-07 2:21

Paddy Boyd

7-Sep-07 2:21

So it's on another network that you don't have direct access to? I don't think you will be able to directly access this database.

manuo57-Sep-07 2:52

7-Sep-07 2:52

They also provide one usename with full access on this mdb then it is possible to access or not ?

Manu

How to copy database from other database

Paddy Boyd7-Sep-07 3:01

Paddy Boyd

7-Sep-07 3:01

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?

C#Coudou6-Sep-07 21:19

C#Coudou

6-Sep-07 21:19

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

pmarfleet6-Sep-07 21:57

6-Sep-07 21:57

Have a look at this article.

Paul

C#Coudou6-Sep-07 22:12

C#Coudou

6-Sep-07 22:12

link doesn`t work. Frown | :(

******************************
I just want to
know everything

pmarfleet6-Sep-07 22:17

6-Sep-07 22:17

Oops. Copy-and-paste error. D'Oh! | :doh:

This link should work.

Paul

C#Coudou6-Sep-07 22:32

C#Coudou

6-Sep-07 22:32

got it. this is very helpful. Smile | :)

thanks so much.

******************************
I just want to
know everything

Frank Kerrigan7-Sep-07 5:06

Frank Kerrigan

7-Sep-07 5:06

<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 />

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

Did u mean ??

samerh6-Sep-07 21:17

samerh

6-Sep-07 21:17

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.

Re: Did u mean ??

pmarfleet6-Sep-07 21:54

INSERTING TWO TABLES IN ONE GRIDVIEW

6-Sep-07 21:54

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

shyne76-Sep-07 20:58

shyne7

6-Sep-07 20:58

How to insert two tables in one gridview?and how to connect it and to navigate...tnx;)

sunshine

Re: INSERTING TWO TABLES IN ONE GRIDVIEW

Frank Kerrigan7-Sep-07 5:10

Frank Kerrigan

7-Sep-07 5:10

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.

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

Re: INSERTING TWO TABLES IN ONE GRIDVIEW

shyne710-Sep-07 8:54

shyne7

10-Sep-07 8:54

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

Can I modify ANSI_NULLS after table is created?

ckruger6-Sep-07 20:49

ckruger

6-Sep-07 20:49

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!

Re: Can I modify ANSI_NULLS after table is created?

Frank Kerrigan7-Sep-07 5:11

Frank Kerrigan

7-Sep-07 5:11

Whats your database SQL Server ????????

You may have to change the value of any nulls in the table first

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

how to know the connection is establised

prasadbuddhika6-Sep-07 17:11

prasadbuddhika

6-Sep-07 17:11

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. Smile | :)

Re: how to know the connection is establised

Parwej Ahamad6-Sep-07 19:26

Parwej Ahamad

6-Sep-07 19:26

According to connection object provide the property named state which denote the connection is establish or not.

Parwej Ahamad
g.parwez@gmail.com

hide print button in reporting services

Luis Corrales6-Sep-07 9:59

Luis Corrales

6-Sep-07 9:59

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

Re: hide print button in reporting services

pmarfleet6-Sep-07 10:31