Database Search

match allmatch any Look in all areasLook in current areas Check all datesPrevious dayPrevious 3 daysPrevious weekPrevious fortnightPrevious monthPrevious 2 monthsPrevious 3 monthsPrevious half-yearPrevious year

TechHome

Sample Code

• !!NEWSFLASH!!
• 1437 or 3437 Extender Load Error
• 3132 error when using DAO
• 521 Attribute string too long
• Access SQL Update
• An SQL Tutorial
• Automated ODBC Data Source creation
• Calling a MS SQL Server 2000 Stored Procedure
• Change database then Update then count rows
• Compact an Access Database
• COMPACT_DB and Password MDB Files
• Continue a SQL Query after a Warning Message from Driver
• Create a System DSN for a TXT File Problem
• Create an SQL DSN with User name and Password
• DSN Connection Strings
• Execute an Oracle stored procedure
• Explanation of ODBC Usage
• Get Installed Driver Information
• Get Parameters from a Stored Procedure
• How Does qBindCol Work
• How to Do a Simple Sql Query
• Invalid Cursor State Error
• MDAC Invalid Object
• Microsoft SQL Server ODBC driver Info
• More on How ODBC Works
• ODBC and Services
• ODBC and SQL
• ODBC DSN Maker
• ODBC DSN Port Configuration
• ODBC Extender with WebBatch problems
• ODBC on 64 bit System
• ODBC SQLDescribeCol Example
• ODBC WHERE Syntax Blank Data
• Pervasive SQL Syntax Error
• Problem Adding System DSN for SQL Server
• Problem Using qConfigData with the Oracle ODBC Driver
• qConnect Crashes with Exit Code -1073741571
• qExecDirect and SQL Questions
• QExecDirect Second handle issue with SQL Server Drivers
• qFetch with Empty Cell
• qFetch with qBindCol and qGetData
• qGetData 50 columns limit
• qLastCode to Check these SQL Return Codes
• Read Information from Lotus Notes
• Retrieving data after a SQL JOIN
• Return Codes in ODBC Extender
• s0022 error from SQL Server Driver
• Specify SQL Server Password in qConfigData
• SQL Server SELECT SUM Statement
• SQL SUCCESS WITH INFO
• Syntax for Insert Into Access
• Updating ODBC.INI File over the Network
• Using WildCards in an ODBC SQL Statement

Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.

Create an SQL DSN with User name and Password

---

Question:

I pretty much have this down but I don't know how to create an SQL DSN with a user name and password (not Windows Authenication) What do i use as a keyword for the password?

Answer:

From what I can tell there is really no way to programmatically create a DSN with a password. Probably due to security restraints.

If you just need to give your scripts access to the SQL server, you may not need to create a DSN. Instead you could attach using DSN-Less connection which may allow you to specify username and password. See the function qDriverCon.

Or maybe you can create a UDL with name/password?

Referenced:

http://www.databasejournal.com/features/mssql/article.php/1491051

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&frame=right&th=a96a5eb2591dcd65&seekm=985ufv%2413m%40dispatch.concentric.net#s

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&frame=right&th=df4b231adaca64d2&seekm=99c901c28ffb%24f1fa6f40%2489f82ecf%40TK2MSFTNGXA01#s

---

Article ID:   W15843

File Created: 2004:03:30:15:41:06

Last Updated: 2004:03:30:15:41:06