Visual Basic :: Visual Studio Installer - How Do I Package An ODBC Driver And A ODBC Connection?

ODBC Error: [Microsoft][ODBC Driver Manager]Data Source Name Not Found And No Default
I have a VB App accessing Access Database. I have created an installer using Windows Installer. When the application is installed on a PC with Microsoft Office, everything works fine, However, on PC@s with no Office, the following error message pops up

ODBC error: [Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified

The Operating System is XP wit SP2. MDAC 2.8 is installed.

Any help will be highly appreciated.

Using The Visual Fox Pro ODBC Driver -- Need Any Info
I'm having problems using the new Visual Fox Pro ODBC driver to connect to FoxPro 2.6 tables. I get an adodb.connection object and establish a connection fine. I can only open recordsets on simple SQL statements (e.g. "Select * From Table1;"); whenever I try to use a Where clause (e.g. "Select * From Table1 Where (field1 = thisValue);") I get a "Run-Time error '-2147217887 (80040e21)': The request properties can not be supported by this ODBC Driver." Any experience anyone has using this driver would be greatly appreciated. Any info that anyone might feel is applicable here would be quite helpful as well. This has been a long outstanding problem. Thank you.

SQlite ODBC Driver With Visual Basic 6 0
Hi,

I want to connect to a sqlite3 database on a remote PC from Visual Basic 6.0. For this I have downloaded the SQlite ODBC Driver and installed it on my terminal (i.e the terminal where the VB forms are kept). After installation I get three options under the System DSN tab ( Control Panel -> Administrative Tools -> Data Sources(ODBC) ) - i. SQlite Datasource ii. SQlite UTF-8 Datasource iii. SQlite3 Datasource.

I have used the SQLite3 Datasource and created a System DSN on my terminal named 'cesc_simputer' which points to the database 'cesc_simputer.db' residing on the other terminal. For this I had to give the mapped path to the database file in the other terminal when creating the System DSN.

Now, I want to create a VB form in my terminal which should access the remote database using the DSN and select some records. How do I go about with it?

Any early help in this context will be highly appreciated. For intimation, I am working on Windows 2000 platform. Any further queries may please be mailed to anirban.sarkar@cesc.co.in

Regards,
Anirban

Where Is The Visual Foxpro Odbc Driver For Windows Xp?
Hi,

I have a vba application which reads some data from foxpro tables. It works perfectly in windows 98.
The user migrated to windows xp, and can't create de ODBC driver.
It asks me to update Visual Foxpro from microsoft page.
When I go to that page, it says not to update with windows 2000 or windows Me. It doesn't say anything about windows xp.
Where can I find the Visual foxpro odbc driver for windows xp?
I downloaded MDAC 2.8, vfpoledb for windows xp.
Please, I don't know what to do!!!

Thanks,
Amota

ODBC Driver To Informix And Visual Basic
Hi,

I work with Informix 7 and Visual Basic 5.0.

Which ODBC driver may I use ?

Thanks !!

Federica Pavese

fedepavese@bolsamza.com.ar

Visual Studio 2005 And ODBC
when I want to define my ODBC connection string:

dim mydbconn as odbcconnection = new odbcconnection(".......")

the odbcconnection does not show as a valid statement, odbc is available but all the documentation (pulled from .net framework developers guide on MSDN.COM) shows that odbcconnection is a valid statement. I just want to get started connecting to an MS Accesss database using odbc..

How To Make Package With Visual Studio Installer
Earlier I was making my packages with the "Package and deployment wizard" but now it is giving me problems, the window disappears as soon as i click at finish to make the package.

Now I have downloaded Visual Studio Installer but i don't know how to use it? Can someone provide me step by step discription for using VS installer?

Thanks

Visual Studio Versions - ODBC Connections
Morning all,

We are looking at moving to visual stuido.net from Visual Studio 6.

On the microsoft web site there are several versions. Most applications we write connect to databases via ODBC.

The express version that can be downloaded from the web site does not support ODBC.

Does anyone know what version we need to purchase inorder to get the full ODBC connction options.

Does standard edition support ODBC or do we have to purchase the Professional Edition.

thanks

Does Visual Foxpro ODBC Driver Support Select Into Clause?
Dim rdocon As rdoConnection
Dim rdoqry As rdoQuery

Private Sub Form_Load()
Set rdocon = New rdoConnection
rdocon.CursorDriver = rdUseOdbc
strcon$ = "dsn=vfpdsn;uid=;pwd="
`vfpdsn is a DSN buid in odbc vfp driver 6.00.8428
rdocon.Connect = strcon
rdocon.EstablishConnection
Set rdoqry = rdocon.CreateQuery("aa", "select * into dbf c: emp.dbf from customer.dbf")
rdoqry.Execute
End Sub

The program execute with no error message,but can not produce
temp.dbf.
Does not Visual Foxpro ODBC Driver (6.00.8440.00) support Select into Clause?

[ODBC Driver Manager] Data Source Name Not Found And No Default Driver
For some reason every time i now try to use OSQL it come up with

Code:

[ODBC Driver Manager] Data source name not found and no default driver
specified

it worked before and i need to use it all the time, could someone help

daniel

Error In ODBC Connection Using Visual Data Manager
To all VB Master

I want to ask you, why did my table(s) in my database got NOT UPDATABLE status from ODBC Connection using Visual Data Manager? Meanwhile I can update that table(s) via SQL Server 2000 Enterprise Manager.
If I try to update that table(s) with Not Updatable status I receive message :
"Can't update. Database or objects is read-only. Error Number 3027"

Please help me anyone.
Thank You

How To Connection To Oracle Dataase Using Oracle 9.2 ODBC Driver
I try to connect to the Oracle database using the Oracle in OraHome92 driver, the code is:

Private Sub ConnectDB()
   Dim sConn As String
   Dim DB As String

   Select Case cboEnviro.Text
      Case "Production"
         DB = "PROD"
      Case "Testing"
         DB = "TEST"
   End Select

   sConn = "Driver=(Oracle in OraHome92);" & "Data Source=" & DB & _
                ";Uid=userid;Pwd=password;"
   dbConn.Open sConn
End Sub

I got the following error message:

Run-time error '2147467259 (80004005)':
[Oracle][ODBC][Ora]ORA12560: TNSrotocol adapter error

Can anyone tell me what wrong with this and how to fix the problem. Thanks.

Connection To An Oracle 9i Database With The Oracle ODBC Driver
I have this older VB6 application that I don't have the time to convert to VS2005 right now. I have the Oracle ODBC client installed and the DSN are created as system DSN's. They are not using the "Microsoft ODBC for Oracle" driver, instead they are using the actual Oracle driver. Ive tried several connection strings including:

Code:

cn.connectionstring = "Password=gers4us;Persist Security Info=True;User ID=gers;Data Source=NUREV"

cn.connectionstring = "Password=" & gstrPassword & ";Persist Security Info=True;User ID=" & gstrUser & ";Data Source=" & gstrDSN

cn.connectionstring = "Driver={Microsoft ODBC for Oracle};" & "UID=report;PWD=reportpw;DSN=nurev"

cn.connectionstring = "Driver={Microsoft ODBC for Oracle};Server=nurev;Uid=report;Pwd=reportpw;"

I keep getting the error handler from my function:

Code:

Public Function OpenDatabaseConnection() As Boolean
On Error GoTo errhandler
Dim connectionstring As String

Set cn = New ADODB.Connection
cn.Provider = "MSDAORA.1"
'cn.connectionstring = "Provider=OraOLEDB.Oracle.1;Password=gers4us;Persist Security Info=True;User ID=gers;Data Source=NUREV"
'cn.connectionstring = "Password=gers4us;Persist Security Info=True;User ID=gers;Data Source=NUREV"
'cn.connectionstring = "Password=" & gstrPassword & ";Persist Security Info=True;User ID=" & gstrUser & ";Data Source=" & gstrDSN
'cn.connectionstring = "Driver={Microsoft ODBC for Oracle};" & "UID=report;PWD=reportpw;DSN=nurev"
cn.connectionstring = "Driver={Microsoft ODBC for Oracle};Server=nurev;Uid=report;Pwd=reportpw;"
cn.Open
OpenDatabaseConnection = True
Exit Function
errhandler:
MsgBox "Connection failed, Enter Login Parameters Again", vbCritical
OpenDatabaseConnection = False
Exit Function
End Function

...any ideas on the correct connection string?

Problem Faced With ODBC Driver Of Sybase While Using To Connect Visual Basic Application To Sybase B
I am having a certain problem with respect to ODBC driver for Sybase 11 .
I am writing an application using VB and Sybase 11.5 that actually reads data from
a text file or wave file from the physical disk and store in a field of
datatype image in sybase 11.5.
When I am using the active X data objects method appendchunk to update that
field to the database the ODBC driver for sybase generates an error that says this method
is not supported by the provider.
Could anyone kindly provide assistance regarding this.It would be very nice if anyone can help me out on this as soon as possible.
Waiting for assistance

SQL Error ODBC Visual FoxPro Driver: Syntax Error
Can somebody tell me what is wrong about the query (bold) and a solution for it?

VB Code:
Public cn As New ADODB.ConnectionPublic rs As New ADODB.RecordsetPublic cn2 As New ADODB.ConnectionPublic rs2 As New ADODB.Recordset Private Sub cmdOpenBron_Click() Dim naam As String Set cn = New ADODB.Connection cn.Open "Driver={Microsoft Visual FoxPro Driver};" & _ "SourceType=DBC;" & _ "SourceDB=J:BjornDatadubois.dbc;" & _ "Exclusive=No" Set rs = cn.Execute("Select * from KLPX") Set cn2 = New ADODB.Connection cn2.Open "Driver={Microsoft Visual FoxPro Driver};" & _ "SourceType=DBF;" & _ "SourceDB=C:WINBOOKSdataParfiNV;" & _ "Exclusive=No" Set rs2 = cn2.Execute("Select * FROM PARFINV_csf") While Not rs.EOF While Not rs2.EOF If Not rs![KL_NAM] = rs2![NAME1] Then naam = rs![KL_NAM] [b]cn2.Execute "INSERT INTO PARFINV_csf [(NAME1)] VALUES '" & naam & "'"[/b] End If Wend Wend cn.Close Set rs = Nothing Set cn = Nothing cn2.Close Set rs2 = Nothing Set cn2 = Nothing

Thanx alot in advance

ODBC Driver
I want to create a VB application using ODBC to connect to Oracle and Informix databases. What ODBC driver is suit for this?

thanks

OLE DB Jet 3.51 Or ODBC Driver?
Are there any limitations to using an OLE DB Jet 3.51 driver versus using the ODBC driver for Microsoft Access 97?

Apparently, during a replication session on an app of mine that works with Access & SQL Server... I am getting this ocasional error:

-2147467259
Data Provider or other service returned an E_FAIL status.

I looked it up on MSDN, it is article #Q198532
Apparently this is a "known bug".

Article is titled:
ADO: Unable to update memo field > 64k in Access database.

Apparently it will not fail if you use a ODBC driver, or if you use a client-side recordset.

Gosh... any ideas on what I can do guys?

Thanks
diver

Xp Odbc Driver??
Why is it that i cant create an odbc diver (sql server) in xp?...everthing is done smoothly..even after the TESTING (successfully) ..but after i click ok..i cannot see the sql server driver created...??

ODBC Driver
i am suppose to know this error, but i tried everything i know and nothing happen.

the app is running on other pc with the same configuration: win98, dsn file, etc but i got this error.

[Microsoft][ODBC Driver manager]Data source name not found and no default driver specified

ANYOTHER THING I AM SUPPOSE TO KNOW

ODBC Driver
i have developed a software using VB 6 and SQL Server 7. i am using File DSN to access the database. The problem is i am having a field which is of length 5000. When i run the program in Windows 95 and save the data to this field only 255 charecters are saved. But the same program is runned in Windows NT it saves all the data. What may be the problem ?

MySQL / ODBC Driver
hi ppl

well, i would want to know if, is there any way to find out "in code", if the mySQL drivers are installed in ODBC ?

so, after i check this, if it is not installed, my app will install it

thx for the help

ODBC Driver Update
I need to update my ODBC drivers but have pulled all my hair out searching MicroSoft's web. Can someone tell me "where" I can download the updates for the ODBC.

Thanks in advance!

Thin ODBC Driver Fo VB
Hi Guys,

I'm using Oracle as back-end database for my VB application. My problem is that I need to install Oracle client on all my Client PCs. Is there any thin ODBC driver concept (like thin JDBC driver in Java ) for VB. Or is there any way to put VB and Oracle client together as installable package.
I would prefer some thin driver liek concept.

Kindly help !!!!!

Regards,

Top Speed ODBC Driver
I am looking for a ODBC driver for a Top Speed Database
db.tps
Any help or link would be great

Odbc Driver Timeout
I have a rather large select query that uses 3 large tables and it's timing out and telling me "[ODBC SQL Server Driver] Timeout Expired." I have tried chanfing my ADODB connection Commandtimeout property to 0 and then it just sits there doing nothing. I'm using a client side cursor location Can someone help me get pass this problem please? Thanks.

Create An ODBC Driver
Hi All

I'm not sure whether to ask this question here on in the Database Development section... but here goes anyway!

I have just finished creating my own Database format. EG: MDB [Access], DBF [FoxPro / DB2], and now CDB [My own that I have created]

At this moment I communicate with the data using the actual DLL's. Is it possible to create an ODBC Driver to communicate with this database format?
EG: In the ODBC Window, to create a new DSN and selecting my custom driver for my table...

Reason being, for example: I'm creating my own application. The user can choose whether to save the data in a proprietary format (Access, DB2, etc...) or in the native application format. (CDB) In order to create re-usable code, it would be better using ODBC for this, as I can then just change the ConnectString, for example, and still use the same SQL queries.

I'm not sure if I explained it well enough, but any help would be greatly appreciated!

MySQL ODBC 3.51 Driver
hi i am using cn.Open "DRIVER={MySQL ODBC 3.51 Driver} to connect to a mysql database it works fine but when i put the app on another computer it dosent work it comes up with a error i tryed putting the reference in the app folder, msado15.dll and then i tried putting every file in my ado folder in there too but it still dosent work, can someone please tell me what i have to do.

ODBC Driver Version
Hello,

I have a VB 6 app that uses Access as its back end. I need my app to check which Access Driver version they have. Certain old versions of access won't work with my app, and I want to be able to warn the user of that before they continue on.

Does anyone have any idea how I can do this, or where I can find some code for it???

Thanks

Oracle ODBC Driver
Hi All,
I want to connect to my oracle database from vb,but i don't have oracle driver installed on my system.Where can i download the ODBC driver for oracle for windows 98.

ODBC SQL Server Driver
I have an application that I have created. It works fine from my computer, a server, and a laptop. However, when I install it on another server I get this error "[Microsoft][ODBC SQL Server Driver]Syntax error or access violation -2147217900"

I don't really think that it is a syntax error because of all the other locations it is installed.

Has anyone ever had this problem. Do you know how to fix it or where I should look?

Thanks

ODBC Driver DataFlex
Do anyone here know where I can find an ODBC driver for an old DataFlex program that I can use to connect thrue ADO. I just want to do it so I can read the data and store it in another db.

ODBC Driver Detection From VB
Please tell me how to get ODBC Driver name from existing DSN in visual basic,that is whether it is sql ,access or oracle driver .Please give the code.

How To Unstall Odbc Driver ???
hi

could me suggest me how to unstall odbc driver from control panel ??? i installed sybase system 11 , version 3.00.0000.

pl. give me the reply at the earliest ...

thanks

sanju

Lotus 1-2-3 ODBC Driver
Hi all,

In ODBC Data Source Administrator, under the 'driver' tab, it shows a list
of ODBC drivers installed on my machine. I am looking for a driver for Lotus
1-2-3 (*.WK4). I have tried to install the Lotus 1-2-3 ODBC driver but it
only installs a few ODBC drivers like Paradox, DBase etc. I wonder if anyone
knows how can I get *.WK4 driver on my list of drivers? Thanks in advance!

Cheers,
Tania :)

How Can Create ODBC Driver
Dear All,

How can create ODBC driver through VB code. Pl. Suggest me.

Sanjay

Help Me With An ODBC Driver Problem
Hello people,

I have this problem. I'm running a visual basic 6 project under windows XP but when the program attempts to connect to the database the following error occurs:

Runtime Error '-2147467159(80004005)':
[Microsoft][ODBC Driver Manager]data source name not found and no default driver specified

I read in this forum a solution that worked with windows 98 pc's but I have windows XP and when I try to install the MDAC 2.8 there's a message that tells me that I already have that package in the O.S..

What can be the problem?? I'm using a dns-less connection string. Please, if you have some ideas that can help me, i will thank you a lot.

Ceci

ODBC Text Driver
I'm using an ODBC Text Driver to connect to a tab delimited text file in VB. I seem to connect to the file just fine, but when I execute a SELECT statement against it I get an unknown error.

The weird thing is, I have a 3rd party query tool that let's you connect to a DB via a DSN. I run the exact same SQL statement against the same text file in this program and it works just fine. The only thing that makes me wonder is, when the 3rd party tool initially connects to the text file a window will pop-up and ask me to select a directory. This doesn't happen in my VB program. Any suggestions?

Thanks

ODBC Driver Manager
when i run my program it gives me this error

[Microsoft][ODBC Driver Manager]
DataSource name not found and no default driver specified

what have i do ???

ODBC For Text Driver
I've come across code in a previous job SQL code that selects data from a flat file (SELECT * FROM filename) using rdo and an ODBC for text driver but I cannot recreate this using good old DAO. Can anyone provide me with some code to do this because it is really iratating me!

ODBC Access Driver
I've written a programme in VB, which reads from an Access database - so I'm connecting to it via ODBC. It works on my computer fine (because the Access ODBC driver is installed automatically with Access), but I want to get it to work on other computers that don't have Access installed.

So is there somewhere that I can download the ODBC Access Driver from, and can I distribute it with my programme?

Also - is there another database format which VB supports inherently? (without having to package drivers and so on with the programme....)

Thanks for any suggestions - this is my first VB programme, so I could do with the help!

Rob

How To Create ODBC Driver In VB
how to create ODBC driver to let the application access or share a database in windows?
anyone can help me??
thanks!!

ODBC Driver For Accessing OS/400 DB2(PF Or LF)
Hello all,
Could anybody tell me which ODBC driver I can use to Access OS/400 database(Phisical file or logical file) in using ADO ? Where can I download it? Sample code is prefered.
Thanks in advance,
Sam

Removing ODBC Driver
Not VB specific but...

I am trying to remove a proprietary ODBC driver from my pc to replace it with an older one that works. Unfortunately I don't see anything that will allow me to do that through the ODBC data source. In addition I don't see an uninstall utility.

Please let me know if anyone has any idea?!

thanks

ODBC Excel Driver
I am using the following code to open a connection to an Excel workbook but whenever I run the code it opens the workbook that I am querying?!

Set oConn = New ADODB.Connection
oConn.Open _
"Driver={Microsoft Excel Driver (*.xls)};" & _
"DriverId=790;" & _
"Dbq=" & sFile & ";" & _
"DefaultDir=c: emp"

Set oRs = New ADODB.Recordset

strSQL = "Select * FROM Wherever$;"

oRs.Open strSQL, oConn, adOpenStatic, , adCmdText

What I want to do is query the Excel workbook without it opening. How do I achieve this?

VB Installer (Visual Studio Installer) -Adding File
Hi,
I created my installation package using VB installer.

How to add our company webiste link as menu option in ProgramFiles, just below the shortcut to invoke our application.

I want to have the final links (shortcuts) after running setup on client machine as follows:

ProgramFIles -> OurProject.exe ( this is done automatically)
-> Visit our website ( Should open IE with our website. How to implement this in the VB installation package).

Thanks in advance,
Jagan

Visual Studio Installer - How Do I Package An ODBC Driver And A ODBC Connection?

Can anyone tell me how I can Package an ODBC Driver and a ODBC connection using Visual Studio Installer.thank in advance

Can anyone tell me how I can Package an ODBC Driver and a ODBC connection using Visual Studio Installer.

thank in advance