Now I'm using oledb in order to database connection on the c/c++ application program. Provider=SQLOLEDB;Data Source=127.0.0.1,1433; FailoverPartner=Partner_datbase_server_name;Database=databasename;User Id=id;Password=password;Network=DBMSSOCN;
I'm trying to create a simple app that has a search field that looks for records in a database. Once a record is found, it can be clicked on which populates a template with info to print a certificate.
hello .. im developing vb.net windows application with sqlserver 2008 database but i face aproblem with multi client lied in different location .. since making a network between them is costly ..
I have one directory website which is up and running and using the sql server 2000 database thru Godaddy. I recently made a duplicate of this website as I plan to start a new directory.
Hi, Is there a way to communicate with MSSQL directly avoiding the ODBC. I have been advised to use MSSQL Native Client which uses ODBC, OLE and ADO techniques. But is there a direct communication possible.
Hello, I would like to create a database and add tables from VBA. Can someone help me ? I have tried the following code with no sucess :( Dim str Dim conn, rst Set conn = CreateObject("ADODB.Connection")
Hi! I'm trying to create a test DB in SQL Server 2008, using Visual Basic 2010 Express. I'm failing each time--no message, just nothing shows up. Is it my connection string? Private Sub createDB()
Dear All, how to write the connection string of a file which is XML spread sheet 2003 my file named test.xml and its contains is: <?xml version="1.0"?> <?mso-application progid="Excel.Sheet"?>
Dear all, how to write the connection string of XML File which represent a Spread Sheet document
Hi all , I have two servers in the same domain name , I installed a WebService on IIS one server,, the webservice read data from sql server 2008 database stored on another server ,
i encounter the following errors: 'connection' is ambiguous in the namespace 'ADODB' and 'Recordset' is ambiguous in the namespace 'ADODB'
hi there, i try to set database path in web.config file. i am using file zilla for upload files. Database file in App_data folder. i used following code: above code display error.
Hi, I have an application developed in lightswitch. Using wamp server, I made a website (localhost). The database ("localhost / db.mdf") is in the same folder as the program ("localhost / default.htm").
I am using sqlserver 2008 and .net Framework 4.5 my connectionstring as below: enter code here <connectionStrings> <add name="ConnectionString" connectionString="data source=(local); Database:bongah; User id=myusername; Password=my password"/>
I am creating a windows application.using sql server 2008. I am getting connection string problem while connecting to .mdf file which is in this location c\folder\file.mdf.
I have an 2010 Access Database where I am using a connection string to link (via MA Access Query) to a table on our SQL Server. I am using the connection string below. and it pulls back the table jus
I have read countless postings on connecting to Oracle and I am still stumped. One problem may be that I am running a 64 bit machine with 32 bit Oracle installed trying to make everything work. When I
Error: ... ODBC connection to SQL Server {IP} failed........ I make a code in vb6 using MS ACCESS 2007 with ADO as object in which data was imported or link to Microsoft SQL 2005 in order that I will not change any data from my SQL server.
Hi I am building a web site in asp.net using visual studio 2013 asp 4.0 C# sql server (not certain of version). I am using an existing connect string that works for my other queries. I know that my
Hi, I currently have a my aspx files stored on a web server with 2008 ms sql. I have no problem connecting to the ms sql on the web server using a connectstring in my web.config. My company also has a
Hi All, Im wanting to know if there is a way I can point our connection string to a custom application/utility. The reason being we currently are running an asp mvc LOB application which is having so
I am having difficulty with SQL Server Express when using Visual Basic 2008. I can connect to and use SQL 2005 Express via SQL Server Management Studio without any problems. I can use databases from
Here's the setup: MS Access has a linked table to SQL Server. SQL Server has a password on it. Trying to use Excel VBA to query this linked table in Access, but I can't get the connection string co
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. How can i solved this problem??
Hi, I have a .NET application which is hosted on a web server and an MSSQL db hosted on a different server. As part of the security checklist, I am not supposed to mention the db credentials (conne
I have Access 2010 installed on Win8/64-bit machine. Am using a VBscript in a .HTA file. Trying to connect to .ACCDB using ODBC. I know I'm accessing the database as I am getting a field count corre
I am trying to Connect SQL Server 2005 from VB6 code. I am getting the below error: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was d
DSN Connection error with SQL Server 2000. Hi, I am using VS 2010, here is the code below. System.Data.Odbc.OdbcConnection conn = new System.Data.Odbc.OdbcConnection(); conn.ConnectionString = "Dsn=
I have tried to connect to the remote computer using this string = 'Server=tcp:SERVER,1433;Database=TBSDB.mdf;Integrated Security=True;Network Library=dbmssocn;Connect Timeout=30;User Instance=True'
Using SQL Server 2012, what is the best data type to use for storing date time values. DateTime or DateTime2?