access_oracle (page 7) Questionssubmit your own question

Hello! I'm having an issue with connecting to my Access 2010 database through SQL Server 2008 Report Builder 3.0. I attempted using the 2007 connection string but it keeps failing. I have it set up th

I used the Access 2010 upsize Wizard to put a table on our SQL Server (2008 r2)and still use the 2010 Access database for the frontend. It works fine on my computer because I setup a data source from

Hi, Is there a way to send encrypted password in the connection string? Please let me who had same objective and have any solution for it.

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

Hi, On a Windows 2008 server, in ODBC Data Source Administrator, I have defined a system data source (System DSN) named TRAP, with the driver : "Oracle dans OraClient11g_home1". In the ASP scrip

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

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

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

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

Hi we use,Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production We got a requirment to connect to SQL Server DB and get access a View. My DBA provided servername, DB name,User

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

I have a PC with two Oracle clients, each with his tnsname.ora. In it I created an ODBC connection (System Data Source). I want to know which of tnsname.ora is used to connect to the Oracle.

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

Hi, I'm trying to add an RC4-128 encripted Access 2007 DataSource to my VB2010 Windows Forms Project through the Add New Data Source Wizard but, when I click the Test Connection button, I am gettin

can someone tell me how to turn on/off encryption in the following connection string? ConnectionString: 'Provider=MSDASQL.1;Extended Properties="DRIVER={Oracle in CLIENT9201_HOME};.......

How to connect the postgres database from oracle database.

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

sorry if this is a duplicate post Okay, I am using some older tools here and what I want to do should be easy but I can't get the connection right. I have a access.db setup on a godaddy hosted w

I'm working in Visual Studio. I have created a OleDbConnection object that i need to assign a string to. From what i gather, i think i should use this one: Provider=msdaora;Data Source=MyOracleDB;User

Hi, I've installed a Windows Server 2008, with Oracle 10g client... The old provider in my ".asp" page doesn't work (Windows Server 2003 + Oracle 9i client): conn.open "Provider=MSDAORA;Data

Hi all I have a question, we have been entering data into a database that has sQL Server 2005 in the background and Access 2007 on the front end for over a year. We connect to it by entering in our us

Sir, The problem on the subject sited above is resloved as per your advice for which i am indebted your credit that will never forget. Sir, another problem related to it is that report cannot gene

sir, The following is the extract written in the module . The access always failed when i tried to access ms access password protected database from within the visual basic 6. Displaying Datareport a

Hi! I’m accessing an Oracle database via Oracle Provider for OLE DB 11g Release 1 (11.1.0.7.20) using Delphi (several versions). The program works as expected, opening tables and displaying info

Hi, do you have any idea how to programmatically connect to a database (access 97) located in a different folder(domain) having a password? Like I want to connect to mydatabase which the location i