dsn_excel_sql-server-2008_sql-server (page 8) Questionssubmit your own question

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?

I am new with VB. I got now the Visual Studio 2010. I've never used it before. I need the following: I need a login form, which is using an ms sql server database, in which I stored usernames and pas

I am learning .Net, please help me out regarding this question. Why do people want to write the connection string in web.config? Instead we can assign the string to one public variable so that we ca

I have the Sage50 Pervasive ODBC driver installed on my Win2003 server. I have Sage50 configured for ODBC access (known in Sage50 as Crystal/ODBC access). I'd like to set up a Linked Server in SQL