Unable to Locate Driver Dynamic Library Bcp Cannot Continue Mac

Save Formatted Text using SSMS

July 23, 2020, 7:28 pm

How do I save the following text with the format so it can be returned in the exact same format

to an aps.net's <P> tag.

Welcome to American Saint Miguel, you may now request to online if your lease does not expire within 10 -15 days of your request.   To be considered eligible to lease, you must:  (1) You have not rented before, and   (2) You must be in "good standing".   Note: If your account is delinquent, you will not be able to lease and your application fee will not be refunded.   Good standing means that you do not owe money, you do not have any past due amount to creditors, and your lease expires within 10 - 15 days.   If you do not meet the good standing criteria, your application will not be approved.  If you meet the above mentioned criteria, please click here for details on required documents that you will need to submit.

---

JDBC Batching with prepared statement SQLServer 2019

July 27, 2020, 11:56 pm

Hello,
I've been writing an application for import / export of a database.
So far I've been getting decent performance except with microsoft database.
I suspect, batching is not quite implemented with how slow it's running.

              performBindingOnPreparedStatement(con, prepStatement, datatypes, currentLineData);             prepStatement.addBatch();             if (i % batchSize == 0) {                 int[] executedBatches = null;                  executedBatches = prepStatement.executeBatch();                 con.commit();                                  if (LOG.isTraceEnabled()) {                     LOG.trace(Arrays.toString(executedBatches));                 }                                  importedRecords += (executedBatches != null) ? executedBatches.length : 0;             }

It's pretty straight forward.
I suspected issues with the blob/clob handling but my table it's so slow on, does not contain clobs/blobs.

Now to my table. It has 54 columns with multiple (8) varchar(max) columns.
It's rather big but I don't fully use those columns anyway.
JDBC Driver is mssql-jdbc-7.4.1.jre8.jar. Microsoft Server is 2019.
It has enough resources and statements generally are quite fast on that instance.
It's not having heavy loads or anything since it's used only for development.

Now on oracle I was having time of about 8 Minutes for 4~ Million Entries.
Postgres took about 16 minutes.
With SQLServer I'm 5 minutes in and I don't even have 20 K Entries done. So that's the reason I suspect, there is no actual batching happening.
I've not tried using:

Statement stmt = con.createStatement(); stmt.addbatch(sqlString);

I will try that solution, later.
I would love some kind of help since I'm not really any further after 5 hours of analyzing and trying things differently.

Best Regards

query is running slow from one site

July 28, 2020, 7:40 am

I have two site Site A, Site B.

From Site A it takes 20 sec to get the SQL query result but from Site B it takes 30-40 sec for the same query.

Both of the sites are on 100MB line.

Is they any test I can run to see why its taking longer from site B

Azure SQL Database traffic migration to newer Gateways

July 28, 2020, 1:33 am

Hi everyone,

I am fairly new in the database management world and I just received an email from Microsoft Azure warning me that the gateways IP address in my region will change on the 1st of September 2020, which I guess will potentially impact my database.

Therefore I am wondering if I should do something regarding this change knowing that:
- My Azure SQL server has a "Default" Connection Policy

- I have few IP addresses set in my "Firewall Settings"

- I insert data using the SQL connection

- I query data using Power BI Azure SQL connector

Best,

Kevin

macOS ODBC Driver for SQL Server needs to be updated with arm64 slice

July 30, 2020, 10:44 am

My team is using Python to talk from macOS to SQL server. We have been using (now retired) pymssql but are switching to pyodbc. pyodbc required ODBC Driver for SQL Server. For macOS. I know it exists, as described here: https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/install-microsoft-odbc-driver-sql-server-macos?view=sql-server-ver15

The problem: current ODBC Driver for SQL Server is "Mach-O 64-bit executablex86_64". Apple is moving macOS to arm64/Silicone architecture. My team will be gradually moving development to arm64 Macs as well. We need universal x86_64/arm64 version of ODBC Driver for SQL Server for macOS.

The ask: Whom should ask about updating the macOS version of ODBC Driver?

Thanks

