I wish to transfer MS-Access tables to Oracle 12 on a regular basis for data conversion purposes. I have established the necessary ODBC DSN and the VB connection string and it all works very nicely and fast.
Entering the required connection string gives me Verification failed ERROR...Data source name not found and no default driver specified. This is the connection string I have entered.
Hi all Together ! How to Connect VB.NET to SQL Server? Please Answer when you saw my question , I'm waiting .
Hi, I'm having trouble in connection string, I successfully linked Sybase to SQL server 2008 R2 using Sybase OLEDB Provider. I am using C#.net and asp.net for the front end. here is my connection string:
How to set the connection string for app_data folder for hosting, kindly help me out in this my current connection string is :-
Hi All, I am trying a Tricky one here, Request your help on the same. I have access 2007 Data base, Present in Share point. I have a Excel macro which Interacts with Access Database.
Hello, I am a newbe to programming. Is there a way to connect to multiple databases using ADO. I'm currently using the following string to connect to one database. dbname1 = "FireReportingTest"
I've got some long running data profiling queries that I am running against a SQL Server 2008 DB. Here is the connection string that I am using with the .NET System.Data.SQLClient provider.
Hi, I have created my Sql database in my local server using sql authentication..Created windows application using vb.net.When i install my setup file in my networks computers it runs successfully..but
hai I am getting an error called 'UserInfo' is not a member of 'User'. in the following code Select <% Dim i As Integer For i = 4 To 7
how to recover from the error "Name '__o' is not declared" I was trying to run the project which was developed in .netframework2.0 on .netframework4.0, but frequently i am getting this error like above 30 times.
Connection string to SQL Server 2012 "LocalDB" April 2, 2014 Hello, Could I get a little help on my very first attempt to write an app with code that connects to my own database table on my own computer. Using Windows8.1, Visual Studio 2013 Express bundled with SQL Server2012 Express localDB.
Now I'm using oledb in order to database connection on the c/c++ application program. Provider=SQLOLEDB;Data Source=127.0.0.1,1433; FailoverPartner=Partner_datbase_server_name;Database=databasename;User Id=id;Password=password;Network=DBMSSOCN;
I'm trying to create a simple app that has a search field that looks for records in a database. Once a record is found, it can be clicked on which populates a template with info to print a certificate.
hello .. im developing vb.net windows application with sqlserver 2008 database but i face aproblem with multi client lied in different location .. since making a network between them is costly ..
I have one directory website which is up and running and using the sql server 2000 database thru Godaddy. I recently made a duplicate of this website as I plan to start a new directory.
Hi, Is there a way to communicate with MSSQL directly avoiding the ODBC. I have been advised to use MSSQL Native Client which uses ODBC, OLE and ADO techniques. But is there a direct communication possible.
Hello, I would like to create a database and add tables from VBA. Can someone help me ? I have tried the following code with no sucess :( Dim str Dim conn, rst Set conn = CreateObject("ADODB.Connection")
Hi Every one, I need to connect DBvisualizer with AS400 in local machine. Can any one help on this with step by step procedure. Because i am new to this type of connections.
Jet 4.0 is now in a deprecated state so we intend to redevelop our applications (which currently access Access via DAO) to use something more "future proof".
Hi! I'm trying to create a test DB in SQL Server 2008, using Visual Basic 2010 Express. I'm failing each time--no message, just nothing shows up. Is it my connection string? Private Sub createDB()
Hi all , I have two servers in the same domain name , I installed a WebService on IIS one server,, the webservice read data from sql server 2008 database stored on another server ,
Could you help me? I made a small webservice in c#, there is an oledb connection. The webservice is operate from developer tools perfectly, but in the IIS only appear, and the connection does not work.
How to write connection string to 2003 Excel file( .xls ) with Operating system 64 bits because the provider " Provider=Microsoft.Jet.OLEDB.4.0 " not exist in 64 bits OS.
i encounter the following errors: 'connection' is ambiguous in the namespace 'ADODB' and 'Recordset' is ambiguous in the namespace 'ADODB'
I have a payroll system project with VB 6.0 and I want to connect it to Database (Access) that located in my office via Public IP. So, anyone can give me a code to connect that system to Database via Public IP ?
I have a back of my base on ftp. Now I working on my base using front which is in local network. But I would like to work online. So I have to connect to my base from the Internet. I read about connection string.
hi there, i try to set database path in web.config file. i am using file zilla for upload files. Database file in App_data folder. i used following code: above code display error.
Hi, I have an application developed in lightswitch. Using wamp server, I made a website (localhost). The database ("localhost / db.mdf") is in the same folder as the program ("localhost / default.htm").
I am using sqlserver 2008 and .net Framework 4.5 my connectionstring as below: enter code here <connectionStrings> <add name="ConnectionString" connectionString="data source=(local); Database:bongah; User id=myusername; Password=my password"/>