ERROR 126

When I try and connect to the instance of the SQL server
that I set up, I get a error message about not being able
to load a driver (not specific) error 126 SQL server
"TBXML" <TBXML@.discussions.microsoft.com> wrote in message
news:4c5f01c4c6a1$7a342ad0$a601280a@.phx.gbl...
> When I try and connect to the instance of the SQL server
> that I set up, I get a error message about not being able
> to load a driver (not specific) error 126 SQL server
What version of SQL Server are you working with.
Are you using a Sybase driver by accident?
Rick Sawtell
MCT, MCSD, MCDBA
|||It is the version of SQL that comes with SBS 2003
premium. in terms of enterprise or standard i don't know.
I will look into it.
If i am using a sybase driver how do i know?

>--Original Message--
>"TBXML" <TBXML@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:4c5f01c4c6a1$7a342ad0$a601280a@.phx.gbl...
server[vbcol=seagreen]
able
>
>What version of SQL Server are you working with.
>Are you using a Sybase driver by accident?
>
>Rick Sawtell
>MCT, MCSD, MCDBA
>
>.
>

ERROR 126

When I try and connect to the instance of the SQL server
that I set up, I get a error message about not being able
to load a driver (not specific) error 126 SQL server"TBXML" <TBXML@.discussions.microsoft.com> wrote in message
news:4c5f01c4c6a1$7a342ad0$a601280a@.phx.gbl...
> When I try and connect to the instance of the SQL server
> that I set up, I get a error message about not being able
> to load a driver (not specific) error 126 SQL server
What version of SQL Server are you working with.
Are you using a Sybase driver by accident?
Rick Sawtell
MCT, MCSD, MCDBA|||It is the version of SQL that comes with SBS 2003
premium. in terms of enterprise or standard i don't know.
I will look into it.
If i am using a sybase driver how do i know?
>--Original Message--
>"TBXML" <TBXML@.discussions.microsoft.com> wrote in
message
>news:4c5f01c4c6a1$7a342ad0$a601280a@.phx.gbl...
>> When I try and connect to the instance of the SQL
server
>> that I set up, I get a error message about not being
able
>> to load a driver (not specific) error 126 SQL server
>
>What version of SQL Server are you working with.
>Are you using a Sybase driver by accident?
>
>Rick Sawtell
>MCT, MCSD, MCDBA
>
>.
>

ERROR 126

When I try and connect to the instance of the SQL server
that I set up, I get a error message about not being able
to load a driver (not specific) error 126 SQL server"TBXML" <TBXML@.discussions.microsoft.com> wrote in message
news:4c5f01c4c6a1$7a342ad0$a601280a@.phx.gbl...
> When I try and connect to the instance of the SQL server
> that I set up, I get a error message about not being able
> to load a driver (not specific) error 126 SQL server
What version of SQL Server are you working with.
Are you using a Sybase driver by accident?
Rick Sawtell
MCT, MCSD, MCDBA|||It is the version of SQL that comes with SBS 2003
premium. in terms of enterprise or standard i don't know.
I will look into it.
If i am using a sybase driver how do i know?

>--Original Message--
>"TBXML" <TBXML@.discussions.microsoft.com> wrote in
message
>news:4c5f01c4c6a1$7a342ad0$a601280a@.phx.gbl...
server[vbcol=seagreen]
able[vbcol=seagreen]
>
>What version of SQL Server are you working with.
>Are you using a Sybase driver by accident?
>
>Rick Sawtell
>MCT, MCSD, MCDBA
>
>.
>

Error "The OLE DB provider "MSDASQL" has not been registered." on SQL 2005 6

Hi,
I am trying to create a linked server from SQL server 2005 (64bit) to IB 7.5 database.

I installed the driver for IB on SQL box and created a System DNS (using
%SystemRoot%\SysWOW64\odbcad32.exe), tested the connection fine.

Now, on SQL Management Studio, created a linked server to use the System DSN,
sp_addlinkedserver 'MyLinkedSrv', ' ', 'MSDASQL', 'MySYSDNS' -- went fine.

Then ran the openquery,
select * from OPENQUERY(MyLinkedSrv, 'select * from services')

An error msg returned fro the openquery.
The OLE DB provider "MSDASQL" has not been registered.

What am I missing here? I tried with "Native SQL Client" instead MSDASQL but it returns me invaild parameters...

Any advice on this would be aprreciated.

Regards,
Sunny

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=396615&SiteID=1

HTH

error - ODBC sql server driver timeout expired

Hi everyone

I have installed SQL server on my server machine. using localsystem and mixmode option.
It is working fine.

I installed sql server with connectivity tools only option on my client computer.

now, When i try to connect to server using data source from control panel --> Administrative tools --> Data source(ODBC).

but I cant connect.It gives me error as below.

Connection Failed:
SQLState:'HYT00'
Sql Server Error:0
[Microsoft][ODBC SQL Server Driver] Timeout Expired.

I uninstalled sql server from my client and server computer. and installed again.

I tried to ping from client computer to server computer it is working.

even i tried telnet sqlservername 1433

this one is also ok.

But same error facing

Please help me out.

Regards,
ASIFWhat's the client OS? What service pack? What version of MDAC is the client running? What's the status of NetBIOS on your network?

What OS is the server running? Waht service pack for the OS? What version of SQL? What service pack?

Any firewalls running between your client and the server?

You'll need to research these to get to the root of the problem...

Regards,

hmscott