Is there any description? VB sample isn't enough.

My ODBC component gives a developer a way to create an ODBC Datasource Name (DSN) programmatically. The DSN is then used to create an ODBC connection and access a database. It works with MS-SQL Server, MS-Access, Oracle, and MySQL ODBC drivers. Works with Visual Basic, VB Script, JavaScript, and all COM enabled development technologies.

You would use it to create an ODBC Datasource Name as described in the following example:

If Not DSN1.IsValid("TestDSN") Then ' if the DSN does not exist...
DSN1.DSN = "TestDSN" ' set the DSN name
DSN1.ServerName = "SERVER01" ' set the server name
DSN1.Database = "MyDatabase" ' set the database name
DSN1.UserName = "uid" ' your user id
DSN1.Password = "pwd" ' your password
DSN1.ODBCDriver = "SQL Server" 'this is the default value
DSN1.Description = "This is a description" ' set the description
DSN1.TrustedConnection = "Yes" ' make connection trusted
If DSN1.AddDSN Then ' if the add worked...
DSN1.DeleteDSN ' demonstrate delete
End If
End If

This is a really simple component. It's function is just to create an ODBC DSN, nothing else. The programmer would develop the code to open, and use the DSN.

I hope this helps.

Hi,
I find very interesting the DSN.OCX module,
and it is exactly what I was looking for.
The only thing I think is missing(I have not found it!)
is a way to specify a PORT.
I use MySQL database, and I have two installations on different PORTS.
Does your component provide it?

Thanks

Byron

There may be. But since there is no documentation it's hard to find out eh?

You may want to try entering a port in your regular Windows ODBC through the Control Panel and see what they call the port by viewing the registry entry.

HKLocalMachine/Software/ODBC/ODBC.INI/

Perhaps the developer called it the same in his ocx component?

Now if only I could figure out how to call this component from a vbscript during my installation program....

Same as Visual Basic, use CreateObject to create an instance of the component, and then follow the example above....

Where can I download your ODBC COM?
Thanks!

Thank you for your interest in our software Michael.

I can count on my fingers how many copies of the ODBC component that we sold, so it was removed from the site.

If you're interested in buying a copy, then please send me an email at jeff at hendricom dot com.