Error connectiong to database

11 Apr 2006 1:52 PM

helpful sql

Hi,
I am designing a webpage with the DbNetGrid control on it. I am folloing
its documentation and using the following connection string to connect the
grid control to a database:

'Provider=SQLOLEDB;Driver={SQL
Server};Server=(local);Database=pubs;Trusted_Connection=yes;'

But DbNetGrid keeps giving me the following error. I have tried different
variations of this connection string but nothing seems to work.

[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified (-2147467259)

Thanks.

11 Apr 2006 2:28 PM

Sericinus hunter

helpful sql wrote:

> Hi,
> I am designing a webpage with the DbNetGrid control on it. I am folloing
> its documentation and using the following connection string to connect the
> grid control to a database:
>
> 'Provider=SQLOLEDB;Driver={SQL
> Server};Server=(local);Database=pubs;Trusted_Connection=yes;'
>
> But DbNetGrid keeps giving me the following error. I have tried different
> variations of this connection string but nothing seems to work.
>
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified (-2147467259)

You have to create ODBC Data Source object as the message states.
Look for Data Sources icon in the Control Panel/Administrative Tools.
Then use its name in the connection string.

11 Apr 2006 4:47 PM

Jeff Dillon

Not neccessarily.

http://www.connectionstrings.com

And no need really to cross-post so much!

Jeff

Show quoteHide quote

"Sericinus hunter" <serh***@flash.net> wrote in message
news:a2P_f.23982$NS6.16336@newssvr30.news.prodigy.com...
> helpful sql wrote:
>> Hi,
>> I am designing a webpage with the DbNetGrid control on it. I am
>> folloing its documentation and using the following connection string to
>> connect the grid control to a database:
>>
>> 'Provider=SQLOLEDB;Driver={SQL
>> Server};Server=(local);Database=pubs;Trusted_Connection=yes;'
>>
>> But DbNetGrid keeps giving me the following error. I have tried different
>> variations of this connection string but nothing seems to work.
>>
>> [Microsoft][ODBC Driver Manager] Data source name not found and no
>> default driver specified (-2147467259)
>
> You have to create ODBC Data Source object as the message states.
> Look for Data Sources icon in the Control Panel/Administrative Tools.
> Then use its name in the connection string.

11 Apr 2006 5:23 PM

Sericinus hunter

Jeff Dillon wrote:

> Not neccessarily.
>
> http://www.connectionstrings.com

Thanks, I did not know that.

> And no need really to cross-post so much!

I hope your intention was to say that to the original poster.

Show quoteHide quote

> Jeff
>
> "Sericinus hunter" <serh***@flash.net> wrote in message
> news:a2P_f.23982$NS6.16336@newssvr30.news.prodigy.com...
>> helpful sql wrote:
>>> Hi,
>>> I am designing a webpage with the DbNetGrid control on it. I am
>>> folloing its documentation and using the following connection string to
>>> connect the grid control to a database:
>>>
>>> 'Provider=SQLOLEDB;Driver={SQL
>>> Server};Server=(local);Database=pubs;Trusted_Connection=yes;'
>>>
>>> But DbNetGrid keeps giving me the following error. I have tried different
>>> variations of this connection string but nothing seems to work.
>>>
>>> [Microsoft][ODBC Driver Manager] Data source name not found and no
>>> default driver specified (-2147467259)
>> You have to create ODBC Data Source object as the message states.
>> Look for Data Sources icon in the Control Panel/Administrative Tools.
>> Then use its name in the connection string.
>
>

11 Apr 2006 7:14 PM

helpful sql

No, I had already tried this website and all their examples for Sql Server
2000 connection strings. They did work from my test application but they did
not work with DbNetGrid. I had to create an ODBC Data Source in
Administrative Tools. Then it worked fine.

Thanks all for help.

Show quoteHide quote

"Sericinus hunter" <serh***@flash.net> wrote in message
news:ACR_f.3328$mu2.302@newssvr24.news.prodigy.net...
> Jeff Dillon wrote:
>> Not neccessarily.
>>
>> http://www.connectionstrings.com
>
>    Thanks, I did not know that.
>
>> And no need really to cross-post so much!
>
>    I hope your intention was to say that to the original poster.
>
>> Jeff
>>
>> "Sericinus hunter" <serh***@flash.net> wrote in message
>> news:a2P_f.23982$NS6.16336@newssvr30.news.prodigy.com...
>>> helpful sql wrote:
>>>> Hi,
>>>>    I am designing a webpage with the DbNetGrid control on it. I am
>>>> folloing its documentation and using the following connection string to
>>>> connect the grid control to a database:
>>>>
>>>> 'Provider=SQLOLEDB;Driver={SQL
>>>> Server};Server=(local);Database=pubs;Trusted_Connection=yes;'
>>>>
>>>> But DbNetGrid keeps giving me the following error. I have tried
>>>> different variations of this connection string but nothing seems to
>>>> work.
>>>>
>>>> [Microsoft][ODBC Driver Manager] Data source name not found and no
>>>> default driver specified (-2147467259)
>>>    You have to create ODBC Data Source object as the message states.
>>> Look for Data Sources icon in the Control Panel/Administrative Tools.
>>> Then use its name in the connection string.
>>