.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Pankaj Mishra
alex morco
Imran Ghani
Post New Web Links

ODBC Connection

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :SharePoint

Hi all

I am pretty new to sharepoint so i thought i would post to see if anyone could point me in the right direction.

We have a database that is a Visual FoxPro Database and i would like to be able to connect to it through SharePoint Designer so that i can Extract data to publish.

Is this possible to do through SPD i can see that you can easily connect to SQL Databases but i cannot see anything that refers to ODBC connectivity.




View Complete Post

More Related Resource Links

Basic ODBC Connection to connect to Crystal ???


I have visual studio 2008 professional with the inbuilt crystal reports version 10 I think.  I create everything from my laptop and IIS runs from my laptop as well.

I have created the most basic report to try and figure out a problem I have, anyways the report contains one database field that is it .... which I connect to by ODBC.  I then create a web form add the crystal report viewer to the report and the crystal report source run the web page and it loads the data from the field as I would expect to the crystal report viewer !!

I have several ODBC connections setup on my machine one using integrated security the other using SQL authentication both are system DSNs.  Now when I publish my application and access it from IIS and not the localhost I can access everything from my application ok except when I go to form that has the crystal reports I get this error (ODBC used here is the 'sa' account)

Logon failed. Details: IM002:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Error in File

If I use the other ODBC that uses Windows authentication I get this error message

