Hi,
Quick question,
We have a Cobalt Qube 3 Server running Linux & Chilisoft asp.
At the moment my asp applications pull data from the installed MySQL
database which is fed data via MS Access (via ODBC) which is used as
our in-house front-end between 3 staff doing data entry.
We are now possibly looking to implement an ERP/MRP solution to run
our head office & manufacturing site. The data would therefore come
from the new software and no longer from MS Access.
I can export the data via ODBC in windows into MySQL, but I cannnot
Import/link the tables back into the software as I do now with MS
Access to ensure that the web apps data is live as of the moment you
enter information. I would therefore have to do updates several times
a day which is a bit messy.
As the asp pages run from our Cobalt server, how is it possible to set
up an ODBC connection on the Linux server when there is no interface
like we have in Windows. I am trying to get the asp pages to connect
to their database wich is somewhere else on our network, not the
server.
Is this possible ?
Appreciate your thoughts....
David. 3 1440
>As the asp pages run from our Cobalt server, how is it possible to set up an ODBC connection on the Linux server when there is no interface like we have in Windows. I am trying to get the asp pages to connect to their database wich is somewhere else on our network, not the server.
This would make sense to be asking in a Linux or Cobalt newsgroup or
support forum, since it isn't ASP related.
Jeff
since it isn't ASP related ????
What ?, can you not read the word ASP several times in my question....of
course it's asp related !!!...DOH !
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
IIRC (you didn't quote your original post, so excuse me if this is way off
base) you are asking how to set up an ODBC connection on a Linux box. While
the connection may be used in ASP the question is not about ASP (and many
here do not generally attempt to answer questions about ChiliSoft ASP
regardless).
--
Mark Schupp
Head of Development
Integrity eLearning www.ielearning.com
"David Gordon" <da***@scene-double.co.uk> wrote in message
news:Oc******** ******@tk2msftn gp13.phx.gbl... since it isn't ASP related ????
What ?, can you not read the word ASP several times in my question....of course it's asp related !!!...DOH !
*** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: David |
last post by:
Hi,
I have a local user on our network running MS Access 2003 (on Win XP
Home), which needs to connect to a Back-End MySQL DB on our Cobalt
Qube 3 Server.
I installed the correct software to run the Access on their Win XP OS,
and installed the ODBC MySQL Driver 3.51.
When I test the connection in the ODBC panel, CONNECTED !
Then I open MS Access, and great, the app works.
|
by: Steve Farber |
last post by:
I'm not especially new to databases and I have used ODBC before with
other data sources, but I cannot seem to get Access 2003 to talk to
MySQL 4.0.15.
I have MySQL running with new tables defined, but I cannot get a
connection to those tables via ODBC using MyODBC 3.51.
Can anyone point the way?
Many thanks,
|
by: Greg Gursky |
last post by:
Hello:
I'm doing some planning on a potential project with which I need
some help. The database at the focus of this question is a
MS Access database that is currently accessed by DAO from a local
webserver. I need to access the same database remotely through
TCP/IP. There will be potentially many transactions coming from
both the web server and remotely, so the solution needs to keep
the data safe in such an environment. However,...
|
by: David |
last post by:
Hi,
I created an MS Access 2000 front end a long time ago. We use it every
day and everything works great. This MS Access DB is held in a folder
on our Cobalt Qube server. On this server we also have MySQL
installed.
I have allready hapilly exported some of the MS Access tables into
MySQL and import-linked back. Again everything works great.
|
by: David |
last post by:
Hi,
I have an MS Access database in which the tables have been exported to
a MySQL DB on a Cobalt Qube 3 server and then import linked back into
MS Access. This was all done via an User DSN (ODBC) I created on my
local machine.
I then put my front-end on a shared directory on our network. I have
one other user who needs access. I added a shortcut from this
front-end onto their desktop, but whenever I run MS Access, it says it
| |
by: Jon |
last post by:
I have an asp.net app that I've localized using satellite assemblies. It
works wonderfully, even for displaying dates. My problem comes when I try
to use one of those dates in a SQL query.
I have an SQL like "SELECT * FROM Table WHERE date < @Date"
I make a parameter for it as type SQLDBType.DateTime. This works great for
US dates (12/31/04, for instance). But, the equivalent Frnech date
(31/12/04) throws an excption with the...
|
by: dronkanoki |
last post by:
I am attempting to set up myODBC 3.51 on Win XP Pro to a remote MySQL Linux server. I get the following error:
Access denied for user: 'username@ipaddress.serviceprovider.net' (Using password: YES)
I had MySQL installed locally for testing, and myODBC worked fine. All the other apps I use locally (Dreamweaver, PHPmyAdmin, MySQL Front) work great on the remote server with the same login info.
This is my thought (patience, please). My...
|
by: pradeep |
last post by:
Hello,
How to create system DSN (ODBC) on windows 2003 for SQL Server located
on remote machine ?
Please, guide me.
Bye.
|
by: Justin Cave |
last post by:
"Chris Blair" <chris_w_blair@yahoo.com.uk.zzwrote in message news:<bhvk6a$mpf$1@nobel2.pacific.net.sg>...
My guess is that you're not escaping the colon (:). In ODBC :<foo>
indicates the presence of a bind variable.
I have to second Sybrand's concern, though. Why do you want to create
triggers on the fly via ODBC?
Justin Cave
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| | |