karthik
|
Posted: 01/04/2002, 4:40 AM |
|
I use PHP4 and mysql and working with empldir example. Though i created the ODBC connectivity using myodbc i get the following error. I have not created the user name and password for the database so i left those field values blank in the common.php file.
The error is:
Warning: Wrong parameter count for odbc_pconnect() in E:\Inetpub\wwwroot\pixelempdir\db_odbc.inc on line 35
Database error: Link-ID == false, odbc_pconnect failed
ODBC Error: 0 ()
Session halted.
please suggest me the solution.
Thanks
|
|
|
Alex Alexapolsky
|
Posted: 01/04/2002, 4:54 AM |
|
You can't connect to mysql database any way if you don't have login/password +
if you're accessing a remote mysql host via odbc you must be permitted to
access this host from a given ip.
|
|
|
karthik
|
Posted: 01/04/2002, 5:25 AM |
|
I have the database only in my local sytem and not in the server. Please suggest a clear setup procedure that I have to follow to establish the connection.
|
|
|
Nicole
|
Posted: 01/04/2002, 5:48 AM |
|
Hello,
to connect to db via ODBC in CC on Site->Properties->Database Tab->Server part you should fill the following fields:
Database Name: DSN_name_to_your_db
Host: hostname or IP address
Login: db_login
Password: db_password
Database Type: ODBC
Of course you should create DSN to db on the machine where you run generated files. You say that you run files on your local machine, so DSN should be created on your local machine.
|
|
|