Logon failed. Details: 42000:[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database  requested by the login. T

odbc connection failed

i have microsoft sql server 2000. i am using program based on VB.when i try to run the components like  import database design, link table, etc then the message get displayed " ODBC connection failed".please give me the solution.please.....

odbc connection to sql server c#

How can I use ODBC to connect to sql server 2005 in c# windows forms ??  Please post a code snippet as example ....  

ODBC connection to SQL Server 2005 Standard (on windows xp) with Windows authentication does NOT wor

I reviewed lots of postings, still could not find an answer. If I choose Windows authentication: - with TCP/IP and "Dynamically determine port" checked, I get the following error "The user is not associated with a trusted SQL Server connection; - with Named Pipes, Server Name & Pipe Name as "VSAXAONG", I get two errors, one after the other on the same pop-up:       Connection failed  SQL State 01000  SQL Server Error 1385 [Microsoft] [ODBC SQL Server Driver] [Named Pipes] ConnectionOpen (Connect()).       Connection failed  SQL State 08001 SQL Server Error 17 [Microsoft] [ODBC SQL Server Driver] [Named Pipes] SQL Server does not exist or access denied. If I choose SQL Server authentication and fill in the password - the ODBC connection works fine. I have to say that I created two different logins on the server, one for Windows authentication, and one for SQL Server authentication - both for the same Windows user name. I would appreciate any help I can get on this.  Thank you all in advance.

ODBC connection in group policy

Hello, We want to apply ODBC connection setting for all users in AD. We did googling but could not able to find any help. We've SQL 2005 database package which will be used by all users and users have very limited access i.e., only to run this package. Nothing else access given to users. User unable to use package as ODBC connection is set fo them. We do ODBC setting for every users one by one giving control panel setting and then again revert it with limited access. It is very difficult task to for 100 users. Please suggest GP where in we can set the ODBC for all users at the time. Your early response will great and appreciated. Thanks!!!   Regards, Shaikh Sameer

ODBC connection error


I have a 2008R2 server that I have SQL Server 2005 (32-bit) loaded on.  I have my databases installed and can connect to them from SQL Server Management using the 'sa' account and can run scripts, etc.  Howerver, when I try to setup an ODBC connection from another 2008R2 server running an application that accesses some of those same databases I get the following error when trying to connect using 'sa':

  • Connection failed:


  • SQLState: '01000'



  • SQL Server Error: 5



  • [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen



  • ((Connect())



  • Connection failed:



  • SQL State: '08001'



  • SQL Server Error: 17



  • [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

Any help would greatly be appreciated.  I apologize if I have posted to the incorrect forum, please just let me know.  Thanks in advance!!

Tim Garber

SSIS -2008 R2 - ODBC Connection error - Password does not save


Please know that I am new to SSIS 2008 and XML. Have a package I am trying to deploy. Am on a HV 64 Bit environment SQL Server 2K8 R2. Have an ODBC connection to our HBOC system as a data source. As always package runs in test environment and not in prod.  I need a bit of insight into the what and why's of the configuation file and how to change out the XML. 

Main issue is the password not saving and how to handle the ODBC side of things. I appreciate any help in this matter as I have searched with no real understanding of XML and best practices of creating the Congif file.


Configuring ODBC Database connection in Sharepoint Designer 2010


We are trying to connect the simple way from Sharepoint Designer 2010 to an external Pervasive SQL version 10 database.

Normally this is a trivial excercise in any other development tool, you supply an ODBC connection and away you go.

Using Sharepoint Designer 2010 (or the previous version) it is not possible to get a working connection that will get you past the "Configure Database Connection" dialog. We have to use the "Use custom connection string option" as that is the only place there appears to be a Provider for ODBC or OleDB.

No connection string works, I have tried connection strings that work fine in Visual Studio, no joy.



ODBC remote internet connection: works Win 7, but doesnt on Win XP


Hi, I have a SQL Server 2008 express running well. The connections in the local network runs very well via ODBC Native Client 10.0 .

When I try to connect via internet, it works when I configure the ODBC in my notebook that has a Win 7, but when I try to go to other computer in the same network with Win XP, it says "Connection timeout".

I had to download de ODBC Native Client 10.0 for the WinXP pcs, because the standard "SQL Server" ODBC driver was not working...


Anyone has an idea?




Guilherme Louzada

SQL Server 2005 Express ODBC connection error with Windows Vista Business

I have a SQL Server 2005 Express Edition installed on a Windows Server 2003 domain machine. When I do a connection with a client running Windows XP through the SQL 2008 ODBC driver I have no problem.  The problem is when I try to establish a connection using a client running Windows Vista Business Edition which is a member of the domain. Please help me to solve this issue.

Thanks in advance
Danilo Bucheli Sánchez

ODBC connection problem with Matlab



I am working with an application developed with Matlab that needs to connect in a database to load some data. What the Matlab application does is connect to a SQL database by and ODBC connection. This application works without any problem under a Windows XP 32 bits and with a Matlab R2009b installed. I also have created a standalone version (.exe) of the application, that is an executable version that runs without the necessity to have installed Matlab; it's only necessary to have installed the MCR (Matlab Compiler Runtime). This executable version also runs without any problem under a Windows XP 32 bits.

Now, I have tried to run the application under a Windows 7 64 bits and have appeared some problems of connectivity. Well, only have appeared problems of connectivity with the application executed from the .m file in Matlab. The executable version works without any problem. The only need to work with the executable version is run as administrator. Then, it connects with the database and is possible to load all the data and display it.

I have read that in Windows 7 is possible to create an ODBC connection with a 32 bits version of the Odbcad32.exe and a 64 bits version, depending on the application to which you connect . In this case, what I have installed is a Microsoft SQL Server 2005 SP

How to create ODBC connection to SQL 2005


I've created an instance on a SQL 2005 server and have successfully created an ODBC connection on the remote server I'm trying to connect from. When one of my users tries to create a connection he gets a login failure message:


Connection failed:

SQLState: '28000'

SQL Server Error: 18456

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'DOMAIN\username'


I'm not very familiar with SQL 2005. Any thoughts?

Trying to import excel data into dbo schema using odbc connection with sql server


I have written this vb.net code to import an excel spread sheet but need for it to imported into the dbo shema. When I look in the database the table name is me.tablename instead of dbo.tablename.

    Public Sub Main()
        Dim sheetname As String
        excelpath = "S:\Account Management\jkormann\DynamicScoring\GE_Money_MN.xls"
        ServerName = "server"
        DBName = "sf"
        'SchemaName = "dbo"
        InsertedTableName = Dts.Variables("strTableName").Value.ToString
        sheetname = Dts.Variables("strSheet").Value.ToString
        'ImporttoServer(CStr(ExcelPath), CStr(ServerName), CStr(DBName), CStr(SchemaName), CStr(InsertedTableName))
        ImporttoServer(CStr(ExcelPath), CStr(ServerName), CStr(DBName), CStr(InsertedTableName), CStr(sheetname))

        Dts.TaskResult = Dts.Results.Success

ODBC Connection failed




When I am creating ODBC connection for sql server using with Sql Server authentication mode is is giving the following error


Connection Failed:

SQL STATE:'01000'

SQL SERVER Error:10061

[MicroSoft][ODBC Sql SERVER Driver][TCP/IP Sockets] ConnectionOpen(Connect())'

Connection Failed:


Sql Server Error:17

[MicroSoft][ODBC Sql SERVER Driver][TCP/IP Sockets]sql server does not exist or access is denied.


I am giving the correct username and password.... even though it is giving the error

ODBC connection with different SQLSRV32.dll



I have to connect to an MSSQL 2005 database on a W2003 sp2 server.

To perform an first test I installed MSSQL 2005 express localy on my WVista pc, established the ODBC connection and all worked like a charme, I could read and update\write data.

So I made the ODBC connection on the server and tried the same connection. It worked, at least I thought, reading the data from the file was perfect. But as soon as I tried to change the data I got the error " Record has been changed by another user".

I did start the odbc tracing and I think it is in the SQLSEV32.dll driver.

Versions: W2003sp2 2000.86.3959 and Vista 6.0.6001.1800.

Tried to install the 6.0. driver onto the W2003 server using regsrv32 but then I get the error specific driver could not be loaded due to system error 127.

My question is it possible to get the Version 6.0.6001 driver installed on the W2003 server or is there another solution ?


TIA for your help




SharePoint BDC- Oracle ODBC connection with SSO


Can someone help me with LOBSystemInsance for Oracle ODBC connection with SSO?

ODBC connection issue to SQL 2000 SP4. [TCP/IP Sockets]Specified SQL server not found


Server: Stand alone Windows 2003 R2 Enterprise x64 Edition Service Pack 2

The server has 4 quad-core processors with 32Gb RAM

SQL: 2 instances of SQL Server 2000 Enterprise Edition SP4 with cumulative update version: 8.00.2040

I am trying to connect to the named instance of SQL Server with an ODBC connection. I am a local admin on the server and a sysadmin on both the default instance and the named instance. I get the error message

Connection failed:
SQLState: '01000'
SQL Server Error: 11004
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.

My users are trying to connect via SQL login and are also receiving the same error message.

The default instance is listening on port 1433. The named instance is listening on port 1464. There is no Windows firewall installed on the server.

The annoying thing is that if I click on the button called "Client Configuration" when using the "ODBC Data Source Administrator" dialogue wizard, and I un-tick the radio box called "Dynamically determine port", and hardcode the port 1464 into the dialogue box, everything works as it should do.

Unfortunately this

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend