Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > Using Access to connect to SQL via ODBC
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 28th February 11:34
mary chipman
External User
 
Posts: 1
Default Using Access to connect to SQL via ODBC


Take a look at the DSN you're using -- it's probably set to integrated
security (Windows authentication). You'd be better off dynamically
linking at runtime in code, supplying your user ID and password in the
connection string for a DAO tabledef object, rather than using a DSN.
Take a look at the following resources for ODBC connection string
examples:
http://able-consulting.com/ADO_Conn.htm
http://www.connectionstrings.com

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446
  Reply With Quote


  sponsored links


Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666