Error connectiong to database

[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_Conne ction=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.

[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_Conne ction=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.

[Jeff Dillon]

Not neccessarily.

http://www.connectionstrings.com

And no need really to cross-post so much!

Jeff

"Sericinus hunter" <se*****@flash.net> wrote in message
news:a2*******************@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_Conne ction=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.

[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.
Jeff

"Sericinus hunter" <se*****@flash.net> wrote in message
news:a2*******************@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_Conne ction=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.

[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.

"Sericinus hunter" <se*****@flash.net> wrote in message
news:AC****************@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" <se*****@flash.net> wrote in message
news:a2*******************@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_Conne ction=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.