By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,902 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

database connection problem

100+
P: 138
i am using vb6 and postgresql. i have connected this with odbc.

i have created two databases, one test1 and next is test2

when i create a database as
CREATE DATABASE test1
WITH OWNER = postgres
ENCODING = 'SQL_ASCII'
TABLESPACE = pg_default;
it works fine, it is connected through vb6
but when i create another database as

CREATE DATABASE test2
WITH OWNER = postgres
ENCODING = 'UTF8'
TABLESPACE = pg_default;

and is connected through vb6
it does not work, shows the error message
run time error- 3146
odbc call failed.

does the encoding parameter differs the connectivity?
what can i do to connect to the database test2
plz help
TIA
Sep 17 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.