Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NevaB
Starting Member
2 Posts |
 Posted - 2004-08-11 : 19:53:46
|
| I have written an application in Visual Basic to hook up to an Oracle database. It uses Microsoft ODBC drivers for Oracle but can also work with Oracle ODBC drivers.I compiled it with a program called Inno Setup (which is a very good compiler program by the way).I then installed it on my machine (I have Windows xp home operating system) and it worked fine.I installed it on my work computer (there I have Windows 2k) and it worked fine too.But when I installed it on my user's computer (she has Window XP Professional) I got the error message "DSN not found and no default driver specified."Another weird thing is that when I just copy the Visual Basic files (whatever.vbp, etc) and run my application from within her Visual Basic, it works fine.Any ideas? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
NevaB
Starting Member
2 Posts |
Posted - 2004-08-14 : 16:15:10
|
| Oops, I am new to this site. I guess I should have posted this under Development tools/other. Should I repost? |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-14 : 19:37:53
|
| You might want to actually post it here:www.dbforums.comThey have a section just for Oracle. My guess is that you need to install MDAC on her machine or the Oracle drivers. Just a guess though.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2004-08-15 : 05:46:46
|
| I'd start with the obvious: if it says "DSN not found", does your application depend on a DSN to be created on the computer so that it can connect to the database? So has that DSN been created? If you are using a DSN-less connection (i.e. OLEDB) this error usually appears when the connection string for the ADO connection is blank. If you loading this connection string from a file or the registry, check if the file or registry key is accessible from your application. It could be a permissions problem on certain operating systems.OS |
|
|
|
|
|
|
DSN not found and no default driver specified