Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » ODBC   (RSS)
Tuesday, November 24, 2009 9:59 AM

How to create a DNS less linked server in Access to SQL Server.

Sometimes you may want to use Access as a front end for SQL Server. When doing this you typically have linked tables to the SQL Server and you have the .mdb on a shared drive for users to access. Normally you create a DSN and use that for the linked server.
Posted by maspeng | 3 Comments
Filed under: ,
Friday, November 14, 2008 3:08 PM

Connectionstrings, mixing usernames and windows authentication. Who goes first?

When connecting to Sql Server from .Net, there are three namespaces containing classes to do so: System.Data.SqlClient / System.Data.OleDb / System.Data.Odbc The one should use is System.Data.SqlClient since this contains functions specific to Sql Server,
Posted by maspeng | 1 Comments
Filed under: , , ,
Friday, November 07, 2008 4:25 PM

SQL Server Error: 10060 \ SQL Server Error: 10061

Ok, new entry with connectivity problems and examples. The scenario: You have a SQL Server 2005 that is up and running you also know that the SQL Browser service is up and running. So on the server side, all is well. On a side note, if you do not know
Posted by maspeng | 1 Comments
Filed under: ,
Friday, September 19, 2008 3:18 PM

Dude, where did my ODBC System DSN go?!

When creating ODBC DSN’s, sometimes it all seems to go well. You open the ODBC Data Source Administrator. You enter the connection details for a new User DSN, test the connection and all is well. BTW: instead of going: Control Panel -> Administrative
Posted by maspeng | 0 Comments
Filed under:
Friday, August 01, 2008 9:08 AM

How to use a FileDsn in .Net

Another short one. I saw a question on how to use FileDsn’s in a .Net application. This may not be the most common scenario, but it can be done. I’ll show you how. This example will assume that you have an Access database located at C:\Temp. This Access
Posted by maspeng | 1 Comments
Filed under:
Tuesday, July 15, 2008 3:38 PM

Creating a new system DSN: "Faulting application odbcad32.exe, version 3.526.3959.0, faulting module unknown, version 0.0.0.0, fault address 0x5bb312de"

This is an issue that I have seen a few times, so it could be worth mentioning. The error is as follows: When trying to create a new System DSN using the ODBC Data Source Administrator, the odbcad32.exe process goes down. And you will see something like
Posted by maspeng | 1 Comments
Filed under:
 
Page view tracker