index | search | no replies | posting guidelines | help login | register
Index » Products » ASP Report Wizard v2
search this forum:
:: Probleme with my Connection ODBC :: (9)Post a New Message | Post a Reply
Sep 20 2005, 7:51 AM
 Probleme with my Connection ODBCPost a Reply
 Orfeo

View this author's profile Send this author a private message

since: Sep 20, 2005
from: somewhere

Hi, I want try your ASP report Wizard but I can't connect with my DataBase

My page default.asp is on my web serveur, but my dbo is on a another server. I connected with a ODBC. My web site is connected with "dsn=SpaData;uid=admin;pwd=10826234"
But i don't find a good connection for your application. You can help me?

I use MS SQl 7 on my server with my dbo. But this server he don't have acces to web.
Thanks

Sep 20 2005, 9:12 AM
 Re: Probleme with my Connection ODBCPost a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

Do you get a Connection Failed error or no tables are displayed?

if no tables are displayed, then try using the UseTables property (as shown below) and let me know if anything changes.

'TODO: Change the table names to valid table names in your database
objWiz.UseTables = "Table1,Table2,Table4"
objWiz.Init(Connection String)





-------------------------
Ghost
Sep 25 2005, 12:28 PM
 Re: Probleme with my Connection ODBCPost a Reply
 Orfeo

View this author's profile Send this author a private message

since: Sep 20, 2005
from: somewhere

I would like to change a parameters for a connection


This connection do not work Because I use a ODBC for to connect to my dbo

strConnectionString = "Provider=MSDASQL;Driver={SQL Server};Server=YOUR_SERVER_NAME;" & _
"Database=YOUR_DATABASE;User ID=YOUR_USERNAME;Password=YOUR_PASSWORD;"

Write me a good string for the connection  if you hage please.
Thanks
Eric Boisvert

Sep 26 2005, 1:55 PM
 Re: Probleme with my Connection ODBCPost a Reply
 whichman

View this author's profile Send this author a private message Visit author's homepage

from: Laurel, MD

The ODBC format below also works

strConnectionString = "dsn=MyServer;uid=sa;pwd=sa"


-------------------------
Master of the Game
Sep 27 2005, 5:07 PM
 Re: Probleme with my Connection ODBCPost a Reply
 Orfeo

View this author's profile Send this author a private message

since: Sep 20, 2005
from: somewhere

Always a same error:

Error #:-2147467259
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

But My ODBC Is work on my website for a another Form.

:( it's very bad


Sep 28 2005, 6:28 AM
 Re: Probleme with my Connection ODBCPost a Reply
 whichman

View this author's profile Send this author a private message Visit author's homepage

from: Laurel, MD

What is the name of your data source?
replace it with MyDSN below.
Also replace the uid and pwd with your username and password.

strConnectionString = "dsn=MyDSN;uid=sa;pwd=sa"


-------------------------
Master of the Game
Sep 29 2005, 10:36 AM
 Re: Probleme with my Connection ODBCPost a Reply
 Orfeo

View this author's profile Send this author a private message

since: Sep 20, 2005
from: somewhere

I writing

strConnectionString = "dsn=SpaData;uid=user1;pwd=password1"

It's a same line of my other page but he don't work for asp report wizard :(



Sep 29 2005, 10:58 AM
 Re: Probleme with my Connection ODBCPost a Reply
 whichman

View this author's profile Send this author a private message Visit author's homepage

from: Laurel, MD

What error message do you get?


-------------------------
Master of the Game
Sep 29 2005, 12:21 PM
 Re: Probleme with my Connection ODBCPost a Reply
 Orfeo

View this author's profile Send this author a private message

since: Sep 20, 2005
from: somewhere

Error #:-2147467259
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Thanks for your help!

Pages: (1)   [1]

search this forum: