Link to home
Create AccountLog in
Microsoft SQL Server

Microsoft SQL Server

--

Questions

--

Followers

Top Experts

Avatar of al4629740
al4629740🇺🇸

The login is from an untrusted domain and cannot be used with Integrated authentication
I am trying to setup an adodc connection on a vb6 form.  I am able to login to the database fine, but when I setup the recordsource I get the error below.  Is there a way to change the connection string so that this is not a problem?

Here is the string: Provider=SQLNCLI11.1;Integrated Security="";Persist Security Info=False;User ID=xxxx;Initial Catalog=PhoData;Data Source=xxxx\SQLExpress;Initial File Name="";Server SPN=""

User generated image

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

ASKER CERTIFIED SOLUTION
Avatar of HainKurtHainKurt🇨🇦

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account
Avatar of HainKurtHainKurt🇨🇦

or set it to false...
Avatar of al4629740al4629740🇺🇸

ASKER

False didn't work, but removing it did the trick.
Avatar of HainKurtHainKurt🇨🇦

or try one of these connection strings

Provider=SQLNCLI11;Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; 

Provider=SQLNCLI11;Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=yes; 

Provider=SQLNCLI11;Server=myServerName,myPortNumber;Database=myDataBase;Uid=myUsername;Pwd=myPassword; 

if above did not work...

SQL Server Native Client 11.0 OLE DB Provider connection strings
https://www.connectionstrings.com/sql-server-native-client-11-0-oledb-provider/
Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Avatar of al4629740al4629740🇺🇸

ASKER

is there one connection string that might be more preferable than another when it comes to security?
Microsoft SQL Server

Microsoft SQL Server

--

Questions

--

Followers

Top Experts

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.