(page 24) Questionssubmit your own question

Hello Dear Friends i need a help with the connection string, im using visual studio 2010 and sql server 2008. I create a exe file for my application, so that i can install it in another laptop, after

I have an access database frontend installed on multiple workstations on the network. The backend (containing the tables) is stored on a network drive. Beint new to access, and VBA, I am not sure how

Hi, I am working on migration from Sybase to SQL server 2005 project. I need to connect Sybase through OLE DB provider. I want to download Sybase ASE OLE DB provider for 12.5 Is there any locat

This is the scope: We are engaged in the cleanup of our systems with the sole purpose of checking and remediateing vulnerabilities in all our servers. We will continue with the process in the

Hi, I want to use cobol to retrieve data from oracle data base. But I have not see any connection string for oracle Somebody have an example of connection to oracle database with cobol with a simpl

I use var selectCmd = "SELECT * FROM [" + excelSheetName + "]"; The connection string With Extention of: Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + absPath + fName + ";Extended Properties=

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

Hi all, using the SQL Azure Migration Wizard tool, I get the following error in around 10 tables, when trying to connect to the SQL Azure instance. The first step for connect to the Umbraco DB is sup

hi, i m new to this environment. can u explain me how can i get all the column names from a sheet.I have more than one sheet in my workbook and i want to get the column name from with their respectiv

I have tried to connect to Citrix Oracle Database using the logic i used to connect to Database..But here i am getting error.. is Connecting to Citrix database is different to Normal Oracle databas

Hi there, I am a member of this forum. I am interested to learn SQL server, now i own 2008 standard edition version. Just got it downloaded from website. I do not know anything about this. This is a

Hi I have made this VBA programming that copys from a Excel sheet to another. But now I get this message "There is a lagre amount of information on the Clipboard. Do you whant to be able to paste t

Provider=MSOLAP;Data Source=http://serverName/;Initial Catalog=myDataBase;User Id=domain\user;Password=myPassword;Protection Level=connect;Transport Compression=None;Protocol Format=XML;

Hi All, Can anyone please help me with connection string for DB2 URL connection string using vbscript? Thanks, Lakshmikanth

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, I am trying to create a query with some information coming from 2 different databases that request two different users and passwords. So I guess I should create something like a multiple connecti

I used the Access 2010 upsizing wizard to upload the tables from an Access database to SQL 2008. I believe that I understand the connection string, but I don't know how to apply it. Is it a function i

hi i am using visual foxpro 7 i want to populate a table in foxpro fetching data from oracle we are using oracle 11g standard edition can any one help me here? hemu

I am trying to create a SQL 2008 connection from VBscript using Windows Authentication and I am getting the error "login failed" for the below string. Any sort of help is much appreciated. strConnect

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

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.

I open a DBF file with Microsoft.Jet.OLEDB.4.0 provider in c#. The data that I have to insert in the file contains characters like é, è, à (is a French application), and those characters are replaced

Now that Rocket Software has acquired both the Universe and UniData platforms, the driver names are obviously different. http://www.rocketsoftware.com/u2/products/universe In addition, I have been ins

I can get the connection to work to our AS400 system. I can pull in any field that is declared as a number. Any field that is delcared a "text" or string field does not come in. We do have one field t

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

Hi Guys, I'm using OLE DB IB Provider ver3 to Connecting to InterBase XE in Visual studio 2010, c++ environment. I'm using following for local host strConn = L"Provider=LCPI.IBProvider.3;"; st

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