Physical Database Not Found Error?
I know this is the wrong forum to post this message but I'm not getting any help and I need it quick. I'm using Crystal Reports and I get the error message: Physical Database not found. What could be causing this? I have my database and reports in the proper directory locations. It only happens on a certain computer to. The reports run fine my desktop computer.
Thanks,
Blake
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Error - Physical DataBase Not Found?
When i run my application on client system, all forms are coming correctly except the crystal reports. When i try to open the crystal reports it is giving me the error that "Physical database not found". But it run perfectly on my computer, where i deveoped the application. I am using VB6 and Crystal report8.5 and Ms-Access(xp) as my database. And i am creating the .msi file using the visual studio installer to distribute the application. While creating the .msi file i copied "craxdrt.dll, craxddrt.dll, crviewer.dll, crystl32.ocx and dao360.dll" files and when it install in client PC it is storing to their system directory. can anyone please help me to solve this problem.
VB/Crystal Report Error" Physical Database Not Found"
Hi all,
I have a VB 6.0 front end application that uses Crystal Report 8.5 and a text file as my database.
I am trying to run this application on a non-developer machine (that doesn't have MS Visual Studio, or Crystal Report).
I have setup the ODBC DSN for the text file (MS Text Driver) on the client PC,and also used Visual Studio Installer to run the VB executable from the client PC.
I placed all the dependent DLL's,MSM's and OCX's on that machine, but I get an error: "PHYSICIAL DATABASE NOT FOUND" although the VB form opens up.The crystal report doesn't open up.
Can someone please help, or let me know what I'm missing?
Thanks.
Physical Database Not Found
Did I miss anything here? I use the PDW to pack dan distribute my VB application. It uses Crystal Report for the reporting part. I'd included the p2ssql.dll, ntwdblib.dll, sscsdk80.dll and pg32conv.dll files. Few years back, I encountered the same problem and seems like the four dlls helped to solve the problem. But not anymore. When I try to open crystal report, it says Physical Database not Found.
Any idea? Anybody?
Thanks.
Physical Database Not Found
Error Message
Run-Time Error -2147192191
Physical database not found
I finished my program and installed it on a workstation.
But when I run the application, It loads but when I try to get it to connect to the SQL Server, I get the error message listed above.
Any ideas?
I know the server is up, my machine could access it fine.
Same log-in
I also was able to my an access database and import data from the SQL server into access on the client machine. I just can't the
application to work.
Thanks
he9ap00
Physical Database Not Found
I have just completed a VB 6 program which contains a number of reports. I am using Crystal Reports 8.5 and an Access 2000 database.
The program runs fine on my machine (I have Windows XP) but when I try to run it on a user machine I get the error "Physical database not found.".
I searched Crystal Report's knowledge base and their forums and the only thing that was suggested is to place the file p2soledb.dll in the Windows/System32 folder of the user machine.
Unfortunately, that didn't help. Has anyone any oyher suggestions?
Physical Database Not Found
I am using SQL 2000 and Crystal Reports 8.5 Developer and I
wrote a report that gets an ADO recordset set at runtime. There
is no problem running the query and printing out the report on
my system, but on another users system it gives a "Physical
Database Not Found" error. The app and report are located on a
network share with no security on it.
This is some of the code...
VB Code:
'ADO objects are populated and open.Set crxApp = New CRAXDRT.ApplicationSet moReport = New CRAXDRT.Report Set moReport = crxApp.OpenReport(App.Path & "MyReport.rpt", 1)moReport.Database.SetDataSource goRs, 3, 1moReport.DisplayProgressDialog = TruemoReport.PrintOut True, 1
I'm at a loss on this one.
Thanks in advance for any help.
Physical Database Not Found
hi friends,
I am developing on project in VB6/Access.
While running one report in crystal 8.5, I am having error 'physical database not found'.
In crystal help it is said that
---
The program is unable to locate either a DLL or the database. Check to make certain that the directories that hold these files are listed in the path statement.
---
but I have checked my database file. Even checked set location, it is ok. Is there any way I can get the name of the dll file missing. Is it possible with on error. How to use it. Or any other better solution.
Pls note that I am getting this error only after running my EXE file on any other machine & not mine.
Thanks in advance
Physical Database Not Found
hi to all
hoping for your assistance with this problem of mine
backend : msaccess
frontend : vb6
report utility: cyrstal report 8.5
problem: physical database not found
after installing the project on pc with no crystal report this ERROR occured when i
viewed the report
Physical Database Not Found
Hi,
I have developed an application using crystal report 8.5, VB 6.0 and Microsoft Access 2003....I create a setup and install to my client's computer.. It runs on Win XP, everything works properly...but when i run my report, it shows me an error "Physical Database Not Found".
Anyone can help me to solve this problem? I'm using ADODB/OLEDB in VB...
I need it urgently...
Urgently
Physical Database Not Found: Seems Like A Challenge
I have a Visual Basic 6.0 application, that
uses a SQL Server 7.0 database on the net server, and Crystal
Reports 8.5. It runs OK in my machine, but
when I install in a client machine, and try
to run the reports, the CR viewer comes up
blank and the error message "Physical
Database Not Found" is displayed. Does
anybody know of a solution for this problem?
Please Help!!
Physical Database Not Found (Crystal Reports)
I have a report based on an Access 2000 database, used by an application written in VB6.0. In my PC (developer machine) the application and the report run ok, but when I distribute them, the report doesn't open, and I get the error "Physical database not found.".
I think it is related to files I have to distribute, but I'm not sure which are those files? Could you please help me with this?
Crystal Help said I have to look into DAO 3.5 SDK, but where could I find that?
Any help will be appreciate.
Thanks in advance
Crystal Report : 'Physical Database Not Found'
Hi
I am using Crystal Report Viewer control to display the report, when the form(containing crystal report viewer control) is load, it gives the error 'Physical database not found'. But everything runs better on my developement machine. What is the meaning of that error.
Please help
Crystal Reports - Physical Database Not Found
I recently installed crystal reports 8 replacing crystal reports designer component 6.0. After packaging my application and installing it on a client, I get "Physical database not found" when I try to print reports. I don't get this on the system that I created the application with or with the old report designer component.
Am I missing a dll or something when packaging?
Thanks in advance
Physical Database Not Found-Crystal Report 8.5
Hi Folks,
I am developing an application in VB6.0 and using seagate crystal
report 8.5 for my reports. I am using ADO with ODBC connection
to Ms Access 2003 database. I have a laptop (IBM Thinkpad r51)
for development.
Now everything works so perfect on my Laptop. However when I
packaged the application and installed it on a second desktop
(or any other desktop) all the forms for the application works
perfect except that my reports does not open (can not be viewed
at all). The report form only opens with an error message that
says: Physical Database not found. The reports were designed
within VB6.0 using the crystal report designer and report
viewer. can any one help me with the solution to this problem.
Thanks. cheers.
Crystal Reports - Physical Database Not Found
Hi guys,
I have a VB program which access a Crystal report .rpt file. Using VB code I logon to Oracle database, and pass an SQL query. The report works fine.
I was running this VB program as a scheduled task on the server (Windows 2000). I had no problems.
Recently the server was upgraded to Windows 2003. I copied across the VB program and the crystal report file to the new server. It would not work on that server.
It generated "Invalid TLV record". I installed VBRuntime files on the server.
Now it generates VBruntime : Physical database not found error
This works perfect on my local machine.
Any ideas guys ???
Error: Physical Data Not Found
hi folks,
i have developed an application using vb
6.0,crystal reports 8.5 and access 2000.I have created
an exe using package and deployement wizard.
I m using report designer control and CRviewer
to view my reports.When i install my application at my
clients machine and execute my report , it shows an
error, that Physical data noth found, OTOH all my
forms get the data from the database.I m using a
system dsn to connect to the database.
can anybody tell what the problem is ? .why is
the report not able to get data from the database.
thanks in advance
rajiv mukhi
Crystal Report 8.0 - Physical Database File Not Found
hi friends,
I m using crystal report 8,0 as reproting tool.
I have added new crystal report 8 and from crystal expert i have designed my crystal report from vb6 IDE.
it's working fine on my system ,
but when i make exe and install on client system it's giving me message that
"Physical database file path not found". and viewer is not displaying any data.
where m i wrong ??
Pls help me exact and more reliable method to use crystal report ??
thanx
It May seem Impossible, But Possibly We don't know the way how to reach there ????
Whats This Error ? Physical File Not Found?
hi
i have desgin one school application. and i have installed it in few systesms in the schools. in some schools its working fine, but in some systems i am getting this error : pdsodbc.dll file missed or not found. or posodbc.dll file was not found.
i have a crystal report. so when i trying to open this report its giving this error. and the application is closing .
but when i checked in my system the file was not found. but the application was executing fine.
thanks in adv.
thanks
---------------------------------------------
Srinivas.
"physical Database Not Found"
ive written an application with vb6 and CR 8.5 DE. it contains reports base on a database of employees. when i click the report button it works fine on pcs which have CR installed on them but if they dont have CR i get a message "physical database not found". im pretty sure i installed all the crx dlls in the package so i dont know what the problem is
thanks!
Can Not Find Physical Database Error
Hello:
I have two VB exes which work on user workstations. My "new" problem is, I have Crystal Report dsn files which give me the error "Can not find Physical Database". When I first created the dsns I realized that I had their datasource mapped incorrectly. So I went back and set the ado connection to the ODBC driver. Well, I re-compiled the exe and I am still getting the same error. I know the exe can find the OBDC driver because the other functions such as searching a recordset and updating a record work fine. Why can't the .dsn files see the ODBC database. It is calling to the same location as the rest of the application. Has anyone had this problem before? Do I have to Package and Deploy the whole thing over again? I made the changes to the dsn and recompiled the exe which didn't seem to help..I'm almost positive the dsn are now calling to the ODBC driver. Any assistance? Thoughts?
Martin Koslof
Physical Datbase Not Found???
Hi
I'm using crystalreport 8.5 I've created a report using rdc using active data connections the problem is when i'm on my design station every thing works fine but when I install the application on my test PC i get the error physical database not found I've tried everything changed the report database from ole DB to database nothing worked.
i think that there is some components that are missing in my installation but i can't pinpoint them, because when i change the location of the db in my design station it works fine, so i've roled out the possibility of wrong database location.
any one encountered this problem before???
help
BR
Begin Dump Physical Memory Error....
Hi all
I'm using my software and then suddenly.... i receive an error that says something like Beginning dump of physical memory...
Then the PC freeze....
Any idea what might happen?
Thanx
According to my calculations the problem doesn't exist.
Database DLL Not Found
Hi,
I have developed an application using vb6 and crystal reports 8.5.
Initially i connected the report using sql server native connection but as i got error like database dll not found. I searched the forums and found that for a native connection to be used we need sqlserver client to be loaded on the client machine.
So, i went for a system odbc connection. I setup the system dsn and changed the report as well to access via the system dsn created. But still it gives database DLL not found error.
I tried to use the module.exe file to look for the difference in the dll files but in my machine which is a win2k i get loads of dlls assoicated with my program but in the clients machine which is win98 it shows only 7 to 8 dlls associated while have included all the required dll files in the package itself.
Things are turning to be very confusing.
Please advise.
Thanks and regards
Hitendra
Database Can Not Be Found...
Here's the problem...
When I make an .exe file so the program can be run it can't find the database when if the problem is moved elsewhere... Is it really nescessary to type in the full length of where the database is??? I have tried to just type in the database's name (database.mdb) but VB claims that it can not find it and it is in the same folder as the rest of the program...
What do I have to write in order to the program find the database in the same folder as the program is in???
Can Not Found Database DLL
hi
I compile my vb 6 project with Install shield my front end is vb 6 backAccess and for Print crystal Report 8.5
when i try to install this project in other computer its work fine allvb part but once give command for Print give this error " Can not foundDatabade Dll "
and once install crystal report completly its work. pls help
Tahanks
Provider For Database Not Found?
After running the following below in vb6 i get...
"Run-time error '3706'
Provider cannot be found. It may not be properly installed."
with recPerson.Open strSQL, strConnect then highligted in the debug...
what am i doing wrong? thanx
-Martin
Public Sub Load(SSN As String)
Dim recPerson As Recordset
Dim strConnect As String
Dim strSQL As String
strConnect = "Provider=Microsoft.Jet.OLEDB.3.51;" & _
"Persist Security Info=False;" & _
"Data Source=C:person.mdb"
strSQL = "SELECT * FROM Person WHERE SSN='" & SSN & "'"
Set recPerson = New RecordSet
recPerson.Open strSQL, strConnect
With recPerson
If Not .EOF And Not .BOF Then
udtPerson.SSN = .Fields("SSN")
udtPerson.Name = .Fields("Name")
udtPerson.Birthdate = .Fields("Birthdate")
Else
recPerson.Close
Err.Raise vbObjectError + 1002, "Person", "SSN not on file"
End If
End With
recPerson.Close
Set recPerson = Nothing
End Sub
Database, Data Field Not Found
This works on my computer at work, but not at home, any suggestions.
Private Sub Command5_Click()
Dim db As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim strParm As String
Dim sql1 As String
name1 = Text1.Text
sql1 = "SELECT DOA, DOB, `Full name`, GP, `Marrital status`,nationality, NOK, `NOK address`, `NOK Relationship`,`NOk tel no`,Religion, `S/W tel no`, sex, `Social worker`,`National Ins`, `Admitted from`,`GP address`, Admissiondetails From `Res data`where `full name` = (" & Chr$(34) & Text1.Text & Chr$(34) & ")"
db.Open "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=C:Care ManagerLister Residential.mdb;"
rs.Open sql1, db
Set rptFrontSheet.DataSource = rs
rptFrontSheet.Show
End Sub
Highlighting Text Found In Database
I have a "dictionary" of certain words. I would like my program to go through and "highlight" the words that are in the dictionary(access table).
Anyone have a clue on how to do this? I'm sure it would use the replace function.
Delete Row From Database After License Code Is Found?
I am trying to code my program to delete the license # from the database after the user enters his/her license code so that after the program expires they cannot just re-enter the same code and re-register. At that time they would have to ask for a new license #. The program is able to compare the codes and register the program but the only part that is not working is the delete SQL line. I get a "Type Mismatch" error. And when I replace the rs with mPassword I get a run time error: No value given for one or more required parameters.
Code:
Private Sub Command1_Click()
Dim mPassword As String
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim sSQL As String
Dim dbpath As String
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
mPassword = Trim(Text1.Text)
sSQL = "Select * FROM licenses WHERE licenses = '" & mPassword & "'"
dbpath = App.path & "data.mdb"
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=data.mdb;Mode=Share Deny None;Persist Security Info=False;Jet OLEDB:Database Password=rocky3"
rs.Open sSQL, cn, adOpenKeyset, adLockOptimistic, adCmdText
If Not rs.EOF = 0 Then
MsgBox "This password does not exist"
Exit Sub
Else
frmRegistered.Show
End If
cn.Execute "Delete from licenses where licenses like " & rs 'mPassword
rs.Close
cn.Close
Set rs = Nothing
Set cn = Nothing
End Sub
Thank you so much if you can help!
gfolz
Looping Untill All Rows In A Database Are Found
Hi there,
Can any one help me make a loop that grabs all the data from a field in a databse and then display them in labels using an array or somthing?
So far i can do this for one but not for them all.
This is the code i have for getting out on record and displaying it in a table:
PHP Code:
Dim priceRange As Long
' Database connections
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Private Sub Form_Load()
Set cn = New ADODB.Connection
' Create a new connection to the database
cn.ConnectionString = "provider=microsoft.jet.oledb.4.0;data source=E:vbprice_ranges.mdb;persist security info=false"
cn.Open
Set rs = New ADODB.Recordset
rs.ActiveConnection = cn
rs.Open "SELECT * FROM pr;"
priceRange = rs![range_value]
lbleValue.Caption = "Price Range: " & priceRange
rs.Close
cn.Close
Set rs = Nothing
Set cn = Nothing
End Sub
DSN Not Found Error
My VB application uses the Access data base which is in a Server, thro' a DSN. Using Distribution & Deployment wizard, this VB application is made in to a Package and installed in some other machine. When running the programme in that machine, an error message occurs saying 'DSN is not found'. What are the various possiblities to solve this problem?
Thanks
File Not Found Error
I wrote a small program to analyze a group of associated files and display information extracted from them.
I built into the program the ability to accept a command line argument of the base file name and open with a data set displayed.
I ran into a problem where the command line processing resulted in a file not found error when a file name was dragged from Windows explorer and dropped on the desktop icon for the program.
After some effort at debugging, I found that the problem occurs when the file path I drag and drop contains a space, e.g., part of the path is "C:Program Files...". If I eliminate the space in the file name, the error does not occur.
Yet, if I insert the SAME path name in the development environment, I do NOT get the error. The error only occurs when I drag and drop the path name on the desktop icon and the path name contains a space.
Also, if I select the path name containing a space via the common dialog control, the error does not occur in either the IDE or the executable file.
Does anyone have an explanation for this?
Error 53 File Not Found
a programmer is programming a program for me in visual basic which self-deletes on exit and sometimes (not every time) on exit the file won't delete and there will be an error that says "error 53 file not found". The file does exist since it's an intermittent problem and if you try again it works.
I did some research on this and advised him to add a delay to slow the script down but, the error still occurs intermittently.
Does this mean the delay just needs to be longer?
I've only noticed this on Vista and haven't noticed this error on XP. It is an intermittent problem but, it always occurs atleast 1 out of 10 times.
any advise would be appreciated.
Thanks
File Not Found Error
Hi All,
This is a funny one though I'm pretty certain it is a network security issue. My scenario is thus:
I have a VB6 app which accesses an Access db stored on a SBS 2003 Sever. It also creates and saves Word docs onto the server. This is all working fine. However the issue I have is when I try to open the Word docs using the VB app. Here I am getting the "File Not Found" error.
I have two pcs networked to the server, a laptop and a pc. The Pc has Win XP Pro while the Laptop has XP Home Edition. It is with the laptop I see the problem. The pc works perfectly.
Both laptop and pc have a mapped drive to a folder on the server in which the db and files are stored. This needs to be accessed with a username and password upon logging onto the pcs (share was already created this way by hardware eng).
Needless to say, I can manually navigate to the shared folder on the server and open anything I want. It is just with the automated process in the VB app that I see the problem. I have confirmed that the file path and file name are correct.
Just to add, the laptop does not have a secured user log in. When the laptop boots, you simply click on a profile and off you go. Also, the laptop is not set up as a manged computer on the server.
So here's my question: How is it I can create and save the word docs to the shared drive on the server but not open these files? Does it come down to shared drive security issues and most importantly, can it be overcome?
I hope this is explained well and that someone might have a suggestion/answer?!
Thanks All,
GB
Path Not Found Error When Run On Xp
My program works fine with windows 98 2000 but is giving runtime error 76 Path Not Found when run on xp. I do not have access to the machine so I cant debug but am assuming the problem is with the FSO or ADOX commands I am using to copy and update files. I havent written anything for xp b4. Heres my current code. Do I have to use different code for xp?
btw QLink comes from a commondialog control
Dim copyTo As String, QLink As String
Dim fso As New FileSystemObject, fl As File
Dim pth As String, x As Integer
Dim wShell As New WshShell, sct As WshShortcut, dtp As String
copyTo = "C:ClientsClients v03.mdb"
QLink = lblPath.Caption
If optUA = True Then
GoTo UserApp
End If
'if Datastore file already exists check if should be replaced
'if no goto main if yes rename existing
Set fso = CreateObject("Scripting.FileSystemObject")
If fso.FileExists(QLink) = True Then
If MsgBox("A datafile '" & QLink & "' already exists are you sure you want to overwrite it?", vbYesNo, "") = vbNo Then
MsgBox "Installation Cancelled", , ""
Exit Sub
Else
Splash.Show
a = Str(Day(Date) & Month(Date) & Year(Date))
b = Str(Hour(Time) & Minute(Time))
If fso.FileExists(QLink & a & b) = False Then
fso.CopyFile QLink, QLink & a & b, True
End If
fso.DeleteFile QLink, True
End If
End If
'if path does not exist create it
x = InStr(1, StrReverse(QLink), "")
pth = Left(QLink, Len(QLink) - x)
If fso.FolderExists(pth) = False Then
fso.CreateFolder pth
End If
'copy datastore file
fso.CopyFile App.Path & "SetUpFilesClients Data.mdb", QLink, True
Set fl = fso.GetFile(QLink)
fl.Attributes = Normal
GoTo Done
UserApp:
Splash.Show
'if FE file already exists rename
If fso.FileExists(copyTo) = True Then
a = Str(Day(Date) & Month(Date) & Year(Date))
b = Str(Hour(Time) & Minute(Time))
If fso.FileExists(copyTo & a & b) = False Then
fso.CopyFile copyTo, copyTo & a & b, True
End If
fso.DeleteFile copyTo, True
End If
'copy user app file
fso.CopyFile App.Path & "SetUpFilesClients v03.mdb", copyTo, True
Set fl = fso.GetFile(copyTo)
fl.Attributes = Normal
'update link to datastore
Dim catDB As ADOX.Catalog
Dim tblLink As ADOX.Table
Set catDB = New ADOX.Catalog
' Open a catalog on the database in which to refresh links.
catDB.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=" & copyTo
For Each tblLink In catDB.Tables
' Update datasource for all linked tables.
If tblLink.Type = "LINK" Then
tblLink.Properties("Jet OLEDB:Link Datasource") = QLink
End If
Next
Set catDB = Nothing
'create shortcut on desktop
dtp = wShell.SpecialFolders("Desktop")
Set sct = wShell.CreateShortcut(dtp & "Clients v03.lnk")
sct.TargetPath = copyTo
sct.Save
File Not Found Error
I have a VB program, which runs flawlessly, installed on several Win98 machines (its database is on our LAN server). I reconfigured the installation so that it would run on Win2000 machines, which it does. The problem is this, when any Win2000 machine that has the program on it is rebooted, and the program is again launched, a file not found error occurs. If no reboot is done, the program can be exited and rerun day after day without any problems -- only a reboot will lead to the error.
I've checked all the networked drives after experiencing the error, and they all seem to be pointing to their proper network directories. I'm unsure why a reboot would cause such a disruption...any ideas?
Thanks
ps. Win98 machines can reboot without the program being the least bit affected.
File Not Found Error
filename is a textbox on the form where user inputs a filename
Code:
Dim inputFileNum as integer
inputFileNum = FreeFile
Open FileName.Text For Input As #inputFileNum
file exists in the same folder as the program......
any ideas?
File Not Found (Error 53)
Situation: I have a class file reading input from a text file, when I compile in into a Dll I'm gettin the ol'Error 53 File Not Found
When I tested the project before creating the Dll and setting a reference to it for the exe all was well, the error occured after the dll was compiled? Any thoughts..
The Exe and Dll operation is fine except for the part of getting external data from my text file...other unrelated methods. etc...are working ok
Thanks
Brent
Error: Provider Cannot Be Found...
1) When I test my code, I get an error msg that says
"Runtime error 3706, Provider cannot be found. It may not be properly installed."
I used MyConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB .4.0;" & _
"Data Source = D:VBdb1.mdb"
How do I know if it is not properly installed? Do I have to reinstall anything?
2) Is there anything wrong in the following code?
frmSearch.Show vbModal
'Create SQL statement to search
SQL = "SELECT * FROM Invoices WHERE Name LIKE '" & frmSearch!txtName.Text & "%'" & _
" OR Company LIKE '" & frmSearch!txtCompany.Text & "%'" & _
" OR No = '" & frmSearch.txtNo.Text & "';"
Unload frmSearch
I use Windows 2000 Pro
Visual Studio 6.0
Thanks.
Error 53 File Not Found
a programmer is programming a program for me in visual basic which self-deletes on exit and sometimes (not every time) the file won't delete on exit and there will be an error that says "error 53 file not found". The file does exist since it's an intermittent problem and if you try again it works.
I did some research on this and advised him to add a delay to slow the script down but, the error still occurs intermittently.
Does this mean the delay just needs to be longer?
I've only noticed this on Vista and haven't noticed this error on XP. It is an intermittent problem but, it always occurs atleast 1 out of 10 times.
any advise would be appreciated.
Thanks
Vb6 Error 76, Path Not Found
I get "runtime error 76 Path not found" when I try to display a picture from a camera to a vb6 form. I am using a Kodak digital camera 6.1. (a) I do not want to save the picture to a file, I just want to be able to display it on a form.
Here is the code. The camera is plugged into a slot on a Pc
Private Sub CmdShowPicture()
Picture1.Picture=LoadPicture("Computerz650 Zoom digital Camera Removable storage")
end sub
Been struggling with this for a while
Any help will be appreciated
al
Item Cannot Be Found Error
Why is it that Im getting this error? Item cannot be found in the collection
corresponding to the requested name or ordinal
Below are my codes.
On Form_load:
Code:
Private Sub Form_Load()
Call openConnection
Me.Left = LeftPos - 200
Me.Top = TopPos - 200
Set rsStockOut = New ADODB.Recordset
Set rsClient = New ADODB.Recordset
rsStockOut.CursorLocation = adUseClient
sSQL = "SELECT tblStockMasterFile.ProductID, " & _
"tblStockMasterFile.ProductName, " & _
"tblStockMasterFile.Unit, " & _
"tblStockMasterFile.ReOrderPoint, " & _
"tblStockTransFile.EntryDate, " & _
"tblStockTransFile.pSequence, " & _
"tblStockTransFile.PurchasePrice, " & _
"tblStockTransFile.Quantity, " & _
"tblStockTransFile.Reason, " & _
"tblClientMasterFile.ClientName, " & _
"tblClientMasterFile.ClientCode , " & _
"tblClientMasterFile.Budget " & _
"FROM tblClientMasterFile INNER JOIN " & _
"tblStockTransFile ON " & _
"tblClientMasterFile.ClientCode = tblStockTransFile.ClientCode INNER JOIN " &
_
"tblStockMasterFile ON " & _
"tblStockTransFile.ProductID = tblStockMasterFile.ProductID"
If rsStockOut.State = adStateOpen Then rsStockOut.Close
rsStockOut.Open sSQL, oConn, adOpenStatic, adLockOptimistic
Call FillcboClient
Call LockFunction(frmStockOut, "TextBox")
lstStockOut.Enabled = False
End Sub 'Form_Load
The Function FillcboClient:
Code:
Private Sub FillcboClient()
cboClientName.Clear
cboClientName.AddItem "- Type or Select -"
'TODO : Fill cboAuthorID
'-------------------------------------------------------------------------------------
sSQL = "SELECT ClientCode, ClientName FROM tblClientMasterFile"
'this what i mean for 1 trip..u open the rs just one time
If rsClient.State = adStateOpen Then rsClient.Close
rsClient.Open sSQL, oConn, adOpenStatic, adLockOptimistic
If Not rsClient.BOF And Not rsClient.EOF Then
rsClient.MoveFirst
While rsClient.EOF = False
cboClientName.AddItem rsClient("ClientName").Value
rsClient.MoveNext
Wend
cboClientName.ListIndex = 0
End If
'-------------------------------------------------------------------------------------
End Sub
Product ID Change event:
Code:
Private Sub txtProdID_Change()
txtProdQtyOut.Text = ""
'Use for Barcode reader
' If InStr(1, txtProdID.Text, "*") = Len(txtProdID.Text) Then
' txtProdQty.SetFocus
' End If
If rsStockOut.State = adStateOpen Then rsStockOut.Close
On Error Resume Next
If txtProdID.Text <> "" Then
rsStockOut.Open "SELECT * FROM tblStockMasterFile WHERE ProductID = '" & txtProdID.Text
& "'", oConn, adOpenStatic, adLockOptimistic
If rsStockOut.RecordCount <> 0 Then
txtSupply.Text = rsStockOut.Fields("Quantity")
txtProdName.Text = rsStockOut.Fields("ProductName")
Else
'txtSupply.Text = ""
txtProdName.Text = ""
End If
Else
txtSupply.Text = ""
txtProdName.Text = ""
End If
End Sub 'txtProdID_Change
The cboClientName Change event: The call ReplaceQuotation Function is not working here but in my other forms the same code is perfectly working.
Code:
Private Sub cboClientName_Change()
txtClientCode.Text = ""
'if user click this..then search for the appropriate record then _
display the Client Code in the textbox
sSQL = "SELECT ClientCode, ClientName FROM tblClientMasterFile " & _
"WHERE ClientName='" & cboClientName.Text & "'"
If rsClient.State = adStateOpen Then rsClient.Close
rsClient.Open sSQL, oConn, adOpenStatic, adLockOptimistic
' Call ReplaceQuotation(cboClientName)
'display the Client Code in the textbox
If rsClient.BOF = False And rsClient.EOF = False Then
txtClientCode = rsClient.Fields("ClientCode").Value
End If
End Sub 'cboClientName_Change
The Add Button: the highlighted parts is where the error points.
Code:
Private Sub cmdAddItem_Click()
Dim lst As ListItem
If txtProdID.Locked = True Then
txtProdID.Locked = False
End If 'txtProdID lock
If lstStockOut.Enabled = False Then
lstStockOut.Enabled = True
End If
If CheckNullValue = False Then Exit Sub
Set lst = lstStockOut.ListItems.Add(, , txtProdID.Text) 'DISPLY IN LISTVIEW
lst.SubItems(1) = txtProdName.Text
lst.SubItems(2) = txtProdQtyOut.Text
lst.SubItems(3) = Format$(rsStockOut.Fields("PurchasePrice"), "###,###,##0.00") 'Capital
lst.SubItems(4) = Format$(lst.SubItems(3) * 1.15, "###,###,##0.00") 'Selling Price
lst.SubItems(5) = Format(lst.SubItems(2) * lst.SubItems(4), "###,###,##0.00") 'Total
txtProdID.Text = ""
txtProdQtyOut.Text = ""
txtProdID.SetFocus
Set lst = Nothing 'destroy the list
End Sub 'cmdAddItem_Click
Can someone please tell me what am i missing here?
I have attached here my table relationships
Any help is much appreaciated and thank you very much in advance.
Cek File With Dir(...) Found ERROR
i have code like this :
VB Code:
If Dir(Format$(filePath)) Then cekFileDir = True Else cekFileDir = False End If
filePath value is "C:Documents and SettingsGrandongMy DocumentsYHInventorysrcinventory.conf"
and the value there on directory.
but when i run my program i found error : Type mismatch
what is wrong with my code ?
Error 53 Dll File Not Found
I am having a strange error when debugging my program.
Strange, because it only occurs when I am debugging in the IDE and not when the program is compiled.
(this is on a Win2K PC)
I have a Fortran DLL, so it does not need registering and I am declaring it like this:
VB Code:
Declare Sub leastsquares Lib "c:codelinearsolvers.dll" (matrix As Double, righthandsides As Double, _ m As Long, n As Long, ifail As Long, solution As Double)
When I use Sysinternals File Monitor, it says that VB is looking for the dll in
C:Program FilesMicrosoftVB98
C:codedbfilemon
c:winntsystem32
c:winnt
...everything else in my PATH directories
Why does it do this and not just go directly to the full path in the declare statement?
Like I said at the beginning, when it is compiled this doesn't occur.
I can work around it by removing the full path and putting the dll in the SYSTEM directory,
but I am interested to know why the IDE doesn't look in the full path in the declare statement.
Path NOT Found Error #76
Hi this is my first time using this thread to actually get help for my problem from VB HELL. I have the following excerpt of my code below and im using it to obtaine the pictures from USER ACCOUNT PICTURES:
Dim fso As New FileSystemObject
Dim Path_to_Folder As String
Dim Path_Info_to_Pass As String
Path_to_Folder = Left$(App.Path, InStrRev(App.Path, "", InStrRev(App.Path, ""))) & "All Users.WINDOWSApplication DataMicrosoftUser Account Pictures"
Path_Info_to_Pass = Path_to_Folder
****** NOTE ***********
'_______________________________________
Call Get_Files(fso.getfolder(Path_Info_to_Pass))
'_______________________________________
As soon as i get to the above line, i get error # 76 "Path not found"
I dont understand why this keeps getting generated. Although when hard-code the whole sections like below:
Dim fso As New FileSystemObject
Dim Path_to_Folder As String
Dim Path_Info_to_Pass As String
******* NOTE **********
'______________________________________________
'Path_Info_to_Pass = "C:Documents and SettingsAll Users.WINDOWSApplication DataMicrosoftUser Account Pictures"
'______________________________________________
Call Get_Files(fso.getfolder(Path_Info_to_Pass))
When i hard-code the path above, VB does not generate any errors. My problem is that i dont want to hard-code the path because the USER ACCOUNT PICTURES can be somewhere else. Can someone please tell me what im doing wrong? Thanks in advance.
PDW Error - SETUP.EXE Not Found
When I try to package a vb project, I choose the dir to make the package, and click next. I then get an error message that says: "These files are needed for this package but cannot be found. Click browse to locate the file"
and its looking for SETUP.EXE
Why? I don't know what to browse to
No Export DLL Found Error
Can any one help to fix this problem
I have just finished a VB project which includes reports written with Crystal Reports ( Specifically Crystal Components )
The Report run perfectly on my PC.
I have used default VB packaging to get package the application and write it to Cd.
On installation on a similar windows 2000 nachine the application runs fine.
The other reports also run EXCEPT the report in which I have the option Report.Export specified.
The system returns the error
"Runtime Error 2147190909 No Export DLL's Found"
1. Which DLL do I need to export from my development PC to the production PC
2. How do I register the DLL
Thanks
Error 53 File Not Found
Ok i am making a skin editor for my own mp3 player i made a setup file for it.. and it has all the needed files in it..
now when i install it and put a skin in the directory of the editor.. it opens it perfectly...
But when he installs it and inserts accetly the same skin (or another) it will just not work it gives an RUNTIME ERROR 53: File not found...
but it doesnt say wich one it is missing.. is there a way to make the program tell me what is wrong? or can somebody tell me if this is a program file or a skin file!
|
TRACKER
