>1) What is the best way to set up a connection to a Sybase server across a network without storing the connection information in the local DSN files?
>
>OR
>
>2) Can you make a DSN entry where the database name could be an alias to any Sybase database?
>
>OR
>
>3) Is it possible to make an ActiveX control to do all of this?
>
>Thanks for any assistance...
>Michael

Our office had a similar dilemma but going against Oracle or SQL-Server. What Scott's (one of the develoers) solution was. Create a file.dsn and keep it in the application's directory.. ex: Oracle1.dsn, or SQLServer.dsn Then we were able to connect using SQLStringConnect()

lnHandle = SQLStringConnect( "filedsn=x:\appdir\oracle1.dsn;uid=username_id;pwd=password" )

This way, any other user running the app would have the same definition of the .DSN. Just make sure that any machine using the connection has the same driver. Can't have the .DSN using Microsoft driver on one machine while using Sybase driver on another...

HTH