Web Hosting Forum | Lunarpages


*
Welcome, Guest. Please login or register.
Did you miss your activation email?


Login with username, password and session length
May 21, 2013, 09:14:08 PM

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: trying to port an NT ASP page over to chillisoft with mySQL  (Read 2330 times)
bews002
Pong! (the videogame) Master
*****
Offline Offline

Posts: 20


WWW
« on: October 10, 2002, 07:27:00 AM »
hey guys.. ive recently moved my webpage from a NT server to here (chillisoft and mysql). I was wondering if anyone could help me out with some tips on how to port it across (ive never used chillisoft and mysql). Im not too sure how i should go about all this.

Thanks for the help
Ash
Logged
stephan
Guest
« Reply #1 on: October 10, 2002, 07:59:00 AM »
There really shouldn't be any problem.

Was the script specifically written ONLY for NT?

There shouldn't really be many changes needed.

The only thing is that loading and saving files might be different.

What errors are you getting when you run the script?
Logged
bews002
Pong! (the videogame) Master
*****
Offline Offline

Posts: 20


WWW
« Reply #2 on: October 10, 2002, 08:52:00 AM »
well .. without touching anything

Error Trapped
while creating DB connection
SQLState: IM002
Native Error Code: 0
[INTERSOLV][ODBC lib] Data source name not found and no default driver specified

so im guessing i have the wrong datasource

in my asp code im using
' connect to the database
cn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & server.MapPath(dbpath)

and i know im not using the microsoft one now =)
Logged
gruckiii
Spaceship Navigator
*****
Offline Offline

Posts: 93



WWW
« Reply #3 on: October 10, 2002, 09:56:00 AM »
MICROSOFT.JET.OLEDB.4.0
as the name implys thats for connecting to a microsoft Access database. Last I checked lunarpages doesn't have the ODBC drivers and do not support Access databases

I am not sure what the line for a MySql databse would be

after pokeing onlie a bit I think it is supposed to be
"PROVIDER=SQLOLEDB"

found it on  this site
 
 [ October 10, 2002, 06:07 PM: Message edited by: gruckiii ]
Logged
bews002
Pong! (the videogame) Master
*****
Offline Offline

Posts: 20


WWW
« Reply #4 on: October 10, 2002, 10:38:00 AM »
do i have to use a mysql database though .. or can i continue to use my old database?
Logged
Max
Über Jedi
*****
Offline Offline

Posts: 2534



WWW
« Reply #5 on: October 10, 2002, 01:23:00 PM »
Are you trying to connect to a remote access database? That case i have to setup a dsn for you.

Best thing is if you could convert your database to MySQL using Access2MySQL found at http://www.programmersheaven.com/zone18/cat706/21365.htm
Logged
bews002
Pong! (the videogame) Master
*****
Offline Offline

Posts: 20


WWW
« Reply #6 on: October 10, 2002, 01:33:00 PM »
what do i use as the server name ??

I tried my domain name and mars.lunarpages.com (with my lunarpages login and pass) and im getting the error "Couldn't connect to the host or the database doesnt exist"

Im pressing the refresh button to get a list of databases (that is how it works isnt it?)
Logged
Kelvin
Jabba the Hutt
*****
Offline Offline

Posts: 737
« Reply #7 on: October 21, 2002, 07:59:00 AM »
use Localhost ..
Logged
Kelvin

"Failure is not an option. It comes bundled with the software."
bews002
Pong! (the videogame) Master
*****
Offline Offline

Posts: 20


WWW
« Reply #8 on: October 22, 2002, 12:50:00 PM »
it didnt work .. i ended up having to put mysql on my  machine to do it. Then i didnt know how to save the sql database .. and it was all to hard .. so i forgot about it and went to another program and started again

its all good .. thanks for the help though
Logged
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: