access-2003_excel-2003_sql-server-2008_access_excel_sql-server (page 13) Questionssubmit your own question

Hey all, first time poster. I am a GIS (Geographic Information Systems) analyst and I use ACCESS and EXCEL alot for data extraction to bring into my GIS system. I have a vbScript file that was crea

I have made at database at SQL 2008. I have added the database at my Visual basic project and prepare my application. While I am adding records from the FORMS I have made at VB, it is saving at the da

Dear Buddies: I have a sql db with its application. I bring this program and the associated sql database to another computer. How can I get the "server" and "data source" of new computer for str

Hi. I have two files (file1.xlsm and file2.xlsx) and I want to bring a series of data from file2.xlsx to file1.xlsm, without opening the first one (file2.xlsx). For this I am using this code, which

Hi! (sorry for bad english) I get an error code that says (translated from swedish) "Wrong SQL expression, use Delete, Select, Insert...." Error Code -2147217900 (80040e14) rs.Open i marked The thi

Good Day Sir, Thanks for your articles on connection strings. They are quite educative and useful for beginners and experienced users. Please I have an issues that goes as follows: I have a 32

Hi, I'm having windows application and ms access database as backend.... I want to use IP address of machine, where my ms access database resides, in datasource property of appsettings in app.conf

How to connect access 2007 or 2010 with vb 6, thanks for your help. attn. gerardo g

I have multiple programs that access a single connection string in a ini file. Some of the programs are .net and some are not. I am using the following connection string. ConnectionString=Provider=

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 am currently testing the conversion to Access 2007 from Access 1997. I have discovered an anomaly in the external access process to Access 2007 databases. If you connect to the Access 2007 databas

Have a small ap that otheres want to use. Originally the ap was connected to SQLServer Express R8 via odbc with linked tables (only use 2 of the 50 tables in the db) and it works fine. Now that others

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

Hi there.! I've been working on our Software Analysis Development project for how many days and sleepless nights, the application is an Online Shopping. I'm using Microsoft Visual Studio 2010 as my en

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

When I attempt to connect to an MS Access database with the following connection string, "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;User ID=Admin;Data Source=" + strDatabasePath

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.

I have a web site which is a subset of another web site (that's what the client wanted). I want to share the Access database between the two. What would the connection string look like? Help most

Dear guys, can i interact with database on a web space via ftp or http from my winform application? if so then whats the starting point? Why i want to do this is becuase i have A client server applica

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 ?

hi all - first post - unfamiliar territory - looking for a helping hand been trying to open/use an old app - dev'd about 5 or 6 yrs ago - uses an export/import function to an Access db. I'm on Vista H

Bonjour, J'arrive pas à me connecter sur ma base de donnée ACCESS, voici le message d'erreur : le fournisseur "microsoft.jet.oledb.4.0" n'est pas inscrit dans l'ordinateur local voici la cha

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