TSQL Openrowset error with Timberline ODBC Sage 300 CRE
We are trying to Connect to Sage 300 CRE. The Timberline Driver ODBC has been installed. When we try to execute an SQL statement: SELECT a.* FROM OPENROWSET('MSDASQL','Driver=Timberline Data;
We are trying to Connect to Sage 300 CRE. The Timberline Driver ODBC has been installed. When we try to execute an SQL statement: SELECT a.* FROM OPENROWSET('MSDASQL','Driver=Timberline Data;
I want to connect to ABSS software and easily extract accounts, inventories etc. Can I use a similar way like SQL Server connection and do it? What could be the code for ABSS?
Upgraded from access adp to access 2013 accdb linked tables. Successfully linked the tables to sql server 2019 using SQL Server Driver 17. The database uses a module and lots of stored procedures in the Moduled, forms and reports.
Hello. I am writing to thank you for your many help. especially those on connection strings which helped me a lot and I thank you for that. Please also help me please. here is my problem:
Bonjour. Je vous écris pour vous remerciez pour vos multiples aides. particulièrement ceux sur des chaînes de connexion qui m'ont beaucoup aidée et je vous en remercie. Je vous prie également de me venir en aide s'il vous plaît.
Hi I am trying to connect to a Oracle Database from SSIS using kerberos /keytab authentication. What will be the connection string for database in case i want to read the pwd from my keytab file
What is meant by changing Namespace and how do you do it, for the new Microsoft.Data.SqlClient
hello. i'm trying to use tables from ms access and explore the data in excel so i want to write a code in vba excel that enables me to connect to the database in access. i searched and i found that i have to use connexion strings..
Hi. I am looking for the right connection string to retrieve data from microsoft sql database (2019 version) to an excel worksheet, using vba. I am currently using the MS Office 2016 version..
I am unable to connect SQL Server database from my Julia Language code web server; I suspect I am not able to figure out proper connection string.
how to connect ssms from visual studio using a domain account or service account ?
I get the error below when I run code to write clear data and write data into a SQL Server Database.
Hello everyone, I'm trying to make a VB console app to send mails extracting the data for the mail from a database located in the same pc. I didn't set up anything of the mysql server client.
I am a Continuity Management consultant, and work with app and infrastructure resources to create and validate recovery/resiliency plans.
If i will use other domain i cannot connect to the MS SQL Server but if i am using the same domain i was able to connect to the MS SQL. Another domain is okay i can ping and i can remote also share drive ok also only the application cannot.
I am trying to connect from my Azure function app to a SQL server which is installed on a Azure VM. Kindly help with the connection string "Server = MyVMIpAddress;Integrated security = true;Database = mydb;User Id = myuser;Password = mypwd;"
I'm building an Visual C++ project which is connected to Azure SQL database via ODBC, I placed the following connection string that Azure:
I'm a student learning programming. I need to find out what web address gets my database and server. I need to find out what the database name is.
I try to transfer a classic-asp-application from Windows Server 2008R2/II7 to 2016/II10 and SQL 2008 to SQL 2016. The application works fine with IIS10 and SQL 2008. Also with IIS7 and SQL 2016.
SSIS package works fine in Visual Studio, But when deployed it says gives error, SQL Jobs fails execution
I'm trying to make use of gMSA's to connect from ASP/X code to an MS SQL 2016 server. I've configured the gMSA with permissions on the target database and set up the gMSA on the source server, but can't get a connection string configured to use the account.
Why does the SQL Server ODBC Connection page not mention any example of using a non-standard port? I was incorrectly trying to use the "Port" attribute as "Port=x" but that does not work.
Hi Guys I am using SQL Server 2012 , using import and export wizard i want to migrate nuodb databse to sql , but could not find any JDBC data source inside the wizard.
I am trying to connect my C# code to SQL Server. My connection string is not working. It gives the following error: "Format of the initialization string does not conform to specification starting at index 0."
I have a VBA code (in excel 2016) that i use to grab information from a MS SQL server (2008R). The connection works fine on the computer i wrote it on. When i run it on another computer i get the error "[Microsoft][ODBC Driver Manager] Data source file not found and no default driver specified".
Remote MySQL Linked Server deployed in SQL Express Management Studio do not show any content and structure, it only LIST NAME of the tables belongs to the remote connected MySQL database
I want to Connect from Oracle to MS SQL Server with a connection string to pass location (IP) / username / Password and SQL Database !
Excel 2016 VBA to create an OLE connection to a sql 2014 db and then execute a stored procedure returning the results starting cell A1 on sheet :StoredProcData. Server & instance is QGZZZ\MYINSTANCE db is data
How do i specifiy to use the regional settings (those settings in Windows control panel) for numbers, dates and currency? When defining a DSN connection in ODBC manager Windows i can check to use the regional settings.
Trying to connect to a SQL Server 2014 and receive the error : (System.Data.OleDb.OleDbException: '[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.')