|
A connection string for an Access database requires the physical path to the database file to be specified.
Paul
|
|
|
|
|
Problem is that website host in another server .so we donot know physical path of mdb .
|
|
|
|
|
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
|
|
|
|
|
Thanks but web Aplication running now so it is not possible .
Manu
|
|
|
|
|
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.
|
|
|
|
|
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 .
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
