Hi,
The connection string is written like this;
database@host user password
hence you should give the following connection string:
customerDb localhost pass52696
You do not need to specify the host name when running Zope and SQL-server on
the same machine.
Also note that you should not use brackets ( [ ] ) when specifying the
host name, if you intend to do so.
Best regards
Petter Enholm
Snapper as
----- Original Message -----
From: Angietel
To: [EMAIL PROTECTED]
Sent: Tuesday, December 12, 2000 4:37 AM
Subject: [Zope] Problem on connect to MySQL
When i type in the Connection String , it will prompt out the error
message - "illegal operation" and in my python it will exactly like this:-
Files\WebSite\z2.py" -D
------
2000-12-12T03:15:10 PROBLEM(100) ZServer Computing default hostname
------
2000-12-12T03:15:11 INFO(0) ZServer Medusa (V1.16.4.2) started at Tue Dec 12
11:
15:11 2000
Hostname: ANGIE
Port:8080
------
2000-12-12T03:15:11 INFO(0) ZServer FTP server started at Tue Dec 12
11:15:11 20
00
Authorizer:None
Hostname: angie
Port: 8021
------
2000-12-12T03:15:11 INFO(0) ZServer PCGI Server started at Tue Dec 12
11:15:11 2
000
Inet socket port: 8090
------
2000-12-12T03:15:11 INFO(0) ZServer Monitor Server (V1.8) started on port
8099
C:\Program Files\WebSite> #// This is error msg
and i would like to confirm to u whether the Connection String is write like
this:-
customerDb[@localhost]Password pass52696
In mySQL i set up the user password like this:-
INSERT INTO user
VALUES('localhost','password',PASSWORD=Password('pass52696'),'Y','Y','Y',Y',
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
and my Database name is CustomerDb
P/s let me know where is my mistake! Thank You!
_______________________________________________
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )