Connecting to SQL Server 2008 over the Internet
Hello. I am writing to thank you for your many help. especially those on connection strings which helped me a lot and I thank you for that. Please also help me please. here is my problem:
Hello. I am writing to thank you for your many help. especially those on connection strings which helped me a lot and I thank you for that. Please also help me please. here is my problem:
Bonjour. Je vous écris pour vous remerciez pour vos multiples aides. particulièrement ceux sur des chaînes de connexion qui m'ont beaucoup aidée et je vous en remercie. Je vous prie également de me venir en aide s'il vous plaît.
I have a VBA code (in excel 2016) that i use to grab information from a MS SQL server (2008R). The connection works fine on the computer i wrote it on. When i run it on another computer i get the error "[Microsoft][ODBC Driver Manager] Data source file not found and no default driver specified".
How do i specifiy to use the regional settings (those settings in Windows control panel) for numbers, dates and currency? When defining a DSN connection in ODBC manager Windows i can check to use the regional settings.
I have trouble to run my app when installing on another system the language is c# and I used DataAdapter and drag table to form to connect to db. when I Install on another system it gives sql server error :
the error is in conn.Open("Provider=SQLNCLI10.DLL;Persist Security Info=False;Initial Catalog=backup_db;Data Source=acer\JOSEPH")
I've read many questions about that problem but i still can't solve my problem. When I run my website on localhost everything is working. The problem happens when I run my site on SQL Server 2008. I've got an error:
I'm trying to export the data from multiple database from a single server into one excel using VBA code. Please can anyone help.
Getting a related error Microsoft SQL Server Native Client 10.0 error '80004005' Invalid connection string attribute /index.asp, line 44 Below is line 44. Running server 2008 with a DSN nmo idea what this syntax problem is?
I am having issues getting failover working with mirrored databases. Below is my information on driver I am using and connection string info. Any help would be greatly appreciated!
Target: Microsoft SQL Server Express Edition with Advanced Services (64-bit) OS: Microsoft Windows NT 6.1 (7601) Version: 10.50.1600.1 I have tried close to 30 various of the following, none of which work, any insight/suggestions would be great appreciated!
Hi,I have developed an application using Visual Studio 2008 on C# for stand-alone device, working under Windows Embedded Compact 7. Application work with SQLCompact 3.5 . using System; using System.Linq;
I am trying to connect to sql server 2008 r2 from Excel 2010 (VBA). the process is for internal purposes only. I need to pass an id and password to connect to the db from excel.
I have been using this connection string with no problem on a number of databases and MS operating systems. Sever 2003, 2008 R2 and 2012 R2 Eval.
I want to import excel data into my database using odbc and in .Net so i used this connection string: OdbcConnection occon = new OdbcConnection ("Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};
I have an MS Access 2010 32-bit database that is primarily a front-end. The data is stored in an SQL Server 2008 R2 managed by my company's IT.
Hi, I use Visual studio 2008, i try to create a new connection for a dataset in a vb application. But the datasource is on a SQL SERVER 2012, it's seem to be a problem of incompatibilty..
Hi everyone, I'm currently doing some research on the MS SQL native client for ODBC driver's security. I would like to seek details on how secure is ODBC driver in MS SQL Native client?
I am executing SSIS packages that override the Connection string by submitting new connection parms from batch execution of the package using dtexec.
Hi, Help!! How do I use a variable in a select statement in vba? This is a standard query Select IngredientID, Quantity, from Recipes where RecipeID = 7 This is what I would like to do, but do not know how to.....
I want to use multiple DSN connection string in my web.config file. But its giving error as default driver not specified. Any one please help me
hi friends have connected my database to sql server but the problem is setup file when make a setup file it doest not includes database(tables of that data base) the setup works in that system only if i tried to install the setup file in another pc it does not work..
First for some background on my situation: I am working in Access 2010 user frontend with a Microsoft SQL Server 2008 backend. I have a stored procedure that inserts new values(supplied by the parameters) into a table.
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 :-
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"
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
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 ..
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")