Sign up using Facebook. Too easy for you? Magnitude Support Community http: Can anyone help me out? I think it deppends as to what database you want to connect, because of the Driver that its used to connect to the database engine. By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of service , privacy policy and cookie policy , and that your continued use of the website is subject to these policies.

Uploader: Zulumi
Date Added: 15 June 2011
File Size: 69.41 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 63451
Price: Free* [*Free Regsitration Required]

Database Connectionstrings

By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. Stack Overflow works kdbc with JavaScript enabled. Note The feedback system for this content will be changing soon. Hah, someone connection string odbc me a downvote on this. Depending on the configuration of the data source and the type of connection string odbc you are working with, you might need to specify additional connection attributes.

Have you tried something like this for SQLServer? You should be able to find whatever you need here: Can anyone help me out? The connection string odbc of some of the drivers may be listed in multiple languages. Sign dobc using Email and Password.


The feedback system for this content will be changing soon. Skip the rest of this page and continue to the next step of the wizard. Old comments will not be carried over. Provide a connection stringwhich you can look up online, or create and test on your computer with the ODBC Data Source Administrator applet.

Configuration options that connection string odbc passed in using a connection string take precedence over configuration options that are set in the DSN.

Some applications connection string odbc support for connecting to a data source using a connection string odbc without a DSN. Click ok when done and open the file in notepad to see the connectionstring. I want both the odbc and the regular You have two options.

One of the most incredible hidden gems I’ve yet seen. This site uses cookies to deliver our services and to show you relevant ads and job listings.

Using a Connection String

After you configure your data source and click Finishyou connection string odbc see a summary of your selections and have an orbc to test them.

That is, the options you see are the same on both the Choose a Data Source and the Choose a Destination pages of the wizard. In the Create a New Data Source dialog box, select the driver for your data source, then click Finish. I’ve always done web apps and now I need to do a console app. Remember where you connection string odbc the file so you can find it and open it in a subsequent step.


Here are the contents of our SQL Server example.

This third-party site contains sample connection strings and more info about data providers and the connection info they require. A truly bad-ass trick!

– What is the connection string for odbc connections? – Stack Overflow

I have tried multiple combinations, looked online including connectionstrings. After you assemble the necessary values from the sample conncetion DSN, you have the following connection string.

For the SQL Server driver, for example, there are four pages of custom settings. The wizard parses the string and you’re ready to continue! I’m amazed that I did not know this.

Enter the connection string in the ConnectionString field on the Choose a Data Source or Choose a Destination connection string odbc, then continue to the next step of the wizard. Post as a guest Name.