SQL 2008 and using the logged in user, please help
I am new to this, I have searched and searched but cant find the answer im looking for. Im using visual basic c# and a web app form this is where the users log into the site. (I have sql 2008 appl
I am new to this, I have searched and searched but cant find the answer im looking for. Im using visual basic c# and a web app form this is where the users log into the site. (I have sql 2008 appl
Error: A network related or instance-specific error occurred while establishin a conncection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct an
Am using a connection string to connect to SQL Server 2000 via Visual Basic DLL. We are moving to SQL Server 2008. Tried to use same connection string but am not getting any results. Do I need to use
I have Excel 2007 data sheet with connetion to external data source (SQL Server 2008). Sometimes server goes blocked for hours - so I need command timeout to switch to another server. I need it within
I have an Access 2007 database with records being inserted every 5 minutes, there are 17 columns. 1st column - date and time 2nd column to 17th column are values - (0-100) My Excel 2007 OLEDB dat
Is it possible via connection string, specify to which schema refer, just to be more clear, I cannot refer to dbo, I have a schema named as the username, it's an shared hosting environment. This
Hi, I am trying to create an Entity Data Model project in Visual Studio 2010 that uses a .mdf file as it's database and am experiencing some difficulty. On this particular computer MS SQL Server
I was wondering if the connection string object for SQL Server 2008 would still work in Denali or would it be different?
Hello everyone. I'm having a really rough time with this so I figured I would ask. I haven't had much input on MSDN Forums. Here's my thread though if you'd like to see it: http://social.msd
Hi, I have created a database using Microsoft Visual Web developer 2008 express edition, which creates a .mdf file. I have converted that file to an .mdb file because that is what my ISP supports.
Hi, Can I set up an odbc DSN to connect to SQL server on the same machine, using an Active Directory domain userID that is not logged on to the machine?
What connection string would I need to access an attached SQL Server 7 (SP3 version, to be precise) database located within a SQL Server 8.0 environment? This question is driving my work area bats
How to write string connection for ADODB ?
I found the useful connection string to access to Excel 2007 Macro enabled workbook. Here is the connection string Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\report.xlsm;Extended Propertie
Hi I need to write a C#.Net program to read an Excel 2010 file. What is the OLE DB driver that I should use? Is it ACE OLEDB 12.0? Thanks in advance.
I am using the following connection string in web.config file for my application where both web server( Win 2003) and database server (sql 2005 EE) are running in the same machine. Source=.\\SQLEXP
I am trying to make a connection from an HTA to a SQL Server 2000 server on a network but only know the name of the server, not the IP address. The connection strings don't want to work with the serve
I have a problem with connection string for SQL Server 2008. I think it is connection string. It give me error 26 when i try to login. This is the connection string Data Source=192.168.0.1;Initial C
I am running Oracle 10g on an Windows XP system. How do I access data in a MS-eXcel spreadsheet from SQLPlus? I have set up the eXcel ODBC Driver. What does the following SQL Server code translate
I am trying to run a vb 2010 application using sql express 2008. I have the app on the server (ELDSRV1) and an instance og sql 2008 on both the server and my workstation (ELDWK1). I can run the app
Can we get data from table feature of Excel 2007 / 2010? Ex. Select * from Table1 or Table 6, instead of select * from [Sheet1$]
Dear Experts How can connect to mydatabase of sql server express 2008 r2 on a virtual dedicated server of godaddy.com what should be connectionstring kindly help regards dheeaj kumar
I'm converting a web app to run on Azure. I want it to access a SQL\Express instance on my server. I have the endpoint setup, but I can't find a clear example of the connection string that I need. T
Hi Peeps, I am totally confused now. My application uses a direct connection, which works 100%. The string: Public sConn As New SqlConnection("Data Source='JUAN-PC';Initial Catalog='chromepos
Hello everyone! I have a big problem :) How can I export an Excel spreadsheet (only a single worksheet) to a remote MySQL database using VBA code? I have always imported a .csv file with phpmyadmin, b
Hi all, I am trying to figure out how to create my connection string so that I can use current logged on account for authentication with my remote SQL server. Currently I can connect to my SQL server
I need to rewrite a c# app that is accessing an SQL 2008 server via linked tables in MS Access. I have an ODBC connection on my pc to the SQL database located at our hosting facility. I am relatively
I have configured a VPN connection between two offices. I have TCP/IP connectivity between both the server and client machine, and I have the firewalls open to the specific ports I need. I can conne
Hello I want to create a connectionstring for sql server that contains AttachDbFilename . I just found this for sql express in http://www.connectionstrings.com/sql-server-2008 Please help me
We recently have ported our GIS system to a Win 7 box in preperation of converting our whole system and ran into problem accessing a side database (SQL 2000) on one of the applications. The prolem is