Error connectiong to database

  • Thread starter Thread starter helpful sql
  • Start date Start date
H

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.
 
helpful said:
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)
Click to expand...

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.
 
Not neccessarily.

http://www.connectionstrings.com

And no need really to cross-post so much!

Jeff

Sericinus hunter said:
helpful said:
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)
Click to expand...

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.
Click to expand...
 
Jeff said:
Not neccessarily.

http://www.connectionstrings.com
Click to expand...

Thanks, I did not know that.
And no need really to cross-post so much!
Click to expand...

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

Sericinus hunter said:
helpful said:
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)
Click to expand...
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.
Click to expand...
Click to expand...
 
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 said:
Jeff said:
Not neccessarily.

http://www.connectionstrings.com
Click to expand...

Thanks, I did not know that.
And no need really to cross-post so much!
Click to expand...

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

Sericinus hunter said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top