Search found 5 matches

by dmb
Tue Apr 11, 2006 1:04 pm
Forum: General Discussion
Topic: ODBC/Connection string and use of OCX
Replies: 12
Views: 12658

Fred wrote:dmb: the database name should be put in the DSN no ?
Sorry that I come back to this once more, but does your answer indicates that you're not going to add this parameter to the OpenDatabase command?.
by dmb
Thu Apr 06, 2006 6:55 pm
Forum: General Discussion
Topic: ODBC/Connection string and use of OCX
Replies: 12
Views: 12658

dmb: the database name should be put in the DSN no ?

The DSN itself doesn't contain a reference to a particular database name. The database type to which I want to connect to is SQLBase. When using VB6 I use the following connection string:

DSN=Name of DSN;UID=userid;PWD=password;DB=database ...
by dmb
Thu Apr 06, 2006 4:11 pm
Forum: General Discussion
Topic: ODBC/Connection string and use of OCX
Replies: 12
Views: 12658

Thanks for your answers so far. I'll look at the examples soon.

I've been testing a bit myself and found that I can use the command:

OpenDatabase(0,"dsn name", "userid", "password")

The only thing missing here is the ability to specify the database name, like f.e. '150'.

Is database support ...
by dmb
Thu Apr 06, 2006 8:36 am
Forum: General Discussion
Topic: ODBC/Connection string and use of OCX
Replies: 12
Views: 12658

Yes you can connect to any database via ODBC.


I know that it's possible to connect to a ODBC database, but for my purposes I need to be able to specificy connection properties via a connection string. F.e. information like userid, password, database number and servername is not available in the ...
by dmb
Wed Apr 05, 2006 8:07 pm
Forum: General Discussion
Topic: ODBC/Connection string and use of OCX
Replies: 12
Views: 12658

ODBC/Connection string and use of OCX

Hi,

I'm currently using VB6 for my (business) applications and I'm looking for a good alternative. PB looks quite good. I really like the idea of a one-EXE application (remembers me of the good-old DOS days ;) ).

I've browsed through the forum, but still couldn't find a definitive answer to the ...