Welcome, Guest ( Customer Panel | Login )




 All Forums
 VPCart Forum
 VP-ASP set-up problems
 Issue with running mysql scripts.
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

chughes
Starting Member

USA
29 Posts

Posted - March 23 2007 :  17:51:48  Show Profile  Visit chughes's Homepage  Reply with Quote
I am trying to get my database setup with mysql and I have edited the shop$config.asp as shown below.

const xDatabase="mysql" 'Database name
const xdblocation="E:/MySQL/data/mysql" 'location of database relative to VP-ASP files

'NOTE - XDATABASETYPE SHOULD BE ENTERED IN UPPER CASE LETTERS
const xdatabasetype="MYSQL" ' Database type: leave empty for Access or change to one of the options shown below
'const xdatabasetype="ODBC"
'const xdatabasetype="Drive"
'const xdatabasetype="SQLServer"
'const xdatabasetype="MYSQL"
'const xdatabasetype="MYSQL351"
'const xdatabasetype="ACCESS2007"


const xSQLUser="root" ' SQL Server user
const xSQLPwd="*********" ' SQL Server password
const xSQLServer="localhost" ' SQL Server name or IP address

Below is the settings I put in for the convertmysql.asp


Filename create650mysql.txt
Database mysql
Username root
Password
Server URL localhost
Database Type MYSQL

When I try and run the convert I get the following error message:

Could not connect to the database

Open Messages
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

DRIVER={MySQL}; Server=localhost; Database=mysql; UID=root; PWD=******
Sql completed. Records read=0

Anyone have any ideas or am I missing a step? Any help would be appreciated!

chughes
Starting Member

USA
29 Posts

Posted - March 25 2007 :  18:48:06  Show Profile  Visit chughes's Homepage  Reply with Quote
Does anyone have any suggestions for me in order to get my database setup correctly?
Go to Top of Page

Scooter
VP-CART New User

USA
102 Posts

Posted - March 25 2007 :  20:49:38  Show Profile  Reply with Quote
Hi Chughes,

Have you try putting MYSQL351 in xdatabasetype? Maybe work?

S.
Go to Top of Page

bluesky
VP-CART Super User

304 Posts

Posted - March 25 2007 :  20:59:18  Show Profile  Reply with Quote
Scooter
like above mesage , I am running MYSQL but needs MYSQL351 in databasetype to work

PAUL
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00