VB Crystal Report, Error: server has not yet been opened

Error: server has not yet been opened

Author	Message
Andr #1 / 3	Error: server has not yet been opened This message is somehow related to my previous one, "Newbie: password-protected database". When I try to preview a report in a VB5 procedure using CRViewer) I get the following message: "Run-time error: server has not yet been opened" Then the program halts marking the following line: crxReport.Database.LogOnServer "pdsodbc.dll", "", "", "", "password" The CR help (developr.hlp) says I can pass the pServerName, pDatabaseName, and pUserId parameters as "" (empty string), using then the settings of the report. So, what's the problem? By the way, my database is an Access 2000 .mdb password protected file . The best of it is that, when I try to print out directly (without previewing), I don't get any error messages, but nothing gets printed out. In fact, the "printing" window just flashes at the screen, then disappears. Weird. Well, I'm really lost as how to acces password-protected databases. Any help will be most welcome!
Tue, 05 Oct 2004 03:47:20 GMT

hiram #2 / 3	Error: server has not yet been opened Best thing to do is use Report.Database.Tables(1).Setlogoninfo "Servername","db name", "uid","pwd" instead. It's less quirky, and more reliable than using LogonServer. h. Quote: > This message is somehow related to my previous one, "Newbie: > password-protected database". > When I try to preview a report in a VB5 procedure using CRViewer) I get the > following message: > "Run-time error: server has not yet been opened" > Then the program halts marking the following line: > crxReport.Database.LogOnServer "pdsodbc.dll", "", "", "", "password" > The CR help (developr.hlp) says I can pass the pServerName, pDatabaseName, > and pUserId parameters as "" (empty string), using then the settings of the > report. So, what's the problem? By the way, my database is an Access 2000 > .mdb password protected file . > The best of it is that, when I try to print out directly (without > previewing), I don't get any error messages, but nothing gets printed out. > In fact, the "printing" window just flashes at the screen, then disappears. > Weird. > Well, I'm really lost as how to acces password-protected databases. Any help > will be most welcome!
Sat, 09 Oct 2004 05:49:33 GMT

gome #3 / 3	Error: server has not yet been opened I can't get this to work with OLEDB, is there another option or am I missing something? Quote: > Best thing to do is use Report.Database.Tables(1).Setlogoninfo > "Servername","db name", "uid","pwd" instead. It's less quirky, and more > reliable than using LogonServer. > h. > > This message is somehow related to my previous one, "Newbie: > > password-protected database". > > When I try to preview a report in a VB5 procedure using CRViewer) I get > the > > following message: > > "Run-time error: server has not yet been opened" > > Then the program halts marking the following line: > > crxReport.Database.LogOnServer "pdsodbc.dll", "", "", "", "password" > > The CR help (developr.hlp) says I can pass the pServerName, pDatabaseName, > > and pUserId parameters as "" (empty string), using then the settings of > the > > report. So, what's the problem? By the way, my database is an Access 2000 > > .mdb password protected file . > > The best of it is that, when I try to print out directly (without > > previewing), I don't get any error messages, but nothing gets printed out. > > In fact, the "printing" window just flashes at the screen, then > disappears. > > Weird. > > Well, I'm really lost as how to acces password-protected databases. Any > help > > will be most welcome!
Sat, 09 Oct 2004 07:58:52 GMT

Page 1 of 1

[ 3 post ]