Bingbot sprider producing errors

July 31, 2020, 11:30 am

Recently some links have been receiving errors as follows by bingbot spider. However when I check the pages they seem to be available:

1:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

and

2:

Object reference not set to an instance of an object

Auto growth in sql server 2016

August 3, 2020, 12:25 am

What is the impact if idisable the Autogrowth option in SQL Server 2016?

[Announcement] SQL server related Forums will be migrated to a new home on Microsoft Q&A!

August 3, 2020, 6:11 pm

This SQL Server related Forum will be migrated to a new home onMicrosoft Q&A!

We've listened to your feedback on how we can enhance the forum experience.Microsoft Q&A allows us to add new functionality and enables easier access to all the technical resources most useful to you, like Microsoft Docs and Microsoft Learn.

Now until Aug 23, 2020:

• You can post any new questions onMicrosoft Q&Aor here.

From Aug 24, 2020 until Sep 7, 2020:

• New posts – We invite you to post new questions in the "SQL Server" forum's new home onMicrosoft Q&A. The current forum will not allow any new questions.
• Existing posts – Interact here with existing content, answer questions, provide comments, etc.

Sep 7, 2020 onward:

• This forum will be closed to all new and existing posts and all interactions will be inMicrosoft Q&A.

We are excited about moving toMicrosoft Q&Aand seeing you there.

---

""SQL Server related"" forum will be migrated to a new home onMicrosoft Q&A!
We invite you to post new questions in the "SQL Server related" forum's new home on Microsoft Q&A!
For more information, please refer to the sticky post.

---

invalidoperationexception. timeout expired

August 3, 2020, 4:18 am

Today one of the application user complained the he is getting below error:

But i didn't find any error from SQL Server error Log. We are using SQL server 2016.

ADO.NET Exit Call
Invalidoperationexception.Timeout expired.The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached

Time 15,008ms
From filedeployer
To  SQLserver1.abc.com,12345-DB1

Details DATA SOURCE=ABC

ASP.NET Webservice Query MSSQL Timeout (Poolgrösse/Poolsize)

August 3, 2020, 4:10 am

I created a new webservice where I want to get some SQL queries. It worked for a while but sometimes I get the following error:

    System.InvalidOperationException: Timeout abgelaufen. Das Zeitlimit ist vor dem Anfordern einer
    Verbindung aus dem Pool abgelaufen. M&#246;glicherweise werden alle Verbindungen im Pool bereits
    verwendet, und die maximale Poolgr&#246;&#223;e wurde erreicht.
    bei System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection,
    TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection,
    DbConnectionInternal& connection)
    bei System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection
    outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry,
    DbConnectionOptions
    userOptions)
    bei System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
    bei System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
    bei System.Data.SqlClient.SqlConnection.Open()
    bei SailTrainer.GetSchueler(String un) in C:\inetpub\wwwroot\alert\App_Code\SailTrainer.vb:Zeile 81.

after a while it just work again.

Any of you an idea?

What I've tried:

I tried con.Close() at the start of the function that it closes already open connection before opening a new one but that doesn't seem to work.

and every time I save my .asmx file it works fine again for a few queries.

User Permission in SQL Server

August 5, 2020, 1:15 pm

Hi Team,

I created two AD groups.

abc/Group1 --Read-Write

abc/Group2--Read

Now if the user is part of both the groups. In this case which one take precdence?

Update Excel spreadsheet using ACE driver (Microsoft.Ace.OLEDB.12.0) in 64bit environment.

November 20, 2012, 6:39 am

Hi all,

Well, I finally thought I'd try to ditch the dogleg through 32bit SQL Express and try to update spreadsheets (XLS) using the Microsoft.Ace.OLEDB.12.0 driver. Well, what can I say? It selects from the spreadsheet fine but as soon as I try an update statement it falls over straight away with:

(For xls as linked server)

OLE DB provider "Microsoft.Ace.OLEDB.12.0" for linked server "test" returned message "Bookmark is invalid.".

Msg 7346, Level 16, State 2, Line 2

