about connection via odbc

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

Post Reply
jparada
Posts: 433
Joined: Fri Jan 23, 2009 5:18 pm

about connection via odbc

Post by jparada »

Hi,

I made the following post in the harbour users list.

I still get no response and I have a little urgency to the topic.

That's why I ask here:
jparada wrote:I have a "small problem", I need to access to informix database
(external application), because I need to recover some data, the
database administrator tells me that there is no possibility that he
could provide me the data to connection to the server (username,
password), he tells me he has created a DSN and I should be able to
connect to the server.

I've been looking at some examples to connect via ODBC with Harbour,
and I've seen in all the samples, which is needed in the connection
string, the DSN name, username and password.

So does this mean, I can not access from Harbour only the DSN name?, I
need also to know username and password?.

I hope I'm not asking something stupid, but either way, I hope someone
can give me some help.

I appreciate any help

Thank you very much.

Best Regards,
Javier
User avatar
Rathinagiri
Posts: 5482
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: about connection via odbc

Post by Rathinagiri »

IMHO, ODBC is so generic to connect with many types of databases starting from dbf, server databases, single file databases etc.,

Username and password are required for server type databases only. Had you tried supplying 'nil' for username and password?
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
fchirico
Posts: 324
Joined: Sat Aug 23, 2008 11:27 pm
Location: Argentina

Re: about connection via odbc

Post by fchirico »

Please see if this helps you http://www.connectionstrings.com/informix.
Saludos, Fernando Chirico.
Post Reply