Database Search
If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.
TechHome
ODBC
 |
- !!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.
ODBC DSN Port Configuration
Question:
I am creating a new DSN. I am able to create the DSN but I need to be able to specify the port in the server alias. I have been unable to do this as of yet. Any suggestions?
AddExtender("wwodb34i.dll")
request=4;ADD SYSTEM DSN
driver="SQL Server";case sensitive
;Modify next like with connection specifics
attrs="DSN=sctestadmin|DESCRIPTION=sctestadmin|SERVER=Ind1Sql06";pipe delimited
displayflag=@FALSE
ret=qConfigData(request, driver, attrs, displayflag)
;Displays error if DSN not created
If ret== @FALSE
Message("qConfigData failed", qConfigError())
Exit
EndIf
Exit
I need to know what I can add to automatically configure the port to 1433.
Answer:
To connect to SQL Server running on a remote computer (via an IP address)Maybe try this:
attrs="DSN=sctestadmin|DESCRIPTION=sctestadmin|SERVER=xxx.xxx.xxx.xxx|Address=xxx.xxx.xxx.xxx,1433|Network=DBMSSOCN|Database=myDatabaseName|Uid=myUsername|Pwd=myPassword";pipe delimitedWhere:
- xxx.xxx.xxx.xxx is an IP address
- 1433 is the default port number for SQL Server.
- "Network=DBMSSOCN" tells ODBC to use TCP/IP rather than Named Pipes (Q238949)
http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForSQLServer
Answer:
Thank you for the suggestions. After doing snapshots of the pc, I was able to track down the registry key that holds this information. Just as FYI, here is what I had to add to my code.RegSetValue(@REGMACHINE, "Software\Microsoft\MSSQLServer\Client\ConnectTo[%servername%]", "DBMSSOCN,%servername%,1433")
Article ID: W16836
File Created: 2007:07:03:14:26:30
Last Updated: 2007:07:03:14:26:30