Data of a DB of PostgresSQL Excel import
The example of the program of import of data in Excel from PostgresSQL DB is necessary
The example of the program of import of data in Excel from PostgresSQL DB is necessary
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