Developers number one Connection Strings reference Knowledge Base Q & A forums

About Contribute log in

ODBC Connection String

Is there a way to pass a user parameter i.e. 'THIS IS A TEST' via the ODBC connection string?

0

share edit delete

are you sure?

asked Feb 23, 2016 Soan Do

0 answers

Post an answer but please log in first

Post Answer

Please log in to post answer

Similar Questions

error Multiple-step OLE DB operation generated

Getting an error ADODB open connection -2147217887 (hex: 80040E21) - Multiple-step OLE DB operation generated. This is after out DB2 moved from a AS400 server to a new server. The conn string PROVIDER=IBMDA400;Data Source=198.19.236.75;UID= ; PWD=

0 votes

0 answers

SETH JAFFE • 3 weeks ago

Passing special characters in passwords to iSeries ODBC Connection

I am attempting to use a VB.NET ODBC Connection to connect to an AS/400 iSeries database. I need to be able to pass special characters in users' passwords, but am getting an "Syntax error in connection string" because of the special characters in the password.

0 votes

0 answers

Anonymous user • Jan 15, 2021

ODBC Driver Connection login timed out

Hello Everyone, I am trying to create a iSeries Access ODBC Driver connection via TestComplete tool. The connection string used is : "Driver={iSeries Access ODBC Driver}; System=; Uid=UserId; Pwd=Password; MGDSN=0";

0 votes

0 answers

Amytav M • Nov 30, 2020

how can i connect IDB DB2 ODBC using SSL?

how can i connect IDB DB2 ODBC using SSL? IBM DB2 Driver for ODBC and CLI connection strings standard ODBC = Driver={IBM DB2 ODBC DRIVER};Database=myDataBase;Hostname=myServerAddress;Port=1234;Protocol=TCPIP;Uid=myUsername;Pwd=myPassword;

0 votes

0 answers

FERNANDO VASQUEZ • Jul 31, 2020

Connectionstring for ssl

How should a IBM DB2 for IBM i .NET Provider connection string change in order to communicate through ssl ports (9470-9476) instead of default (8470-8476) ?

0 votes

0 answers

Al Al • Jun 02, 2020

SSIS Package Encrypt password in IBM DB2 Conncetion string

Hello There, I have created an ssis package which pulls the data from IBM DB2 to a SQL table. To connect to DB2 i was using a project parameter DB2_ConnectionString as below

IBM DB2 Integration Services

0 votes

0 answers

Anonymous user • Jan 28, 2020

C# connect to DB2 timeout

Use 50 task.factory.startnew to query 50 subbusinesses at the same time, and execute 50 methods, all of which are using to open the database connection and execute their own queries.

0 votes

0 answers

Anonymous user • Jan 08, 2020

Error: System.ArgumentException: Absolute path information is required.

Error: System.ArgumentException: Absolute path information is required. My situation is this: Virtual Machine Oracle V 5.2.8 Running Ubuntu 16.04 With a C# Program developed in MonoDevelop

1 vote

0 answers

Ivan Pequeño • Dec 03, 2019

ArgumentException occurs when specifying IsolationLevel in DB2 ADO client

The following VB .Net code fails on the last line with an ArgumentException because of the IsolationLevel. I'm using V11.1 of the IBM DB2 ADO client(IBM.Data.DB2.dll). Does IsolationLevel work at all? I've tried dozens of values to no avail.

0 votes

0 answers

Clifton Sothoron • May 08, 2017

iSeries ODBC Access Driver - Get exact Double value as it is

Hello All, I am trying to get data from DB2 database using iSeries ODBC Access Driver and I am getting required data and working fine, but I am facing a problem in getting exact double value i.e. For Ex.

0 votes

0 answers

Shanmugavel Chinnagounder • Mar 03, 2017

Load more posts

Tagsfor this question

Forum

Access×161 Access 2000×8 Access 2002×4 Access 2003×15 Access 2007×29 Access 2010×29 Access 2013×45 Access 97×6 Active Directory×9 AS/400×13 Azure SQL Database×22 Caché×1 Composite Information Server×2 ComputerEase×2 DBF / FoxPro×20 DBMaker×1 DSN×21 Excel×129 Excel 2000×2 Excel 2002×2 Excel 2003×10 Excel 2007×16 Excel 2010×22 Excel 2013×30 Excel 97×4 Exchange×1 Filemaker×1 Firebird×8 HTML Table×3 IBM DB2×17 Informix×8 Integration Services×6 Interbase×2 Intuit QuickBase×1 Lotus Notes×3 Mimer SQL×1 MS Project×2 MySQL×63 Netezza DBMS×4 OData×3 OLAP, Analysis Services×3 OpenOffice SpreadSheet×2 Oracle×63 Paradox×3 Pervasive×6 PostgreSQL×20 Progress×4 SAS×5 SAS IOM×1 SAS OLAP×2 SAS Workspace×2 SAS/SHARE×2 SharePoint×20 SQL Server×214 SQL Server 2000×8 SQL Server 2005×13 SQL Server 2008×52 SQL Server 2012×35 SQL Server 2014×9 SQL Server 2016×12 SQL Server 2017×2 SQL Server 2019×4 SQL Server 7.0×3 SQL Server Compact×11 SQLBase×7 SQLite×16 Sybase Adaptive×13 Sybase Advantage×6 Teradata×4 Textfile×8 UDL×3 UniData×1 UniVerse×1 Visual FoxPro×10 Windows Azure Storage×4

connectionstrings articles search Q & A ask question contribute retro about contact log in join

Copyright 2024, © ConnectionStrings.com - All Rights Reserved

Powered by CSAS on .NET 8.0.7

Made possible by Contributing Developers