View Single Post
Old 2010-01-03, 00:59   #7
mdettweiler
A Sunny Moo
 
mdettweiler's Avatar
 
Aug 2007
USA (GMT-5)

3·2,083 Posts
Default

Quote:
Originally Posted by MyDogBuster View Post
Followed all the instructions. I can see the database thru the MYSQL tool and even see the structure of the tables. When I start the prpserver, I get this.

[2010-01-03 00:31:22 GMT] ODBC Connection String: <Driver={MySQL ODBC 5.1 Driver};Server=localhost;Port=3306;Database=C:\ProgramData\MySQL\MySQL Server 5.1\data\prpnet;User=root;Password=buster;Option=3;>
[2010-01-03 00:31:22 GMT] Connect to database failed: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, native code=0

The database in Windows is actually a folder. I'm pointing to the folder. Is that correct?

MySql.ini looks like this:

driver=MySQL ODBC 5.1 Driver
server=localhost
port=3306
database=C:\ProgramData\MySQL\MySQL Server 5.1\data\prpnet
user=root
password=buster
Not knowing much about MySQL, on a hunch I'd suggest that you set database= to "prpnet" instead of the full path.
mdettweiler is offline   Reply With Quote