(page 13) Questionssubmit your own question

I am very new and very green to SQL. I am just learning and have downloaded SQL 2012 Express to experiment with. My apologies if this question is basic, something I should know.

Access Connection String for Passthru Query I have an access 2013 front-end that uses pass-thru queries to run SQL Jobs and stored procedures. I have to manually change these connection strings to move between a test and a production environment

I have set up an Open Edge ODBC datasource, and it says that it is connecting to my database, and I have verified this from like 3 or 4 different places, and it is even able to recognize the name of the database. However, I cannot query information from it.

This is my asp page,when i carry it out, the system tell me: Security settings on this computer prohibit access to data sources in other domains. (Please forgive me for low level of English.)

I am using below connection string to read the data from excel Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path of the file + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\""

We have been using the following Connection Screen to connect MS Access 2016 (64 bit) on a Win7 64 bit computer to our Pervasive V11 database.

I am using vb.net and I try to insert from my web in visual studio to my sql DB but it does not work also there is no any Error pleas help me " Imports System.Data Imports System.Data.SqlClient

I wonder if anyone has begun working with MongoDb? I have my own implementation of an Entity Framework that abstracts all the typical CRUD operations, and I'm investigating what it will take to support MondoDb.

I wish to have a vba like : In an Excel sheet, a) In a row , say 1 & at any col.say 'A' , the cell content is P1; at cell B1, the cell value is 1,at cell C1, the cell value is 1 & so on till it is other than 1, may be q or any other data.

I have just started to learn ASP.NET. Now, I have created a code first, database. It is using localdb v 11.01 The database which is generated show 3 tables. But, I do not know where to open the database to see the data inside.

Good morning, I'm new here, live in Venezuela, glad to know about you, come here to solve a problem with a connection between a Visual Basic 6, and Sql Server 2000, converted my Access database to Sql database with Access, .adp, and move to Sql server 2000 with access2003.

Hello; I has and old web application begin with windows 2000 and SQL 200. Then Windows 2003 and SQL 2005. In the 2 scenarios I change in this string the data source (server name and the password and then work fine.

Hello All, I am facing one issue like "External table is not in the expected format." with 2013 micro enable excel . when i am trying to open the connection string for reading the excel file i.e oleConn.Open(); .

hi friends i want create a connection string to a sql server database by asking connection string parameter values from user in a cosole application?? anyone can help me on this ??

We're trying to reconcile what we see under the "ODBC Administrator" application for Windows 7/8 versus what has been referenced on this site under the following drivers/providers:

I need to connect netezza from EXCEL. When I am going (DATA --FROM OTHER SOURCES --FROM DATA CONNECTION WIZARD--Other/Advance--IBM NATEZA OLE DB DATA PROVIDOR --(In Data source I am putting IP , and user name and password) but it is not working.

I am trying to connect to an Informix database from powershell 4 I can connect to ms sql easily $table=(Invoke-Sqlcmd -ServerInstance $server -Username $login -Password $password -Database $database -Query $query)

Dear Friends I have developed a Windows form c# application in which I've used SQL CE toolbox to create contacts application to store phone numbers. When I run this application file in other PC, then all woks fine except contacts application as it says database not found.

I have a VB6 application that runs correctly from the system that contains the sql server and the source code, either when compiled as an exe or directly from the VB6 developer. It uses this connection string.

Hi, I am fairly new to VBA I have some syntax problems that I do not understand with the connection strings that you give. For example for XL 2007 With the following, the first ( which you give ) and the Third give Syntax errors.

hi, I want to construct a string connection for accessing a custom OData Service. The format of such string must be of the form "prover=**;metadata=" What may I use to replace *

Can anyone share the syntax for a SQL connection string that has variables for the different parameter values? Need to pass the values of some textbox fields into the connection string but I get an End of Statement Expected Error with my string in Visual Studio 20102:

Whenever i select DATA SOURCE as"Microsoft Access Database File (OLE DB) " the pop up window does not shows browse button to select Database.

I'm new on working with databases. Right now, I'm working on an Access 2013 database. In my table I have first name and last name, the job and other related personal information.

Hello, i have been using only one mysql server in connection string until now, but today after making of replication of server1, i have server1 and serve2 operationg which are synchronized between them.

Hi, I'm trying to do an export from access into a text file via a query select CustomerName into [Text;FMT=TabDelimited;HDR=NO;DATABASE=C:\Temp\;].CustomerList.txt from Customer

Drop down lists without arrows. I have a spreadsheet created by someone else, there are multiple cells with drop down lists that can only be seen when right clicking the cell and selecting "drop down list".

I have a form (.asp) on Dreamweaver. I want to connect to a remote server. The database on the server is http://www.table-pads-custom.com/newestonline.mdb. I want to connect so the form info goes into the database.

Access 2010 includes an option checkbox "Open databases by using record-level locking" (under Client Settings). Is there an ODBC connection string to enable or disable this option from a program?

I have three questions. any helps,thank you very much! 1.How to connect Oracle 11g release 2 in Excel VBA with ODBC? 2.How to insert records into a oracle table, for example, table HR.DEPARTMETS