Lengkap

Access database SQL query for ASP application

I have a classic ASP application and using Access database.

i have two Microsoft Access database and each database has "Parts" table

Each Parts table stores different data.

I want to display all data from two parts tables

----First Database----

database name: [url removed, login to view]

table name: parts

fields: partno, partname, info

----Second Database----

database name: [url removed, login to view]

table name: parts

fields: partno, partname, info

i need full SQL query for ASP language.

First database Connection string will be

pass1="111222"
MyDB1 = Server.MapPath("admin/database1.mdb")
Set cn = Server.CreateObject("ADODB.Connection")
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&MyDB1&";Jet OLEDB:Database Password="&pass1
cn.Open


Second database Connection string will be

pass2="222111"
MyDB2 = Server.MapPath("admin/database2.mdb")
Set con = Server.CreateObject("ADODB.Connection")
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&MyDB2&";Jet OLEDB:Database Password="&pass2
con.Open

Kemahiran: ASP, Microsoft Access, SQL

Lihat lagi: query sql server access 2007 vba, asp page query access database, asp online application program database access, sql, microsoft access, convert database sql server access asp, software write mq4, software write chip epson, useful software write book, convert access 2000 application 2005 sql database, software write web specs, free software write user guide, software write edid, free software write company profile, software write websites idea, convertire database access web application asp, software write book images, software write books, software write protection, free software write book

Tentang Majikan:
( 29 ulasan ) Melbourne, Australia

ID Projek: #11960332

Dianugerahkan kepada:

hardikshah83

Experienced programmer with more than 10 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like MySQL, Mic Lagi

$25 AUD dalam sehari
(21 Ulasan)
4.7
guoxinliu917

Hello, I am ASP, Access and Microsoft SQL Server expert. I have done many projects using classic asp, access and Microsoft SQL Server database. Look at my work samples https://www.freelancer.com/jobs/project-1150377 Lagi

$50 AUD dalam 0 hari
(79 Ulasan)
7.0

15 pekerja bebas membida secara purata $38 untuk pekerjaan ini

ITservice

Hi, I have developed various projects in ASP with MsSql database. Infact, 90% of the projects done so far are in ASP, which includes simple dynamic page to complex ecommerce related websites. Will make the query Lagi

$55 AUD dalam sehari
(180 Ulasan)
7.5
SKJoy2001

SQL ================================================================ SELECT DB1P.* FROM parts AS DB1P IN 'C:\MyData\[login to view URL]' UNION SELECT DB2P.* FROM parts AS DB2P IN 'C:\MyData\[login to view URL]' ======== Lagi

$25 AUD dalam sehari
(12 Ulasan)
4.3
alaeddindhahri

Hi, I'm a professional Microsoft Access and VBA developer with strong background in developing and modeling information systems using Ms Access. I have read your project description and would like to help you fulfillin Lagi

$40 AUD dalam 0 hari
(7 Ulasan)
4.1
crypthne

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ Lagi

$30 AUD dalam 2 hari
(17 Ulasan)
3.8
roamabdul

'WILLING TO BE PAID ON YOUR TERMS' Hello sir.. I offer my services for the job you posted. I can solve your problem. I have more than 11 years of experience of dealing with SQL and Access Databases. Please let me h Lagi

$25 AUD dalam sehari
(5 Ulasan)
3.5
farhan1991

Hello Sir. I have 5 years of experience in asp.net development. This is a very easy task I am interested to work for you on this project. Just message me so that we can start waiting for your positive response :)

$25 AUD dalam sehari
(6 Ulasan)
3.1
dlmvikas

first of all query will not be in asp language it will be written either in C# language or raw SQL query. So if interested then let me know.

$20 AUD dalam sehari
(4 Ulasan)
1.5
$30 AUD dalam sehari
(0 Ulasan)
0.0
srilakshminithu

Am clear with your requirement and I can finish as soon as possible

$25 AUD dalam 5 hari
(0 Ulasan)
0.0
jfonseca

Hi, i have more than 15 years building ASP.NET web applications for commercial banking, Insurance and International Cooperation sectors. Please, let me know the scope details. Best regards, Jairo

$35 AUD dalam sehari
(0 Ulasan)
0.0
khp31

Sr. Software Developer having 7+years experience. Sr. Software Developer having 7+years experience. Sr. Software Developer having 7+years experience. My Contact Info SKyid: ktanpatel31 if required.

$77 AUD dalam sehari
(0 Ulasan)
0.0
phuckn2015

i can do it at the moment. i am programming apps related to sql server 2008+. i will complete this job for you. so please give it to me.

$55 AUD dalam 5 hari
(0 Ulasan)
0.0
satyenverma

A proposal has not yet been provided

$30 AUD dalam sehari
(0 Ulasan)
0.0
asiza

Hi. just create record set for both tables and loop through each recordset to display data. i can help you in an hour if you like. thanks and regards

$15 AUD dalam sehari
(0 Ulasan)
0.0
ndataconsulting

Hello, I found your Access database SQL query for ASP application job post and I am very interested in your project. I am an expert in classic ASP, ASP.NET, ASP.NET Core 1.0, VB.NET, C#, MVC, EF, EE, WebAPI, WCF, MS Lagi

$61 AUD dalam sehari
(0 Ulasan)
0.0