Cannot get the data of the row from the OLE DB provider "Microsoft.Ace.OLEDB.12.0" for linked server "test".

----------------

For xls using OPENROWSET

OLE DB provider "Microsoft.Ace.OLEDB.12.0" for linked server "(null)" returned message "Bookmark is invalid.".

Msg 7346, Level 16, State 2, Line 2

Cannot get the data of the row from the OLE DB provider "Microsoft.Ace.OLEDB.12.0" for linked server "(null)".

--------------------

Just for completeness I also tried using the MSDASQL driver but that failed miserably too.

SELECT * FROM OPENROWSET('MSDASQL'

,'DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);UID=admin;UserCommitSync=Yes;Threads=3;SafeTransactions=0;ReadOnly=1;PageTimeout=5;MaxScanRows=8;MaxBufferSize=2048;FIL=excel 12.0;DriverId=1046;DefaultDir=D:\filepath\;DBQ=D:\filepath\filename.xls'

,'SELECT * FROM [NamedRange]'

)

gives

Msg 7390, Level 16, State 2, Line 2

The requested operation could not be performed because OLE DB provider "MSDASQL" for linked server "(null)" does not support the required transaction interface.

Linked server = null is interested as there is no problem if I use select.

Dynamically Setting Up SQL connection string

August 7, 2020, 12:22 pm

I am trying to store the data in SQL that was fetched from CyberArk using Logic Apps, How can i dynamically set up the connection string to make this work?

SQL TDE Question

August 10, 2020, 1:33 am

I went through the docs document to set up SQL Server TDE Extensible Key Management by using Azure Key Vault.

I have a question: how to rotate the key without destroying the SQL database? What's the script?

Note: I am using local SQL Server not Azure SQL Database.

Corrupted SQL backup file (*.bak).

May 20, 2017, 1:58 am

Dear All,

I am using sql server 2012 platform and I recently took backup of my SQL server database with the file extension .bak. But when I tried to access my backup file, I wasn't able to open the file any more. I think backup file got corrupted. Please help me to get out of this situation.

---

BCP fails with error "Unable to locate driver dynamic library. BCP cannot continue." while using ODBC Driver on Linux

June 26, 2012, 11:17 am

I have recently installed Microsoft's ODBC Driver on Linux Red Hat and trying to get BCP to work.  When I execute any BCP command, I get error "Unable to locate driver dynamic library. BCP cannot continue." For example:

[root@localhost DATA]# bcp master..spt_values out spt_values.txt -c -t , -r \n -S SqlServer -D -U sa -P myPassword
Unable to locate driver dynamic library. BCP cannot continue.
[root@localhost DATA]#

What could be wrong?  I am able to connect and execute queries from Linux to my SQL Server using "sqlcmd -S SqlServer -D -U sa -P myPassword".

My odbc.ini file contains the lines below.

[ODBC Data Sources]

SqlServer = MS Sql Server

