No announcements
Found 13774 threads
-
2 Votesaccess database row and edit one line of existing user
ok what i am trying to do to the best of my ability is create a user username and password witch is done perfectly fine the issue i am having is once the user is registered i want ...Proposed | 5 Replies | 2293 Views | Created by elfenliedtopfan55 - Tuesday, July 28, 2020 5:04 PM | Last reply by Echo Liuz - Thursday, July 30, 2020 5:29 AM
-
0 Votes
When I using ODBC, characters are broken.
I have configured 64 bit ODBC. Then I set DBLINK in MSSQL. Then when I called the data using openquery SQL the characters were ...Proposed | 6 Replies | 2596 Views | Created by MJ_P - Monday, July 27, 2020 2:40 PM | Last reply by Erland Sommarskog - Tuesday, July 28, 2020 3:29 PM -
0 Votes
Sync between Local SQLite and Remote SQL SERVER
Hello Experts, I have SQLite installed in my machine and i have a remote database server. I have installed ODBC drivers of sqlite in my machine and created ...Unanswered | 5 Replies | 3207 Views | Created by Topen Tech - Friday, July 24, 2020 9:30 AM | Last reply by Melissa Ma - Tuesday, July 28, 2020 9:06 AM -
0 Votes
SQL Server Linked Server to Azure SQL using Azure AD
I am trying to set up a linked server from an on-prem SQL Server to an Azure SQL instance. The Azure SQL instance uses Azure AD for authentication. When we attempt the connection we get the ...Unanswered | 5 Replies | 2468 Views | Created by trbrown10 - Tuesday, July 21, 2020 1:06 PM | Last reply by Echo Liuz - Friday, July 24, 2020 1:25 AM -
2 Votes
Issue with SQL Backups
Hello everyone! I have an issue with SQL Server that is really driving me nuts so I wanted to ask if anyone has any suggestions. I have a program that does a ...Answered | 15 Replies | 2678 Views | Created by MLyons10 - Wednesday, July 22, 2020 11:02 PM | Last reply by Erland Sommarskog - Thursday, July 23, 2020 10:08 PM -
2 Votes
Distributed Transactions for Microsoft.ACE.OLEDB 12.0
Hi Anyone, I am trying to import data from sql server to excel using microsoft.ace.oledb.12.0. insert into openrowset('Microsoft.ACE.OLEDB.12.0','Excel ...Answered | 17 Replies | 10870 Views | Created by Kamfa - Saturday, May 25, 2013 10:40 AM | Last reply by lifalin0802 - Wednesday, July 22, 2020 9:17 AM -
0 Votes
re: Data Virtualization
Hello, re: Data Virtualization I cannot get an “External Data Source” connecting successfully from my local laptop’s SQL Server 2019 to my Azure SQL ...Proposed | 1 Replies | 1914 Views | Created by sjwexler52 - Tuesday, July 21, 2020 11:28 PM | Last reply by Melissa Ma - Wednesday, July 22, 2020 1:39 AM -
0 Votes
Insert - update two tables in SQL Server
hi I want to write a one stored procedure to insert into two tables I want to write a one stored procedure to update into two ...Proposed | 4 Replies | 2336 Views | Created by ahmeddc - Friday, July 17, 2020 4:39 PM | Last reply by Echo Liuz - Wednesday, July 22, 2020 1:37 AM -
0 Votes
Query to increment a table number on 1st of every month
Hi, I am trying to access some data from joining few tables and the table names are ending with number XX which do have an increment every month. lets say for this month I have the ...Proposed | 8 Replies | 2915 Views | Created by Debadas Nayak - Wednesday, July 1, 2020 3:37 PM | Last reply by Debadas Nayak - Tuesday, July 21, 2020 4:59 PM -
0 Votes
Add-OdbcDsn timeout with Amazon Redshift (x64)Driver
Hello every body, I would like to add a ODBC DSN to my driver "Amazon Redshift (x64)" programmatically using wdac cmdlet (I try with Powershell). The ...Unanswered | 3 Replies | 2325 Views | Created by GatienP - Friday, July 17, 2020 3:08 PM | Last reply by Melissa Ma - Tuesday, July 21, 2020 7:20 AM -
0 Votes
TLS 1.2 MS Access 2010
Hi, Recently our Network team disabled below TLS 1.2 I'm no expert on security but all my applications have stopped working... I'm using ...Proposed | 5 Replies | 3903 Views | Created by StSingh - Monday, July 20, 2020 12:32 AM | Last reply by Melissa Ma - Tuesday, July 21, 2020 2:19 AM -
0 Votes
Restoring SQL Server 2000 database on
I have a database that I developed in ms sql 2000 and I want to restore it to the latest version of sql server express. How do I do that if I don't have a copy of ms sql server 2000? Or ...Proposed | 3 Replies | 2035 Views | Created by Ssalongo Kizito - Thursday, July 16, 2020 12:30 AM | Last reply by Melissa Ma - Friday, July 17, 2020 7:26 AM -
0 Votes
Cannot create user DSN or System DSN
Hi All, I tried editing an exiting user dsn and it did not work. When i tried to create a new one both User and System level , i do not get any error messages, connection is ...Proposed | 10 Replies | 2423 Views | Created by LordofthePlains - Thursday, July 9, 2020 5:46 PM | Last reply by Echo Liuz - Friday, July 17, 2020 7:20 AM -
0 Votes
Prefilling BCM field with text
Outlook 2010 with BCM When creating a new account, is it possible that the web address field be prefilled with text? I use ...Proposed | 4 Replies | 2145 Views | Created by CAVUJIM - Thursday, July 9, 2020 1:54 PM | Last reply by Echo Liuz - Thursday, July 16, 2020 5:24 AM -
0 Votes
SQL Server is terminating because of fatal exception c0000005
Hi Can someone help me understand how to resolve this error. NOTE: I'm not a professional. I'm just helping my ...Proposed | 9 Replies | 4423 Views | Created by Leslie7611 - Thursday, July 9, 2020 4:29 AM | Last reply by Laxmidhar sahoo - Wednesday, July 15, 2020 3:28 PM -
1 Votes
Issue with Left Join
= '1/1/2020' AND Jobs.DateCreatedProposed | 7 Replies | 2364 Views | Created by MLyons10 - Friday, July 10, 2020 10:07 PM | Last reply by Naomi N - Tuesday, July 14, 2020 5:03 PM -
0 Votes
C# Multiple thread connect to one SQL Server database, dbconnection.open hang
my code process is as below: 1. create database connection 2. create database dbCommand 3. call ExecuteReader and get reader (parse database data) 4. ...Proposed | 2 Replies | 1836 Views | Created by Hi, Shirley - Thursday, July 9, 2020 1:37 AM | Last reply by Echo Liuz - Monday, July 13, 2020 7:11 AM -
0 Votes
Connection issue
Hi, Any help to error below? What to check further? "ERROR" 1544 "2020-02-14 ...Proposed | 16 Replies | 2958 Views | Created by Jackson_1990 - Sunday, February 16, 2020 1:14 PM | Last reply by Erland Sommarskog - Wednesday, July 8, 2020 9:19 PM -
0 Votes
add-odbcDSN for Azure database with Encrypted=yes
Hey! Posting this in this forum as well as on Powershell forum, it relates to both components I believe. I'm trying to create user ...Answered | 2 Replies | 2354 Views | Created by olek.stasiak - Thursday, July 2, 2020 12:45 PM | Last reply by olek.stasiak - Thursday, July 2, 2020 1:42 PM -
0 Votes
SQL 2019 - Data Virtualization - Unable to Create External Data Source from my Laptop (On-Premise) to my Azure SQL Database.
Hello, The title for my question says it all. I am unsuccessful at creating a connection from on-premise to my Azure SQL database. I can successfully connect through ...Answered | 1 Replies | 2445 Views | Created by sjwexler52 - Tuesday, June 30, 2020 7:12 PM | Last reply by Lily Lii - Wednesday, July 1, 2020 6:26 AM
No announcements
