ljj
Jul 24 2008, 02:23 PM
| | Hello:
I am new to JAVA and server-side applications and have a dumb question. I have set up Tomcat on my machine and created a JSP program to query an Access database using a DSN-Less connection. If I publish the page to a webserver and include the .MDB file will it work? I'm not sure exactly what needs to be packaged with my Java application to make it work. Since I don't have a remote server that supports .jsp I cannot really test it. I'm assuming that JDBC driver would be bundled with my site but not sure.
Thanks! |
Comment/Reply (w/o sign-up)
(G)mani
Dec 6 2008, 06:28 AM
remote server connection string
Database Access On Remote Server W/jsp
I using asp.Net and ms access databse I am able to run in localhost but I need the connection for remote server sp kindly help me ...
Con = new OleDbConnection("Provider=MS Remote; Remote Server=http://69.50.218.251; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\\bin\\SearchAndLogin.Mdb;Username = info@bookforstay.Com;password=india123");
-reply by mani
Comment/Reply (w/o sign-up)
(G)vasanth.a
Jul 18 2009, 11:49 AM
Fetch Data from the Remote Server Database
Database Access On Remote Server W/jsp
hai,
I want to connect the remote server from my LAN to access the database of the remote server in C# code. So give me some useful ideas.
-reply by vasanth.A
Comment/Reply (w/o sign-up)
Similar Topics
Keywords : database, access, remote, server, w, jsp
- Free Or Opensource Database/schema Browser?
Alternatives to TOAD or PL/SQL Developer (6)
How To Understand A Database Schema
A very nice and simple tutorial (9) Yesterday while i'm seaching for a data model and database schema at the Library of Free Data
Models for a new project of a friend of mine i found there this nice and simple tutorial on How to
Understand a Database Schema . As its name says, this tutorial will help you to better understand a
Database Schema and covers the following basics topics that every Database Schema must define:
QUOTE Primary and Foreign Keys. One-to-Many and Many-to-Many Relationships. Inheritance.
"Rabbit's Ears", (Recursive relationships). The Scope of this tutorial is ....
Best Database
(16) What is the best free database if some one trying built a social networking website? And how to
operate it with dreamweaver 8?....
Some Useful Database Links.
(7) I thought I would take a moment to point the users here to some of the database resources available
for reference and learning. First I will start with actually designing the database. This site by
R937 covers the basics of database design. The author is professional database guru and a frequent
helper at the at DB forums listed below. The Library of Free Data Models is an excellent
resource for finding data models for projects you may have or as examples of well put together data
models. With around 500 data models the chances are you find something at least cl....
Space Needed For Database
(10) Iam assuming the information in the databases i will create will be stored in the 500 MB space i
get, but since 500MB isn't enough iam wondering if you guys can tell me how much bytes the
following take: Varchar(x),Tinyint,Text,date,smallint,mediumint,bigint,float.... And the rest
present when you add/edit a row in a table. Also what are the ranges of tinyint,smallint,mediumint
and big int....
Mysql Database Entry By Excel Sheets
(2) Hello .. I would like to ask if i can use use Microsoft excel files in order to make entries to
mysql database. Thanks....
Mysql Database Management
(1) Hi i am new, I have a problem in understanding the query decomposition in D-DB. Can anyone help me
to understand the first question of the exercise 25.21 of Elmasri-Navath 4th edition? Consider the
following relations: BOOKS (Book#, Primary_author, Topic, Total_stock, $price) BOOKSTORE (Store#,
City, State, Zip, Inventory_value) STOCK (Store#, Book#, Qty) Consider a distributed database for a
bookstore chain called National Books with 3 sites called EAST, MIDDLE, and WEST. Consider that
BOOKS are fragmented by $price amounts into: B1:BOOK1:up to $20. B2:BOOK2:from ....
Accessing Ms Access Database From A Centralized Location?
(10) Hi I am a manager at a trading/wholesaling company (and have no programming background). I
customized the Northwind sample access database to make invoices and keep accounts for my company.
We now opening another office at a distant location. So, the order entry will be done at two
points(we plan to use the same Access database). I am not able to figure out how to access the same
MS Access database from two different location(as LAN can't be used). Moreover, we can't
afford to pay huge sums to the software developers. Can intranet or uploading the database t....
Integrate Access Database Onto Intranet Site
Looking to integrate access database into my intranet site (5) Hey guys, im new here and am looking for answers /tongue.gif" style="vertical-align:middle"
emoid=":P" border="0" alt="tongue.gif" /> Firstly, i have designed a database using M$ access, it
consists of multiple forms which i plan to host on an intranet website, i need to be able to add
records directly from the form on the intranet website aswell as being able to edit/review current
entries on forms in the database. My question is, how would i go about integrating these forms onto
the intranet website? i plan on keeping the database and the intranet site on the same d....
Database
prblem with it (1) i have free script but it is working fine on a lot of sites i tried to use it to my web site ....i
edit its config.php right and but my database name and my user name and password every thing right
and when i try to install it it gives me this error can`t connect to database please choose file
from this mobile.sql can any body help plz coz i tried huderd of times and no thing happend....
Connecting To A Remote Database
(9) I wondered if anyone here can help. I have a database on a remote server (A). I want to access it
through a php script on a different server C. I have allowed access on (A) in Cpanel - mysql dbases
- Remote Access by putting the IP address of server C The host of server (A) has also whitelisted
the IP of server C. Though I am having trouble connecting from server C which is with a different
webhost. any ideas how to get round this? I have though of SSH forwarding, but I think this can
only be used to connect a client - e.g. my pc to the remote server A. I do not ha....
Need Help In Database Auto_increment
(9) i am creating a game and i set when someone registers than he gets id...in "extra" i have set it to
be "auto_increment" but whenever new player signs up he gets number bigger than 210...(my first id
was 211,next was 212,third was 213,fourth got 214) how to set it to go from 1 to infinite? thnx....
World Of Warcraft
Server (2) Is Hosting a World of warcraft server Illegal? I ask because I was playing and I spotted a ad for a
server. I do not have anything to make it with but would like to know before I do anything. Thanks,
Apez....
Script Tables On Sql Server Compact
(0) So I have an application that's using SQL Server Compact Edition 2005. I need to export the
table schema to a file of SQL statements, containing only the schema...no data, no rows, just the
tables, indexes, and constraints. Now, when using SQL 2000/2005 I just use the script table as...
feature to do exactly this, but because SQL server Compact Edition doesn't have the support for
it, I can't do this. The tables in SQL Server Compact *do* have the information_schema views
though, so I was wondering if anyone knows of any tools that can read these views and....
Access 97 To Access 2003
(15) I need to convert a database that is in Access 97 to Access 2003 but every time i do it using the
Convert tools of Access 2003 i got some errors and can't change or add any of the objects
-tables, querys, etc- of the converted database. All the errors i got are related to the user
priviligies and permissions of the database, is there exists a way or procedure that allows me to
reset this permissions??? Best regards,....
Access
Is this easy to make a login/password? (17) I was looking to make a site where people need to create an account, and log in to view the main
pages. Is it easy, or do-able, to use msoft access to make a database where people are able to sign
up with a username and password via my website?....
Permission Problem With Mysql Database Creation
Please Help! (8) I seem to have a problem with accessing my database with proper permissions. I have set the my
database correctly giving my db username all priviliges yet i seem to be unable to even log on with
this username with a denied access error. Any ideas on resolving this?....
Is It A Good Practice To Store Image Or Other Binary Files Directly In A Mysql Database
(6) Hello to all of you beautifull people out there, I am new to MySQL, i just wanted to know if its a
good practice to directly store images and other binary files in a MySQL database. Any one with
help? Thanks....
MS Access Validation Rule
Desperate help needed (4) I have to create a whole project using Microfost Access. I have a field which will eventaually
contain details of a a list of people's DOBs. I have added an input mask, so that it it displays
the place holder __/__/____ However, how can I validate this field. For example, not it is possible
to type 30/10/1991 . How can this be changed so that it validates it correctly?....
Access -> Mysql
Converter (8) I have a problem. Is any program wchich converts database Access to Mysql ??....
Read/Write Issues After Copying An Access .mdb File
(4) Alright, I'm currently creating an interface program for a MS Access database. I've only
used Access once in the past but used other DB's a handful of times so I didn't have any
trouble getting the general program created. My issue arose when I tried to make it so that the
users needing to use the program can just copy the .exe and the .mdb files and use it. The program
doesn't require users to share the database but to store their OWN programs information in their
OWN database, so basically each needs to have their own database with the exact same d....
MS Access DB To Webpage Connection ?
(6) ok .. i have this little problem i am going through ... Leme explain this project of mine first . I
have a MS Access DB of student fields like ID no, Name, Marks .. etc .. This one Access DB would be
updated by just adding more rows and would be done on the server. It looks sumthing like this:
Now .. I have a HTML page that shows this : I would enter the ID number of a student (no
authentication .. anyone can access anybodys marks), and when i hit submit .. I would be taken to a
page that gets the values from the ID specified and shows it in the next page. The pa....
MySQL Output Database Question
(19) I am new to MySql and have just created a database after using a script. My problem is not the
script, but what it says about putting it into the output file. I cant figure out the right terms
to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE
'location' but it isnt working. I'm lost with this stuff, I really am. Can someone
please help me out?....
MS-database To MySQL
I'd like to batch them (6) Hi, maybe one of you already came across this, so I ask. I'll continue searching on. I've
got two vocable trainers, one is Windows-native, the other one is on the web. While I can't
control the output of the Windows-thing (so I can't export them to a *csv or something), I can
write an import script. But since I'm not that great with Regular Expressions and don't know
anything about *.mdb (that is MS SQL, isn't it?) files, I would need some finished thing to make
out the field information and put it in arrays or something more readable. It wou....
Mirror My MySQL Database To Another Mysql Server
(7) Hi..I want to ask if its possible to automatically mirror my mysql databases into another mysql
server?or create a small php script to do this? The reason is because, we all know that database is
very improtant if we have dynamic website. I have my forum hosted and i want to automatically
mirror this or backup into another mysql server(free). Like in freesql.org. So that im not afraid
that i forgot to backup my database..also i have one central backup database. Thanks for the
help..Im looking forward for this posibility.....
Need Advice On Creating Online Music Database
ps - dont know anything about databases! (6) I need to create a database of around 1000 music albums that I can put on my site, with the ability
to search the database according to several different criteria. Being a complete and total NOOB to
the world of databases, can anyone point me in the direction of some software that will let me
create a good-looking and functional database, but that isn't too complicated for me to use?!
Sounds like a tall order I know, be grateful if anyone can help though. Thanks!
Notice from microscopic^earthling:
Topic edited to reflect content....
MySQL Database Problems
(8) My friends have a little forum running here . The problem is that quite often we get the following
message when we try to open the page: QUOTE Warning: mysql_connect(): Can't connect to
local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in
/home/vhosts/rohit.bizhat.com/forums/db/mysql4.php on line 48 Warning: mysql_error(): supplied
argument is not a valid MySQL-Link resource in /home/vhosts/rohit.bizhat.com/forums/db/mysql4.php on
line 330 Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in
/home/vhosts/roh....
Error In Installing MySQL Server
MySQL server cannot be started (9) I try to upgrade my MySQL server from 4.018 to 4.1.10a. Firstly, I downloaded mysql-4.1.10a (not the
essential one) for win XP Then I install the new version after the old version was uninstalled.
After the installation process, Instance Configurator comes up to help for the configuration. But an
error occured when it try to start the MySQL service. Error messageis "cannot create windows
service for MySQL. Error:0" So my MySQL server cannot be started. It is running win XP on my
computer. Does anybody can tell me what is wrong?. Thanks (sorry for my bad english)....
How Can I Import Csv Files To My MySQL Database?
I was able to export but where's import? (3) I am having hard times finding that import csv in the mysql phpmyadmin. I once worked on some csv
files and someone imported it on the mysql server. I was not able to ask him. Does someone know how
can I import csv files in mysql server?....
Embedded Database
Embedded Data base at client side, (7) Hi, Now its the era of Embedded databases, no more db servers, no more host,Because with embedded
db you can get all those options, what you are used to get with DB Servers. Some of Embedded DB Are
1) Cloudscape From IBM (NOW Derby from ASF) 2) HSQLDB (OpenSource) and many more Feel the power of
EDB Cheers Arunkumar.H.G....
Looking for database, access, remote, server, w, jsp
|
See Also,
*SIMILAR VIDEOS*
Searching Video's for database, access, remote, server, w, jsp
|
advertisement
|
|