[SqlServer]
Driver=/opt/microsoft/sqlncli/lib64/libsqlncli-11.0.so.1790.0
Server=xx.xx.xx.x (Note: my SQL Server's ip address)
port=1433
TDS_Version=8.0

odbcinst  returns:

[root@localhost DATA]# odbcinst -q -d -n "SQL Server Native Client 11.0"
[SQL Server Native Client 11.0]
Description=Microsoft SQL Server ODBC Driver V1.0 for Linux
Driver=/opt/microsoft/sqlncli/lib64/libsqlncli-11.0.so.1790.0
Threading=1
UsageCount=1
[root@localhost DATA]#

Thanks,

Perry.

UDL Connection string testing

August 13, 2020, 12:21 am

Hello,

I use the simple UDL to test connectivity from App server to database server. Since there is an upgrade happened in application server on TLS version UDL test seems to be failing eventhough there is connecvivity between the server. Do we have a workaround to show successful connecvivity using UDL even for different values of TLS version in app adn database servers?

Thanks,

---

Best Regards,ACDBA

Customer application unable to connect to database and throw error " operation is not allowed when the object is closed"

August 13, 2020, 7:10 pm

Hi All,

I have custom application that unable to connect to database and giving error below.  I am using SQl express with 2017 console. Let me know whether you need any more information to help me resolve this issues. Thanks.

Here is the code

Imports ADODB
Imports System.Data.OleDb
Imports System.IO
Imports System.Data

Public Class DatabaseCn
    Public strDBDir As String
    Public Cn As Connection
    Public cmdSP As Command
    Public Rst As Recordset
    Public Rst1 As Recordset
    Public Rst2 As Recordset
    Public Rst3 As Recordset
    Public da As OleDbDataAdapter
    Public ds As DataSet
    Public dt As DataTable

    Public CnMode As Integer = ConnectModeEnum.adModeUnknown
    Public cmdType As Integer = CommandTypeEnum.adCmdStoredProc

    Public CnStr As String
    Public Sql As String

    Public Sub New()
        Cn = New Connection
        cmdSP = New Command
        Rst = New Recordset
        Rst1 = New Recordset
        Rst2 = New Recordset
        Rst3 = New Recordset
        da = New OleDbDataAdapter
        ds = New DataSet
        dt = New DataTable

        '***SQL***
        'Cn.CursorLocation = CursorLocationEnum.adUseServer
        Cn.CursorLocation = CursorLocationEnum.adUseClient

        CnStr = "Provider=sqloledb; Data Source=" & objSQL.Server & "; Initial Catalog=" & objSQL.Database & "; " _
            & "User ID=" & objSQL.UserID & "; Password=" & objSQL.UserPwd & ";"
    End Sub

    Public Sub Open()
        Cn.Open(CnStr, objSQL.UserID, objSQL.UserPwd, CnMode)
    End Sub

    Public Sub Execute(ByVal strSql As String)
        Rst = Cn.Execute(strSql)
    End Sub

    Public Sub Execute1(ByVal strSql As String)
        Rst1 = Cn.Execute(strSql)
    End Sub

    Public Sub Execute2(ByVal strSql As String)
        Rst2 = Cn.Execute(strSql)
    End Sub

    Public Sub Execute3(ByVal strSql As String)
        Rst3 = Cn.Execute(strSql)
    End Sub

    Public Sub Close()
        Cn.Close()
    End Sub
End Class

Regards,

Siva Kumar

---

Siva

New Azure SQL db gateway

August 14, 2020, 7:00 am

- For the notice "Update your network configuration to allow communication with new Azure SQL Database gateways by 15 September 2020"

- Where would I add the gateway ip address for a region ? Is this through the Azure portal/SQL Database/Security-Firewalls and virtual networks?

[298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]

March 11, 2008, 2:44 pm

I've received this error twice over 2 days in the SQL Agent error log during off-hours from a server which has not had any changes to it in the last few months (once at 3:32AM and the next day at 3:46AM.  I've been able to tie it to log-shipping backup jobs (all of which run under the SQL Service domain account) which run every minute.  It seems to be only momentary, as the next attempt a minute later is successful.

I get the same set of messages for each database for the same time which look like this:

Date  07.03.2008 3:31:51 AM
Log  SQL Agent (Current - 10.03.2008 6:15:00 PM)

Message
[298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001]

Date  07.03.2008 3:31:52 AM
Log  SQL Agent (Current - 10.03.2008 6:15:00 PM)

Message
[165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00]

Date  07.03.2008 3:31:52 AM
Log  SQL Agent (Current - 10.03.2008 6:15:00 PM)

Message
[298] SQLServer Error: 258, Unable to complete login process due to delay in login response [SQLSTATE 08001]

Date  07.03.2008 3:31:52 AM
Log  SQL Agent (Current - 10.03.2008 6:15:00 PM)

Message
[382] Logon to server '(local)' failed (SubSystemStepHistoryLogger)

I can't find any documentation on these errors on the web or MSDN site.  Can I chalk this up to possibly "winking" connection to our domain controller?  We've never had these messages before, and our LAN department swears that there have been no upgrades to the network or domain controller servers recently.

taylortose1960.blogspot.com

Source: https://access1348.rssing.com/chan-8127163/latest.php

Share this post