ODBC Connection - SQL Server

  • Thread starter Thread starter Mythran
  • Start date Start date
M

Mythran

The entire application I am writing uses the ODBCConnection object. Now I need
to apply a way for the user to enter the SQL Server location, authentication
type, user id and password if SQL Server authentication is required, and then
show the user the list of databases to connect to.

My problem is, I do not want to create a DSN entry for this connection, what I
would like to do is just use the ODBCConnection object still but perhaps use a
file dsn (created programmatically, then removed after the connection gets
closed).

Also, I have a SQL Server connection object in a library, I need to connect with
only the information the SQL Server object provides using the ODBCConnection
object.

Any and all help appreciated, thanks.

Mythran
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL and ODBC operate diffrently with Trusted Connection? 3
Create a connection object (sql/oledb/odbc) based on connection method/string. 2
troubles with dns-less connection to sql 0
ODBCConnection Problem 3
ODBC driver for CSV/TEXT file on Windows 2008 0
Cannot display ODBC login prompt - want to connect without DSN 31
ODBC adapter update command syntax nothing happens 1
odbc adapter syntax HELP make it do the update 1

Back
Top