SetLogOnInfo - ODBC in CR 8.5 - Posting Again. (Please Help)

[zwieback89]

Hi,

The setLogonInfo method used in ASP pages takes in the DSN name, the database name, userid and password. For instance,

crtable.SetLogonInfo "Pubs Sample Database", "pubs", cstr(userid), cstr(password)

When I develop a report based on the titles table of the pubs database, I choose the ODBC pointing to the Pubs Sample Database and Pubs database. I then strip off the pubs.dbo

Now when I mention a different value in the setlongoninfo method - say

crtable.SetLogonInfo "Pub Test", "Pubs_Duplicate", cstr(userid), cstr(password)

I cannot view any information in the report because it originally points to the ODBC - "Pubs Sample Database".

So how can strip off the ODBC name from the report as well other than the pubs.dbo ? Though the databases are different, the tables, its fields and the views are the same.

Hope to hear a solution for this. I really hope someone replies to this query.

Padmaja.

 

[mmaz]

If I understand correctly, you run your report from your ASP but you're not seeing ANY records?

 

[mmaz]

Also, do your 2 database have the same location?

 

[zwieback89]

I am able to see the records shown in the report viewer when the ODBC is Pubs Sample Database. But when I point the ASP page to the Pub Test ODBC and the Pubs_Duplicate database, then I do not get to see any information in the report viewer because the report when designed points to pubs sample database ODBC

So how I strip off the ODBC name as well ?

Tables are the same.

Hope to hear from you soon.
Padmaja.

 

[mmaz]

I'll try to find a solution, but in the meantime, search at

http://www.crystaldecisions.com/search/

for keywords ODBC and SetLogonInfo. There are a few documents that might help you solve your problem...

 

[zwieback89]

Can I mail you the report and the ASP file that pulls information from the Pubs database. I did all the searching, but I shall search again.

Do reply if I can send the files. My email address is coolpersona@hotmail.com

Padmaja.