General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only