Re: Create DSN programmatically cannot set Port (VBA)
- From: srinivas_t <srinivas_t.1nys63@xxxxxxxxxxxx>
- Date: Sat, 23 Apr 2005 07:57:43 -0500
Debbie wrote:
> *Hello,
>
> I have tried for the past three days to find all of the
> possible attributes for SQL Server ODBC, most specifically
> how to 'uncheck' the "Dynamically determine port" option
> and set the port number to 1435.
>
> Here is what I have so far,
> Const IMO_DSN_name = "EAOPS"
> Const IMO_Server_Name = "Y0001-DBS0109-S\WFT2"
> .....
> lngResult = SQLConfigDataSource(0, ODBC_ADD_DSN, "SQL
> Server", "DSN=" & IMO_DSN_name & Chr(0) & _
> "Server=" & IMO_Server_Name & Chr(0) & _
> "Database=IMO" & Chr(0) & _
> "UseProcForPrepare=Yes" & Chr(0) & _
> "Description=IMO Database" & Chr(0) & Chr(0) & _
> "Login ID=imoreader" & Chr(0) & _
> "Password=somepassword" & Chr(0) & _
> "Port=1435" & Chr(0))
>
> I have tried to append the Port number after the server
> name separated by a colon. Also, if I put the second Chr
> (0) at the end instead of after the Description, I get an
> error.
>
> Best regards,
> Debbie *
Hi,
I'm also searching for the same solution of programmatically unchecking
the "Dynamically Determine Port" option.
If you find/have any solution, please let me know.
Regards,
Srinivas
--
srinivas_t
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message32039.html
.
- Prev by Date: Successful connection with invalid UserId
- Next by Date: MS Access Linked Tables under SQL 2005 x64?
- Previous by thread: Successful connection with invalid UserId
- Next by thread: MS Access Linked Tables under SQL 2005 x64?
- Index(es):
Relevant Pages
|
Loading
