I have an asp news website which used an MS Acess database. The website has a config.asp which is where the order to the database originates,
I have to move to MySQL but am having trouble. I used Bullzip which didn't quite transfer all the files, and then tried Data Doctor Ms Access to MySQL, when i check with a GUI client it looks like the files have been transferred.
The problem is that the pages return an error on the web,
The publishing software tells you to amend the database connection string in the config asp file and a few other minor changes, i did all that,
then it returns an error from another include page
I seem to connect OK, using this - Set MyConn = Server.CreateObject("ADODB.Connection")
-
MyConn.Open "Driver={MySQL ODBC 3.51 Driver}; Server=MYSQLSERVERADDRESS; uid=USERNAME; pwd=PASSWORD; database=DATABASENAME; option=3; port=3306;"
but the page on the web says this line of code (not in the config.asp ) returns an error - RS_SIDE.Open SQL_SIDE, MyConn_SIDE
any tips as what is causing this? would appreciate some responses, i'm not html literate, so pls keep it simple:)
many thanks
2  1813  code green 1,726
Recognized Expert Top Contributor
Maybe you would be better on the help site of the third party software you are using.
The errors are coming from their software not MySql
I am using DB convert, the trial version, at least this one produced a few good results, Bullzip, and others didn't work,
I'm sure it's a matter of tweaking the code, as i had other errors which i was able to resolve, by fiddling with the code...
thanks for your input, any others please? surely their are some Mysql and Asp genius's here;)
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: steve |
last post by:
I am having huge problems migrating large db’s from one server to
another. I use phpmyadmin to dump the data into a file, and then
migrate it to my production server. Then I try to use this:
mysql dbname < filename
but if the tables are too large, it simply does not work.
So I tried the following two work-arounds, which work but are tedious.
Is there a nicer way to do it:
Solution A: Create a dump file with subset of all the...
|
by: Rich May |
last post by:
Afternoon all,
Apologies for cross-posting but as my query covers both Access and SQL
Server I thought I'd send it both!
I have inherited a project to migrate a fairly complex series of
Access databases into a single proper SQL database with a web front
end.
Its quite a nasty job as people are working on a variety of data sets
|
by: david |
last post by:
Hi,
I have the following code which returns an error when run as part of my
ASP SQL....
strquery = strquery & "FROM (Customers INNER JOIN Orders ON
Customers.CustomerID = Orders.CustomerID) INNER JOIN (Products INNER
JOIN (OrderLines INNER JOIN StockMovements ON OrderLines.JobNumber =
StockMovements.JobNumber) ON (Products.ProductID =
OrderLines.ProductID) AND (Products.ProductID = OrderLines.ProductID))
|
by: JDS |
last post by:
Hi all. I don't know if this is possible, and if it is, whether it needs
to be done within Apache configuration or PHP configuration, but here goes:
I am migrating my web server to another machine. In fact, it is two
machines -- one for the web server itself, and one as a data server for
user home directories and MySQL.
The users' home dirs will be mounted on the web server as NFS mounts.
Now, the original, current, configuration...
|
by: canigou9 (remove your socks to reply) |
last post by:
(cross posted - comp.databases.ms-access, microsoft.public.access)
Hello folks - this is my first post here, after a short lurk.
I have written an application in Access2002 for a friend's business
which allows him to take orders, arrange deliveries and trace
deliveries back in the event of subsequent complaints.
It uses a handful of tables in a relational schema, with a few
ancillary lookup tables, some forms, reports and VBA modules.
| | |
by: Kenneth P |
last post by:
Hi,
I have installet MySql 4.1 db and am using .Net Connector successfully.
I have a few databases with a lot of tables I'd like to migrate and aftewr
I've converted them to access and am trying to migrate the access database to
MySql 4.1 db I come to a picture "Source Schemata Selection". Since I don't
use schemata at all I don't know how to continue. Do I have to set up
schemata in the mysql admtooll? How can I do that, because I had...
|
by: tc |
last post by:
I have an app that I'm re-writing for MySql and MsSql, the old version
connected to an Access database. It is more than likely that existing
customers will want to upgrade to the later version. I don't want to rely
on 3rd party apps for Migration, so.... I'm more than happy to write the
connection code and transfer the data myself, but I don't know how to ensure
that all Auto Number fields in the Access database transfer correctly, as in...
|
by: janetopps |
last post by:
I am trying to migrate from an MS access to MySQL and am having problems. I have an asp pages on my website.
<% ' Dim SQL_REC, RS_REC, NID, TITLE, POSTED, NEWS_LISTING, SHOW_HL, MyConn_REC, I_REC, SUMMARY
' ------------------------------------------------------------------------------------------------------------------
|
by: theS70RM |
last post by:
Hi,
Im having some issues migrating a database using mysql tools.
I have a windows 2000 server running an older version of mysql hosting several databases. If I connect locally on that server using a standard user account I set up (not root) I can see all the schemata.
When I connect from another machine (winxp) I can only see (and therefore migrate) only one database. All I need to be able to do is connect using mysql tools on...
|
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: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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
| |
