Connecting to SQL Server from Oracle 11g
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 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
How to write string connection for ADODB ?
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.
I am using the following connection string in web.config file for my application where both web server( Win 2003) and database server (sql 2005 EE) are running in the same machine. Source=.\\SQLEXP
I am trying to make a connection from an HTA to a SQL Server 2000 server on a network but only know the name of the server, not the IP address. The connection strings don't want to work with the serve
I have a problem with connection string for SQL Server 2008. I think it is connection string. It give me error 26 when i try to login. This is the connection string Data Source=192.168.0.1;Initial C
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
I am trying to run a vb 2010 application using sql express 2008. I have the app on the server (ELDSRV1) and an instance og sql 2008 on both the server and my workstation (ELDWK1). I can run the app
Dear Experts How can connect to mydatabase of sql server express 2008 r2 on a virtual dedicated server of godaddy.com what should be connectionstring kindly help regards dheeaj kumar
I'm converting a web app to run on Azure. I want it to access a SQL\Express instance on my server. I have the endpoint setup, but I can't find a clear example of the connection string that I need. T
Hi Peeps, I am totally confused now. My application uses a direct connection, which works 100%. The string: Public sConn As New SqlConnection("Data Source='JUAN-PC';Initial Catalog='chromepos
Hi all, I am trying to figure out how to create my connection string so that I can use current logged on account for authentication with my remote SQL server. Currently I can connect to my SQL server
I need to rewrite a c# app that is accessing an SQL 2008 server via linked tables in MS Access. I have an ODBC connection on my pc to the SQL database located at our hosting facility. I am relatively
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
I have configured a VPN connection between two offices. I have TCP/IP connectivity between both the server and client machine, and I have the firewalls open to the specific ports I need. I can conne
Hello I want to create a connectionstring for sql server that contains AttachDbFilename . I just found this for sql express in http://www.connectionstrings.com/sql-server-2008 Please help me
We recently have ported our GIS system to a Win 7 box in preperation of converting our whole system and ran into problem accessing a side database (SQL 2000) on one of the applications. The prolem is
hi everybody ... i want ur help about this problem ... i created a tiny project of Company Stores and it's run very well on my Computer, But when i run it on another computer, this message appears .
Which string i can used for my problem,? my problem is: i crate a windows form application in vb.net. my back end is sql server 2005.( sql authandication) using Which connection string i can easily ru
Any one can suggest me for how to connect the sql server from the forms 6i. With Regards Ravi
I used import/export wizard for importing tables from sybase ase12 to mssql2005. I've used .netframework provider for odbc for connection. My odbc works fine. But while using this, the first option is
i know the remote server's address like 114.120.124.112,the login name to the server is ,for example, test,password is test_1.there is a database named testDatabase in the server.there is no password
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
Hello, I have an iMac with Dreamweaver. I have to connect with Dreamweaver Mac on an SQL Server 2005. With a Windows station, i'm connect with this parameter : Provider=SQLNCLI;Server=myServerA
Hi There, I'm trying to connect to a remote sqlserver using c# in a web application. with no success: authen tication mode="Windows" identity imper sonate="true" add key="Connection Str
I am developing an app in visual studio 2008. This app should run to any computer where it will be installed. I connect it to SQL 2005 express. SQL 2005 express will also be installed to the same co
Hi all, please can any one help me to connect with mdf file using oledb connection string. Thank you.
I am coding my Project using ASP.Net and C#.My database is ms sql server 2005 express.I publish my project in server but I have a problem. The problem is; error: 40 - Could not open a connection