| Author |
 Topic  |
|
shaungallant
Starting Member
5 Posts |
 Posted - 19 January 2005 : 12:34:45
|
I would have thought so too, but unfortunately neither is working for me. For server_IP, should I be using something like localhost, or the server's actual IP address?
Shaun
quote:
Originally posted by Gremlin
Either of the two provided in the config.asp should work
'strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL w/ MyODBC v2.50
'strConnString = "driver={MySQL ODBC 3.51 Driver};option=4;server=SERVER_IP;user=UID;password=PWD;DATABASE=DB_NAME;" '##MySQL w/ MyODBC v3.51
< |
 |
|
|
scuderip
Starting Member
5 Posts |
Posted - 20 January 2005 : 11:24:25
|
I had the same problem using MyODBC 3.51.10.
I solved this problem downgrading myODBC to the version 3.51.09
Excuse me for my bad English, but I'm italian.< |
Image, no matter what you do, you will never be allowed back at Snitz. We want honest people, here!
|
|
|
|
shaungallant
Starting Member
5 Posts |
Posted - 20 January 2005 : 19:26:35
|
That worked like a charm. I downgraded to MyODBC 2.5 and all is well.
Thanks,
Shaun
quote:
Originally posted by scuderip
I had the same problem using MyODBC 3.51.10.
I solved this problem downgrading myODBC to the version 3.51.09
Excuse me for my bad English, but I'm italian.
< |
|
|
|
shaungallant
Starting Member
5 Posts |
Posted - 21 January 2005 : 07:22:51
|
quote:
Originally posted by shaungallant
That worked like a charm. I downgraded to MyODBC 2.5 and all is well.
Maybe I spoke too soon. Now I'm getting this error:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch
/forum_new/topic.asp, line 352
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Page:
GET /forum_new/topic.asp
Time:
Friday, January 21, 2005, 7:12:03 AM
More information:
Microsoft Support
I've converted the database using the method described in this thread, as well as mysqlfront doing an odbc table import, but nothing seems to work.
Does anyone have any ideas?
Shaun< |
|
|
|
shaungallant
Starting Member
5 Posts |
Posted - 08 February 2005 : 10:32:13
|
quote:
Maybe I spoke too soon. Now I'm getting this error:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Never mind. I was able to get this working.
Shaun< |
|
|
|
stefen
New Member
Italy
88 Posts |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 11 February 2005 : 10:01:17
|
stefen, did you do exactly what is written in the first post ?
I haven´t got it to work yet - main because of:
Step 4 - Open your Access DB in Microsoft Access. In the objects column, make sure you are viewing Tables. You should see each Table listed. Right click on the first table and select Export. You need to select the Save as Type as Text Files (*.txt;*.csv;*tab;*asc). Now in File Name manually add .csv on the end. Click export.
On the next screen make sure Delimited is selected. Click next.
Select Comma as our field delimiter. Click Next.
Select the file destination and click finish.
Repeat step 4 for each table.
My Access won´t let me export in that format.< |
Edited by - wii on 11 February 2005 10:04:58 |
|
|
|
stefen
New Member
Italy
88 Posts |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 14 February 2005 : 07:13:59
|
| Link is dead ?!< |
|
|
|
woodywyatt
New Member
61 Posts |
Posted - 03 March 2005 : 09:37:21
|
After spending the last 3 days trying many different options such as SQLyog, MYSQL-Front, phpmyadmin,and DB manager, I can now say I'm getting very close to importing my data from my old access db/forum
- http://www.fuerteventura-forum.com
However, there are 4 csv (now txt files) that I can't seem to transfer as they are too big for (or seem to 'time out') whenever I use phpmyadmin.
I have also tried using the import data from an ODBC data source feature in SQLyog which seems to work fine for the smaller files but not for these larger ones -
FORUM_A_REPLY.TXT - 5mb
FORUM_REPLY.TXT - 8mb
FORUM_A_TOPICS.TXT - 1mb
FORUM_TOPICS.txt - 1.5mb
Can anyone help me out with any suggestions?
Is it possible to split a csv or txt file so I can send it via phpmyadmin?
Thanks< |
|
|
|
avinh
Starting Member
USA
17 Posts |
|
|
ElPazzo
Junior Member
Austria
116 Posts |
Posted - 21 June 2005 : 14:37:02
|
quote:
Originally posted by scuderip
..., but I'm italian.
Nobody is perfect... 
No, I'm joking.
Just wanted to say that the robbear7's post works well. for all those who have probs with the csv files because access says commas won't work, convert with semicolon and then open the .txt-files and change ; to ,
cu,
pascal< |
www.pet-needs.com
www.pet-needs.com/forum
www.pet-needs.de
www.translating-it.com |
|
|
|
Gargoyle
Junior Member
USA
280 Posts |
Posted - 26 June 2005 : 10:27:40
|
I am using access dump and MySql front. This should work but I also have a few mods to switch over. I would think I could manually edit the tables for the mods but this is what I have so far.
A new blank MySql Database with the snitz table structure installed. No data has been instered yet.
I have no idea where to safely go from here. Has anyone used this combination of software to do this?< |
Here is a link to my Snitz powered Drag Racing site. |
|
|
|
House
Starting Member
3 Posts |
Posted - 13 September 2005 : 04:56:20
|
I used the exact method as stipulated in the first post - it worked a treat.
The only thing I had to do different was delete the first row and column from the imported data.
Also - you have to watch date values as when you convert to CSV all the date values end up as 2E+13 and not the actual number they should be.
Many Thanks< |
Cheers |
|
|
|
n8pbm
Junior Member
USA
212 Posts |
Posted - 10 February 2006 : 10:31:31
|
It appears that AccessDUMP is no longer available. I would like to try this program. Anyone have a copy?
Thanks< |
Mike
Great Lakes Pop Up Club Camping |
|
|
|
Topic |
|
How I converted my Access DB to mySQL - A guide
